php - Mysql_query insert into -

php - Mysql_query insert into -

i have problem insert mysql query. if perform on localhost, works fine. however, on webserver doesn't want work, , don't know why. tried alter syntax in many ways though.

<? if( $_post ) { $dbhost ='ip address'; $dbuser = 'username'; $dbpassword = 'password'; $database = 'db1214492_davidmszabo'; $con = mysql_connect($dbhost, $dbuser, $dbpassword); if (!$con) { die('could not connect: ' . mysql_error()); } mysql_select_db($database, $con); $users_name = $_post['name']; $users_email = $_post['email']; $users_website = $_post['website']; $users_comment = $_post['comment']; $users_name = mysql_real_escape_string($users_name); $users_email = mysql_real_escape_string($users_email); $users_website = mysql_real_escape_string($users_website); $users_comment = mysql_real_escape_string($users_comment); $articleid = $_get['id']; if( !is_numeric($articleid) ) die('invalid article id'); $query = " insert `db1214492_davidmszabo`.`comments` (`id`, `name`, `email`, `website`, `comment`, `timestamp`, `articleid`) values (null, '$users_name', '$users_email', '$users_website', '$users_comment', current_timestamp, '$articleid');"; /* insert `inmoti6_mysite`.`comments` (`id`, `name`, `email`, `website`, `comment`, `timestamp`, `articleid`) values (null, '$users_name', '$users_email', '$users_website', '$users_comment', current_timestamp, '$articleid');";*/ $sql = "insert `db1214492_davidmszabo`.`comments` (`id`, `name`, `email`, `website`, `comment`, `timestamp`, `articleid`) values (null , '$users_name', '$users_email', '$users_website', '$users_comment', current_timestamp, '$articleid')"; /* $sqltwo = 'insert `db1214492_davidmszabo`.`comments` (`id`, `name`, `email`, `website`, `comment`, `timestamp`, `articleid`) values (\'\', \'cd\', \'ddsa@enauk.com\', \'dda.com\', \'dsaf\', current_timestamp, \'1\');'; - code copied phpmyadmin when insert in database */ mysql_query($query); echo "<h2>thank comment!</h2>"; mysql_close($con); } ?>

// edited post - , don't seek connecting localhost. got ip address @ $dbhost = "" - error got adding 2 more: lines error_reporting(e_all); , ini_set('display_errors', 1); - , changed connection mysqli_connect();

warning: mysql_real_escape_string(): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 105 warning: mysql_real_escape_string(): link server not established in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 105 warning: mysql_real_escape_string(): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 106 warning: mysql_real_escape_string(): link server not established in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 106 warning: mysql_real_escape_string(): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 107 warning: mysql_real_escape_string(): link server not established in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 107 warning: mysql_real_escape_string(): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 108 warning: mysql_real_escape_string(): link server not established in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 108 warning: mysql_query(): can't connect local mysql server through socket '/var/lib/mysql/mysql.sock' (2) in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 155 warning: mysql_query(): link server not established in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 155

and after comment: give thanks comment error this:

warning: mysql_close() expects parameter 1 resource, object given in /usr/local/pem/vhosts/479307/webspace/httpdocs/davidmszabo.com/articles/manage_comments.php on line 165

what construction of table inserting into? if id column auto_increment - should not trying insert it.

also, i'm not sure if current_timestamp valid value (especially if column datetime type). perhaps more experienced mysql guru can right me. utilize now() instead

try this:

$sql = "insert `$database`.`comments` (`name`, `email`, `website`, `comment`, `timestamp`, `articleid`) values ('$users_name', '$users_email', '$users_website', '$users_comment', now(), '$articleid')";

php mysql