Problems with PHP/MySQL

[familyon]

Hi,

I'm having a problem using PHP in conjunction with MySQL. This is what I've done:

1. Created a MySQL database using cPanels
2. Created a table and inserted 3 data records into it using phpmyadmin
3. Wrote a PHP script to print out the data I entered in step #2. It worked with no problem
4. Added on to the end of that script some code to insert one more data record. That appeared to work well until I added more code to the script to print out the newly updated database. This showed that it really didn't get updated.

NOTE: I did the same thing on my godaddy account and the exact same thing happened so I suspect its something very simple I am doing wrong. Here's the code and output when I ran it: I also tried to create a table in a PHP script. It appeared to work well until I went to cPanels only to find the table not there.


//Connect To Database
$hostname='localhost';
$username='familyon_john';
$password='pasword';
$dbname='familyon_blog';
$usertable='your_tablename';
$yourfield = 'your_field';

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to MySQL! Please try again later.');
echo "Connected to MySQL
";
mysql_select_db($dbname)OR DIE ('Unable to connect to database! Please try again later.');;
echo "Connected to Database
";

// Print out the database
$query = "SELECT * FROM comments";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
echo $row['date']. " - ". $row['name']. " - ". $row['email']. " - ". $row['url']. " - ". $row['comment'];
echo "
"; }

// Attempt to insert something into database
$query="INSERT INTO `familyon_blog`.`comments` (
`day` ,
`name` ,
`email` ,
`url` ,
`comment` )
VALUES (
'2007-11-21', 'Katrina', 'kjlkdf@gmila.com', 'this.com', 'this is a katrina')"or die(mysql_error());
echo "Data Entered!";

// Print out the database
$query = "SELECT * FROM comments";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
echo $row['date']. " - ". $row['name']. " - ". $row['email']. " - ". $row['url']. " - ". $row['comment'];
echo "
"; }
?>


OUTPUT:

Connected to MySQL
Connected to Database
- John Vogel - sdfs@jkl .com - asdfsa@com - This is a test from John
- Nancy Vogel - sathren@t.com - jksldj.com - This is from Nancy
- David Vogel - sldkfj@dsk.com - dlkj.com - This is from David
Data Entered! - John Vogel - sdfs@jkl .com - asdfsa@com - This is a test from John
- Nancy Vogel - sathren@t.com - jksldj.com - This is from Nancy
- David Vogel - sldkfj@dsk.com - dlkj.com - This is from David

[lnxcode]

I'm not programmer. However, you may want to check that you have the right permissions on the database by going to >> cPanel >> MySQL >> changing the permissions to "All Permissions" then you should be set. Otherwise, you need to look at the code (I don't know PHP, or I'd help).

[familyon]

Thanks Denis,

I checked the permissions and I had all the possible permissions. I'll keep trying.

[itwasntme]

The problem is that you never ran your INSERT query.

The result is that you didn't insert the record and didn't receive an error message.

You just need to modify your code to run the INSERT query and you should be set. Change this part:

// Attempt to insert something into database
$query="INSERT INTO `familyon_blog`.`comments` (
`day` ,
`name` ,
`email` ,
`url` ,
`comment` )
VALUES (
'2007-11-21', 'Katrina', 'kjlkdf@gmila.com', 'this.com', 'this is a katrina')"or die(mysql_error());
echo "Data Entered!";

So that it looks like this:

// Attempt to insert something into database
$query="INSERT INTO `familyon_blog`.`comments` (
`day` ,
`name` ,
`email` ,
`url` ,
`comment` )
VALUES (
'2007-11-21', 'Katrina', 'kjlkdf@gmila.com', 'this.com', 'this is a katrina')";
$result = mysql_query($query) or die(mysql_error()); 
echo "Data Entered!";

I don't mean to be a pain in case you are coding this way by preference, but you can reduce your typing by eliminating all the single quotes except for string values in your SQL statements. So this:

$query="INSERT INTO `familyon_blog`.`comments` (
`day` ,
`name` ,
`email` ,
`url` ,
`comment` )
VALUES (
'2007-11-21', 'Katrina', 'kjlkdf@gmila.com', 'this.com', 'this is a katrina')"or die(mysql_error());
echo "Data Entered!";

ends up looking like this:

$query="INSERT INTO comments (
day,
name,
email,
url,
comment)
VALUES (
'2007-11-21', 'Katrina', 'kjlkdf@gmila.com', 'this.com', 'this is a katrina')";

It will save you a lot of typing.

[lnxcode]

itwasntme - you're a star! - Hopefully this will resolve that users problem Keep up the excellent work!

[itwasntme]

Thanks, Denis. I'm just trying to give back a little for all the help I have received here.