PHP + MySQL can not add row to db and no error

Question

I am trying to add new row into the db, however, it does not add and I do not receive an error. Code is working at local but not working on the web.

Here is the code;

$RoomNo = mysqli_real_escape_string($conn,$_POST["roomno"]);
$Lastname = mysqli_real_escape_string($conn,$_POST["lastname"]);
$Name = mysqli_real_escape_string($conn,$_POST["name"]);
$Arrival = mysqli_real_escape_string($conn,$_POST["arrival"]);
$Departure = mysqli_real_escape_string($conn,$_POST["departure"]);
$EventType = mysqli_real_escape_string($conn,$_POST["eventtype"]);
$AssignedUser = mysqli_real_escape_string($conn,$_POST["assigned_user"]);
$Comment = mysqli_real_escape_string($conn,$_POST["comment"]);
$Action = mysqli_real_escape_string($conn,$_POST["action"]);

$ChooseAssignedUser = explode("|", $AssignedUser);

$eventregister_sql = "INSERT INTO tbl_event (room,lastname,name,arrival,departure,event_type,assigned_user,department,comment,action,user,update_user,call_time,update_time,status,hotel_id) VALUES ('".$RoomNo."','".$Lastname."','".$Name."','".$Arrival."','".$Departure."','".$EventType."','".$ChooseAssignedUser[0]."','".$ChooseAssignedUser[1]."','".$Comment."','".$Action."',".$_SESSION['user_id'].",".$_SESSION['user_id'].",'$gmtdbro','$gmtdbro','N',".$_SESSION['hotel_id'].")";
$eventregister_result = $conn->query($eventregister_sql);
echo "<center>Event registered successfuly. <a href=\"index.php\">Go back to main page</a>.</center>

I don't see that you're checking for errors. Have you looked in the error logs? — Jay Blanchard, Oct 30 '18 at 20:13
What did error reporting http://php.net/manual/en/function.error-reporting.php and `mysqli_error($conn)` produce? — Funk Forty Niner, Oct 30 '18 at 20:34

Oleksii Semeniuk · Answer 1 · 2018-10-30T21:24:37.397

-2

First I suggest you to use PDO to insert a data in database... The pluses is

no necessery to use mysqli_real_escape_string
readable code
etc

http://php.net/manual/en/pdostatement.bindvalue.php

$db = new PDO('mysql:host=localhost;dbname=DATABASENAME;charset=utf8',$dbname,$dbpass);
try{
$request=$db->prepare('INSERT INTO tbl_event (room,lastname,name,arrival,departure,event_type,assigned_user,department,comment,action,user,update_user,call_time,update_time,status,hotel_id) VALUES (:room,:lastname,:name......:hotel_id)');

$request->bindValue(':room',$_POST["roomno"],PDO::PARAM_STR); 
$request->bindValue(':lastname',$_POST["lastname"],PDO::PARAM_STR); 
.... 
$request->bindValue(':hotel_id',$_SESSION['hotel_id'],PDO::PARAM_INT); 

$result = $request->execute();
} catch(PDOException $e){
    var_dump($e);
}

Then in your case try to print sql string and use this string exactly in phpmyadmin to find out what's going on

echo $eventregister_sql;

Try to var_dump return value to see what's going on

var_dump($eventregister_result);

or

echo mysqli_error($db);

edited Oct 30 '18 at 21:24

answered Oct 30 '18 at 20:29

Oleksii Semeniuk

176
1
6

4

While I'm also a fan of PDO, mysqli also provides both an object-oriented syntax _and_ prepared statements. – Patrick Q Oct 30 '18 at 20:31
@PatrickQ for me much easier to read a code written with PDO but anyway – Oleksii Semeniuk Oct 30 '18 at 20:33
This does not solve the question, IMHO. It's something of the same, only written differently. – Funk Forty Niner Oct 30 '18 at 20:34
@FunkFortyNiner pls read till the end – Oleksii Semeniuk Oct 30 '18 at 20:35
2

Worthy of a comment on the end. – Funk Forty Niner Oct 30 '18 at 20:35
1

The return value of `$conn->query()` is either `true` or `false`, so `var_dump()` won't be very helpful. – Barmar Oct 30 '18 at 20:48
@Barmar anyway you will know if your request was succeed if it's true – Oleksii Semeniuk Oct 30 '18 at 21:07
2

He already knows it's not successful, since the DB wasn't updated. He needs to know *why* it failed. – Barmar Oct 30 '18 at 21:09
@Barmar ahh ok in this case try{}catch(PDOException $e){var_dump($e);} or mysqli_error($db); – Oleksii Semeniuk Oct 30 '18 at 21:21
That should be in the answer, not a comment. – Barmar Oct 30 '18 at 21:22
1

But since he's using mysqli, it should be `echo $conn->error;` This is all explained in the duplicate question that Funk Forty Niner linked to. – Barmar Oct 30 '18 at 21:22

PHP + MySQL can not add row to db and no error

1 Answers1