Questions tagged as 'mysql'

Tagged questions
0
answers

function defined with variable

I have the following code to define a constant with the value of a variable: define('DB_NAME', $row['co_database_name']); and use it in a connection string $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET ....
asked by 21.10.2018 / 18:46
0
answers

How to insert data into tables related to primary key autoincremental?

Well I got a little problem that I have my class diagram and I want to insert data to 5 tables that are related to each other Here I show you my tables that I have and also I will put an image of all my diagram that made this little system that...
asked by 21.10.2018 / 05:02
2
answers

Group data in MySQL query

I have a pivot table that holds 3 fk, user_id, subject_id and level_id .. What I want is to group the user to a subject and all levels .. in the pivot table is stored as follows: |usuario_id|materia_id|nive_id| | 1 | 1 | 1...
asked by 21.10.2018 / 02:41
0
answers

Link PHP with Mysql

Hi, link the PHP with MySql but I get this error: Fatal error: Uncaught Error: Call to undefined function mysql_connect () in C: \ xampp \ htdocs \ doubled \ BD.php: 15 Stack trace: # 0 C: \ xampp \ htdocs \ double \ connectionion.php (4 ): c...
asked by 21.10.2018 / 19:10
0
answers

Upload Google Maps capture to MySQL with PHP

I am trying to upload a Google Maps capture that I made from Android Studio , but when sending the capture to the server the image arrives empty and I do not know why. Code: public void captureScreen() { SnapshotReadyCallba...
asked by 19.10.2018 / 23:23
0
answers

The message "use mysqli or PDO instead" is optional or mandatory

A while ago I transferred a website that works with smarty to another hosting and since it happened there was a section of the front-end that did not work well. Some change was made and it was solved, or apparently that seemed. The fact is th...
asked by 19.10.2018 / 20:52
0
answers

error when installing npm dependency

I'm trying to install this dependency: npm install mysqljs/mysql But I get an error loading it npm ERR! code 1 npm ERR! Command failed: D:\Program Files\Git\mingw64\bin\git.EXE submodule update -q --init --recursive npm ERR! fatal: D:\Pr...
asked by 18.10.2018 / 00:03
1
answer

Store SELECT in Two-dimensional Array PHP / JSON

I have been doing this query, in which I make two queries to two tables, to take in one the data of the Student and in the other the modules that it studies. What I need is for me to generate an arrangement, where for each student I store the...
asked by 18.10.2018 / 00:04
1
answer

Show related of three tables

I have four tables, the first one would be: The table "articles" this table only has id_articulos, descripcioncorta, archivo, id_estatus. The table "images" which will contain the id_imagenes and the location of the images, the table. T...
asked by 22.10.2018 / 18:05
0
answers

I need to search the database depending on the selected checkboxes of the regions, their states as it could be solved

table = commerc fields id, name, brand, region, district, provincia, categoria I need that when consulting the regions, I bring the records and can select through a checkbox the districts and provinces of the selected regions....
asked by 24.10.2018 / 13:16