Questions tagged as 'mysql'

Tagged questions
1
answer

problem with multi query PHP mysql

Hello people, I do not know why this code does not work for me (print "you can not create the date") and I have seen on the internet that multicary is done in this way, here I leave what I did, regards    * CLARIFICATION: this is the part of...
asked by 22.04.2017 / 01:41
1
answer

Moodle permissions from PHP and MySQL

Good morning. First of all I would like to clarify that I really do not know much about these issues. I installed XAMPP in Windows and I'm installing Moodle . In Moodle I get the following errors: mysql_full_unicode_support # File_for...
asked by 20.04.2017 / 16:47
1
answer

Print two queries in the same "td" or "select"

Good morning, I'm doing a CRUD, and right now I'm making a table where I can select modify or insert users, well I come to the conclusion, that when I pass the table to users they choose for example which user they want to select, but they can o...
asked by 27.04.2017 / 06:55
1
answer

Get signature with android tablet for PHP form

Good afternoon friends. Today for work needs I had the need to make a small form to take the data of some clients, this work is going to make some colleagues from a tablet, I decided to do it in php so that the data will send them to me to a...
asked by 10.04.2017 / 20:16
2
answers

How can I place a WHERE statement on this query?

Query: SELECT 'i'.'name', 'i'.'id', 'i'.'img', 'd'.'url', GROUP_CONCAT(t.name SEPARATOR ', ') as tags FROM 'demos' i INNER JOIN 'details' d ON 'i'.'id' = 'd'.'demo_id' INNER JOIN tags t ON t.demo_id = i.id GROUP BY 'i'.'id' ORDER BY 'i'.'crea...
asked by 10.04.2017 / 16:22
1
answer

Error inserting data into mysql with foreach

The following code is used to insert mysql with a foreach foreach ($puntosVisita as $nombre) { echo $nombre; mysqli_query($bd, "INSERT INTO puntosVisita (idRuta, nombre, fechaMod) VALUES ('$consecutivo', '$nombre', '$fechaMod')") or di...
asked by 10.04.2017 / 18:00
2
answers

Connection of SQL SERVER 2012 with Codeigniter

Hello everyone, I am developing a system with CI, Mysql and Sql Server 2012, I am configuring in php 5.6.30 and I put all the exemptions in php.ini and nothing I get this error when I pick it up and that's in my databse, php $db['sqls...
asked by 10.04.2017 / 15:55
1
answer

Problems when doing an INSERT with php

I have a registration form and to enter the data in the database I have to do INSERT in different tables but in the same query. The php code that I have is the following: <?php //OBTENGO LOS DATOS DEL FORMULARIO $usuario = $_POST["usuario"...
asked by 10.04.2017 / 02:05
1
answer

Replicate a table every time another one is updated

I have two tables. Tabla A and Tabla B and I need you to just insert something in Tabla A is copied identically in Tabla B . The fields in both tables are: id , nombre and posicion Example:...
asked by 12.04.2017 / 15:53
1
answer

display a variable in mysql query Inner

I have a query of several tables and they have fields with the same name. I would like to know if there is a way to show the value of one of those fields with the same name but selected from which of the tables. I normally use $ row ["id"]...
asked by 17.05.2017 / 18:25