I’m trying to loop through a SQL result in PHP twice, and I am not succeeding. I have tried to use mysqli data seek, but this does not work. Here is what I have tried so far: my-new-file.php
Tag: mysqli
how do I correctly use mysqli_stmt::bindParam()
I am having difficulty understanding how to properly use bindParam(); I have been following the details at the following URL: http://php.net/manual/en/pdo.prepared-statements.php which show the following as one of their examples: This example is obviously incomplete, however, it shows enough of the details th…
Vtiger 6.2 shows blank page after login [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed last year. Improve this question I insta…
Dynamic variables binding in mysqli bind_param
When I try to below code it give me a warning I really don’t know why its happening I read a lot of same title questions in Stack Overflow but some has comma separated types or need more type but in my case I think its proper but why I am keep getting warnings? Answer
PHP mysqli_query() expects parameter 1 to be mysqli, null given in
I have 2 classes, controller and connector. They are used by delete.php. I got error saying Does anyone know here did I make mistake? For me it looks like the link to the connection is badly passed to the controller class somewhere. Or the return doesnt work as I wanted. It all did work before I had to make i…
mysqli_fetch_array returning only one result
I’m trying to make a very, very simple query of a small mysql database, using the following code (with appropriate values in $host, etc.): As you can see, I printed out the results in a human-readable way, yielding: There are a few example universities in that column, so I’m not sure what I’…
MySQLI Fetch Database Column
I have database table options, where am using it as a dedicated table to store information. I have never heard of this type of table query and have never tried it. I saw on WordPress database so thought to try my own. Here’s database table This is what am trying now This is inside my database class file…
PHP code convert to PHP/MySQLi OOP
today i tried to convert my code to PHP/MySQLi OOP code. class Database { private $host; private $user; private $password; private $db; private $mysqli; function __construct() { $this->host = …
MySQLi $userid returning 0
I’m just learning the ropes of MySQLi, so got this mostly from a tutorial (though had to throw in parts from different sites – hence the errors). Is anyone able to explain why $userid returns 0 instead of 1 that it should be? I’m hoping it’s a simple mistake. The query is correct, I…
Using one parameter multiple times in prepared mysqli-statement
Is it possible to use one parameter in a prepared mysqli-statement multiple times with only binding it one time? something like this I think this is possible with PDO, but I don’t konw how to do this with mysqli. Answer Just to close the question: The answer is no. If you want to bind a parameter only o…