I am having shared server with cpanel.I have mysql database on server.I want to insert or update data to remote database by running php script on my local computer.Please give me solution. Thanks.
/* mysql database properties */
$host = 'mydomain.com'; // or I.P address of domain
$user = 'database user name';
$pass = 'database password';
$database = 'database Name';
$table = 'Table Name';
/* Database Connection */
$connection = mysql_connect($host,$user,$pass) or die (mysql_error());
mysql_select_db($database, $connection) or die(mysql_error());
$name = 'Amir Khan';
$age = '27';
/* Insert query */
$sql_query = "INSERT INTO $table (name, age) VALUES ('$name', '$age');";
$result = mysql_query($sql_query,$connection) or die(mysql_error());
/*update query too same like above*/
/* you can go mysqli or PDO for better query structure*/