Questions tagged as 'mysql'

Tagged questions
1
answer

How to load a mysql table with php?

Good morning, I'm new to php, I need to load a complete table that is in my mysql database and show it as a table with its header and everything on my website, if you could help me, thanks?     
asked by 19.02.2018 / 15:34
1
answer

Replace Mysql does not work

When I try to replace all records in a field, it indicates a syntax error which I do not understand, this is the query. UPDATE tabla SET campo=REPLACE(campo,'\.',''); And I get two alerts 1 - A new declaration was found but there is n...
asked by 14.02.2018 / 14:04
0
answers

Entity from view with float as ID

I have the following model: use Doctrine\ORM\Mapping as ORM; /** * SignosGuion * * @ORM\Entity * @ORM\Table(name="vw_signos_guion") */ class SignosGuion { /** * @var float * * @ORM\Column(name="id", type="float", nulla...
asked by 14.02.2018 / 16:57
3
answers

generation and sending of array php by post

I have a mysql query: while ($qry = mysql_fetch_array($res)){ $id_prod = $qry["id"]; $id_venta = $qry["id_venta"]; $idcl = $qry["id_cl"]; $garzon = $qry["usuario"]; $valor_total = $qry["valor"]; $prod= $qry['producto']; --> es...
asked by 07.02.2018 / 14:52
1
answer

Product check in Wordpress [Woocommerce]

Good morning community StackOverflow, I have some doubts because I want to make a check in PHP on the Wordpress platform, in the table wp_posts . I want to check if the title of a product exists. But how should I proceed to perform a check, for...
asked by 07.02.2018 / 08:36
0
answers

Group consecutive records with the same value

I am working with tables that receive data every 5 seconds. Many times the same value is received for quite some time. My idea is to only show the records when they change. This is the example: If you see the image, there are three grou...
asked by 08.02.2018 / 19:00
3
answers

Paint a table with php

The result of this query I want to convert to a table, since the query is a value of the same field called name SELECT id_departamento, departamento.nombre FROM 'departamento' WHERE departamento.id_raiz= '1' Throw each of...
asked by 06.02.2018 / 20:59
0
answers

3 columns in ESC-POS PHP

I'm trying to print a sales ticket using the Mike42 ESC-POS script. So far, I can only print 2 columns, but the reality I need 3. The idea is that the quantity, the product and the quantity appear. In other words, the information comes from mysq...
asked by 12.02.2018 / 15:48
0
answers

when I use join I skipped many records using eloquent with laravel

I am presenting an inconvenience regarding an eloquent query with laravel, the problem is that when I use the direct select it brings all the normal records without problem, but when using join to bring in this case I bring municipalities and de...
asked by 12.02.2018 / 17:44
0
answers

Very heavy database in Laravel

Good morning: I have a database, with a column with 20,000 records, which will increase. When trying to connect locally, I get this problem: [Mon Feb 5 10:42:12 2018] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried...
asked by 05.02.2018 / 09:49