Home » PHP/MySQL

A very basic tutorial. For the beginners who want to pass array values from PHP to Javascript for them to be accessible in the client side JS as an array. It’s really easy to pass PHP array to Javascript. The below code passes a string array in PHP to Javascript. <?php $arr = array("a","b","c"); ?> <script> var...
Sometimes, or very rarely we might need to access a model in AppController (Application Controller). This could be for fetching values from a table and make it available for all the controllers in the application (AppController is inherited by all the other controllers). Also, often we need to access models that are not associated with a controller. I...
Filed in: CakePHP, PHP/MySQL
One of the most powerful features of CakePHP is the ability to link relational mapping provided by the model. In CakePHP, the links between models are handled through associations. The associations are defined in the models as hasOne, hasMany, belongsTo etc. It is possible to define deep relationships involving many tables and retrieve data. But CakePHP...
Filed in: CakePHP, PHP/MySQL
Developers normally use functions that use Regular Expression to convert under_scored strings in to CamelCased strings. Usage of Regular Expression is quite heavy. We can use a simple yet powerful method to convert these strings to CamelCase without using RegEx in PHP. Here is the method: echo join(””, array_map(“ucwords”, explode(‘_’,...
Do you think your website is sluggish? Does it take a lot of time to download on to a user computer? Here are some techniques to make your site load faster on user computers and enhance it’s performance. These are some of the best practices followed in the Web industry. Implementing these practices has proved that your site will become 20-30%...
Failed To Read Auto-Increment Value From Storage Engine Error in MySQL. This is a very strange MySQL error. The error happens when trying to insert a new row in to a table. Basically this is a bug in MySQL that causes the problem but a work around is simple. The problem happens when the Auto-Increment value of a table grows beyond the limit. Just run...
Filed in: 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

Page optimized by WP Minify WordPress Plugin