Category Archives: PHP/MySQL
Here’s How You Can Copy a SQL Server Table to MYSQL Using PHP
Generally everybody has a basic way of proceeding at the working space. While working everyday the developers work on a planned job everyday. This includes pulling out the information’s out of Oracle database and then afterwards dumping them into Microsoft SQL table which is on one of the local IIS Web server. Then the team has in their hand a script on the remote LAMPP Web server that queries the MSSQL table and afterward shows results on the Web site. However sometimes the results can be a bit undependable and slow as because of the different location of …
Use PHP and Pear Graph in your Web Page to show Statistics
Nowadays it has become a nice trend to add graphical representation of statistical data to enhance the quality of web pages. But the question is how to create dynamic graph or pie chart or bar chart in the web pages with PHP programs. Trust me guys, its very easy if you do it with PEAR image package. Ok…let me write down all the steps, how you might do it. • If PEAR is not installed in your server please install PEAR. Good news…it comes absolutely free being an open source package. You will get PEAR installation guide from …
How to use PHP Unit
In the previous topic I discussed the use of PHPUnit for PHP programmers. Hope it has been of help to you. Today I would like to discuss the implementation part of it. As I said earlier, PHPUnit is an integral part of PHP testing. PHPUnit is very easy to use but prior to it, we need to know how to install it in the system. There are some manual downloads available on Internet but I would suggest you go for the PEAR Installer which, you will find in http://pear.php.net. This installer is the backbone of PEAR, which provides …
The Power of ‘i’
Yes, ‘i’ makes a difference…and for those working in MySQL there could be no better way getting it proved. Shift to MySQLi… the latest extension for PHP5 that will support all the features in MySQL version 4.1 and more. Why would anyone like to switch to ext/mysqli … let’s have a deeper insight into it. 4 reasons to shift to MySQLi: Greater speed: the modified features in MySQLi have made operations faster. Can you believe now you can perform a task in MySQLi 40 times faster as compared to ext/mysql!? Better security: In the older versions of the …
