Home » PHP/MySQL

When a form is submitted to the server, only selected values in a multiple SELECT box reaches the server. It is not possible to access the unselected options in a SELECT box from the server. Though this is not really required always, there are situations where you would want to access all the options in a SELECT tag. One example is, when you allow users...
PHP Encountered Access Violation at [some random memory address] Many of the guys who asked me about this problem faced it when trying to run PHPMyAdmin or other applications which access database, after setting up a local PHP environment on their machine under IIS. Try these fixes. Add your PHP path (the location of PHP files in your machine) to the...
Filed in: PHP/MySQL
Often, we come across situations where we need to INSERT multiple rows in to a database table from an Array, File or even from another Database Table. I am explaining various methods for inserting multiple rows using a single query using MySQL and PHP. MySQL documentation says you can use the following methods to speed up inserts: If you are inserting...

Convert XML to Array in PHP

Posted by on January 29, 2010
Convert XML to Array in PHP using  SimpleXML Though I would suggest using DomDocument for parsing XML strings and files in PHP, here is an example of converting XML to an Array in PHP using SimpleXML method. The SimpleXML extension in PHP provides a very simple and easily usable toolset to convert XML to an object that can be processed with normal...
Filed in: PHP/MySQL
A small article for those who want to experience with Regular Expressions in PHP. Regular expressions, also referred to as regex or regexp, provide a concise and flexible means for matching strings of text, such as particular characters, words, or patterns of characters. Regular expressions are used by many text editors, utilities, and programming languages...
I have no reasons for posting this article here. But I’m sure someone can get some insight from this. This is a good example of making use of recursive function calls also known as recursion. It takes the form of a function that calls itself. Recursive functions or recursion are something that needs a little more attention as you have to be sure that...
Pretty long time back, I developed a batch uploading tool in Flash for a large online photo sharing website. The purpose of the tool was to allow the site users to upload photos from their computer to their online account. This flash tool with the complete source code is given free here. Many of the Batch process tools available cause errors while...
If you guys haven’t heard about or started using MySQL Workbench yet, it’s high time you started exploring it. MySQL Workbench is a visual database design tool that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system. Sun Microsystems has recently released the 5.2...
Filed in: PHP/MySQL
This is basically not a tutorial. Here is a ready-made code-piece you can use in your program if you need to store credit card numbers in your database while processing it for payments. If you ever need to store credit card numbers in your database, it should be encrypted before inserting in to the database. PHP has a library called Mcrypt which...
Filed in: PHP/MySQL

Page optimized by WP Minify WordPress Plugin