1. Home
2. mysql - mysqli::query() expects parameter 1 to be string in PHP

259 votes

1 answers

mysql - mysqli::query() expects parameter 1 to be string in PHP

Get the solution ↓↓↓

I have below Query in my Php, it outputs result but at the same time giving an errormysqli::query() expects parameter 1 to be string what is wrong in below code

 $con = @mysqli_connect("localhost","$dbname","$dbpass","$dbuser");

 if (!$con)
 {
    die('Connect Error: ' . mysqli_connect_error());
 }

 $sql_uid=$con->prepare("SELECT id From $dtUsi Where mobile_number='$umobile' and user_type='$user_type'");

 $stmti = $con->query($sql_uid);

 while($rowi = $stmti->fetch_assoc()) {
 $ur_id= $rowi['id'];
 }
 echo $ur_id;
Copy code

Undefined asked

2021-12-5

Write your answer

---

248

votes

Answer

Solution:

You can't use prepare and query at the same time. You are giving$sql_uid toquery function like it's a query string while it isn't. Use one the these approaches.

Either

$con = @mysqli_connect("localhost","$dbname","$dbpass","$dbuser");

 if (!$con)
 {
    die('Connect Error: ' . mysqli_connect_error());
 }

 $stmti=$con->query("SELECT id From $dtUsi Where mobile_number='$umobile' and user_type='$user_type'");

 while($rowi = $stmti->fetch_assoc()) {
 $ur_id= $rowi['id'];
 }
 echo $ur_id;
Copy code

or

$con = @mysqli_connect("localhost","$dbname","$dbpass","$dbuser");

 if (!$con)
 {
    die('Connect Error: ' . mysqli_connect_error());
 }

 $stmti=$con->prepare("SELECT id From $dtUsi Where mobile_number='?' and user_type='?'");
 $stmt->bind_param("ss", $umobile, $user_type);

 $stmt->execute();
 while($rowi = $stmti->fetch_assoc()) {
 $ur_id= $rowi['id'];
 }
 echo $ur_id;
Copy code

These links might be helpful:

PHP MySQL Prepared Statements

Select Data With MySQLi

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-5

Link To Source
Link To Answer People are also looking for solutions of the problem: filter_sanitize_string

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

737 php - Nested mysql_query() - Resets first result's pointer?

924 php - JSON parser error java.lang.String cannot be converted to JSONObject] Array

884 php,mysql,html - Display SQL query(conjunction) properly in HTML

169 php - Database Error mysqli_init()

788 php - Filter content from mysql db with checkboxes using jQuery?

639 php - Use mysql_fetch_array() with foreach() instead of while()

95 php - Mysql to JSON, how to get a nested array?

677 php - Check if a variable has been set with the name of the value of another variable

243 php - function query() on a non-object error

951 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/