Questions tagged as 'mysql'

Tagged questions
0
answers

In what way could I page with vuejs, axios and pure php?

public function paginarClasificados($pagina) { #Inicializamos el tamaño de la pagina $tamaño_pagina = 5; #Iniciamos en donde iniciara la pagina $pagina = 1; $empezar_desde = ($pagina - 1) * $tamaño_pagina; #Inicializamos e...
asked by 01.12.2018 / 16:54
0
answers

Error creating tables

I have the following error Can not create table 'base1.articles' (errno: 150) by passing the create table command to my database, which does not allow me to create the table posts within it CREATE TABLE 'articulos' ( 'id' int(11) NOT NULL A...
asked by 21.11.2018 / 00:56
3
answers

DatePicker subtracts 1 day to date!

My problem is that in my program I load a date for a record through a datepicker, that date I keep in the database, all as Date type. Then when I call the list of the records stored in the database and show it on a table view the date is modifie...
asked by 20.11.2018 / 14:11
0
answers

does anyone know how to assign a fetch_assoc () or a mysqli_fetch_array () to a variable?

Thanks for reading my post. I've been trying to do an assignment to a variable from a fetch_assoc () or a mysqli_fetch_array (), this is my code: $dba = mysqli_connect('localhost', 'root', '', 'prueba'); $salida = ""; $query = "SELECT * F...
asked by 11.11.2018 / 06:09
0
answers

validate a BD data and show results in an option

The detail I have is that I have to validate a text (RFC) of an input, and that when clicking on a submit check, I return the clients with the same RFC in an option .... I already look and I do not understand how to do it ... this part is the...
asked by 06.12.2018 / 23:32
1
answer

Bar Graph with Google Chart, PHP and Mysql

I have the following arrangement emanating from a query in Mysql: I need to create a graphic in google charts in the following way: I need, please, a technical guidance on how to configure google chart, in PHP, to show the graph i...
asked by 06.12.2018 / 18:35
0
answers

Uncaught Error: Call to a member function fetch_assoc ()

Hello I have a problem with a conditional if when I put as a condition if ($pagina > $total_paginas || $pagina <= 0) { header('Location:index.php?pagina=1'); } the number of rows are 7 of mysql stored in $ total_pages and the var...
asked by 06.11.2018 / 17:11
0
answers

Error trying to make custom queries to Mysql database

I have a table in HTML where the information I have stored in a table of my Mysql database is displayed and this information is consulted through ajax. At first I had a code that extracted and showed all the data without having any search option...
asked by 19.11.2018 / 02:13
1
answer

Relationships in my database

I have a doubt as to which 3 tables would do practically the same, Save the urls of where the files are located I have a table called Groups - where you can save files, in general it's just uploading files. And already in their respective gro...
asked by 20.11.2018 / 04:04
3
answers

Delete data from a table connected to BD with Java

Today I appeal to you in order to ask your help for the following problem. Result that I have a table in JAVA that is connected to a BD (Mysql). I want to delete a record of this table but when I try it it marks the following error " incompatibl...
asked by 04.11.2018 / 11:03