PHP Syntax for beginners Cheat Sheet

A Programming › PHP cheat sheet in English by guslong

Helpful PHP

86,334 views 18,473 downloads 20 Jul 2012 History

PRs

Download

4.9 avg · 19 ratings

Connect to the database

$dbc = mysqli_connect(HOST, USER, PW, DB);

Query the database

$result = mysqli_query($dbc, $query);

Close the connection

mysqli_close($dbc);

isset()	test for variable exists
empty()	test for empty variable
mail($to, $subject, $msg, 'From: ' . $email)	mail function
mysqli_fetch_array($result)	fetch each row of a query (in $result)
header()	send a header from the server
is_numeric()	test to see if a value is number
exit()	causes script to stop immediately
trim($string)	trims leading and trailing spaces
mysqli_real_escape_string($string)	escapes special characters
str_replace('a', 'b', $string)	replace a with b in a string
explode(', ' , $string)	make string into array
implode(', " $string)	make array into string
substr ($string, start, len)	grabs a substring
preg_match('regex', $string)	matches regular expressions
preg_replace('regex', $replace, $string)	replaces characters in a string by regex

if (condition) {
... }
elseif (condition) {
... }
else {
... }

FOR loop	for (initialize; condition; update) { ... }
WHILE loop	while (condition) { ... }
FOREACH loop	foreach ($array as $value) { ... }
DO WHILE	do { ... ;} while (condition)

FOR (loop until a condition is met)
WHILE (loop through query results)
FOREACH (loop through an array)

for ($i = 0; $i < 5; ++$i) {
if ($i == 2)
continue;
print "$i , ";
}

produces the following output:
0 , 1 , 3 , 4

SWITCH ($s) {
case 1:
...
break;
case 2:
...
break;
default:
...
}

can be used with numbers, or strings

^	start of string
\d	number from 0 to 9
\s	whitespace
.	any letter or digit or whitespace
\w	any alphanumeric [0-9A-Za-z]
$	end of string
( )	group
[ ]	character class
{x} {x,} {x,y}	x of \| x or more of \| x to y of
\|	or
*	none or more
?	none or one
+	one or more
\	escape

Badges

Useful Cheat Sheet Great Cheat Sheet Good Cheat Sheet Nice Cheat Sheet Appreciated Cheat Sheet Downloaded from Unusual Locations × 11

Bryan 10:53 11 May 2014

use php PDO for database access. the call show here is dinosaur age and dangerous.