Questions tagged as 'mysql'

1
answer

Create stored procedure with MySQL

I do EAD for a bank and have very little material to help me do my activities. I have this question to solve, if anyone can help me or help me with some study material path I am very grateful. Create a stored procedure call sp_generate_q...
asked by 30.11.2017 / 14:25
1
answer

Notice: Undefined variable: connection [closed]

Recently I changed all my code mysql to mysqli . But that gave me a lot of headache. It gives me the following errors: Notice: Undefined variable: conexao in D:\Programas\wamp64\www\admin\css\header.php on line 44 Warning: mysqli...
asked by 10.10.2017 / 02:38
2
answers

Delete multiple rows using checkbox in php and mysql

I want to delete the rows that I select with my checkbox and also delete the database so that pq is given in this part of the code: <?php include "conexao.php"; if (isset($_POST['sel'])) { foreach ($_POST['sel'] as $id) { $sql...
asked by 27.08.2017 / 18:53
1
answer

Why is the given $ variable not receiving the DB values?

<?php require'conecta.php'; $id = 0; if (isset($GET['id']) && !empty($GET['id'])){ $id = addslashes($GET['id']); $sql = "SELECT * FROM usuarios WHERE id = '$id'"; $sql = $pdo->query($sql); if ($sql->rowCount(...
asked by 04.02.2018 / 21:53
1
answer

Data search

I'm not sure what to do, but I'd like to do this in jsp. I want the client to type the word to search mysql database. Example leonardo dai I'll have multiple database names, only the client that will search the data base he typed wrong leotard a...
asked by 28.07.2017 / 01:38
1
answer

Problem creating SQL INJECTION security

   I have a PHP function where I pass the data to it and the same as an UPDATE in the data. but I'm doing security against SQL INJECTION, but it's not working what would be the problem? Here is the code for the function: function alterar($upd...
asked by 27.07.2017 / 15:12
4
answers

Select option selected

I need to leave the selected option selected according to the field recorded in mysql. The form is to edit pos so it displays the available fields with the foreach. Ex: <select name="segurado" > <option value=""></optio...
asked by 11.08.2017 / 11:29
1
answer

Update in two MYSQL tables [duplicate]

How to do an update in two tables, Ex: first table users , would only update in senha , but in table users_info would update cos fields, cidade , nascimento , sexo e etc. I can do it in one, but I wante...
asked by 04.09.2017 / 05:22
1
answer

Synchronize the server database with a localhost

I need to synchronize two databases so that their information is the same because of internet instability issues. I found the replication that exists in phpmyadmin, but since I use a cloud server I can not tweak its settings to convert my databa...
asked by 31.08.2017 / 05:47
1
answer

Fatal Error: Call to a member function bind_param ()

I'm getting this problem:    Fatal error: Call to a member function bind_param () on boolean in C: \ xampp \ htdocs \ Myworld \ Registry \ create_user.php on line 32 When you run this code: $email = htmlspecialchars($_POST["email"]);...
asked by 01.07.2018 / 19:38