Questions tagged as 'mysql'

Tagged questions
1
answer

Filter products by category in PHP

I am learning php (I am quite new) and I have been doing some exercises, I am creating a section where all the categories are shown, but I can not show the images that correspond to each category, but in each category I shows all the images in t...
asked by 15.03.2018 / 03:54
0
answers

How to bring a query to the database by Dates?

As the title says I am trying to make a query for a range of dates to the database 'Facilities', to the table 'PROYECTOF' to the field called 'Date' But I do not have much idea of how to do it since I am starting with php. My HTML code is as fol...
asked by 12.03.2018 / 14:44
0
answers

Does not correctly insert field type Date in BD

I make a massive import module of an excel.csv file but in my date field (DATE) it does not insert the data correctly, it only inserts 0000-00-00 , the other fields in the import do it without problem it is only in the date field. Thank...
asked by 12.03.2018 / 08:32
0
answers

Execute Stored Procedure using Mysql and Visual

I am developing a system in visual basic and using Mysql database engine Currently I make inquiries from visual basic, but I want to change that for stored procedure, but the problem I have is that calling it from the visual application do...
asked by 12.03.2018 / 08:36
3
answers

What is the error in these PHP codes? (Warning: mysqli_num_rows () exp ..) (Warning: mysqli_fetch_array () exp ...)

I'm following a tutorial to create an feed on Android. I have already created the database and I have uploaded the PHP scripts to the host, but I get these errors:    Warning: mysqli_num_rows () expects parameter 1 to be mysqli_result, bool...
asked by 30.10.2016 / 04:39
1
answer

Update information

<?php session_start(); $mysqli = new mysqli("localhost", "root", "", "lista"); if ($mysqli->connect_error) { die("Connection failed: " . $mysqli->connect_error); } $id = $_POST['id']; $agencia = $_POST['agencia']; $depa = $_POST[...
asked by 03.03.2018 / 19:27
0
answers

How to read a csv with PHP and not repeat the data in MySQL?

I have a .csv file with the positions of a mobile object. Every time the position of the object is updated and a new position is recorded. I want to read the .csv at each time interval to enter the data in a mysql table, but as I read all the...
asked by 03.03.2018 / 18:28
0
answers

Lost data when saving in relational database

I've had this problem since I linked my database, at first I thought it was the error it was because all the data was not sent, but then try another DB without relating it and it turns out that if all the data are sent data and all the data coin...
asked by 03.03.2018 / 18:26
0
answers

How can I code a MySQL query to UTF-8?

Bendo with a problem that ails. All the records that I insert into my database are saved with characters of this type (or). This is a (ó). My problem is that I am using a function to encode it as UTF-8 when it comes to consulting the informat...
asked by 02.03.2018 / 18:53
1
answer

is it possible to make a pivot table with the Django models?

Is it possible to create pivot tables in the database with the Django models ?, I need to create a table of that type to relate emails and telephones of a database in the tables of employees and clients Is it possible to create these table...
asked by 02.03.2018 / 19:10