Questions tagged as 'mysql'

Tagged questions
0
answers

Error connecting to the MySql database

I try to connect to the Mysql database in PhpMyAdmin from php to fill a drop-down list but it does not fill up. Share php code: Conexion.php <? $conexion = mysql_connect('localhost', 'root', '1234'); mysql_select_db('sistema_sms', $conex...
asked by 12.01.2018 / 22:52
2
answers

Problems executing mysql -u -p command

I have a problem and a few days ago I tried everything and I could not find the solution. On my server where my DB is hosted in MySQL when executing MySQL login mysql -u -p It shows me the following error mysql: [ERROR] unk...
asked by 12.01.2018 / 21:05
0
answers

Display grouped query data in Hightchars

I want to be able to show on a Highcharts chart the result of the following query with Json: process_combustible3.php $MES_ACTA3 = $_POST['MES_ACTA3']; $ANO_ACTA3 = $_POST['ANO_ACTA3']; $resultado7 = []; $query= "SELECT PLACA, SUM(VALO...
asked by 24.01.2018 / 13:34
0
answers

Delete files from a server from a MYSQL trigger

Dear friends: I have the following code in a MYSQL trigger CREATE DEFINER = CURRENT_USER TRIGGER 'mfnmlsbase'.'post_BEFORE_DELETE' BEFORE DELETE ON 'post' FOR EACH ROW BEGIN DELETE FROM ficheros WHERE ficheros.fic_token_padre = old.pos_toke...
asked by 24.01.2018 / 16:07
0
answers

Databases in IONIC with MySQL

I am looking for information on the topic of access to data from Ionic 3, and I do not get it completely clear. You see, I have a web application, which is supported by a MySQL Database by phpmyadmin (relational). What I want to do is an app, fo...
asked by 13.01.2018 / 11:49
0
answers

php does not save in database

good, I'm doing a php mvc tutorial and I have the problem that I do not run the PDO, I thought it could be xampp problem, so change to wamp, and even delete the instance of mysql that had already installed before, thinking that it could be a pro...
asked by 24.01.2018 / 12:42
1
answer

Edit two fields from different tables in a query

One question, I opened some way that when I edit a specific field of a table, at the time I edit another field in another (Database = Mysql), since I have a date type field and I need that when I modify in special that field I edit another field...
asked by 24.01.2018 / 14:26
1
answer

How to connect Xampp-android wifi

My question is if it is possible to open a web page created in xampp from my laptop by means of my android cell phone just by using the wifi zone of my cell phone. Since as a beginner developer, I would like to try my website from my cell phone....
asked by 14.01.2018 / 02:48
1
answer

Sqldatareader invalid cast exception getDouble

I'm trying to get Double type values from an sql datareader, so all right, it happens that when I do a dr.getDouble (2) it gives me invalid cast exception.    System.InvalidCastException: 'Unable to convert an object of type' System.Byte [] '...
asked by 15.01.2018 / 09:54
1
answer

update Trigger - Mysql

I have to create a trigger associated with the orders table so that when I update a record in the orders table, I update it in the table detailing requests, I have tried it in the following way but there is no way, if someone could solve it. ......
asked by 14.01.2018 / 11:21