preacher
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by preacher
-
-
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"
?>
Can't get my php script to connect to mysql
in PHP Coding Help
Posted
[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]