Not passing information of one page to another

ruprety

Hello,

Each time, I fill the values on the newbook.html and click the Submit button to add them on the database, the error line “You have not entered all the required details…” which I wrote in insert_book.php executes.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
newbook.html

<html>

<head>
<title>Book-O-Rama - New Book Entry</title>
</head>

<body>

<h1>Book-O-Rama - New Book Entry</h1>

<tr>
<td>Author</td>
<td><input type=text name=author maxlength=30 size=30><br></td>
</tr>

<tr>
<td>Title</td>
<td><input type=text name=title maxlength=60 size=30><br></td>

</tr>

<tr>
<td>Price $</td>
<td><input type=text name=price maxlength=7 size=7><br></td>
</tr>

</table>
</form>
</body>

</html>

!!!!!!!!!!!!!!!!!!!!!!!!!!
insert_book.php

<html>
<head>
<title>Book-O-Rama Book Entry Results</title>
</head>

<body>

<h1>Book-O-Rama Book Entry Results</h1>

<?
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", "upretyr1_sqluser", "sql488704");

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

mysql_select_db("upretyr1_userInfo");

$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>

Neumy

Hi Ruprety,

I see a few things that could cause some issues and re-wrote a few things for you:

With netbook.html; make sure you have QUOTES around any text in your HTML tags.
For example: <input type='text' name='title' maxlength=60 size=30>
Some browsers and OS have a hard time distinguishing the tags if the text is not in quotes.

With insert_book.php;
1) Declare all your variables before you use them. This is best practice and will make sure your code will not cause problems for you later.
For example: $author="";

2) Check and manage all variables that you're pulling in from a FORM.
For example: if(isset($POST['author'])) $author = StripSlashes($POST['author']);
This will make sure the two pages are communicating correctly.

<h1>Book-O-Rama Book Entry Results</h1>

<?php
$isbn=""; $author=""; $title=""; $price="";
if(isset($_POST['isbn']))   $isbn   = StripSlashes($_POST['isbn']);
if(isset($_POST['author'])) $author = StripSlashes($_POST['author']);
if(isset($_POST['title']))  $title  = StripSlashes($_POST['title']);
if(isset($_POST['price']))  $price  = StripSlashes($_POST['price']);
if ($isbn=="" || $author=="" || $title=="" || $price=="")
{
   echo "You have not entered all the required details.<br>";
   echo "<a href='netbook.html'>Please go back and try again.</a>";
   exit;
}

...

I hope this helps.

ruprety

Thank you so much. My frustation is over.
By the way, it is working here on my web hosting account. Since I install Apache, PHP, and MySQL 5.1 on my local machine, I also wanted to run both PHP and MySQL locally. As my understanding to connect to the MySQL 5.1 on the local machine, I write the following parameters in mysql_pconect method. The password is my real password, but the remaining I thought I should leave them as a default. So the “localhost” and “root” are the default since I install MySQL 5.1 on the same machine.

Even though, I did all these, I couldn’t able to connect to my database. Correct me where I make a mistake. The most likely mistake I think I made is passing wrong parameters in mysql_connect method. Also, Is there any way to see my MySQL database and table by just clicking rather than typing in the command prompt.

Below is the code what parameters I pass:

@ $db = mysql_pconnect("localhost", "root", "488704");

mysql_select_db("information");


$query = "insert into books values ('".$isbn."', '".$author."', '".$title."', '".$price."')";
       echo "under from $query";

Neumy

I'm not a DB expert; in fact, I built a Class years ago that I've been using all my DB access - and I haven't touched it in years. But looking at your logic, I see nothing wrong.

My advice is to try to figure out where exactly the issue lies. For example:

1) Is your data correct in your mysql_pconnect? Your values look correct to me; but you might want to confirm that you can connect to the DB with these values. Try to connect via the commandline with:
C:> mysql -u root -h localhost -p
Then type your password (488704). If you can connect and get the mysql> - then you should be fine.

2) Is your DB named correctly? Once you're in the MySQL commandline - try to connect to the DB. Try to connect to the DB with:
mysql> connect information
Hopefully this will be successful - you should be fine here.

3) Before you try to "insert", try a simple "select" to verify that you're able to access the DB/Table. It could be that the ISBN is a numeric field and you're trying to put quotes around it. Try these two queries in hopes that you can find out where the issue lies:
mysql> select author from books;
This should verify that you're accessing the DB correctly.
mysql> insert into books values ('1234','You','My Book','$3.44');
Hopefully MySQL will give an error message somewhere during these steps and you can figure out why you aren't connecting.

Hopefully this helps (but I may not be the best in helping you out with DB question - you might want to post a new question to get fresh eyes).

ruprety

Thank you so much for your help. It does work in the command line. These are the line I get when I enter this:

C;\mysql -u root -h localhost -p information
Enter password: 488704
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.37-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

I am successfully adding, deleting, or selecting the values into the MySQL dabase through command line. But when I insert the values from one page to another to the database, I am getting error like this: Fatal error

Even after I reset the path of environmental variable and reconfigure the php.ini file, by commenting out the semi colon before this statement “;extension=mysql.dll to execute the MySQL database, I am still unable to connect to the database from browser.

ruprety

Thank you so much for your help. It does work in the command line. These are the line I get when I enter this:
C;\mysql -u root -h localhost -p information
Enter password: 488704
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.37-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

ruprety

😕:o

Neumy

Now were getting into a bit of a grey area for my troubleshooting skills.

It sounds like MySQL is configured correctly, but PHP may not be configured to connect to MySQL. I would check your php.ini configuration and ensure that extension=php_mysql.dll is uncommented. Beyond that, I may not be much of a help here.

I did run the below through my server and had positive results (with changed MySQL login information). I don't think anything is wrong with your code, but you may have an issue with configuration. Good luck!

$db = mysql_pconnect('localhost','root','488704');

if(!$db)
{
   echo "Error: Could not connect to database. <a href='netbook.html'>Please try again later.</a>";
   exit;
}

mysql_select_db('information');

$query = "select author from books;";
echo $query."<br><br>";

$result = mysql_query($query);
if ($result)
   echo mysql_affected_rows()." book inserted into database.";