Like to learn php Database, don't how

[Joan Garnet]

Hi shebul

Do you have all software installed??
Mysql
php
Apache
(I recommend using Mysql-front database editor as well)

Do you have any knowledge level of php ??

To start -->
the database has three rows :
id --> autoincrement - not null - primary - index - unique - unsigned
name --> varchar - 50
email --> varchar - 50
php script:

Code: Select all

<?php
$server = "localhost" ;
$login = "your_login" ;
$pass = "your_pass"; 
$table = "your_table";
$bbdd = "your_database";
$db=mysql_connect($server,$login,$pass);     
mysql_select_db($bbdd,$db); 

$sql="select * from ".$table." order by id desc"; 
$result=mysql_query($sql,$db); 

while ($row = mysql_fetch_array ($result)) { 
   echo $row["id"]."\n";
             echo $row["name"]."\n";
             echo $row["email"]."\n";
}
?>

This file should be placed in the htdocs directory C:/Apache Group/Apache/htdocs
Then go to your browser and type:
http://localhost/my_file_name.php
That's it.
bye!

[greg]

From the officical PHP site:

http://www.php.net/links.php

For MySQL, try:
http://www.awtrey.com/support/dbeweb/

or

http://hotwired.lycos.com/webmonkey/pro ... rial4.html