Jump to content

Archived

This topic is now archived and is closed to further replies.

preacher

Can't get my php script to connect to mysql

Recommended Posts

I have set up Apache, Mysql and php and from what i can tell. Its all working well. How i have this script which when i run gives me a blank screen. Some one help me please.

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'softna';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'auth';
mysql_select_db($dbname);
echo "database".$dbname"
?>

Share this post


Link to post
Share on other sites
change this

[code]mysql_select_db($dbname);[/code]

to this
[code]mysql_select_db($dbname, $conn);[/code]

Ray

Share this post


Link to post
Share on other sites
please is there any thing wrond with this script: I just can't get it to add data to the database table.

[code]<html>
<head>
  <title>Book-O-Rama Book Entry Results</title>
</head>
<body>
<h1>Book-O-Rama Book Entry Results</h1>
<?php
  // create short variable names
  $isbn=$_POST['isbn'];
  $author=$_POST['author'];
  $title=$_POST['title'];
  $price=$_POST['price'];

  if (!$isbn || !$author || !$title || !$price)
  {
    echo 'You have not entered all the required details.<br />'
          .'Please go back and try again.';
    exit;
  }

  $isbn = addslashes($isbn);
  $author = addslashes($author);
  $title = addslashes($title);
  $price = doubleval($price);

  @ $db = mysql_pconnect('localhost', 'root', 'softna');

  if (!$db)
  {
    echo 'Error: Could not connect to database.  Please try again later.';
    exit;
  }

  mysql_select_db('books',$db);
  $query = "insert into books values
            ('".$isbn."', '".$author."', '".$title."', '".$price."')";
  $result = mysql_query($query);
  if ($result)
      echo  mysql_affected_rows().' book inserted into database.';
?>

</body>
</html>[/code]

thanks
[b]EDITED BY WILDTEEN88: PLEASE USE THE CODE/PHP TAGS ([nobbc][code][/code] or [php][/php][/nobbc]) WHEN POSTING CODE TO THE FORUMS[/b]

Share this post


Link to post
Share on other sites
How many fields you have in the table?? If you have more than 4 then sql is not going to know where to put them. use SET of list the fields then the values for the insert.

IE:

[code]$query = "insert into books (`field1`, `field2`, `field3`, `field4`) values
            ('".$isbn."', '".$author."', '".$title."', '".$price."')";[/code]

OR
[code]  $query = "insert into books SET
            `field1` = '".$isbn."',
            `field2` = '".$author."',
            `field3` = '".$title."',
            `field4` = '".$price."'";[/code]
Ray

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.