I'm having really hard time trying to make this work. I have this table : evid_record Its named evid_record and I want to sum columns : 'Kolokvijum teorija' + 'Kolokvijum zadaci' + 'Aktivnost' + 'Prisustvo' + 'Seminarski rad' + Domaci…
I have been working on phpmyadmin for the past couple of days. Everything was working perfectly fine until I saw this problem which was not there yesterday. 4:19:45 PM [mysql] Error: MySQL shutdown unexpectedly. 4:19:45 PM [mysql] This may be…
The SQL query in the $sql works when I directly enter that in the phpmyadmin only replacing the '$movieid' as 1 The code in the deletemovie.php: $delete = "Includes/deletemovierecord.php?id=$movieid"; echo " <tr> <td>$movieid</td> <td>$moviename</td> <td>$year</td> <td>$genere</td> <td>$stock</td> <td> <form action='Includes/updatemoviestock.php?key=$stock&id=$movieid'…
I'm trying to learn more with SQL and I am trying to INSERT a List of Numbers linked with 1 ID (row). Now I figured out how to use List in SELECT, basics like SELECT * FROM products WHERE catalog_number…
I am trying to import database through PHPMyAdmin. My database file is abc.sql and it's size is 50.9 MB. I am trying this on local and it's saying: You probably tried to upload a file that is too large. Please…
I have a standard Input Box that is submitting the value directly to the database, however including a semi-colon in the string is screwing up the DB Value. (Example 1) Text Input Value: <input type="text" id="security_check" value="a:1:{i:0;s:10:"1234567890";}"> Database Value Result:…
I have numerous error checkers which the newly inputted code successfully meet the requirements of, however, the data doesnt seem to be going into the database. Its not updating, therefore i believe theres something wrong with my line of update…
I have a website that let users download PDF files, I made a download limit 10 files per day for each user and I stored the numbers inside MySQL table under column named "downloads". Each day I use this command…
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'usr'@'localhost' (using password: YES) in /storage/emulated/0/htdocs/includes/condb.php on line 9 Failed to connect to MySql: Access denied for user 'usr'@'localhost' (using password: YES) Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in…
I have a website that let users download PDF files, I made a download limit 10 files per day for each user and I stored the numbers inside MySQL database. everything works great! The problem is: The limit will be…