Questions tagged as 'mysql'

Tagged questions
1
answer

Procedures MySql

Hello, I'm new to procedures and I have a question I did not find on the internet. I need to create a procedure to include 2 tables: "User", "Supplier". The provider has a user FK, that is, in this procedure, I need to insert a user, get t...
asked by 20.10.2018 / 05:57
1
answer

Get the data related to more than one table, separately?

I can not do this at all. It seems to be with the join, but when I try, it returns zero records. I have the tables: TB1, TB2, TB3, TB4, TB ... etc All with PK (ID) I tried this code: SELECT ID FROM TB1 inner join TB2 on (TB1.ID = TB2.ID)...
asked by 27.08.2018 / 15:43
1
answer

Pagination error removing number displayed on link

** The pagination works perfectly, but when I do the following: I change everything in good pagination, it gives me a url parameter equal to: localhost / index.php? page = 1 if I remove the page number and I just leave it = it gives me an error...
asked by 23.08.2018 / 19:08
1
answer

FORM HTML5 and PHP all on the same page [closed]

How to process these tasks before the form is written to the database? CASE 01: How do you prevent visitor from being repeated in visitor ? CASE 02: How to determine winner or draw? CASE 03: Given the CASE 02 , how to write...
asked by 21.08.2018 / 03:59
1
answer

PHP error when writing using double quotes [duplicate]

I'm trying to write a record to a MySql database, but it gives error because one of the fields gets the value Frantchelle's with quotes.    Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL synta...
asked by 16.02.2018 / 17:59
1
answer

(PHP MYSQL) Split number of hours in number of users and save in mysql

Good morning, fellow programmers. I would like help, I have a mysql database with a certain amount of users, and I need to get the range of hours (ex: 10:00 p.m. to 2:00 p.m.) and divide by the number of users, and then set the value divided for...
asked by 15.03.2018 / 15:53
2
answers

How to access the database of another machine

Well, guys, good night. The following is: I'm having a PHP project with MySQL to be delivered. However, I'm doing it this way: I created 3 virtual machines in VMWare Workstation Pro, Client's is Windows, which only stays PHP is Ubuntu, and the on...
asked by 10.12.2017 / 23:43
1
answer

PHP update undefine

I can not do the Update in the database faults.php <?php if($_SESSION['MM_Username']=="Comandante"){ if(isset($_POST['estadoComando'])){ updater($_POST['estadoComando'],$_POST['id']); //<-- linha 213 } function u...
asked by 20.12.2017 / 16:39
2
answers

Checking whether the record already exists in the database [duplicate]

I'm using this function in my form but I have a problem. It is validating the field and is not including in the bd, but the message instead of saying that the client already exists is saying that it was successfully registered. How to fi...
asked by 20.12.2017 / 15:21
1
answer

How to receive data from an html form with PHP [duplicate]

Good afternoon, I'm new to this area and I'm having trouble getting my html form data with my PHP code. My problem is that I am using the Inputs name format the following format name="data [Curriculum] [name]"  however when I enter the...
asked by 02.08.2018 / 19:13