How can I fetch data from one database on a server and store them in other database on another server using PHP?
Many times we need to transfer data from one database exists on a server to another database exists on another server ,in that case we can use fourth parameter of mysql_connect function which is an optional parameter. If fourth parameter is true then it will create a new link for another database connection even if we have created database connection earlier with same detail with same database or with another database. Lets discuss how it works by an example.
Function syntax:
mysql_connect ( [string $server [, string $username [, string $password [, bool $new_link [, int $client_flags]]]]] )
Now Connect database1 using host, username and password as given below
$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(’db1name’, $db1);
Fire a query on db1
$res1 = mysql_query(”query”,$db1);
Connect database2 using host, username and password and include fourth parameter true as given below
$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(’db2name’, $db2);
Fire a query on db2
$res2 = mysql_query(”query”,$db2);
Now both link will remain live.If you will not use fourth parameter than setting of $db1 will be overwrite by $db2 so you can not use both objects without using this fourth parameter as true.Now after using fourth parameter you can use both database1 and database2 on same page.You can fetch data from first database and than insert that data in second database .
Tags: mysql_connect, transfer data
javascript validation to check only one checkbox among multiple checkboxes
Dec 8, 2009 Php
Suppose you have a page with the listing of all the users registered on your site. Every record has a check box with it to select that record . Client want that user can select only one record at a time from that list and user must select one record for further action. Now what to do . Don’t worry this is not so hard , you can found the solution on web for this or you can write your logic for this. But i am giving here so you can find it very easily.Here it is: Read the rest of this entry »
How to unzip a zip file using php
Nov 26, 2009 Php
Very exciteing and challenging work!.You are thinking that what is exciteing and challenging in this work but i am talking about how to unzip a zip file using php.
Some times programmer has the requirment to select a zip file and unzip all the files and folder at a particular location and then delete that zip file.
I faced this problem first time when i was making a file manager in php . That was not just a file manger but also a full featured ftp client.I tried to search on Read the rest of this entry »
google but not found anything .finally i got a small help from google and than i made a good function for you all to unzip a zip file.
Tags: chmod, create directory, delete zip, directory permission, directory structure, folder permission, ftp, linux, mkdir, overwrite, Php, server, subdirectory, unzip, windows, zip, zip_open
how to download a file without display download request
Usually when we try to download something from a server we get a confirmation request whether you want to save the file or open it.
To avoid this request you can use the below code and then user can directly download that file without any message.
First give a link or a button for user to download and when they click redirect them to a file which will have the code below.
suppose you want user to download a pdf file then first make a link like this:
<a href=”javascript:void();” onClick=”location.href=’doc/document_download.php’”>download pdf</a>
Tags: attachment, Content type, Content-Disposition, direct download, download, file, filename, pdf download, Php
How to run code of php5 on a server with php4 using htaccess
Nov 26, 2009 Beginners, Experts, Php
This is big question for beginners every time.Now as we know that php5 is in full flow but still there are lot of servers out there with php4 and if you upload your php5 code on those servers then it will be mess.May be your site will not run or any part or your will go down.But don’t worry friends , there are only 2 lines to put this problem far from you.
Just put these 2 lines below in a htaccess file and put that htaccess at the root directory.
AddHandler x-httpd-php5 .php
AddHandler x-httpd-php .php4
Now all the modules either they have written in php4 or php5 will work very well.
