Warning: mysqli_query() expects parameter 1 to be mysqli, object given

Question

I am experiencing an issue with this error, The code I have used is given below:

<?php
$cus_name = isset($_POST['client_name'])?$_POST['client_name']:'';
$description = isset($_POST['desc'])?$_POST['desc']:'';
$amount = isset($_POST['amnt'])?$_POST['amnt']:'';

$query = "INSERT INTO ".$RECORD_TABLE."(cus_name,description,amount) VALUES ('$cus_name','$description','$amount') " ;
$result = mysqli_query($dbObj,$query);

if(!$result)
{
  echo "error while inserting";
}


?>

That is the code I am using for insertion of date into the database. The connection code I am giving below:

$DB_HOST = 'localhost';
$DB_USER = 'root';
$DB_PWD = '';
$DB_NAME = 'hotel_booking';

$BOOKING_TABLE = 'hotel_booking';
$PRICING_TABLE = 'hotel_pricing';
$SETTING_TABLE = 'hotel_setting';
$RECORD_TABLE = 'hotel_record';
require_once('Database.class.php');

global $dbObj;
$dbObj = new Database($DB_HOST,$DB_USER,$DB_PWD,$DB_NAME,1,0);

I concur with the error message here, `Database !== mysqli`. — deceze, Nov 05 '15 at 09:59

score 1 · Accepted Answer · answered Nov 05 '15 at 10:00

1

I think you problem is for connection Try this code

$conn = mysqli_connect($DB_HOST,$DB_USER,$DB_PWD,$DB_NAME);

and also change

$query = "INSERT INTO ".$RECORD_TABLE."(cus_name,description,amount) VALUES ('".$cus_name."','".$description."','".$amount."') " ;
$result = $conn->query($query);

answered Nov 05 '15 at 10:00

Shaymol Bapary

468
3
11

The latter change is very optional. – deceze Nov 05 '15 at 10:01
it worked the form details is going into the db, Thanks – DEV Nov 05 '15 at 10:08

score 0 · Answer 2 · answered Nov 05 '15 at 09:58

0

Now your $dbObj is an object of Database class. If you waht to use with mysqli_*, then $dbObj should be like this.

$dbObj = mysqli_connect("host", "user", "password","database name");

See here for more info.

answered Nov 05 '15 at 09:58

Niranjan N Raju

12,047
4
22
41

It is not submitting at all now – DEV Nov 05 '15 at 10:04
Form is not submitting?? – Niranjan N Raju Nov 05 '15 at 10:06
form was not submitting with the code you put up, but it's alright, i got the solution, Thanks Niranjan – DEV Nov 05 '15 at 10:11

Sugumar Venkatesan · Answer 3 · 2015-11-05T10:10:08.550

-2

check whether class returns new mysqli

 class Database() {
    function __constructor(){
        $obj=mysqli_connect($DB_HOST,$DB_USER,$DB_PWD,$DB_NAME);
        return $obj;
    }
 }

edited Nov 05 '15 at 10:10

answered Nov 05 '15 at 10:05

Sugumar Venkatesan

4,019
8
46
77

thanks for the answer, but shaymol bapary's answer worked – DEV Nov 05 '15 at 10:09

Warning: mysqli_query() expects parameter 1 to be mysqli, object given

3 Answers3