Questions tagged as 'mysqli'

Tagged questions
4
answers

Retrieve dynamic input and insert into bank with procedure

I'm having trouble inserting input data from a dynamic input. My procedure only inserts once, it follows my code where I get the data: $ddd = $_POST['ddd']; $userid = $_POST['userid']; $idusuario = $_POST['idusuario']; $telefo...
asked by 22.11.2015 / 00:10
0
answers

How to create function in PHP to recover password? [closed]

I use 2 pages, one to insert the email ( forgotPassword.php ) that still only has the graphic design. And the recuperar.php that will be used for the user to change their password. My user table (where registered people go) has t...
asked by 27.01.2016 / 19:50
4
answers

How to delete the database from the database if the user does not activate it by email within "X" hours?

Well, when registering on the site the user has their ACTIVE set to 0, so with the code I posted in the question answer below I can update the ACTIVE to 1: How do I activate a user's registration by email? But if the user does not activate...
asked by 21.08.2014 / 17:06
2
answers

Comparing prepare () vs query () with mysqli

I made a query in the database, with query() using mysqli and num_rows to return the number of lines, see the code: $consulta = $mysqli -> query("SELECT * FROM tabela WHERE Pedido = '$pedido' AND Email = '$email' "); $linhas =...
asked by 19.01.2015 / 15:10
3
answers

Pass SQL result to JSON

Hello, I want to pass the result from a select to json, but I can not see why I can not see it. So could anyone tell me why this code does not print anything? include_once 'conexao.php'; $query = "SELECT client_id, name, email FROM clie...
asked by 03.11.2016 / 23:57
2
answers

Error "expects parameter 1 to be mysqli, string given in"

I am creating an insert form to register, but when I click the button it is presenting me an error:    Warning: mysqli_query () expects parameter 1 to be mysqli, string given in C: \ wamp64 \ www \ Project Beauty and Harmony \ Beauty and Harm...
asked by 05.01.2017 / 01:39
2
answers

How to use echo in a query with prepared statement?

I would like to know how to use echo in a query with prepared statement, to be able to see how it was mounted by php before it was executed, thus facilitating visualization of the error when bind_param is done ... Example: $Apagar = $conn-&...
asked by 11.03.2014 / 19:43
2
answers

Always present an error when I try to use the mysqli expression

I know that the expression mysql has been deprecated, so I'm trying to use the expression mysqli , but every time I try it shows me a syntax error! example: $buscaDados = mysqli_query("SELECT * FROM usuario"); Generate this er...
asked by 04.03.2014 / 23:13
3
answers

mysqli_escape_string () expects exactly 2 parameters, 1 given

I'm experiencing an error in my code, when I run the DW c6 server behavior, when I move from mysql_ to mysqli_ , I get an error in the function executed on line 10. The error is:    Warning: mysqli_escape_string () expects exa...
asked by 21.09.2015 / 17:06
2
answers

Show Total Records

Personal Talk, I am developing a system for videoconferences and this should include a Dashboard with some information, such as the total of videoconferences of the current day, the next day and the amount of VIP videoconferences. To show the...
asked by 22.07.2018 / 16:58