Transfer php variables to html page

[Anon]

All,
I'm new to programming with php and have what is probably a super easy question. I have created a database and have successfully written the sql query to extract three different pieces of data; a manufacturer name, a model name and a url to a product literature page.

I now want to take those variables (Manufacturer, Model, and Link) and transfer them to an HTML page for display. How do I get the information to display in table form? There would be three columns; one corresponding to each variable. I'm assuming I would create a loop to create the correct number of table rows.

Any help would be GREATLY appreciated.

Karen Rosencrance
[e-mail]

[cordex]

Karen,
PHP creates HTML dynamically and sends it to the browser. in your PHP code you would include something like:

echo "<input type=text name=varnam value='$varnam'>";

to display the value in a text box.

[krosy]

Ben,
I want to put the variables into corresponding table cells. Is the principle the same?

[Anon]

or you could put the variables into the url:http://www.blah.com/index.php?var1=hi&var2=bye dont know if thats what you wanted or not tho

[mithril]

Yes ma'am, same thing.... only different🙂 I recall just reading a post you made asked about html table tag parameters, so I'm assuming that you've probably figured it out. However, just in case:

<?php

// code to connect to mysql and execute the select query

echo "<table>\n";

while ($myrow = mysql_fetch_array($myresult)) {

printf("<tr>\n<td>\n%s\n</td>\n<td>\n%s\n</td>\n<td>\n%s\n</td>\n</tr>\n", $myrow[0], $myrow[1], $myrow[2]);
}

echo "</table>\n";

?>

This will quite happily fill your table with all the info returned. The "%s" is the placeholder replaced by the variables which make up the rest of the printf() arguments. There must be as many "%s"'s as there are variables, or else everything get's loused up. You can use any valid <tr> or <td> paramter in the printf() function, just remember to escape the quote if you place the param's in quotes.

ie. <td align="center"> becomes <td align=\"center\">

HTH.

Geoff A. Virgo

[cordex]

Right-o Geoff. For some reason I thought I read form in Karen's first post.

[krosy]

Thanks Geoff! That solved part of my dilema. I did add to the echo "<table width='100%'>\n"; and it widened my table. I'm going to play around with it somemore to see if I can get it to center within the page.
I'm finding that it's tricky to try to replicate html formatting functionality using php.

Stay tuned and thanks again!
Karen