我与cpanel共享服务器。我有mysql数据库在服务器上。我想通过在本地计算机上运行php脚本插入或更新数据到远程数据库。请给我一个解决办法。谢谢。
/* 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*/
这是连接到MySQL远程数据库并从本地csv文件插入的一行查询
mysqlimport --ignore-lines=1 --fields-terminated-by=',' --lines-terminated-by="n" --local -u <username> -p'<password>' -h <hostname> -P <port> <database> <tablename>.csv