\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{Benoit Tavernier (benoit)} \pdfinfo{ /Title (fondamentaux-sur-php.pdf) /Creator (Cheatography) /Author (Benoit Tavernier (benoit)) /Subject (Fondamentaux sur PHP Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{8892BF} \definecolor{LightBackground}{HTML}{F7F8FB} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Fondamentaux sur PHP Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{Benoit Tavernier (benoit)} via \textcolor{DarkBackground}{\uline{cheatography.com/27689/cs/8091/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}Benoit Tavernier (benoit) \\ \uline{cheatography.com/benoit} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 23rd May, 2016.\\ Updated 12th May, 2016.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{3} \begin{tabularx}{5.377cm}{x{2.83689 cm} x{2.14011 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Syntaxe globale}} \tn % Row 0 \SetRowColor{LightBackground} Ouverture de contexte PHP & `\textless{}?php` \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Fermeture de contexte PHP & `?\textgreater{}` \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Commentaire (ligne simple) & `// Texte` \tn % Row Count 6 (+ 2) % Row 3 \SetRowColor{white} Commentaire (multiligne) & `/* Texte */` \tn % Row Count 8 (+ 2) % Row 4 \SetRowColor{LightBackground} Fin d'instruction & `;` \tn % Row Count 9 (+ 1) % Row 5 \SetRowColor{white} Bloc d'instructions & `\{ {\emph{instruction;}} \}` \tn % Row Count 11 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Types primitifs}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{bool} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{int} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{float} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{string} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{array} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{object} \tn % Row Count 6 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{resource} \tn % Row Count 7 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{5.377cm}}{null} \tn % Row Count 8 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.44333 cm} x{3.53367 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Variables}} \tn % Row 0 \SetRowColor{LightBackground} \seqsplit{Initialisation} & `\$variable = 'valeur';\{\{nl\}\}\$variable = \$autreVariable;\{\{nl\}\}\$variable = {\bf{\&}}\$reference;` \{\{fa-warning\}\} \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} Test valeur vide & `empty(\$variable);` \tn % Row Count 6 (+ 2) % Row 2 \SetRowColor{LightBackground} Test \seqsplit{d'existence} & `isset(\$variable)`; \tn % Row Count 8 (+ 2) % Row 3 \SetRowColor{white} \seqsplit{Destruction} & `unset(\$variable)`; \tn % Row Count 9 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.54287 cm} x{3.43413 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Constantes}} \tn % Row 0 \SetRowColor{LightBackground} \seqsplit{Initialisation} & `define('NOM', 'valeur');`\{\{nl\}\}`const NOM = 'valeur';` \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} Utilisation & `echo NOM;` \tn % Row Count 4 (+ 1) % Row 2 \SetRowColor{LightBackground} Test d'existence & `defined(NOM);` \tn % Row Count 6 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.94103 cm} x{3.03597 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Manipulation de booléens}} \tn % Row 0 \SetRowColor{LightBackground} Inversion & `!true` \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} ET logique & `AND` \{\{fa-warning\}\}\{\{nl\}\}`\&\&` \tn % Row Count 3 (+ 2) % Row 2 \SetRowColor{LightBackground} OU logique & `OR` \{\{fa-warning\}\}\{\{nl\}\}`||` \tn % Row Count 5 (+ 2) % Row 3 \SetRowColor{white} OU exclusif logique & `XOR` \tn % Row Count 7 (+ 2) % Row 4 \SetRowColor{LightBackground} Priorités forcées & `( {\emph{test booléen}} )` \tn % Row Count 9 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.14011 cm} x{2.83689 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Manipulation de nombres}} \tn % Row 0 \SetRowColor{LightBackground} Adition & `1 + 2` \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} Soustraction & `1 - 2` \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} Multiplication & `1 * 2` \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} Division & `1 / 2` \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} Modulo & `1 \% 2` \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} Incrémentation & `\$nombre++` \tn % Row Count 6 (+ 1) % Row 6 \SetRowColor{LightBackground} Décrémentation & `\$nombre-{}-` \tn % Row Count 7 (+ 1) % Row 7 \SetRowColor{white} Augmentation & `\$nombre += \$valeur;` \tn % Row Count 8 (+ 1) % Row 8 \SetRowColor{LightBackground} Diminution & `\$nombre -= \$valeur;` \tn % Row Count 9 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{1.74195 cm} x{3.23505 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Manipulation de texte}} \tn % Row 0 \SetRowColor{LightBackground} \seqsplit{Initialisation} large & `"phrase"` \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} \seqsplit{Initialisation} stricte & `'phrase'` \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Encapsulation & `"Phrase n°\$numero !"` \tn % Row Count 5 (+ 1) % Row 3 \SetRowColor{white} \seqsplit{Contaténation} & `'Phrase n°' \{\{nl\}\}~. \$numero \{\{nl\}\}~. " !"` \tn % Row Count 8 (+ 3) % Row 4 \SetRowColor{LightBackground} Recherche & `strpos()`\{\{nl\}\}`strrpos()` \tn % Row Count 10 (+ 2) % Row 5 \SetRowColor{white} Extraction & `substr()` \tn % Row Count 11 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{x{2.28942 cm} x{2.68758 cm} } \SetRowColor{DarkBackground} \mymulticolumn{2}{x{5.377cm}}{\bf\textcolor{white}{Manipulation de tableaux}} \tn % Row 0 \SetRowColor{LightBackground} Déclaration & `\$tableau = array();\{\{nl\}\}\$tableau = {[}{]};` \tn % Row Count 2 (+ 2) % Row 1 \SetRowColor{white} Tab. numérique \{\{nl\}\}auto & `\$nombres = {[}1, 9{]};` \tn % Row Count 4 (+ 2) % Row 2 \SetRowColor{LightBackground} Tab. numérique \{\{nl\}\}fixe & `\$nombres = {[}\{\{nl\}\}~~{\bf{0 =\textgreater{}}} 1, \{\{nl\}\}~~{\bf{5 =\textgreater{}}} {[}2, 6, 1{]}, \{\{nl\}\}{]};` \tn % Row Count 9 (+ 5) % Row 3 \SetRowColor{white} Tab. associatif & `\$client = {[}\{\{nl\}\}~{\bf{'nom' =\textgreater{}}} 'Ben',\{\{nl\}\}{]};` \tn % Row Count 12 (+ 3) % Row 4 \SetRowColor{LightBackground} Ajout auto d'élt & `\$nombres{\bf{{[}{]}}} = 11`; \tn % Row Count 14 (+ 2) % Row 5 \SetRowColor{white} Test d'existence & `isset(\$client{[}'nom'{]})` \{\{fa-warning\}\}\{\{nl\}\}`array\_key\_exists()`\{\{nl\}\}`in\_array()` \tn % Row Count 18 (+ 4) % Row 6 \SetRowColor{LightBackground} Accès au contenu \{\{nl\}\}associatif & `echo \$client{[}'nom'{]};\{\{nl\}\}{\bf{var\_dump}}(\$client);` \tn % Row Count 21 (+ 3) % Row 7 \SetRowColor{white} Accès au contenu \{\{nl\}\}numérique & `{\bf{foreach}} (\$nombres as \$n) \{ \{\{nl\}\} ~~echo "Nombre : \$n \textless{}br\textgreater{}"; \{\{nl\}\} \}` \tn % Row Count 26 (+ 5) % Row 8 \SetRowColor{LightBackground} Modification d'élt & `\$client{[}'nom'{]} = 'B.';` \tn % Row Count 28 (+ 2) % Row 9 \SetRowColor{white} Effacement d'élt & `{\bf{unset}}(\$client{[}'nom'{]});` \tn % Row Count 30 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}--} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Fonctions}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{/{\emph{* \newline }} @param array \$chanson \newline {\emph{ @param int \$nombreDeFois \newline }} @return bool True si on a pu tout chanter. \newline */ \newline function chanter(\$chanson, \$nombreDeFois = 1) \newline \{ \newline // On chante \newline \newline return true; \newline \}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{5.377cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{5.377cm}}{\bf\textcolor{white}{Base de données MySQL}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{5.377cm}}{\$connexion = mysqli\_connect( \newline \$hote, \newline \$compteMysql, \newline \$motDePasseMysql, \newline \$baseDeDonnees \newline ); \newline \newline if (!\$connexion) \{ \newline \seqsplit{http\_response\_code(500);} \newline die('Erreur de connexion'); \newline \} \newline \newline if (\$res = \seqsplit{mysqli\_query(\$connexion}, \$sql)) \{ \newline while (\$valeurs = \seqsplit{mysqli\_fetch\_assoc(\$res))} \{ \newline var\_dump(\$valeurs); \newline \} \newline \seqsplit{mysqli\_free\_result(\$res);} \newline \}} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}