Questions tagged as 'mysql'

Tagged questions
0
answers

Inner join and left join Doctrine symfony

Hi, I want to do an inner join with a left join to join the data I need from several tables, the normal query works for me, but when I pass it to the doctrine format I do not know how to accommodate the syntax SELECT c.id,c.'name',c.'st...
asked by 13.03.2018 / 17:18
2
answers

Fatal error: Using $ this when not in object context in

I have this code: function enlaces($X){ $a = $this->db->query("SELECT * FROM enlaces WHERE codigo = '$X'"); if($a->num_rows()>=1){ return $a->fetch_array(); }else{ return false;...
asked by 28.03.2018 / 23:48
0
answers

Sort data from the MYSQL field

In a field of the database in mysql some logs are saved that each user makes in the system, which keeps them like this: - > keys < - - > fields < - visits_id: 0 run (new): 11111111-1 start_date (new): 2017-11-21 new_date...
asked by 13.03.2018 / 12:07
0
answers

How to make this Query from the Prestashop hooks table not consume too much server / database resources?

I moved a website made in Prestashop 1.5.6 from one hosting account to another from the same company and I started having problems of too much use of resources, to the point that the company temporarily disabled access to Mysql. The previous acc...
asked by 13.03.2018 / 13:39
1
answer

Is it possible to integrate an array to a mysql query?

given the following arrangement: $tablas= array("honda_firme","honda_service_parts","honda_oe"); It is possible to record it to a query and with a FOR cycle to traverse it and in each iteration change the query table, I have a vague idea bu...
asked by 13.03.2018 / 15:11
1
answer

Problem with insert in cakephp-mysql

Driver code public function fullClient() { // $information = $this->data['Cliente']['informacio']; $client = $this->data['Cliente']['cliente']; //$posicion_coincidencia = strrpos($cadena_de_texto, $cadena_bu...
asked by 26.03.2018 / 22:39
0
answers

Optimize code in php and mysql with excel

I am receiving several fields from another form and based on them I generate a table and I have a button to generate the excel based on the generated table, this I do in reportExcel.php and after I send the query (with a echo) to ReporteExcel5.p...
asked by 27.03.2018 / 01:24
1
answer

Obtain a date with a certain frequency [closed]

I need your help, I have a date that is variable, at that date you will add a frequency example 15 days , I would like from the date given example: 12 / 03/2018 make a count of your established frecuncia that therefore summary 15 days an...
asked by 12.03.2018 / 18:08
1
answer

Error inserting in Mysql from Sql Server2014 with SSIS

I am using an Integration Services with VS 2013 and Sql Server 2014 I want to export data from a Sql Server table to Mysql but it gives me an error and I will export to another database in Sql Server and also to execel 2016 and I will not no pro...
asked by 12.03.2018 / 19:01
0
answers

Error in array not defined in php and Mysql

I can not find the error in my arrangement. I have the following function. I get this message in my combobox: data: arrayCuadroFuerzaGrid.LISTA (Uncaught TypeError: Cannot read property 'LISTA' of undefined) This is my function: public...
asked by 12.03.2018 / 17:48