PHP & MySQL Question

DJMK4 · 30 Jan 2006 at 13:04

You know you have to create a php frontend for the database, well i have done that on a new blank page and its displaying data from the database, if i wanted to integrate this onto a page i have already designed..And more specifically in a specified content div..can i do this??

How do i add php script to an already coded xhtml page?

Berserker · 30 Jan 2006 at 13:37

You can embed PHP anywhere in a page. Just rename it to .php and use the usual <?php ... ?> tags wherever you need them.

Dj_Jestar · 30 Jan 2006 at 13:41

you just put the content inside the div..

Code:

<div class="table">
    <table>
        <tr><th>col1</th><th>col2</th><th>t3</th></tr>
<?php
while ($row = mysql_fetch_assoc($result)) {
    echo "\t\t<tr><td>" . htmlentities($row['col1']) . '</td><td>' . htmlentities($row['col2']) . '</td><td>' . htmlentities($row['col3']) . "</td></tr>\n";
}
?>    </table>
</div>

DJMK4 · 30 Jan 2006 at 14:18

Dj_Jestar · 30 Jan 2006 at 14:37

might want to remove your db username and password..

DJMK4 · 30 Jan 2006 at 19:28

Done, but anyone see any reason to make it flicker and not display menu items properly?

Edit: A new discovery, the problem only occours in firefox browser aswel, works fine in IE

DJMK4 · 30 Jan 2006 at 23:33

Nix · 31 Jan 2006 at 05:21

Sorry mate, I've got exp with PHP but when it came to MySQL I couldn't get the damn thing working. Just really weird. I have since then forgotton all knowledge. Probably could back easy enough though.

Dj_Jestar · 31 Jan 2006 at 09:36

The flickering is nowt to do with PHP or MySQL I'm afraid.. that's down to browsers interpretation of (X)HTML and/or JavaScript.

DJMK4 · 31 Jan 2006 at 12:55