how to Create & import Database using command prompt? Here is the steps for Create Database & import sql file into the database from command prompt.
Hindi data could be fetch using ‘utf8’ encoding. Solution is to change database character set or change mysqli config data character set.
What are the technical reasons for why one shouldn’t use mysql_* functions? (e.g. mysql_query(), mysql_connect() or mysql_real_escape_string())?
Why should I use something else even if they work on my site?
Use prepared statements and parameterized queries. These are SQL statements that are sent to and parsed by the database server separately from any parameters. This way it is impossible for an attacker to inject malicious SQL.
Here we will see how to Increase The Database Upload Size In Wamp Server.
Go to your Wamp installed directory and follow the below steps and open the “phpmyadmin.conf” file
When we try to upload database in Wmap server sometimes we get error like “WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded”.
When you try to run Wordpress in windows and you got this error “ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password:NO)”, you can follow this steps to solve the issue.
Here we will see How to store Emoji Character in My SQL Database with custom coding in php and database.