Thilo Klein wrote:
Dear readers,

I am new to relational DB but not to MySQL & PHP in general. I created a RDB using Struggling with the program's complexity I managed to create a set of databases being interconnected via (foreign) keys.

What I want to know is how to use this database via php. How does my ER-Diagram come into play? In other words I want to know more about a general approach to using relational databases via php.

Regards from .de

PS: If you speak german, answer in german. Appreciate it.

well you export the db you designed into ansi sql and use the cmdline mysql client to create a db with it...

this guide

seems ok on the first look..

from php you access the db like this...

$username = "pee_wee";
$password = "let_me_in";
$hostname = "localhost";      
$dbh = mysql_connect($hostname, $username, $password)
        or die("Unable to connect to mysql");
print "connected to mysql<br>";
$selected = mysql_select_db("first_test",$dbh)
        or die("Could not select first_test");
if (mysql_query("insert into people values('5','Hazel','Burger')")) {
  print "successfully inserted record";
else {
          print "Failed to insert record";


PHP General Mailing List (
To unsubscribe, visit:

Reply via email to