I'm trying to solve a problem pertaining to PHP. So far I have created an html login form login.html and a PHP file login-insert.php. I'm having trouble detecting if the username already exists in the database created using phpmyadmin. I'm…
I'm looking to run a query that gets all rows that occur on a specific date. For example, the query should return both of these entries, if I want all entries that occured on 2019-03-21. Any ideas on how to…
My apache is running properly but mysql server is showing this error Error: MySQL shutdown unexpectedly. [mysql] This may be due to a blocked port, missing dependencies, [mysql] improper privileges, a crash, or a shutdown by another method. [mysql] Press…
Here i am again. Thank you so much for help. Here is my Old question on how i can select and display the grade of student in a junction table. Select and display all rows belonging to a specific ID…
hi i have a backend with php in cpanel and i have a problem with one of jsons . this is part of my php code : ... }elseif ($work == "dollardate") { $query3 = "SELECT * FROM tabl_dollar_date"; $result3…
Really need some guidance, I have a website where people can upload images to competitions and they get a result (marks), I want to pull out a LEADERSHIP BOARD to see how everyone is doing. However the SQL Query I…
I have Table student, student_subject and subject_bsit "student" ----------------------- |studentID | FullName | ----------------------- |1234 | John | |1235 | Michael | |1236 | Bryce | "subject_bsit" ----------------------------------- |subject_id| subject_name |grade | ----------------------------------- | 1 | Programming | 3 |…
lets say I have the link http://localhost:8080/Simple/index.php?ref=user5 after I click it, I want "user5" to show up inside Input. Thank you in advance
I want to pass the values of the below form in a database set up with phpMyAdmin: <form action="recordBook.php" method="post"> <input type="text" name="title" placeholder="Enter the book title"> <input type="text" name="author" placeholder="Enter the author's name"> <input type="checkbox" name="read" value="1"> <br><input type="submit">…
I'm trying to create a stored procedure in phpmyadmin but when I try to create a second one, I get the error #1327 - Undeclared variable. This works fine: BEGIN DECLARE id_pro INT(9); SELECT user_product_id INTO id_pro FROM usuario; END…