用户韩昊杰的主页 - 第 13 页 - 辛达科技-一个只分享技术的站

21 1

管理员

这家伙很懒，什么都没有写...

PHP微擎简易导表程序-辛达科技-一个只分享技术的站

PHP微擎简易导表程序

PHP微擎简易导表程序 <?php global $_GPC, $_W; $aid = $_GPC["aid"]; $lottery = pdo_get("me_daticj_lottery", array("uniacid" => $_W["uniacid"], "id" => $aid)); $condition = " a.uniacid = '{$_W["uniacid"]}' AND a.aid = {$aid} AND a.userid = b.id AND a.awardid = c.id"; if (!empty($_GPC["nickname"])) { $condition .= " AND b.nickname LIKE '%{$_GPC["nickname"]}%'"; } if (!empty($_GPC["realname"])) { $condition .= " AND b.realname LIKE '%{$_GPC["realname"]}%'"; } if (!empty($_GPC["mobile"])) { $condition .= " AND b.mobile LIKE '%{$_GPC["mobile"]}%'"; } $condition .= " AND a.hasAward=1 ORDER BY a.id DESC"; $list = pdo_fetchall("SELECT b.nickname,b.realname,b.mobile,c.award_type,c.award_name,a.status,a.createtime,b.xiaoqu,b.isvip FROM " . tablename("me_daticj_winner") . " a, " . tablename("me_daticj_user") . " b, " . tablename("me_daticj_awards") . " c WHERE {$condition}"); $html = "\xef\xbb\xbf"; $html .= "微信昵称\t,真实姓名\t,手机号码\t,奖品类型\t,奖品名称\t,发奖状态(1已发0未发)\t,中奖时间\t,校区\t,是否是会员(1是会员0不是会员)\t,\n"; foreach ($list as $key => $value) { foreach ($value as $k => $v) { $row = $v . "\t,"; $html .= $row; } $html .= "\n"; } $filename = "中奖记录----" . $lottery["title"]; header("Content-type:text/csv"); header("Content-Disposition:attachment; filename=" . $filename . ".csv"); echo $html; exit;直接访问该路由即可

韩昊杰4年前

0 0 0

[go语言]百度翻译软件-辛达科技-一个只分享技术的站

[go语言]百度翻译软件

PHP微擎简易导表程序 <?php global $_GPC, $_W; $aid = $_GPC["aid"]; $lottery = pdo_get("me_daticj_lottery", array("uniacid" => $_W["uniacid"], "id" => $aid)); $condition = " a.uniacid = '{$_W["uniacid"]}' AND a.aid = {$aid} AND a.userid = b.id AND a.awardid = c.id"; if (!empty($_GPC["nickname"])) { $condition .= " AND b.nickname LIKE '%{$_GPC["nickname"]}%'"; } if (!empty($_GPC["realname"])) { $condition .= " AND b.realname LIKE '%{$_GPC["realname"]}%'"; } if (!empty($_GPC["mobile"])) { $condition .= " AND b.mobile LIKE '%{$_GPC["mobile"]}%'"; } $condition .= " AND a.hasAward=1 ORDER BY a.id DESC"; $list = pdo_fetchall("SELECT b.nickname,b.realname,b.mobile,c.award_type,c.award_name,a.status,a.createtime,b.xiaoqu,b.isvip FROM " . tablename("me_daticj_winner") . " a, " . tablename("me_daticj_user") . " b, " . tablename("me_daticj_awards") . " c WHERE {$condition}"); $html = "\xef\xbb\xbf"; $html .= "微信昵称\t,真实姓名\t,手机号码\t,奖品类型\t,奖品名称\t,发奖状态(1已发0未发)\t,中奖时间\t,校区\t,是否是会员(1是会员0不是会员)\t,\n"; foreach ($list as $key => $value) { foreach ($value as $k => $v) { $row = $v . "\t,"; $html .= $row; } $html .= "\n"; } $filename = "中奖记录----" . $lottery["title"]; header("Content-type:text/csv"); header("Content-Disposition:attachment; filename=" . $filename . ".csv"); echo $html; exit;直接访问该路由即可

韩昊杰的软件

韩昊杰4年前

0 0 0

微信公众号获取AccessToken，并保存到文件中，且过期前5分钟时再次自动获取-辛达科技-一个只分享技术的站

微信公众号获取AccessToken，并保存到文件中，且过期前5分钟时再次自动获取

PHP微擎简易导表程序 <?php global $_GPC, $_W; $aid = $_GPC["aid"]; $lottery = pdo_get("me_daticj_lottery", array("uniacid" => $_W["uniacid"], "id" => $aid)); $condition = " a.uniacid = '{$_W["uniacid"]}' AND a.aid = {$aid} AND a.userid = b.id AND a.awardid = c.id"; if (!empty($_GPC["nickname"])) { $condition .= " AND b.nickname LIKE '%{$_GPC["nickname"]}%'"; } if (!empty($_GPC["realname"])) { $condition .= " AND b.realname LIKE '%{$_GPC["realname"]}%'"; } if (!empty($_GPC["mobile"])) { $condition .= " AND b.mobile LIKE '%{$_GPC["mobile"]}%'"; } $condition .= " AND a.hasAward=1 ORDER BY a.id DESC"; $list = pdo_fetchall("SELECT b.nickname,b.realname,b.mobile,c.award_type,c.award_name,a.status,a.createtime,b.xiaoqu,b.isvip FROM " . tablename("me_daticj_winner") . " a, " . tablename("me_daticj_user") . " b, " . tablename("me_daticj_awards") . " c WHERE {$condition}"); $html = "\xef\xbb\xbf"; $html .= "微信昵称\t,真实姓名\t,手机号码\t,奖品类型\t,奖品名称\t,发奖状态(1已发0未发)\t,中奖时间\t,校区\t,是否是会员(1是会员0不是会员)\t,\n"; foreach ($list as $key => $value) { foreach ($value as $k => $v) { $row = $v . "\t,"; $html .= $row; } $html .= "\n"; } $filename = "中奖记录----" . $lottery["title"]; header("Content-type:text/csv"); header("Content-Disposition:attachment; filename=" . $filename . ".csv"); echo $html; exit;直接访问该路由即可

wechat公众号

韩昊杰4年前

2 0 0

微信公众号，用户消息接收与回复-辛达科技-一个只分享技术的站

微信公众号，用户消息接收与回复

PHP微擎简易导表程序 <?php global $_GPC, $_W; $aid = $_GPC["aid"]; $lottery = pdo_get("me_daticj_lottery", array("uniacid" => $_W["uniacid"], "id" => $aid)); $condition = " a.uniacid = '{$_W["uniacid"]}' AND a.aid = {$aid} AND a.userid = b.id AND a.awardid = c.id"; if (!empty($_GPC["nickname"])) { $condition .= " AND b.nickname LIKE '%{$_GPC["nickname"]}%'"; } if (!empty($_GPC["realname"])) { $condition .= " AND b.realname LIKE '%{$_GPC["realname"]}%'"; } if (!empty($_GPC["mobile"])) { $condition .= " AND b.mobile LIKE '%{$_GPC["mobile"]}%'"; } $condition .= " AND a.hasAward=1 ORDER BY a.id DESC"; $list = pdo_fetchall("SELECT b.nickname,b.realname,b.mobile,c.award_type,c.award_name,a.status,a.createtime,b.xiaoqu,b.isvip FROM " . tablename("me_daticj_winner") . " a, " . tablename("me_daticj_user") . " b, " . tablename("me_daticj_awards") . " c WHERE {$condition}"); $html = "\xef\xbb\xbf"; $html .= "微信昵称\t,真实姓名\t,手机号码\t,奖品类型\t,奖品名称\t,发奖状态(1已发0未发)\t,中奖时间\t,校区\t,是否是会员(1是会员0不是会员)\t,\n"; foreach ($list as $key => $value) { foreach ($value as $k => $v) { $row = $v . "\t,"; $html .= $row; } $html .= "\n"; } $filename = "中奖记录----" . $lottery["title"]; header("Content-type:text/csv"); header("Content-Disposition:attachment; filename=" . $filename . ".csv"); echo $html; exit;直接访问该路由即可

wechat公众号

韩昊杰4年前

0 0 0

微信公众号推送模板消息，向指定的openID群发-辛达科技-一个只分享技术的站

微信公众号推送模板消息，向指定的openID群发

PHP微擎简易导表程序 <?php global $_GPC, $_W; $aid = $_GPC["aid"]; $lottery = pdo_get("me_daticj_lottery", array("uniacid" => $_W["uniacid"], "id" => $aid)); $condition = " a.uniacid = '{$_W["uniacid"]}' AND a.aid = {$aid} AND a.userid = b.id AND a.awardid = c.id"; if (!empty($_GPC["nickname"])) { $condition .= " AND b.nickname LIKE '%{$_GPC["nickname"]}%'"; } if (!empty($_GPC["realname"])) { $condition .= " AND b.realname LIKE '%{$_GPC["realname"]}%'"; } if (!empty($_GPC["mobile"])) { $condition .= " AND b.mobile LIKE '%{$_GPC["mobile"]}%'"; } $condition .= " AND a.hasAward=1 ORDER BY a.id DESC"; $list = pdo_fetchall("SELECT b.nickname,b.realname,b.mobile,c.award_type,c.award_name,a.status,a.createtime,b.xiaoqu,b.isvip FROM " . tablename("me_daticj_winner") . " a, " . tablename("me_daticj_user") . " b, " . tablename("me_daticj_awards") . " c WHERE {$condition}"); $html = "\xef\xbb\xbf"; $html .= "微信昵称\t,真实姓名\t,手机号码\t,奖品类型\t,奖品名称\t,发奖状态(1已发0未发)\t,中奖时间\t,校区\t,是否是会员(1是会员0不是会员)\t,\n"; foreach ($list as $key => $value) { foreach ($value as $k => $v) { $row = $v . "\t,"; $html .= $row; } $html .= "\n"; } $filename = "中奖记录----" . $lottery["title"]; header("Content-type:text/csv"); header("Content-Disposition:attachment; filename=" . $filename . ".csv"); echo $html; exit;直接访问该路由即可

wechat公众号

韩昊杰4年前

0 0 0

上一页 1 ...12 13 14 下一页