edit-article

Article Description: ] Top 10 MySQL Mistakes Made By PHP Developers -

Chapter ID/Name:

Status: Write Writing Written

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">Top 10 MySQL Mistakes Made By PHP Developers</h1> <h2>[WHAT]</h2> <ol> <li>] by __ @ sitepoint.com -&nbsp;PHP is relatively easy and most new developers can write functional code within a few hours. However, building a solid, dependable database takes time and expertise. Here are ten of the worst MySQL mistakes I&rsquo;ve made (some apply to any language/database)&hellip;</li> </ol> <h2>[WHY]</h2> <ol> <li>]&nbsp;</li> </ol> <h2>[WHERE]</h2> <ol> <li><strong>] READ THE FULL ARTICLE</strong></li> <ol> <li>]&nbsp;<a href="https://www.sitepoint.com/mysql-mistakes-php-developers/" target="_blank">https://www.sitepoint.com/mysql-mistakes-php-developers/</a></li> </ol></ol> <h2>[WHEN]</h2> <ol> <li>] 2017-04-25</li> </ol> <h2>[EXAMPLE]</h2> <ol> <li>] DO use innodb</li> <li>] DO use PDO</li> <li>] DO sanitize user input&nbsp;</li> <li>] DO use UTF-8</li> <li>] DO USE sql over php</li> <li>] DO optimize your queries</li> <li>] DO use the right data types</li> <li>] dont use * in select queries</li> <li>] DO get indexing right</li> <li>] DO backup</li> <li>] DO consider other RDBMS</li> </ol> <h2>[HOW-TO]</h2> <ol> <li>]</li> </ol> <h2>[REFERENCE]</h2> <ol> <li>] SRC = g?='mysql'</li> </ol> <h1 style="text-align: center;">&nbsp;</h1>