I'm currently coding a blog to get experience with php(I've made an MVC-Framework), so I am still new to this. I have two tables important for this question: user(id, username, password, registrated) comments(id, content, post_id, comment_author, date, editedAt, editedBy) In…
I deleted a sql table (without key constraint check) and now i can't regenerate from sql query or import again. creation query: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;…
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:…
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…
Hope you are doing all ok. I am new to programming and I've been messing around with some things: javascript in Google app script, some python lines too, and some basic SQL skills too. I managed to create a simple…
I want to display certain DIVs to certain users. To do that I have a column in phpMyAdmin, called "UserType" which indicates if the user is above or below 18. Based on that, if the user is below 18, I…
Image attachment pages show up in search results on website. I need to know how i can remove ones that are currently there. If i can only do this in my database, how can i make sure i delete the…
I want to copy a row for example whith ID=23 in a table A into another table with ID=30 into another database. I got this INSERT INTO pacaya_control_venta.tb_venta_pacaya WHERE ID=33 SELECT * FROM llamadas.tb_venta_pacaya WHERE ID = 48; But I…
Im doing a project for restaurant.so in it i need invoice tabel in database.in invoise there are multiple items like mango juice and fried rice, like wise.the amount of items are different for each bills.so how i create my in…