Common PHP Mistakes Beginners often make

Laravel Meetup Georgia 2016 #1 Speech

Transcript

1. Common PHP Mistakes Beginners Often make
2. Using mysql extension 1 $c = mysql_connect("host", "user", "pass"); 2 mysql_select_db("db"); 3 $res = mysql_query("SELECT * FROM tb LIMIT 1"); 4 $row = mysql_fetch_assoc($result); 1 $mysqli = new mysqli("host", "user", "pass", "db"); 2 $res = $mysqli->query("SELECT * FROM tb LIMIT 1"); 3 $row = $res->fetch_assoc(); Deprecated! Secure Reliable Fast
3. Not Using PDO 1 $sth = $dbh->prepare 2 ('SELECT * FROM fruit WHERE foo < ? AND bar = ?'); 3 $sth->execute(array(150, 'baz')); 4 $bazs = $sth -> fetchAll(); • Practical OOP Syntax • Support of PostgreSQL, MS SQL, etc. • Can Inject fetched data directly into a new object
4. Not Rewriting URLs https://stupidblog.org/post.php?id=1337 https://stupidblog.org/posts/1337/kardashyan-shit-again/ • SEO • User friendly • Neat
5. @Suppressing errors Warning == Fatal Error @ == code might suck but I just don’t care
6. Not validating User input, Sessions, Cookies 1 mysqli::real_escape_string ( $foo ); 2 htmlspecialchars( $bar );
7. “Screw this, I’m gonna use laravel”
8. Thanks! Contact me: Giorgi Bagdavadze notgiorgi@gmail.com