.php linking to a Database

Cork24

I trying to link a php.xhtml file to my data base in Localhost

I am using xampp in which i have a Database of estate inside that database i have the following tables

Client, branch, Staff, PropertyForSale,Owner,Viewing

I have 1 row inside the Client Table. in which i am trying to run a query that will show up in the webpage that i have,

its showing the page when i go http://localhost/Clients/data.php.xhtml

but it is not showing the query result.

am i better off going with Access & Front page?

Groinshot

Cork24 wrote: »

I trying to link a php.xhtml file to my data base in Localhost

I am using xampp in which i have a Database of estate inside that database i have the following tables

Client, branch, Staff, PropertyForSale,Owner,Viewing

I have 1 row inside the Client Table. in which i am trying to run a query that will show up in the webpage that i have,

its showing the page when i go http://localhost/Clients/data.php.xhtml

but it is not showing the query result.

am i better off going with Access & Front page?

to show the result of the query, you want to run the query, get the result, and print it somwhhere... Something like:

<?php
$con = mysql_connect("localhost","username","pw");
mysql_select_db("estate", $con);
$result = mysql_query("SELECT * FROM Client");

while($row = mysql_fetch_array($result))
  {
  print_r($row);
  }

mysql_close($con);
?>

That will run the query, and print out your returned object, one for each row!