Category Archives: Tutorial

Php web development tutorials

How to enable encoded forward slash in path-info in mvc or CodeIgniter app urls

By Silver Moon | May 16, 2023

Path Info Urls When using path info data , the urls of codeignitor apps or your custom mvc frameworks looks something like this example.com/index.php/controller/method/param1/param2 or example.com/controller/method/param1/param2 The path info data can be used to specify which class and method should be invoked on server application. Forward slash in parameter Sometimes it might so happen that… Read More »

How to use “path info” with PATH_INFO / ORIG_PATH_INFO in Apache Php Setup

By Silver Moon | May 15, 2023

The PATH-INFO is the extra path data that follows the name of a script (or servlet) in the URL. Its different from query string. Here is a classic example: https://www.examples.com/index.php/some/path?a=b Now, over here we are actually invoking the script index.php only. However also providing some path-info data “/some/path”, which is then followed by the query… Read More »

PHP: Get visitor’s location, city, country from IP address

By Silver Moon | July 11, 2019

Ip to Location Many applications need to get information about the geographical location of the user/visitor on their websites. This can be done in many ways. There are online services like ipinfodb and geoio that provide web based api to get the geolocation information about a given ip address. Services like Maxmind geoip provide free… Read More »

Parse and change date format in php

By Silver Moon | May 1, 2009

Parsing dates Most php applications need to parse dates and convert them to timestamps for example. Parsing is also necessary to convert the date into a more standard format like yyyy-mm-dd which can be stored in a database like mysql. Mysql database stores dates in the format yyyy-mm-dd like 2009-04-15. However humans are more used… Read More »

Restore Mysql Database from a sql or zip file using PHP

By Silver Moon | May 1, 2009

In a previous post we learnt how to inside php. In this example the same zip file would be used to restore the database. Code // Function to restore from a file function restore($path) { $f = fopen('restore/temp.sql' , 'w+'); if(!$f) { echo "Error While Restoring Database"; return; } $zip = new ZipArchive(); if ($zip->open($path)… Read More »

Backup mysql database with php and zip it

By Silver Moon | May 1, 2009

Many php applications prefer to backup the mysql database from within the application and save it as an archive. The mysqldump commandline utility can be used to perform this function of backing up a mysql database as sql file. The command would be like this : mysqldump –user=$username –password=$password –opt $db_name > $dir/backup.sql The above… Read More »

Run php scripts from cron

By Silver Moon | March 22, 2009

Automatic Running In a web application there are many cases, when a certain piece of code or script needs to run automatically in the background to perform certain tasks, without the need of any user to start it. Like scraping, extracting or crawling data from web or perform some regular tasks like sending emails, system… Read More »

Php set_time_limit wont take into account socket operations

By Silver Moon | March 8, 2009

The PHP function set_time_limit is used to set a time limit on the maximum execution time of a script. But if the script has socket operations using fsockopen , fread and fwrite or even CURL then the set_time_limit may not appear to have any effect on the scripts timelimit or timeout. Again if safe mode… Read More »

Get real IP address of user in php

By Silver Moon | December 4, 2008

Client IP address Php applications are mostly web based and often need to get the ip address of the user who is connecting to the application. Ip address is required for various logging purpose, geolocation service etc. The most common way to get the ip address of a remote user is by using the superglobal… Read More »

How to do Remote Login with Curl in PHP

By Silver Moon | May 2, 2023

Remote login with CURL The curl extension of php can be used to open remote webpages by both GET and POST methods. There are many situations when you need a php script to login into a website and open a certain page. For example when you are writing a bot or web scraper. To login… Read More »

How to Create Excel files in php with csv and tsv format

By Silver Moon | July 31, 2020

Database applications written in php often need to export data for reporting purpose. A popular export format is excel. Excel is a spreadsheet that lays out data in a grid format. Excel itself is a microsoft proprietory format. There are many libraries available for php like Spreadsheet_Excel_Writer pear package etc that can do the job…. Read More »

Category Archives: Tutorial

How to enable encoded forward slash in path-info in mvc or CodeIgniter app urls

How to use “path info” with PATH_INFO / ORIG_PATH_INFO in Apache Php Setup

PHP: Get visitor’s location, city, country from IP address

Parse and change date format in php

Restore Mysql Database from a sql or zip file using PHP

Backup mysql database with php and zip it

Run php scripts from cron

Php set_time_limit wont take into account socket operations

Get real IP address of user in php

How to do Remote Login with Curl in PHP

How to Create Excel files in php with csv and tsv format

About

Linux and Open Source

Other Categories