allensim81
-
Posts
3 -
Joined
-
Last visited
Never
allensim81's Achievements
Newbie (1/5)
0
Reputation
-
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 <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>
-
Hi, I have 3 queries, 1st wil be creating table, 2nd will be inserting the data into the table and 3rd is to show the data... is it correct to put it like that? Or any solution for these? can you please guide me?
-
hi,i am newbie in php. I created a html page and included a php script and mysql in it. I tested, somehow it doesn't work.... Can you please guide me step-by-step? Thanks & appreciate your guidiance & help. Love Following is my code: <html> <?php $database="websites_database"; mysql_connect("localhost",$user,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="CREATE TABLE websitestable (websites varchar(100) NOT NULL,destination varchar(50) NOT NULL) $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>