Jadual Kandungan
Rumah
pembangunan bahagian belakang
tutorial php
php小白求教form display and update mysql的问题, 可以正常dispaly，无法update
pembangunan bahagian belakang
tutorial php
php小白求教form display and update mysql的问题, 可以正常dispaly，无法update
php小白求教form display and update mysql的问题, 可以正常dispaly，无法update
mysql
php
<?php define('DB_NAME', 'form');
define('DB_USER', 'root');
define('DB_PASSWORD', '123456');
define('DB_HOST', 'localhost');
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link)
{
die('could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db(DB_NAME, $link);
if (!$db_selected)
{
die('Can\'t use ' .DB_NAME .':' . mysql_error());
}
$query = "SELECT * FROM articles";
$result = mysql_query($query) or die(mysql_error());
?>Salin selepas log masuk
Salin selepas log masuk
<code><div class="content-holder">
<form action="" method="post">
<table border='1' cellpadding='10' id='ViewTable'>
<tr>
<th>title</th>
<th>id</th>
</tr>
<?php
while($row = mysql_fetch_array($result))
{
$id = $row['id'];
$title = $row['title'];
?>
<tr>
<td>
<input type="textbox" class="TextAreaTitle" name="title" value="<?=$title?>"></input>
<input type="hidden" name="id" value="<?=$title?>"></input>
</td>
<td><?=$id?></td>
</tr>
<?php
}
?>
</table>
<input type="submit" name="update" class="submitlink" Value="update">
</form>
</div>
<?php if(isset($_POST['update']))
{
for ($i=count($_POST['id']); $i--;)
{
$id = $_POST['title'][$i];
$title = $_POST['id'][$i];
mysql_query("UPDATE articles SET title= $title WHERE id= $id ");
}
}
?></code>Salin selepas log masuk
Salin selepas log masuk
