Search the Community
Showing results for tags 'prepare statement'.
-
Hi, How do you split a search string by space and put it into a prepare query? $strings = $_POST['strings']; $string_array = explode(" ", $strings); $search = $mysqli->prepare(" SELECT * FROM core_table where item_name in ( ? ) "); $search->bind_param("s", $string_array); ...
- 6 replies
-
- search string
- split
-
(and 1 more)
Tagged with:
-
PHP Fatal error: Call to a member function prepare() on null
bbmak posted a topic in PHP Coding Help
Hi Trying to implement with the prepare statement, and it gives me this error. "PHP Fatal error: Call to a member function prepare() on null." Anybody knows what is wrong? function listMerchant() { $merchant = array(); $merchantList = $this->mysqli->prepare("SELECT * FROM core_merc... -
Hello, I am trying to use array in bind statement to avoid entering bind manually Below, I set up the array, then imploded the array to insert , on it // to return 1,2,5 , but I got error Warning: mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of...
- 9 replies
-
- php
- bind_param
-
(and 1 more)
Tagged with: