Cheap VPS & Xen Server


Residential Proxy Network - Hourly & Monthly Packages

PHP MySQL Insert


PHP mysql_query() function is used to insert record in a table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

  • mysqli_query()
  • PDO::__query()

PHP MySQLi Insert Record Example

Example

  1. <?php
  2. $host = ‘localhost:3306’;
  3. $user = ;
  4. $pass = ;
  5. $dbname = ‘test’;
  6. $conn = mysqli_connect($host$user$pass,$dbname);
  7. if(!$conn){
  8.   die(‘Could not connect: ‘.mysqli_connect_error());
  9. }
  10. echo ‘Connected successfully<br/>’;
  11. $sql = ‘INSERT INTO emp4(name,salary) VALUES (“sonoo”, 9000)’;
  12. if(mysqli_query($conn$sql)){
  13.  echo “Record inserted successfully”;
  14. }else{
  15. echo “Could not insert record: “. mysqli_error($conn);
  16. }
  17. mysqli_close($conn);
  18. ?>

Output:

Connected successfully
Record inserted successfully

Comments

comments