Difference between revisions of "PHP"
Jump to navigation
Jump to search
(Created page with "Category:Programming Script language for dynamic web-pages. The syntax and concepts used are similar to Perl ;$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbnam...") |
(No difference)
|
Revision as of 16:01, 9 June 2019
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');
- 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
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