php - mysqli - insert record dont work

Question

I do try to insert information into databace with mysqli but it doesn't work! The command seems to be correct!

$creg=mysqli_connect('localhost','uuu','uuu','pro5');
$sqreg="INSERT INTO tbl_users (username,name,lastname,password,email,gender,country,city,register_date,ip1) VALUES('$un','$na','$lnm','$ps','$eml','$ge','$co','$ci','$rdt','$ip')";
if (mysqli_query($creg, $sqreg) ) {

    echo "Create successfully"."<br>";
    echo  $sqreg . "<br>" . mysqli_error($creg);

} else {
     echo "Error: ";
}

and this is output

Create successfully
INSERT INTO tbl_users (username,name,lastname,password,email,gender,country,city,register_date,ip1) VALUES('dfvdfvd','vfd','dfv','fvdfvd','dfvdfv','1','1','1','0','0')

what is the problem?! thanks

`if (mysqli_query($creg, $sqreg) ) { echo "Create successfully"."
"; echo $sqreg . "
" . mysqli_error($creg);` - um... that error, belongs in the `else{...}` should there be one. — Funk Forty Niner, Jan 24 '18 at 19:49
*"what is the problem?"* - Um, you tell us. If the code is working, and it's *claiming* that it's working, then why do you think something is wrong? — David, Jan 24 '18 at 19:51
and check your connection; you're just assuming you connected successfully. — Funk Forty Niner, Jan 24 '18 at 19:51
[Little Bobby](http://bobby-tables.com/) says [**your script is at risk for SQL Injection Attacks**](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php). Learn about [prepared](http://en.wikipedia.org/wiki/Prepared_statement) statements for [MySQLi](http://php.net/manual/en/mysqli.quickstart.prepared-statements.php). — rollstuhlfahrer, Jan 24 '18 at 19:53
And the version of your php server (if mysqli doesnt work)... ? — IncredibleHat, Jan 24 '18 at 20:05
@behzad `$ php -v` cmd/terminal or create a new `php` file and use this code `phpinfo();` — Sam, Jan 24 '18 at 20:21
@behzad a new php file... save it somewhere in your localhost scope — Sam, Jan 24 '18 at 20:27
@behzad, again I think its your table structure... look at my answer below — Sam, Jan 24 '18 at 20:39

Sam · Accepted Answer · 2018-01-24T20:21:02.787

Two things which may affect your database query:

Test your connection

<?php 
$creg = mysqli_connect();
if(!$creg) {
  trigger_error('Connection did not work.' .  mysqli_connect_error());
}

Check your columns (in your table) and what you are sending to your database

I am pretty sure this would be the reason for you not being able to complete the action. If you are sending wrong column names, or more than your table has, it will simply not add anything.

For instance, you are sending data to these columns:

username, # @varchar
name, # @varchar
lastname, # @varchar
password, # @varchar
email, # @varchar
gender, # @varchar
country, # @varchar
city, # @varchar
register_date, # @date
ip1 # @int

Now, your table should have those columns, and that they are the right type.

That annoying part is that PHP runs the query as though MySQL took it properly, so it would make sense you are seeing the success message.

So check the query and your table.

You could also share your table_schema, that would be helpful in determine the issue.

NOTE: please, please, please! Look at prepared statements, they are both more elegant, and just common sense today.

No problem... That issue can be a pain to fix, because again, PHP will just not tell you something didn't work, so no error_logs, no nothing. It's life tho — Sam, Jan 24 '18 at 20:54

php - mysqli - insert record dont work

1 Answers1