question about my design

tommyy

Hi all, i would like to create a php code which allow user insert data to mysql table and save it to a html file.

there are two part of my design,

the first part allow user insert data to mysql.. like this

<html>
<body>
<form action="insert.php" method="post">
<p>size:<input type="text" name="size" /></p>
<p>color: <input type="text" name="color" /></p>
<p>name: <input type="text" name="name" /></p>
<p>Length: <input type="text" name="length" /></p>
<p>heigth: <input type="text" name="heigth" /></p>
<input type="submit" />
</form>
</body>

</html>

this part work fine

the other part is the html template

<p>Color</p>

</TD>
<TD width="150" valign=top><p>AC1016</p>
<p> </p>

         	<p>Length</p>

         	<p>&nbsp;</p>

       	   <p><?php

mysql_connect(localhost);
@mysql_select_db("testtt") or die( "Unable to select database");

// Retrieve all the data from the "example" table
$result = mysql_query("SELECT * FROM example WHERE id IN (3)" )
or die(mysql_error());

// store the record of the "example" table into $row
$row = mysql_fetch_array( $result);
// Print out the contents of the entry

echo $row['name'];
?>
</p>
<p> </p>

       	   <p>Height</p>

</TD>

</TABLE>

The problem is that i want every column retrieve data from mysql, so according to my method, there will be a lot of php script (start from <?php.............?>) replace to color, size, length, height. This method seems so stupid, i would like to know how does you guys make it.

The second problem is that ("SELECT * FROM example WHERE id IN (3)" ). how can i automate the where id in (y) , i dont want to change every html to display the correct data. Could any body suggest method to me . thanks

johanafm

It's impossible for me to guess what "id IN (3)" is supposed to mean (other than exactly what it does: retrieve every row where id is 3; could just as well be written "id=3"). Where do you get 3 from? How are you supposed to get the other ids?
Once you change your SELECT statement to retrieve several rows at once you can

while ($row = mysql_fetch_array($result)) {
	# then use the exact same code to show each row as a table row
}

You ought to also stick to a consistent markup model. Either you keep your html markup in uppercase, and one of the HTML doctypes, or you stick to lower case and either HTML or XHTML doctypes. You should put your first table row within a thead element followed by a tr element. And furthermore the first row ought to consist of th elements rather than td.
All subsequent rows should be found within one tbody element, and each row within a tr element.

tommyy

there are a lot html file which contain different ID in (y) y= 1,2,3,4,5....
could this possible be automate, i dont wanna change every id to different number