Questions tagged as 'mysql'

Tagged questions
1
answer

How to delete records from the database according to the table relationships?

I hope you are well. What happens is the following, I am developing a simple web application for a school and I am working with a relational database as seen in the attached image. In my web application access several users (Officials, Tea...
asked by 18.04.2018 / 16:31
0
answers

connect php with power BI

I want to take a full view of power BI and show it on my website in php, is this possible? I have the credentials to enter power Bi in my Mysql database I want to give it in a link in the navigation bar to take those credentials to the power BI...
asked by 18.04.2018 / 18:14
1
answer

Problems saving a data

I am trying to insert a data that I extract from a list, but when choosing the data (eg: Esteban), just save the E . Here is a fragment of the code. <td> <select name="noap" id="noap"> <option value="<?ph...
asked by 18.04.2018 / 16:40
0
answers

Generate consecutive number in PHP

Hello, I wanted to assign fixed letters to a column in mysql and generate a consecutive number, this number has already been generated with the following code: <?php $consulta = mysqli_query($mysql,'SELECT MAX(num) as num FROM num_ficha L...
asked by 17.04.2018 / 08:56
1
answer

Autocomplete html sql form

Well, I'm creating a system for the control of dining rooms, I'm really new to this, however I like to learn, I explain my problem I have a bar code reader reads a "card" and inserts the code into an input , I would like that when reading the ca...
asked by 15.04.2018 / 23:19
1
answer

How do I generate the SQL query with a select parameter in php?

Good as I can do to bring me a data from a table, by means of the query sql with a parameter, the parameter will be the value of a select My code is: and where the query is: where is the N ° 1 is where the value obtained fro...
asked by 17.04.2018 / 00:12
1
answer

How to create a form for an existing mysql database [closed]

How can I create a form that stores information in a table in an existing mysql database?     
asked by 13.04.2018 / 18:25
0
answers

Display MySQL records in a DataGridView

I have a database that stores records from a parent MDI Form, all right there. The problem arises when I require that the records of the BD, are shown in a DataGridView that I have inside a child MDI. I have corroborated different sources:...
asked by 21.04.2018 / 23:58
0
answers

error in function insert (connexction must be valid and open)

Hello good afternoon everyone, I have a small problem in VB, I'm working with mysql, I have a button that resionarlo makes a search in a table, if that value does not exist, I wonder if I want to register, this is where the problem comes , since...
asked by 21.04.2018 / 21:42
0
answers

How to solve mysql_connect ()?

Could someone help me with this error (Error triggered: mysql_connect () :), I explain: I have an old script, this contains a typical installation interface. Everything is fine until the final installation step where I get this error:    Erro...
asked by 21.04.2018 / 20:14