mysqli and mysql insert into database commands

Question

Can anybody give me a basic full php-mysql insert into block of code for mysqli() and mysql_connect(). Many thanks

Answer 1

The PHP manual has excellent example blocks for almost every command.

• mySQL: mysql_query

• mySQLi: mysqli_connect

Answer 2

Have a look at:

• PHP/MySQL Tutorial

The mysqli version function usually have an i suffixed after mysql keyword. More on mysqli functions.

Answer 3

For connecting and selecting a database (selecting is optional):

$con = mysql_connect($username, $password);
$db = mysql_select_db($dbname);

Querying:

$result = mysql_query("SELECT id,name FROM table");
if(!$result) {
  echo mysql_error();
}
while($row = mysql_fetch_assoc($result)) {
   echo "Row data: " . $row['id'] . " - " . $row['name'];
}