Warning: mysqli_error() expects parameter 1 to be mysqli, string given in

Question

I want to connect to a database (with xampp) called ranch and insert into this db some form data. The browser displays the error:

Warning: mysqli_error() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\project1\register.php on line 38

ERROR: Could not able to execute INSERT INTO child_parent('childname','childsurname','age','gender','name','surname','address','tk','city','telephone','mobile','email','parea','pass') VALUES('nikos','ads','34','Αγόρι','sds','sds','dsd','34','dsds','34','434','mail@hotmail.com','sds','34').

I have the .php file that is below. How can I fix it?

<?php

ini_set('display_errors', 'On');
session_start();
unset ($msg);
    echo "kajsj<br>";
    $conn= new mysqli("localhost","root","","ranch");
    
    if (mysqli_connect_errno())
    { printf("Connect failed: %s\n",mysqli_connect_error());//error message
    }
    else
    {
    printf("Connect achieved<br>"); 
    echo $_GET['childname'];
    $childname=$_GET['childname'];
    $childsurname=$_GET['childsurname'];
    $age=$_GET['age'];
    $gender=$_GET['gender'];
    $name=$_GET['name'];
    $surname=$_GET['surname'];
    $address=$_GET['address'];
    $tk=$_GET['tk'];
    $city=$_GET['city'];
    $telephone=$_GET['telephone'];
    $mobile=$_GET['mobile'];
    $email=$_GET['email'];
    $parea=$_GET['parea'];
    $pass=$_GET['pass'];
    // Insert data into mysql 
    $query1="INSERT INTO child_parent('childname','childsurname','age','gender','name','surname','address','tk','city','telephone','mobile','email','parea','pass')
                                VALUES('$childname','$childsurname','$age','$gender','$name','$surname','$address','$tk','$city','$telephone','$mobile','$email','$parea','$pass')";
    
    if(mysqli_query($conn, $query1))
    {echo "Records added successfully.";
    } 
    else{echo "ERROR: Could not able to execute $query1. " . mysqli_error($query1);
    }
    }
?>

Possible duplicate of [mysql\_fetch\_array() expects parameter 1 to be resource (or mysqli\_result), boolean given](http://stackoverflow.com/questions/2973202/mysql-fetch-array-expects-parameter-1-to-be-resource-or-mysqli-result-boole) Welcome. But please remember to do a simple search before asking a question. This one must have been ask a 1000 times before. — RiggsFolly, Oct 06 '15 at 09:50

score 4 · Accepted Answer · edited May 23 '17 at 12:29

4

There are three main problems with your code:

Wrong SQL. You have to learn basic SQL syntax prior trying to use SQL from PHP.
Wrong mysqli syntax. You have to use prepared statements instead of adding variables right in the query.
Wrong error reporting. You have to set mysqli in exception mode instead of checking every query result manually.

To solve them one by one, read these three helpful answers:

edited May 23 '17 at 12:29

Community

1
1

answered Oct 06 '15 at 09:53

Your Common Sense

156,878
40
214
345

4: mixing OOP and procedural style calls to `mysqli` – CD001 Oct 06 '15 at 09:59

Warning: mysqli_error() expects parameter 1 to be mysqli, string given in

1 Answers1