作者satisf (无聊无聊赶报告)
看板PHP
标题[请益] 关於资料库连结
时间Sun Jan 6 17:09:32 2008
<html>
<head><title></title></head>
<body background="B-blue03.gif">
<form action="h11.php" method="POST">
<table border="1">
<thead>
<tr><td colspan=2 align=center><p>个人资料</p></td></tr>
</thead>
<tr>
<td>姓名</td>
<td><input type="text" size="15" name="name"></td>
</tr>
<tr>
<td>性别</td>
<td>
<p align="left"><input type="radio" name="gender" value="男姓"><font face="标
楷体">男姓</font>
<input type="radio" name="gender" value="女姓"><font face="标楷体">女姓
</font>
</p>
</td></tr>
<tr>
<td>身分证字号</td>
<td><input type="text" size="20" name="id_num"></td>
</tr>
<tr>
<td>身高</td>
<td><input size=10 name=hght>公分</td></tr>
<tr>
<td> 考试证照或<br>其他技能</td><td>
<textarea name=license rows=3 cols=65></textarea></td>
</tr>
<tr>
<td>自传</td><td>
<textarea name=memoir rows=25 cols=80></textarea></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="Insert" value="送出">
<input type="reset" value="重设栏位"></td>
</tr>
</form>
</table>
</body>
</html>
--------------------------------------
<?php
$name=$_POST["name"];
$gender=$_POST["gender"];
$id_num=$_POST["id_num"];
$hght=$_POST["hght"];
$license=$_POST["license"];
$menmoir=$_POST["menmoir"];
IF (isset($_POST["Insert"])) {
$link = @mysqli_connect("localhost","zxczx","963210")
OR DIE("无法开启MySQL资料库连结!<br>");
mysqli_select_db($link, "lifedb");
echo "ddddd";
$sql="INSERT INTO jobst(name,gender,hght,license,menmoir) VALUES('"
.$_POST["name"]."','".$_POST["gender"]."','".$_POST["hght"]."','".$_POST["license"]."','".$_POST["menmoir"]."')";
ECHO "<b>SQL指令: $sql</b><br>";
// 送出Big5编码的MySQL指令
mysqli_query($link, "SET CHARACTER SET utf8");
mysqli_query($link,
"SET collation_connection = 'utf8_unicode_ci'");
mysqli_query($link, $sql);
mysqli_close($link); // 关闭资料库连结
}
?>
-------------------------
连结上不知道出了甚麽问题
有大大可以解决一下吗
感激不尽!!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.116.58.89