Question

php怎么修改表内字段内容

Answer 1

PHP code
$con=mysqli_connect('localhost','数据库用户名','数据库密码','数据库名');
$re=mysqli_query($con,'SELECT * FROM wdksm');

while($row = mysqli_fetch_assoc($re))
{
$id=$row['id'];
echo '日期:'.$row['time'].' ';
echo '部门:'.$row['bumen'].' ';
echo '姓名:'.$row["name"].' ';
echo ' 职务:'.$row["zhiwu"].'<br />';
echo '未打卡时间:'.$row["wdktime"].'<br />';
echo '未打卡原因:'.$row["wdkyy"].'<br />';
echo '部门责任人审核:'.$row["bmshtime"].' ';
echo '人事行政部/总经理审批:'.$row["rsshtime"].'<br />';
echo '<hr /><br />';
}
echo '<form name="bc" method="post" action=""> ';
echo '<input id="test" name="test" type="text" value="审核" />';
echo '<input type="submit" value="审核"/>';
echo '</form>';
$sql='UPDATE wdksm SET
bmshtime = \'' . $_POST['test'] . '\'
WHERE id = \'' .$id . '\'
';
mysqli_query($con,$sql);

Answer 2

1. 用$m=new  mysqli('ip','username',"password",'dbname');创建数据库对象

2.   if ($m->connect_errno) {

3.         printf("Connect failed: %s\n", $m->connect_error);

4.         exit();//链接失败时

5.     }

6. $m->query("set names  utf8");设置编码

7. $m->query("sql语句");非select无返回值

Answer 3

sql语句啊。