我做的是一个调查程序,有多个页面。
第一次录入个人资料,然后跳转到第二个页面调查,然后第三、第四
现在的问题是第一次添加个人资料后如何取得添加的ID,数据库中ID为自动编号。下面是详细代码
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// some code
mysql_select_db("survey", $con);
function GetIP() { //获取IP
if ($_SERVER["HTTP_X_FORWARDED_FOR"])
$ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
else if ($_SERVER["HTTP_CLIENT_IP"])
$ip = $_SERVER["HTTP_CLIENT_IP"];
else if ($_SERVER["REMOTE_ADDR"])
$ip = $_SERVER["REMOTE_ADDR"];
else if (getenv("HTTP_X_FORWARDED_FOR"))
$ip = getenv("HTTP_X_FORWARDED_FOR");
else if (getenv("HTTP_CLIENT_IP"))
$ip = getenv("HTTP_CLIENT_IP");
else if (getenv("REMOTE_ADDR"))
$ip = getenv("REMOTE_ADDR");
else
$ip = "Unknown";
return $ip;
}
$t1=$_REQUEST['t1'];
$t2=$_REQUEST['t2'];
$t3=$_REQUEST['t3'];
$t4=$_REQUEST['t4'];
$t5=$_REQUEST['t5'];
$t6=$_REQUEST['t6'];
$tel=$_REQUEST['tel'];
$GetIP=GetIP();
$datetime=date("Y-m-d H:i:s");if(isset($_GET['action'])&&$_GET['action']==information)
{
$sql="insert INTO information (user_sex, user_age, user_job,income,address,district,tel,user_ip,datetime)
VALUES('$t1','$t2','$t3','$t4','$t5','$t6','$tel','$GetIP','$datetime')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else
echo '<script>location.href="survey2.php"</script>';
exit;
mysql_close($con);
}?>
survey2.php页面是一个表单页面,survey2.php还要提交到程序页面。如果要传值过去如何写呢?
另外:
另一个页面中改如何查找这个数据库?
第一次录入个人资料,然后跳转到第二个页面调查,然后第三、第四
现在的问题是第一次添加个人资料后如何取得添加的ID,数据库中ID为自动编号。下面是详细代码
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// some code
mysql_select_db("survey", $con);
function GetIP() { //获取IP
if ($_SERVER["HTTP_X_FORWARDED_FOR"])
$ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
else if ($_SERVER["HTTP_CLIENT_IP"])
$ip = $_SERVER["HTTP_CLIENT_IP"];
else if ($_SERVER["REMOTE_ADDR"])
$ip = $_SERVER["REMOTE_ADDR"];
else if (getenv("HTTP_X_FORWARDED_FOR"))
$ip = getenv("HTTP_X_FORWARDED_FOR");
else if (getenv("HTTP_CLIENT_IP"))
$ip = getenv("HTTP_CLIENT_IP");
else if (getenv("REMOTE_ADDR"))
$ip = getenv("REMOTE_ADDR");
else
$ip = "Unknown";
return $ip;
}
$t1=$_REQUEST['t1'];
$t2=$_REQUEST['t2'];
$t3=$_REQUEST['t3'];
$t4=$_REQUEST['t4'];
$t5=$_REQUEST['t5'];
$t6=$_REQUEST['t6'];
$tel=$_REQUEST['tel'];
$GetIP=GetIP();
$datetime=date("Y-m-d H:i:s");if(isset($_GET['action'])&&$_GET['action']==information)
{
$sql="insert INTO information (user_sex, user_age, user_job,income,address,district,tel,user_ip,datetime)
VALUES('$t1','$t2','$t3','$t4','$t5','$t6','$tel','$GetIP','$datetime')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else
echo '<script>location.href="survey2.php"</script>';
exit;
mysql_close($con);
}?>
survey2.php页面是一个表单页面,survey2.php还要提交到程序页面。如果要传值过去如何写呢?
另外:
另一个页面中改如何查找这个数据库?
$id=mysql_insert_id();
echo "<script>location.href='survey2.php?id=$id'</script>";survey2.php 页面通过 $id=$_GET[id] 获取id值,让查询数据库。