Questions tagged as 'mysql'

Tagged questions
0
answers

Codeigniter / Mysql "Warning - mysqli :: real_connect (): MySQL server has gone away"

I'm getting the error "Severity: Warning - > mysqli :: real_connect (): MySQL server has gone away" in codeigniter when the connection to the database is persistent, that is when in the base configuration of data the pconnect parameter is lef...
asked by 18.10.2018 / 22:43
1
answer

Table restarts ID by deleting all records

Today I come with a question about something that had never happened to me, and maybe MySql uses it but I want to tell you to see if it has happened to you and if there is a way to solve it. I have a small sales system (POS) where the sales of t...
asked by 09.10.2018 / 03:16
1
answer

WHERE query conditioned by search parameters

I want to make a query where I show a result by selecting a city or by selecting a month or search by id_nodo or search by city and month to show me all the nodes in that city that month, I attach an image of my form so that you can un...
asked by 28.07.2017 / 21:11
0
answers

My site takes between 0.002 seconds and 5 seconds randomly

it has happened to me lately that my site delays in loading between 0.01 and 5 seconds in loading a page, I would like to know if I am doing something wrong in the code, since I do not understand why it happens.    Fatal error: Uncaught Error...
asked by 09.10.2018 / 21:58
0
answers

Script php from console linux error mysql

I have a script in PHP that I run from the linux console, this script goes through a database table and updates one by one the records in another table, the problem is that randomly, the mysql starts to throwing error in the queries when they ar...
asked by 24.10.2018 / 21:33
1
answer

Fill a PHP select Laravel

I have this select function that what it does is select the customer table and select them by country, in which if you bring the data this in the Client's driver. public function select(){ $data = DB::select('select * from clientes where...
asked by 24.10.2018 / 23:08
1
answer

How to obtain and insert auto-incremental id from one table in another

I have been asked to do in PHP a script that automatically inserts values from a csv to the database, but although I have some idea of PHP (little thing, I'm learning on the fly) I have no idea of MySQL. The script works fine, but the respons...
asked by 08.10.2018 / 07:47
0
answers

How can I insert several data from different tables into a field of another table in mysql?

I have a database "Cafeteria" with four main tables "menu", "client", "menu_has_cliente" and "orden" in the third are the foreign keys to connect to the multiple clients that ask for multiple foods from the table menu being a connection from sev...
asked by 08.10.2018 / 04:43
0
answers

Consume API to BD

I am working on my degree project and I have to make a system that works based on an API. This API must be integrated into a database, that is, I must extract all information regarding the company for which I work and integrate it into a local b...
asked by 05.10.2018 / 12:28
1
answer

Error wanting to save PHP form data to MySQL

I am saving some data from a php to mysql form but I do not know where I am wrong, but it does not save anything, this is the code that I have in my php MY HTML <form class="limpiar" method="POST"> <div class="half izquierda li...
asked by 05.10.2018 / 16:05