preacher
-
Posts
2 -
Joined
-
Last visited
Never
preacher's Achievements
Newbie (1/5)
0
Reputation
-
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]
-
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" ?>