[SOLVED] Trouble with MySQL/php guestbook script

bananababe · May 18, 2009

I'm new to php and I'm trying to complete a class project where I wanted to include a guestbook on the site I created. I am trying to use this script from http://www.phpeasystep.com/phptu/15.html ( apparently the forums there are dead much to my disappointment) which is functioning, EXCEPT that it doesn't seem to be assigning the name, email and comment values to the variables because that info is not saved in the database. Only the id and date/time text areas are populated in the MySQL table and thus not showing up when the view page connects to the database to display each entry. I did not make any changes (I copied and pasted ALL the code) except to put in the correct variable info regarding my host/login/password/database name and table name. Below I xx'd out my username and password for the mysql database so that is not the problem - it is connecting to the database fine, just not assigning the variable information I think. I checked that the id's in the html match the variables. I THINK it is a setting on the table data? anyone got any ideas? I'd appreciate it very much.

Here's what I've got:

This is the php code I used to create the table in the MySQL database:

CREATE TABLE `guestbook` (

`id` int(4) NOT NULL auto_increment,

`name` varchar(65) NOT NULL default '',

`email` varchar(65) NOT NULL default '',

`comment` longtext NOT NULL,

`datetime` varchar(65) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

guestbook.php page: www.allenskillicorn.com/beta/phptests/guestbook.php

<tr>

<td><strong>Test Sign Guestbook </strong></td>

</tr>

</table>

<tr>

<td>

<tr>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

<td valign="top">Comment</td>

</tr>

<tr>

</tr>

</table>

</td>

</form>

</tr>

</table>

<tr>

<td><strong><a href="viewguestbook.php">View Guestbook</a> </strong></td>

</tr>

</table>

viewguestbook.php page: www.allenskillicorn.com/beta/phptests/viewguestbook.php

<tr>

<td><strong>View Guestbook | <a href="guestbook.php">Sign Guestbook</a> </strong></td>

</tr>

</table>

<br>

<?php

$host="localhost:3306"; // Host name

$username="XXXX"; // Mysql username

$password="XXXX"; // Mysql password

$db_name="allenski_guestbook"; // Database name

$tbl_name="guestbook"; // Table name

// Connect to server and select database.

mysql_connect("$host", "$username", "$password")or die("cannot connect server ");

mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";

$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){

?>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

<td valign="top">Comment</td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

<BR>

<?

}

mysql_close(); //close database

?>

viewguestbook.php page: www.allenskillicorn.com/beta/phptests/viewguestbook.php

<tr>

<td><strong>View Guestbook | <a href="guestbook.php">Sign Guestbook</a> </strong></td>

</tr>

</table>

<br>

<?php

$host="localhost:3306"; // Host name

$username="XXXX"; // Mysql username

$password="XXXX"; // Mysql password

$db_name="allenski_guestbook"; // Database name

$tbl_name="guestbook"; // Table name

// Connect to server and select database.

mysql_connect("$host", "$username", "$password")or die("cannot connect server ");

mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";

$result=mysql_query($sql);

while($rows=mysql_fetch_array($result)){

?>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>Email</td>

</tr>

<tr>

<td valign="top">Comment</td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

<BR>

<?

}

mysql_close(); //close database

?>

bananababe · May 18, 2009

The addguestbook.php script was MISSING the variables for the name, email and comment area. the script SHOULD have read as follows:

<?php

$host="localhost:3306"; // Host name

$username="XXXX"; // Mysql username

$password="XXXX"; // Mysql password

$db_name="allenski_guestbook"; // Database name

$tbl_name="guestbook"; // Table name

// Connect to server and select database.

mysql_connect("$host", "$username", "$password")or die("cannot connect server ");

mysql_select_db("$db_name")or die("cannot select DB");

$name=mysql_real_escape_string($_POST['name']); //This value has to be the same as in the HTML form file; this variable initialization was missing

$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file; this variable initialization was missing

$comment=mysql_real_escape_string($_POST['comment']); //This value has to be the same as in the HTML form file; this variable initialization was missing

$datetime=date("y-m-d h:i:s"); //date time

$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')";

$result=mysql_query($sql);

//check if query successful

if($result){

echo "Successful";

echo "<BR>";

echo "<a href='viewguestbook.php'>View guestbook</a>"; // link to view guestbook page

}

else {

echo "ERROR";

}

mysql_close();

?>

Sign In

[SOLVED] Trouble with MySQL/php guestbook script

Recommended Posts

bananababe

Link to comment

Share on other sites

bananababe

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information