Connecting to MYSQL database

[Nexus10]

<?php
$host = "localhost";
$user = "ericsmi_admin";
$password = "password";
$database = "ericsmi_Users"; 

mysql_connect($host, $user, $password) or die(mysql_error("DIED"));
mysql_select_db($database) or die("Error: Could not connect to database"); 

$query = INSERT INTO Users(user, date_registered, password, email) VALUES ("eric", "12/12/12, test, eric@eric.com");
mysql_query($query) or die("Error: data not inserted");
echo("Data inserted");?>

 

Nothing happens, nothing is printed, not no error message.

[phpchamps]

whats in the view source?

[Nexus10]

Still nothing when using the full tag.

[phpchamps]

print insert query and try to run it through phpmyadmin

[Nexus10]

print insert query and try to run it through phpmyadmin

 

I don't understand (new to PHP)?

[Nexus10]

?

[phpchamps]

Try this and tell me whts the output...

error_reporting(E_ALL);
$host = "localhost";
$user = "ericsmi_admin";
$password = "password";
$database = "ericsmi_Users"; 

mysql_connect($host, $user, $password) or die(mysql_error("DIED"));
mysql_select_db($database) or die("Error: Could not connect to database"); 

$query = "INSERT INTO Users(user, date_registered, password, email) VALUES ('eric', '12/12/12', 'test', 'eric@eric.com')";
mysql_query($query) or die("Error: data not inserted");
echo("Data inserted");

[dabaR]

$query = INSERT INTO Users(user, date_registered, password, email) VALUES ("eric", "12/12/12, test, eric@eric.com");

 

There are no quotes around the query string. You need:

$query = 'INSERT INTO Users(user, date_registered, password, email) VALUES ("eric", "12/12/12, test, eric@eric.com")';

[dabaR]

Oh, and....

 

Get into the habit of starting all your scripts with

error_reporting(E_ALL);

[Nexus10]

Try this and tell me whts the output...

 

Error: data not inserted

 

[phpchamps]

cool now problem is in your insert query... get it right.. simple...

 

 

 

[Nexus10]

Thanks, it works now

[phpchamps]

cool....mark this post as solved...