Questions tagged as 'mysql'

Tagged questions
0
answers

how to get the id of a product to modify an image?

I'm trying to modify an image in my database by the id of the product, my table is called products and my id is product_id, only when doing the UPDATE in my file upload_image.php does not modify the image. <?php if($_SERVER['REQUEST_...
asked by 05.04.2018 / 16:26
0
answers

error 2005 (hy000) unknown mysql server host (110)

I'm having a problem, the very repeated 2005 error. I can access a database on a remote server using a URL but when I run the command in the shell of linux pulls that error. This sentence I use: mysql -h (www.blablabla) -u...
asked by 04.04.2018 / 19:08
1
answer

How to upload multiple XML files to MySQL

I need your guidance for the following: In my web server I have a directory where invoices are saved in XML format, a file is generated for each invoice issued so I only know the file extension. The information of each XML I need to store it in...
asked by 05.04.2018 / 20:40
0
answers

Select record by date

I have the following function: public function findDate($empcode, $seldate, $hora) { // query to select all user records $query = "SELECT * FROM " . $this->table_name . " WHERE cdempid...
asked by 10.04.2018 / 21:07
0
answers

how to put the result of a new query in a table that already exists?

How can I place the result of the $ query5 within the table that already exists, that is, put a new column to that table with this result, and also how can I title each column? <?php if ($_SERVER['REQUEST_METHOD'] === 'POST'){ $conexion = m...
asked by 10.04.2018 / 18:34
1
answer

Error does not save data in Mysql

I have the following problem, when I enter data in the form and submission, it responds to me as successful, it even saves the images in the folders, but it does not save anything in the database. I do not know what the error is <?php $mico...
asked by 10.04.2018 / 21:11
1
answer

How to get the id from a codeigniter driver

I'm modifying my controller to get the id and send it to the view that has the role, the roles are handled directly from the table default_users public function sendNew($msg = null) { /*funcion para extrar el usuario logeado */...
asked by 04.04.2018 / 23:54
0
answers

How should you group this query?

Good morning companions, I have the following table co_orderdetail The detail is that I want to list it in columns in the field ordercoin I have executed it like this and it shows me this result: SELECT id_order,...
asked by 04.04.2018 / 23:27
0
answers

error MtSQL 1048 can not be null

drop database BaseDatos; create database if not exists BaseDatos; use BaseDatos; create table if not exists genre( id_genero int not null auto_increment, nombre_genero varchar (45) not null, primary key (id_genero))ENGINE=INNODB; create table i...
asked by 05.04.2018 / 02:43
0
answers

Print the two variables of two tables

My problem is this: I want to print the result of two fields that are in two different tables and that show like this: field1-table1 field1-table2 field1-table1 campo1-tabla2 What I have is this and it prints me the values of one table...
asked by 25.04.2018 / 22:02