How do you run a MySQL query from PHP file?

Answer 1

Here is a simple script that you can do to run a MySQL query after you have set a database up.

<?php

// Database Settings

$db['hostname'] = "localhost";

$db['username'] = "<db username>";

$db['password'] = "<db password>";

$db['database'] = "<db name>";

// Connect to MySQL

$connect = mysql_connect($db['hostname'], $db['username'], $db['password']);

// Select Database

mysql_select_db($db['database'], $connect);

// Do MySQL Query

mysql_query("INSERT INTO table_name SET field_name = '1234567890'");

// Close MySQL

mysql_close($connect);

?>

Obviously you will need to use your own MySQL settings and database details, but this gives you a general overview of how you can do it.