PHP: Difference between revisions

From wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[[Category:Programming]]
[[Category:PHP]]
Script language for dynamic web-pages. The syntax and concepts used are similar to [[Perl]]
Script language for dynamic web-pages. The syntax and concepts used are similar to [[Perl]]


;$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname, $dbport) or die ('Error connecting to mysql');
=Functions=
:Open database connection
;$result = mysqli_query($conn,$query) or die('Error, retrieve failed');
:Execute a query on the opened connection
;$row    = mysqli_fetch_array($result, MYSQLI_ASSOC);
:Fetch a row as hash
;$row    = mysqli_fetch_array($result, MYSQLI_NUM);
:Fetch a row as array
 
==Functions==


Function have global scope, you do not need to declare them before calling
Function have global scope, you do not need to declare them before calling

Revision as of 08:07, 10 June 2019

Script language for dynamic web-pages. The syntax and concepts used are similar to Perl

Functions

Function have global scope, you do not need to declare them before calling

<?php
function func1($arg1, $arg2)
{
    <codeblock>
    return $value;
}
?>


Install

On debian (and its derivates)

apt-get install php-fpm php-mysql
Install php7 and mysql support
Fix php security by editing /etc/php/7.0/fpm/php.ini
Uncomment line with cgi.fix_pathinfo and set it to 0