Questions tagged as 'mysql'

1
answer

Error Connecting to MySQL with PHP and AJAX Requests

I am in a dilemma, so far the code has worked in such a way that it does not return anything and when I return the information to execute the connection and the SQL statement returns null spaces to me. <?php require_once "../../clases...
asked by 19.03.2018 / 02:12
2
answers

Doubt about foreach with mysql data

I'm new to php and mysql, I have a database with some fields already created, the idea is to print a ticket like the supermarkets but I want to list the purchased products one by one, so I read that you could use foreach, this it's the code that...
asked by 25.02.2018 / 09:35
1
answer

How do I update records in the database?

I have this code what I'm looking for is to update the data of the registers but it does not work for me. modifyingFormat.php <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Creando...<...
asked by 13.04.2018 / 15:35
1
answer

Consult mysql and show in a MS Visual Basic listbox?

Cordial greeting colleagues, It turns out that I have a database called quote, a form in MS Visual Basic with a listbox and a button called consult. what I want to do is, by means of the consult button, show in the listbox the information that i...
asked by 09.02.2018 / 18:08
2
answers

Given the hash () of Python, does it exist similar in PHP?

I have a python script, which performs a login and pass, which is stored with hash in Mysql, with the following code: pass = hash(self.get_argument("psw", 'dato')) generating a hash type -5995266028892256335 Now I need to login from PH...
asked by 26.01.2018 / 13:54
1
answer

How to use Django with an existing database in MySQL?

I have an application in Django 2.0 and as a database engine I use MySQL. I have a problem because the database was previously created and already has records, my idea is to use this same database for the application I'm creating. Use the com...
asked by 09.04.2018 / 19:00
1
answer

Error when logging in when completing the registration

Community, the error I have is that the user to have finished the registration process I want to log it at once without the need to go to a login page, the code I am using for it is the following: if(isset($_POST) && !empty($_POST)){ $...
asked by 13.01.2018 / 03:09
2
answers

I can not add the foreign key of the user table

Before the user table create the corresponding tables to add the foraneas create table acreditacion(idacre int not null auto_increment, nomacre varchar(50) not null, primary key(idacre)) ENGINE = I...
asked by 14.03.2018 / 00:24
2
answers

I get an error Call to undefined method PDOStatement :: store_result ()

This is the error    Fatal error: Uncaught Error: Call to undefined method   PDOStatement :: store_result () in   C: \ xampp \ htdocs \ helpProgramming \ core \ controllers \ searchWController.php: 44   Stack trace: # 0 C: \ xampp \ htdocs \...
asked by 29.12.2017 / 23:06
1
answer

Pass tables from MyISAM to InnoDB in MySQL

I have a database that stores content from several years ago in various tables. All the tables are currently in MyISAM and I want to pass them all to InnoDB . How could I do it without risk of data loss? I do not put what I...
asked by 17.01.2018 / 19:01