作者ghostleader (小居批~)
看板Database
标题Re: [SQL ]
时间Thu Jun 26 17:55:12 2008
※ 引述《dinos (守护神)》之铭言：
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"
http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="design.css" rel="stylesheet" type="text/css">
<?php
$link=@mysql_connect("127.0.0.1","aaaa","1234") or die("无法连上伺服器
".mysql_error());
mysql_select_db(summer2008);
import_request_variables("p");
$mem=get_mem_data($reg[name],$reg[birth]);
if($mem)
{
echo "已经报名过了喔!";
}
else
{
echo "感谢您的报名<br>";
/** 国字冲码 **/
if(!get_magic_quotes_gpc())
{
foreach($reg as $col => $val)
{
$val=addslashes($val);
$reg[$col]=$val;
}
}
$i=0;
foreach($reg as $col => $val)
{
if($i)
$content.=",";
$content.="'".$reg[$col]." '";
$i=1;
}
mysql_query("SET NAMES utf8");
mysql_query("SET CHARACTER SET 'utf8'");
$sql="insert into register
(`name`,`sex`,`birth`,`id`,`school`,`eat`,`phone`,`mobile`,`addr`,`email`)
values(".$content.");";
if(mysql_query($sql))
echo "资料新增成功";
else
echo "资料新增失败";
}
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.71.78.30
※ 编辑: ghostleader 来自: 210.71.78.30 (06/26 17:56)
1F：推 PsMonkey:所以这篇是？ 06/27 01:27
2F：→ ghostleader:几乎全部的程式码 只不过资料输进去以後还是?字元 06/27 11:47