How to make a submission form into Database?

[anon]

So whole INSERT script would look like:

<?
if(isset($_POST['name'])){
$name = $_POST['name'];
$url = $_POST['url'];
$description = $_POST['description'];

$query = "INSERT INTO `db_table` (`id`,`name`) VALUES ('','$name')";
$run = mysql_query($query);
}
?>

What do i add at the "INSERT INTO 'db_table' ....... part. It only lists the name variable

[p2grace]

The whole insert statement would look like this:

 

<?
if(isset($_POST['name'])){
$name = $_POST['name'];
$url = $_POST['url'];
$description = $_POST['description'];

$query = "INSERT INTO `db_table` (`id`,`name`,`url`,`description`) VALUES ('','$name','$url','$description')";
$run = mysql_query($query);
}
?>

[anon]

Where do i specify host name and so on?

[p2grace]

For best practice you'd usually put that information into a file and include it.  The code itself would need to be above the insert query.  Here's how to connect:

 

define("DB_USER","username");
define("DB_PASS","password");
define("DB_DATABASE","database");

mysql_connect('localhost',DB_USER,DB_PASS);
@mysql_select_db(DB_DATABASE) or die("Unable to select database!");
mysql_query("SET NAMES 'utf8'");

[anon]

I get this error

Parse error: syntax error, unexpected T_LOGICAL_OR in /home/redzero/public_html/direx/addurl.php on line 8

 

Line 8 is

@mysql_select_db(DB_DATABASE) or die("Unable to select database!");

[p2grace]

I've used that code a hundred times, there must be something else that's breaking before.  Can you post the code for me.

[anon]

Here it is:

 

define("DB_USER","*****");
define("DB_PASS","****");
define("DB_DATABASE","direx");

mysql_connect('localhost',DB_USER,DB_PASS);
@mysql_select_db(DB_DATABASE) or die("Unable to select database!");
mysql_query("SET NAMES 'utf8'");


if(isset($_POST['name'])){
$name = $_POST['name'];
$url = $_POST['url'];
$description = $_POST['description'];

$query = "INSERT INTO `addtable` (`id`,`Name`,`URL`,`Description`) VALUES ('','$name','$url','$description')";
$run = mysql_query($query);
}
?>

I did substitute the user and password; just keeping private 

[p2grace]

There's html syntax in the code that must have been placed when you copied it.

 

It must look identical to this:

 

define("DB_USER","*****");
define("DB_PASS","****");
define("DB_DATABASE","direx");

mysql_connect('localhost',DB_USER,DB_PASS);
@mysql_select_db(DB_DATABASE) or die("Unable to select database!");
mysql_query("SET NAMES 'utf8'");


if(isset($_POST['name'])){
$name = $_POST['name'];
$url = $_POST['url'];
$description = $_POST['description'];

$query = "INSERT INTO `addtable` (`id`,`Name`,`URL`,`Description`) VALUES ('','$name','$url','$description')";
$run = mysql_query($query);
}
?>

[anon]

same parse error but on line 9, same as original parse error. Wtf

[p2grace]

Try removing

 

mysql_query("SET NAMES 'utf8'");

[anon]

That's on line 10, but tried nonetheless

[p2grace]

What verison of php and mysql are you using?

[anon]

The latest i'm sure. I'm on CPanel 11