The webhosting I use has enabled StrictMode for the Databases. All my php scripts now stopped working because they report I haven't defined a default value for some columns. As I have a lot of columns in a lot of…
I am trying to insert some data with node.js. I installed MySQL support via npm, but It still seems to fail to input the right strings with INSERT INTO. (the row types in the database are tinytext and the strings…
I installed phpmyadmin on my ubuntu server following these steps here: https://www.rosehosting.com/blog/install-phpmyadmin-on-ubuntu-16-04/ I installed apache, php, mysql following these steps: https://vijayasankarn.wordpress.com/2017/01/17/setting-lamp-stack-in-ubuntu-16-04-using-aws-ec2/ and when I goto login to http://myserver.com/phpmyadmin I get this error: mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using…
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…
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…
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 don't know why it doesn't show up anything, I already tested my query and it is working in my phpmyadmin, but in my php code it does not work upon adding the AS keyword. My goal for this is…
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 |…
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…