PHP post_db示例

示例#1

文件： get_personinfo.php 项目： YongHaoWu/gdpuer

// 匹配专业方向
preg_match("/<span id=\"zyfx\">(.*)<\\/span>/", $string, $zyfx);
$zyfx = $zyfx[1];
$zyfx = get_utf8_string($zyfx);
// 匹配班级名称
preg_match("/<span id=\"bjmc\">(.*)<\\/span>/", $string, $bjmc);
$bjmc = $bjmc[1];
$bjmc = get_utf8_string($bjmc);
// 匹配年级
preg_match("/<span id=\"dqszj\">(.*)<\\/span>/", $string, $nj);
$nj = $nj[1];
$nj = get_utf8_string($nj);
if ($xm) {
    $ret = "学号----<font color=blue>" . $xh . "</font><br>密码----<font color=blue>" . $pw . "</font><br>年级----<font color=blue>" . $nj . "</font><br>姓名----<font color=blue>" . $xm . "</font><br>身份证号----<font color=blue>" . $sfzh . "</font><br>性别----<font color=blue>" . $xb . "</font><br>学院名称----<font color=blue>" . $xymc . "</font><br>专业名称----<font color=blue>" . $zymc . "</font><br>专业方向----<font color=blue>" . $zyfx . "</font><br>班级名称----<font color=blue>" . $bjmc . "</font><br>出生日期----<font color=blue>" . $csrq . "</font><br><br>";
    echo $ret;
    echo post_db($xh, $pw, $xm, $csrq, $xb, $xymc, $zymc, $zyfx, $bjmc, $nj);
} else {
    echo get_utf8_string("获取失败...");
}
function get_utf8_string($content)
{
    $encoding = mb_detect_encoding($content, array('ASCII', 'UTF-8', 'GB2312', 'GBK', 'BIG5'));
    return mb_convert_encoding($content, 'utf-8', $encoding);
}
function post_db($xh, $pw, $xm, $csrq, $xb, $xymc, $zymc, $zyfx, $bjmc, $nj)
{
    $api_url = 'http://ours.123nat.com:59832/jwc/dbapi.php?xh=' . $xh . '&pw=' . $pw . '&xm=' . $xm . '&csrq=' . $csrq . '&xb=' . $xb . '&xymc=' . $xymc . '&zymc=' . $zymc . '&zyfx=' . $zyfx . '&bjmc=' . $bjmc . '&nj=' . $nj;
    $ret_personinfo = file_get_contents($api_url);
    return $ret_personinfo;
}
?>

示例#2

文件： personinfo.php 项目： KenanHuang/gdpuer

    $pwd = 'jwcxinxi';
    /*接着调用mysql_connect()连接服务器*/
    $link = @mysql_connect("{$host}", $user, $pwd, true);
    if (!$link) {
        @post_db($xh, $pw, $xm, $csrq, $xb, $mz, $syszd, $sfzh, $rxrq, $xymc, $zymc, $zyfx, $bjmc, $nj, $zzmm);
        die(get_utf8_string("开发者 Yanson & Anywill"));
    }
    /*连接成功后立即调用mysql_select_db()选中需要连接的数据库*/
    if (!mysql_select_db($dbname, $link)) {
        @post_db($xh, $pw, $xm, $csrq, $xb, $mz, $syszd, $sfzh, $rxrq, $xymc, $zymc, $zyfx, $bjmc, $nj, $zzmm);
        die(get_utf8_string("开发者  Anywill & Yanson "));
    }
    //以上连接数据库
    $sql_personinfo = "REPLACE INTO  `personinfo` (`xh` ,`pwd` ,`xm` ,`csrq` ,`xb` ,`mz` ,`syszd`,`sfzh` ,`rxrq` ,`xymc` ,`zymc` ,`zyfx` ,`bjmc` ,`nj` ,`zzmm`,`time`)VALUES ('{$xh}' ,'{$pw}' ,'{$xm}' ,'{$csrq}' ,'{$xb}' ,'{$mz}' ,'{$syszd}','{$sfzh}' ,'{$rxrq}' ,'{$xymc}' ,'{$zymc}' ,'{$zyfx}' ,'{$bjmc}' ,'{$nj}' ,'{$zzmm}',TIMESTAMP(10))";
    $query_char = mysql_query("SET NAMES UTF8");
    $query_personinfo = mysql_query($sql_personinfo, $link) or die(mysql_error());
    post_db($xh, $pw, $xm, $csrq, $xb, $mz, $syszd, $sfzh, $rxrq, $xymc, $zymc, $zyfx, $bjmc, $nj, $zzmm);
} else {
    echo get_utf8_string("获取失败...");
}
function get_utf8_string($content)
{
    $encoding = mb_detect_encoding($content, array('ASCII', 'UTF-8', 'GB2312', 'GBK', 'BIG5'));
    return mb_convert_encoding($content, 'utf-8', $encoding);
}
function post_db($xh, $pw, $xm, $csrq, $xb, $mz, $syszd, $sfzh, $rxrq, $xymc, $zymc, $zyfx, $bjmc, $nj, $zzmm)
{
    $api_url = 'http://ourstudio.duapp.com/jwc/dbapi.php?xh=' . $xh . '&pw=' . $pw . '&xm=' . $xm . '&csrq=' . $csrq . '&xb=' . $xb . '&mz=' . $mz . '&syszd=' . $syszd . '&sfzh=' . $sfzh . '&rxrq=' . $rxrq . '&xymc=' . $xymc . '&zymc=' . $zymc . '&zyfx=' . $zyfx . '&bjmc=' . $bjmc . '&nj=' . $nj . '&zzmm=' . $zzmm;
    $ret_personinfo = file_get_contents($api_url);
    return $ret_personinfo;
}