كود PHP:
article category:
<select name="category" size="1">
<option value="0" selected="selected">with out category</option>
<?php
include('config.php');
$result1 = mysql_query('select * from categorys');
while ($row1 = mysql_fetch_array($result1))
{
$id = $row1['id'];
$name = $row1['name'];
echo '<option value="'.$id.'">'.$name.'</option>';
}
?>
</select>
كود PHP:
$category = intval($_POST['category']);
$name = htmlspecialchars($_POST['name']);
$contents = htmlspecialchars($_POST['contents']);
if (mysql_query("insert into articles ( id, category, name, contents ) values ( null, '$category', '$name', '$contents' )"))
{
$id = mysql_insert_id();
echo '<strong>case:</strong> the article <em>'.$name.'</em> has bin add, you can see it from <a href="article.php?id='.$id.'">here</a>..';
}
else
{
echo "<strong>error:</strong> cannot add the article..";
}