Questions tagged as 'mysql'

1
answer

Error sending form data

I am learning mysql and php, but it is giving an error in the form, where even having been filled it still asks to fill in the fields and does not register anything in the database table <?php $db = "progdesenv"; @mysql_connect("localhost",...
asked by 23.04.2015 / 00:12
3
answers

Multiple foreign keys coming from the same table. It's possible?

I am studying MySql using MySql Workbrench to create a diagram of my database and the following situation arose: Imagine I have the table_A and the table_intensity, where: Structure of table_A: id, name, intensity_1, intensity_2 Structu...
asked by 15.04.2015 / 20:39
1
answer

explode () directly in MySQL [duplicate]

I have a column named relacionados in the produtos table and there are some ID's of some items in the produtos table. I needed to make a explode () or something of the type in the produtos table and select all pro...
asked by 01.12.2015 / 17:21
1
answer

phpMyAdmin with slow Xdebug in Windows 8.1 with Xampp

Good, Some time ago I noticed that my phpMyAdmin was stupidly slow (more than half a minute in a simple query) ... After researching this, I came to the conclusion that one should have XDebug turned on in PHP.ini settings ... I commented everyth...
asked by 06.04.2015 / 22:22
1
answer

Problem with filter via JSON

Good evening, I'm here with a filter problem via json for districts and counties to explain. The user chooses a district and it filters and lists in another selectbox the counties that are associated with that district and the system is wo...
asked by 18.02.2015 / 02:02
1
answer

SQL syntax error

I come again with a similar error in the syntax of my SQL. I've tried a few times and so far nothing. If you can give me some help, thank you. Here is my code: $sql="INSERT INTO processos ( processo, numero_beneficio,...
asked by 10.03.2015 / 19:04
1
answer

Product upgrade issue

In query the goal is to update the product unit, with a subquery that retrieves the current drive from the database and subtracts by checking by code. UPDATE loja.produto SET UNIDADE = (SELECT (SELECT UNIDADE FROM loja.produto WHERE CODIGO...
asked by 05.09.2015 / 18:56
1
answer

Database does not display data entered by the user

Good morning, I'm trying to make a news system, but the database does not receive php data. I would like to know how to resolve this. <html> <head> <meta charset="utf-8"> <title>Inserir Notícia</title>...
asked by 06.09.2015 / 15:32
1
answer

Foreach within the while in the output of Json

I'm looking for a few days ago to do a foreach within a while to print the json data related to that query. My scenario is this: <?php require_once('../Connections/db.php'); header("Access-Control-Allow-Origin: *"); header("Content-Type: ap...
asked by 11.09.2015 / 20:10
2
answers

Problem with User Password Validation (php, mysql, crypt)

I'm just trying to validate the password typed with the password stored in the database, and the password stored in the database has been encrypted. The problem is that I type the correct password, my function searches for the correct registry i...
asked by 04.09.2015 / 17:48