用户封面
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;直接访问该路由即可
php
韩昊杰的头像-辛达科技-一个只分享技术的站韩昊杰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
使用JetBrains连接服务器ftp直接线上改代码-辛达科技-一个只分享技术的站

使用JetBrains连接服务器ftp直接线上改代码

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 1 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...121314
在手机上浏览此页面