Create PHP PDO To Insert, Select, Update, Delete In MySQL Database Table. PDO (PHP Data Objects) is a PHP extension to access the MySQL database. function the same as, mysql_query or mysql_fetch_array. Currently functions like mysql_query and mysql_fetch_array already been deprecated and will be removed in the next version of the php program.
Create MySQLi & PHP To Insert, Select, Update, Delete In MySQL Database Table. Given some time to come mysql_ query will be deleted in php program then we can start trying to use other php script to access MySQL database. One php script is to use MySQLi.
The MySQL Extension is Deprecated And Will Be Removed From PHP Programming. MySQL and PHP is arguably the couples two lovebirds are quite intimate. Because, when you first learn about PHP, then surely its database management using MySQL because of its simplicity. But PHP developer would have announced that the mysql PHP extension is removed from the latest version ? Do not worry. Instead of integration between PHP and MySQL to be removed, but the function prefix mysql_ be deleted in the next version of PHP. Why ?
Basic Tutorial : PHP mysql_real_escape_string() Function. mysql_real_escape_string () is a PHP function that is used to give the backslash in some php code to be displayed on webpage, but when storing and matching the data in mysql, the code will remain normal with no backslash.
Some codes is \ x00, \ n, \ r, \, ‘, ” and \ x1a. Unlike the addslashes() function and stripslashes() function are both associated with slash marks, and at the time of saving some code that will change, but not for mysql_real_escape_string() because it uses specialized in MySQL and including the safety. Continue reading
Tutorial : About SQL Injection And How To Fix. In web programming, one of the most dangerous bugs and are at high risk to the security of a website is SQL Injection. This bug is usually exploited by hackers to attack a website. SQL injection is usually done by entering commands or additional syntax into form contained in the website, both form in the address bar, as well as that of the form content.