please can somebody help me with php mysql

mikejkellyuk · #1 (**permalink**) 11-22-2007, 08:18 AM

PHP Code:

  <?php
$con = mysql_connect("localhost", $username, $password, $new_link);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
else
  {
   echo "connect made";    
}

mysql_select_db("addressbook", $con);


mysql_query("INSERT INTO hoursworked (firstname, mon, tue)
VALUES ('mike', '6 hours', '4 hours')")
 
 

?>

any help is good thanks
mike php mysql novice

TeraTask · #2 (**permalink**) 11-22-2007, 10:32 AM

First, please don't post your actual username and password. I removed them for you.

You can probably tell b/c I changed your fourth parameter to $new_link that something's wrong there, and you'd be right. That's supposed to be a boolean value (see the documentation here PHP: mysql_connect - Manual ).

To connect to a database, use the sample code shown below:

Quote:

Originally Posted by http://us2.php.net/manual/en/function.mysql-select-db.php

PHP Code:

 
  <?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

// make foo the current db
$db_selected = mysql_select_db('foo', $link);
if (!$db_selected) {
    die ('Can\'t use foo : ' . mysql_error());
}
?>

The only other thing I see is the missing semicolon on the last line. It should be

PHP Code:

  mysql_query("INSERT INTO hoursworked (firstname, mon, tue)
VALUES ('mike', '6 hours', '4 hours')");

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The Following 2 Users Say Thank You to TeraTask For This Useful Post:
HelloWorld (11-22-2007), mikejkellyuk (11-22-2007)