Questions tagged as 'mysqli'

1
answer

number of variables does not match the mysqli parameters

I'm trying to do a select "binded" but this is returning the following error Warning: mysqli_stmt :: bind_param () [mysqli-stmt.bind-param]: Number of variables does not match number of parameters in prepared statement in $query = "SELECT...
asked by 14.02.2016 / 16:46
1
answer

Mysqli Prepare with loop for Select

I am trying to make a SELECT using MySQLi and PREPARE in FOR but not working. It is always returning a single zero. Application code: if( $teste = $mysqli->prepare("SELECT COUNT(*) AS TOTAL_CONTATOS, 'data' AS...
asked by 13.01.2016 / 16:34
1
answer

bind_param () dynamic

I have the following class: class BindParam{ private $values = array(), $types = ''; public function add( $type, &$value ){ $this->values[] = $value; $this->types .= $type; } public function get(){...
asked by 09.11.2015 / 18:14
1
answer

SQL - Select all records with coding errors

Make a select in the database bringing all the records with coding errors: SELECT * FROM tabela WHERE titulo LIKE '%ÇÃ%' Does anyone know of a more efficient way?     
asked by 05.10.2015 / 17:47
1
answer

Error "Call to undefined method mysqli_stmt :: get_result" and "Class 'mysqli' not found" [closed]

I'm developing a simple API using the Slim Framework. When I run local tests all the functions work the way they should but I started to have problems when I went up to a certain hosting. It happens that when I call some function it is even f...
asked by 03.12.2015 / 22:58
1
answer

Error in update "Call to undefined function mysqli_sql ()"

update returns the following error in the 1st result: Error:    Fatal error: Call to undefined function mysqli_sql () in F: \ XAMPP \ htdocs \ PAPBRUNO \ PAPBRUNO \ alter_cli_exe.php on line 21 My code: <?php $link = mysqli...
asked by 14.06.2015 / 21:21
3
answers

Code to show the data of the client that logged in

Well my question is this, when I log in how do I get the session data? I think it's a select, but in doing so I have to create a session? Because I want to fetch the data only from this client that logged in. I already have login.php...
asked by 10.06.2015 / 22:59
1
answer

Change table in mysql

I have the following situation. A table that displays the search results in mysql, and inside that table I have a column where the edit button is. How do I make this button edit content displayed on that line? I'm using the while lo...
asked by 14.03.2015 / 02:42
1
answer

In the index used in the prepared query / statement

I have a strange warning in my code, when it has only one data in the DB it recognizes and works fine, but when I enter more than 1 data in the DB it shows me the following warning:   SELECT * FROM con_users "SELECT * FROM con_users" To m...
asked by 27.04.2015 / 06:17
1
answer

Request jQuery Post + PHP + MySQL does not write data

I'm doing a registration via jQuery Ajax, so I created the following function: function salvarCadastro(titulo, form, caminho) { var dadosFormulario = $("#" + form).serialize(); var myData = $("#" + form).serialize(); jQuery.ajax({...
asked by 19.02.2015 / 19:07