On Saturday 05 January 2002 00:44, Kelvin wrote:
> Hi everyone,
>
> I have a txt file which is contained the following:
>
> xxxx,aaa,ccc,ddd
> xxxx,aaa,ccc,ddd
> .....etc.
>
> Now, I need to read the data from that file and than insert it into the
> table.
>
> ----insert into Table ("name","pass","phone","somethingelse")
>
> Could someone help me out here, How to write the code?
> I know how to read from a txt file, but I don't know how to separate the
> data determine by ","
Use explode(). For example:
$line = "xxxx,aaa,ccc,ddd";
$bits = explode(",", $line);
Would result in:
$bits[0] = "xxxx"
$bits[1] = "aaa"
$bits[2] = "ccc" etc.
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Love conquers all things; let us too surrender to love.
-- Publius Vergilius Maro (Virgil)
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
