allensim81 Posted July 15, 2009 Share Posted July 15, 2009 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> Quote Link to comment https://forums.phpfreaks.com/topic/166082-html-page-with-php-script-mysql/ Share on other sites More sharing options...
KevinM1 Posted July 15, 2009 Share Posted July 15, 2009 1. Are you sure you want to create a new table in this code? Is this page going to be viewed more than once by the same user(s)? If so, you should create the table manually, through whatever database management system you have access to (phpMyAdmin?), and only let the PHP script insert/update data. 2. Where do $websites and $destination come from? Quote Link to comment https://forums.phpfreaks.com/topic/166082-html-page-with-php-script-mysql/#findComment-875869 Share on other sites More sharing options...
J.Daniels Posted July 15, 2009 Share Posted July 15, 2009 What isn't working? I can see one problem. There is a syntax error: $query="CREATE TABLE websitestable (websites varchar(100) NOT NULL,destination varchar(50) NOT NULL) should be: $query="CREATE TABLE websitestable (websites varchar(100) NOT NULL,destination varchar(50) NOT NULL)"; However, that query will fail after the first time the script is run since the table will already be created. Quote Link to comment https://forums.phpfreaks.com/topic/166082-html-page-with-php-script-mysql/#findComment-875872 Share on other sites More sharing options...
allensim81 Posted July 16, 2009 Author Share Posted July 16, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/166082-html-page-with-php-script-mysql/#findComment-876207 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.