Question

How to add (insert) new record into MySQL table using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli('localhost', $db_user, $db_password, $db_name);

if ($con->connect_error) 
    die('Connection Error: ' . $con->connect_error);
    
$sql =  "INSERT INTO images (image_id, href, src, title, alt, width, height, big, add_date) 
                     VALUES (33, 'https://www.ws.com', 'https://www.ws.com/images/logo343.gif', 
                             'logo', 'logo ws', 25, 30, 0, '2016-07-08')";
                                 
if ($con->query($sql) === TRUE) 
    echo "New record created successfully";
else 
    echo "Error: " . $sql . "<br / >" . $con->error;
                                 
$con->close();


/*
run: 

New record created successfully 

*/

 

70+ SQL courses for beginners and professionals

Answer 2

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli('localhost', $db_user, $db_password, $db_name);

if ($con->connect_error) 
    die('Connection Error: ' . $con->connect_error);
    
$sql =  "INSERT INTO images (webpage_id, href, src, title, alt, width, height, bonus_image, add_date) 
                     VALUES (33, 'https://www.ws.com', 'https://www.ws.com/images/logo343.gif', 'logo', 'logo ws', 25, 30, 0, '2016-07-08'),
                            (34, 'https://www.ws2.com', 'https://www.ws2.com/images/logo343222.gif', 'logo22', 'logo ws22', 2522, 3022, 22, '2016-07-09')";
                                 
if ($con->query($sql) === TRUE) 
    echo "New record created successfully";
else 
    echo "Error: " . $sql . "<br / >" . $con->error;
                                 
$con->close();


/*
run: 

New record created successfully 

*/

 

70+ SQL courses for beginners and professionals