Introductions – Using PHP we can connect many databases like MySQL, Postgresql, DB2, Oracle and SQL server very easily. Now this article provides the information about database connectivity to Oracle using PHP… PHP Oracle functions allow you to access Oracle 10, Oracle 9, Oracle 8 and Oracle 7 databases using the Oracle Call Interface (OCI). …
Introduction – Any database in MySQL is stored physically in Data directory of MySQL server. You can find data directory in /etc/my.cnf file or from running MySQL process.. arun@arunbagul:~$ ps aux | grep “/usr/sbin/mysqld” | grep -v grep mysql 5534 0.0 1.0 127920 21136 ? Sl 21:09 0:00 /usr/sbin/mysqld –basedir=/usr –datadir=/var/lib/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 …
Introduction – Many times System Admin want to transfer cPanel user account (domain) from one cPanel server to other cPanel Server. cPanel allows to do account transfer via WHM as follows… (you should have root access to both server). step(1) Login to WHM step(2) then Main menu >> Transfers >> Copy multiple accounts/packages from another …
Introductions – PHP provides FTP library to connect to file server using File Transfer Protocol. No external libraries are needed to build this extension. In order to use FTP functions with your PHP configuration, you should add the –enable-ftp or –with-ftp option when installing PHP 5 and other versions. The windows version of PHP has …
ORACLE Application Express – Application Express is the open source product by ORACLE. Every one knows HTMLDB, which is used for web representation of oracle database data. Now HTMLDB renamed as Application Express. We can use Oracle forms and reports for data representation. But application express got many good features, which makes web interface very …
Managing Indexes in MySQL – Index is a method/process that MySQL uses to speed up searches and reduce the time it takes to execute complex queries. Index provides an organized list of pointers to the actual data. Due to indexing, when MySQL is executing a query, it does not have to scan each table in …
Introductions – PHP got libraries through which we can create or access the excel data. There are two possible ways of creating or accessing the excel data in PHP – 1) PHP – Excel library provided by PEAR. 2) PHP using Excel COM component functions and libraries. ** In PHP – Excel libraries, Spreadsheet_Excel_Reader is …
Introduction – OpenMoko is the Free and Open Source Mobile Platform. The entire OpenMoko system and application software are built using Free and Open Source Software (FOSS). On the system side, OpenMoko uses software with a tireless history of success and stability, such as the Linux kernel, the GNU C library, the X window system, …
Introduction – Why Ubuntu does not provide GRUB splash image as background for GRUB selection menu?. Really I don’t know but, today we will learn how to do it. root@arunbagul:~# apt-get install grub-splashimages Reading package lists… Done Building dependency tree … …. root@arunbagul:~# Once you install “grub-splashimages” you will get grub splash image installed on …
Introductions – DNS server resolves domain names into IP addresses. So when you request “yahoo.com” for example, the DNS server finds out the address for the domain, and sends your request the right way. You can run a DNS cache on your system This will speed up the process of looking up domain names while …