PHP MySQL Inserting data in a database table using PHP script

Question

Using the given below php script, I connect to database and insert data in it. But the data is not getting inserted in my database table. It is also not throwing any error. Where is my code wrong?

<?php
$host = '127.0.0.1';
$uname='root';
$pswd='';
$myDB='portal';
if($myConn = new mysqli($host,$uname,$pswd))
    echo 'Connected to MySQL server successfully.</br>';

else
    echo 'Unable to connect to server</br>';

$database = mysqli_select_db($myConn,$myDB);
if($database)
    echo 'Connected to database...</br>';

else
    echo 'Database not found!</br>';

$var1='string1';
$var2='string2';
$query= "INSERT INTO users VALUES ($var1,$var2)";
$result = mysqli_query($myConn,$query) or die(mysqli_error($myConn));

?>

Jens · Accepted Answer · 2015-03-17 08:07:55Z

1

You have to add single quotes around the values:

$query= "INSERT INTO users VALUES ('$var1','$var2')

Or better use prepared statements. See this for an example.

answered Mar 17, 2015 at 8:07

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hsols · Accepted Answer · 2015-03-17 08:11:29Z

0

In your statement, you must define the names of the target tables in your database, that the values should be inserted into, like this:

$query= "INSERT INTO users (Name,Age) VALUES ('$name','$age')";

answered Mar 17, 2015 at 8:11

hsols

717 bronze badges

Comments

Nikola Drosakis · Accepted Answer · 2015-03-17 08:15:49Z

0

if users table have only two columns, or two plus an auto-incrementing id the query is:

INSERT INTO users VALUES ('$var1','$var2')

if there are more columns or a non primary id the query is:

INSERT INTO users (col1,col2) VALUES ('$var1','$var2')

You also miss a parameter in the connection instantiation:

$mysqli = new mysqli($host, $uname,$pswd, $myDB);

answered Mar 17, 2015 at 8:15

Nikola Drosakis

2,3581 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

PHP MySQL Inserting data in a database table using PHP script

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related