data key in by user not shown
Posted: Fri Jul 17, 2009 1:15 am
Hi, i checked my code and trying my best to improve it. But wonder why, the data that key in by user is still not showing... I had created mysql db and table... but wonder y data key in by user stl wont be able to insert into db and shown out in the browser....
Can you please guide me?
Thanks in advance
Can you please guide me?
Thanks in advance
Code: Select all
<html>
<?php
$database="websites_database";
$user = 'root';
$password = '';
mysql_connect("localhost",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO websitestable VALUES ('$websites','$destination')";
$query="SELECT * FROM websitestable";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close();
$i=0;
while ($i < $num) {
$websites=mysql_result($result,$i,"websites");
$destination=mysql_result($result,$i,"destination");
$i++;
}
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Websites</font></th>
<th><font face="Arial, Helvetica, sans-serif">Destination</font></th>
</tr>
<?
$i=0;
while ($i < $num) {
$websites=mysql_result($result,$i,"websites");
$destination=mysql_result($result,$i,"destination");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo $websites; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $destination; ?></font></td>
</tr>
<?
$i++;
}
echo "</table>";
?>
<body>
<h1>Goverment Websites</h1>
<form action="insert.php" method="post">
<p>Website address:</p>
http:// <input type="text" name="websites" size="60">
destination: <input type="text" name="destination" size="30">
<input type="submit" value="Submit">
</form>
</html>