Questions tagged as 'mysql'

Tagged questions
1
answer

separate array and query in bd

I have a $servicos variable that receives the list of services registered in the DB through this code. $query_servicos = "SELECT * FROM servicos ORDER BY nome ASC"; $result_servicos = mysqli_query($conectar, $query_servicos); $servicos...
asked by 02.12.2018 / 15:00
0
answers

repeat data from the same query

Well, I'm breaking my head trying to find a solution. $query_listserv = "SELECT * FROM servicos ORDER BY nome ASC"; $result_listserv = mysqli_query($conectar, $query_listserv); while ($linhas_listserv = mysqli_fetch_assoc($result_listserv)){...
asked by 02.12.2018 / 05:06
1
answer

How to list values from multiple queries in a single table?

I have a table with the attendant, total / day and total / month columns. I typed tr / td the names of people through the first MYSQL query. I need through the second query to add the records of these people and print in the next td. The prob...
asked by 28.11.2018 / 18:15
0
answers

Mysql has stopped working

Hello, I am using MariaDB 10.2, I ran the TRUNCATE command on a table with 4 GB and Mysql stopped working, I can not access any other database, I am using Mysql in xampp and it displays the following message :    2018-11-12 11:28:18 8748 [ERRO...
asked by 10.12.2018 / 18:42
1
answer

Error when calling DB table

I'm a beginner in MySQL and PHP , and I want to basically list the information I have in db in>. I made the code and are returning these errors:    Warning: mysqli_select_db () expects parameter 1 to be mysqli, string   given in C: \ xam...
asked by 11.12.2018 / 01:03
1
answer

Syntax error when doing two updates on a single command

I'm trying to perform an update on more than one table in the same query, Local normal wheel, but online gives syntax error in MySQL 5.1.72. What can be done to solve? $query = "UPDATE isc_products SET prodcurrentinv = 12, prodretailprice...
asked by 14.03.2014 / 20:44
1
answer

Linking tables with Code Igniter

I have the following problem, I have a customer table that stores the personal data, login, password among others, and another invoice table, which has all the invoices of all the clients, however I need to search the data of the customer with a...
asked by 16.03.2014 / 23:55
1
answer

BD registration with pre-filled fields

I am creating a registration system on top of a system I found on the net. In my system there are only 2 fields email and password, and the password will already be pre-registered, thus only the user will have to fill in the email. I am having p...
asked by 19.03.2014 / 18:14
1
answer

Connect external php script to mysql of a server codeigniter?

I have a XAMPP server on an iMac OSX with a portal developed in codeigniter and would like to integrate mySQL Database with an external script that is currently running via terminal and is not storing anything. The script is for collecting da...
asked by 20.03.2014 / 12:33
2
answers

Problem with call in database

Next I have several calls that update a database as the user is filling in the fields but specifically in the next error call in the database and not saved for anything, all of which use the same calls only changing the data. Can anyone get a bu...
asked by 20.11.2018 / 20:46