Iterate this for infinity
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ---------------------------------------------------------------- while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if($arraysize=1) { $import="INSERT into $table values('$data[0]')"; } elseif($arraysize=2) { $import="INSERT into $table values('$data[0]','$data[1]')"; } elseif($arraysize=3) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]')"; } elseif($arraysize=4) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]')"; } elseif($arraysize=5) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')"; } elseif($arraysize=6) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')"; } elseif($arraysize=7) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')"; } elseif($arraysize=8) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]')"; } elseif($arraysize=9) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]')"; } elseif($arraysize=10) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]')"; } elseif($arraysize=11) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]')"; } elseif($arraysize=12) { echo "YIPEEEEE"; $import="INSERT into $table values('$data[0]', '$data[1]' ,'$data[2]','$data[3]','$data[4]','$data[5]', '$data[6]','$data[7]', '$data[8]','$data[9]','$data[10]','$data[11]')"; } elseif($arraysize=13) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]')"; } elseif($arraysize=14) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]')"; } elseif($arraysize=15) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]')"; } elseif($arraysize=16) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]')"; } elseif($arraysize=17) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]')"; } elseif($arraysize=18) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]')"; } elseif($arraysize=19) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]')"; } elseif($arraysize=20) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]')"; } elseif($arraysize=21) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]','$data[20]')"; } elseif($arraysize=22) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]')"; } else { echo "Call your DBA - Mark"; } /** if($arraysize=12) { echo "YIPEEEEE"; $import="INSERT into $table values('$data[0]', '$data[1]' ,'$data[2]','$data[3]','$data[4]','$data[5]', '$data[6]','$data[7]', '$data[8]','$data[9]','$data[10]','$data[11]')"; } **/ mysql_query($import) or die(mysql_error()); } ?> -- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ? while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } } but are you dealing with infinite data ?
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data. try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize...................... //and to break the loop if(condition){ $loop = false; } } Be careful with this thoough. Make sure your condition always happens before the end of your data. On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info>
wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ?
while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } }
but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM? On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com>wrote:
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data. try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize......................
//and to break the loop if(condition){ $loop = false; } }
Be careful with this thoough. Make sure your condition always happens before the end of your data.
On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info>
wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ?
while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } }
but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
just as you have done it. You have the $data variable, so use it as you had used it b4 On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote:
In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM?
On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com
wrote:
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data. try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize......................
//and to break the loop if(condition){ $loop = false; } }
Be careful with this thoough. Make sure your condition always happens before the end of your data.
On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info>
wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ?
while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } }
but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
Hi Skunks, I think what Thea is looking for is a solution that will allow him to insert as many column items into a database table as there are tokens in the the $data array, which I assume is a line entry in a particular csv/text file. I would suggest that you use the $data array length as your limit. And concatenate a string representing your INSERT statement. Also it might be prudent to create your table before hand using the $data array length to determine the number of columns needed. Hope this helps some. KR, Loki "Excellent people exceed expectations". ________________________________ From: Frankline Chitwa <frank.chitwa@gmail.com> To: Skunkworks Forum <skunkworks@lists.my.co.ke> Sent: Thursday, September 24, 2009 10:54:46 AM Subject: Re: [Skunkworks] Iterate this for infinity just as you have done it. You have the $data variable, so use it as you had used it b4 On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote: In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM?
On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com> wrote:
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data.
try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize......................
//and to break the loop if(condition){ $loop = false; } }
Be careful with this thoough. Make sure your condition always happens before the end of your data.
On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info> wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
> Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate > this for infinity. > thanks > ---------------------------------------------------------------- > > while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) > {
maybe this ?
while (TRUE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
} }
but are you dealing with infinite data ?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________
Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
--
---------------------------------------------------------------------
Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
_______________________________________________
Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
Hi Skunks, I think what Thea is looking for is a solution that will allow him to insert as many column items into a database table as there are tokens in the the $data array, which I assume is a line entry in a particular csv/text file. I would suggest that you use the $data array length as your limit. And concatenate a string representing your INSERT statement. Also it might be prudent to create your table before hand using the $data array length to determine the number of columns needed. Hope this helps some. KR, Loki "Excellent people exceed expectations". ________________________________ From: Frankline Chitwa <frank.chitwa@gmail.com> To: Skunkworks Forum <skunkworks@lists.my.co.ke> Sent: Thursday, September 24, 2009 10:54:46 AM Subject: Re: [Skunkworks] Iterate this for infinity just as you have done it. You have the $data variable, so use it as you had used it b4 On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote: In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM?
On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com> wrote:
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data.
try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize......................
//and to break the loop if(condition){ $loop = false; } }
Be careful with this thoough. Make sure your condition always happens before the end of your data.
On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info> wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
> Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate > this for infinity. > thanks > ---------------------------------------------------------------- > > while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) > {
maybe this ?
while (TRUE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
} }
but are you dealing with infinite data ?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________
Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
--
---------------------------------------------------------------------
Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
_______________________________________________
Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
Hello Thea; i beleive your interest is in this part /**** elseif($arraysize=12) { echo "YIPEEEEE"; $import="INSERT into $table values('$data[0]', '$data[1]' ,'$data[2]','$data[3]','$data[ 4]','$data[5]', '$data[6]','$data[7]', '$data[8]','$data[9]','$data[10]','$data[11]')"; } ****/ Thea Ashford K. 2009/9/24 Nicholas Loki <lokimwenga@yahoo.com>
Hi Skunks, I think what Thea is looking for is a solution that will allow him to insert as many column items into a database table as there are tokens in the the $data array, which I assume is a line entry in a particular csv/text file. I would suggest that you use the $data array length as your limit. And concatenate a string representing your INSERT statement. Also it might be prudent to create your table before hand using the $data array length to determine the number of columns needed. Hope this helps some.
KR, Loki
"Excellent people exceed expectations".
------------------------------ *From:* Frankline Chitwa <frank.chitwa@gmail.com> *To:* Skunkworks Forum <skunkworks@lists.my.co.ke> *Sent:* Thursday, September 24, 2009 10:54:46 AM *Subject:* Re: [Skunkworks] Iterate this for infinity
just as you have done it. You have the $data variable, so use it as you had used it b4
On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote:
In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM?
On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa < frank.chitwa@gmail.com> wrote:
Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data. try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize......................
//and to break the loop if(condition){ $loop = false; } }
Be careful with this thoough. Make sure your condition always happens before the end of your data.
On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info>
wrote:
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ?
while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } }
but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Unless your table "$table" is dynamic, you will encounter errors with all insets where column count is not valid assume $table is table_column-count then ... .. . while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $c = count($data); // get count of columns $table = "table_$c"; // concat table name $sqldata = ""; // empty sting for concatenation below foreach($data as $dat) $sqldata .= ', "'.msql_real_escape_string($dat).'"'; // convert $data into csv of quoted escaped values $sqldata = substr($sqldata,2); // remove first space and comma ", " if($c > 0 and $c <= 22) mysql_query("insert into $table values ($sqldata)", $connection); if($c ==12) echo "YIPEEEEE"; if($c > 22 or $c == 0) echo "Call your DBA - Mark"; } Ashford K.
Unless your table "$table" is dynamic, you will encounter errors with all insets where column count is not valid assume $table is table_column-count then ... .. . while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $c = count($data); // get count of columns $table = "table_$c"; // concat table name $sqldata = ""; // empty sting for concatenation below foreach($data as $dat) $sqldata .= ', "'.msql_real_escape_string($dat).'"'; // convert $data into csv of quoted escaped values $sqldata = substr($sqldata,2); // remove first space and comma ", " if($c > 0 and $c <= 22) mysql_query("insert into $table values ($sqldata)", $connection); if($c ==12) echo "YIPEEEEE"; if($c > 22 or $c == 0) echo "Call your DBA - Mark"; } Ashford K.
Hi Ashford. Thanks Man. That might work.. I do create the table dynamically with varying columns and the first column is always a PK with a value.. i hope to dynamically populate it with some sample data. I'll paste what works. Any more help is appreciated.. regards On Thu, Sep 24, 2009 at 5:27 PM, Ashford Kuria <kuriashford@gmail.com>wrote:
Unless your table "$table" is dynamic, you will encounter errors with all insets where column count is not valid
assume $table is table_column-count then
... .. . while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $c = count($data); // get count of columns $table = "table_$c"; // concat table name $sqldata = ""; // empty sting for concatenation below
foreach($data as $dat) $sqldata .= ', "'.msql_real_escape_string($dat).'"'; // convert $data into csv of quoted escaped values
$sqldata = substr($sqldata,2); // remove first space and comma ", "
if($c > 0 and $c <= 22) mysql_query("insert into $table values ($sqldata)", $connection);
if($c ==12) echo "YIPEEEEE";
if($c > 22 or $c == 0) echo "Call your DBA - Mark"; }
Ashford K.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
Try this: while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $insert_fmt = "INSERT INTO %s VALUES('%s')"; //string format $values = join("','", $data); //join the pieces of the array without regard for array size $table_name = "tbl"; $import = sprintf($insert_fmt, $table_name, mysql_escape_string($values)); mysql_query($import) or die(mysql_error()); } Reference: http://www.php.net/manual/en/function.join.php - String function for joining the pieces of an array. It goes without saying that you need to do the necessary validations to ensure that your queries don't trip up. HTH On Mon, Sep 28, 2009 at 8:57 AM, thea maina <theamaina@gmail.com> wrote:
Hi Ashford. Thanks Man. That might work.. I do create the table dynamically with varying columns and the first column is always a PK with a value.. i hope to dynamically populate it with some sample data. I'll paste what works. Any more help is appreciated..
regards
On Thu, Sep 24, 2009 at 5:27 PM, Ashford Kuria <kuriashford@gmail.com>wrote:
Unless your table "$table" is dynamic, you will encounter errors with all insets where column count is not valid
assume $table is table_column-count then
... .. . while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $c = count($data); // get count of columns $table = "table_$c"; // concat table name $sqldata = ""; // empty sting for concatenation below
foreach($data as $dat) $sqldata .= ', "'.msql_real_escape_string($dat).'"'; // convert $data into csv of quoted escaped values
$sqldata = substr($sqldata,2); // remove first space and comma ", "
if($c > 0 and $c <= 22) mysql_query("insert into $table values ($sqldata)", $connection);
if($c ==12) echo "YIPEEEEE";
if($c > 22 or $c == 0) echo "Call your DBA - Mark"; }
Ashford K.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- blog: http://imma.wordpress.com
Hey, Using the hard limit of 4096, compare your array size with 4096 and limit the index to 4095. Anything above that split to another table. (PK-FK) Hope that helps! Oj. The optimist sees the doughnut; the pessimist the hole. --- On Thu, 9/24/09, Nicholas Loki <lokimwenga@yahoo.com> wrote: From: Nicholas Loki <lokimwenga@yahoo.com> Subject: Re: [Skunkworks] Iterate this for infinity To: "Skunkworks Forum" <skunkworks@lists.my.co.ke> Date: Thursday, September 24, 2009, 4:52 AM Hi Skunks, I think what Thea is looking for is a solution that will allow him to insert as many column items into a database table as there are tokens in the the $data array, which I assume is a line entry in a particular csv/text file. I would suggest that you use the $data array length as your limit. And concatenate a string representing your INSERT statement. Also it might be prudent to create your table before hand using the $data array length to determine the number of columns needed. Hope this helps some. KR,Loki "Excellent people exceed expectations". From: Frankline Chitwa <frank.chitwa@gmail.com> To: Skunkworks Forum <skunkworks@lists.my.co.ke> Sent: Thursday, September 24, 2009 10:54:46 AM Subject: Re: [Skunkworks] Iterate this for infinity just as you have done it. You have the $data variable, so use it as you had used it b4 On Thu, Sep 24, 2009 at 10:46 AM, thea maina <theamaina@gmail.com> wrote: In your while loops, How is the $data from the CSV file been INSERTed INTO a new TABLE COLUNM? On Thu, Sep 24, 2009 at 10:30 AM, Frankline Chitwa <frank.chitwa@gmail.com> wrote: Maybe he wants to break the loop if he encounters a certain condition, and not necessarily go to the end of his data. try $loop = true; while($loop){ $data = fgetcsv($handle, 1000, ","); if($arraysize...................... //and to break the loop if(condition){ $loop = false; } } Be careful with this thoough. Make sure your condition always happens before the end of your data. On Thu, Sep 24, 2009 at 9:21 AM, <ashok+skunkworks@parliaments.info> wrote: On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate
this for infinity.
thanks
----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
maybe this ? while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } } but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general -- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general -- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general -- www.dealcent.com - Your electronics shop www.golavish.com - The travel and leisure www.raccuddasys.com - code Development issues -----Inline Attachment Follows----- _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Good question Ashok. @ Thea, why infinity? --- On Thu, 9/24/09, ashok+skunkworks@parliaments.info <ashok+skunkworks@parliaments.info> wrote: From: ashok+skunkworks@parliaments.info <ashok+skunkworks@parliaments.info> Subject: Re: [Skunkworks] Iterate this for infinity To: "Skunkworks Forum" <skunkworks@lists.my.co.ke> Date: Thursday, September 24, 2009, 9:21 AM On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ? while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } } but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Hi from your implementation, you are reading the file upto 1000 lines since fgetcsv takes the second parameter as the line numbers to read, if you want to read the entire file then have the second parameter as 0, it will process the entire file. I refuse to believe that the file is of infinite length : ) I am also seeing a problem with the inserts, if the lines of the csv file are of variable columns then you might have to explicitly define the columns to be inserted in the table. e.g. if your table has 4 columns and the csv has 3 columns then the import statement ends looking like this: insert into table values(1,2,3); this will throw a mysql error ( ERROR 1136 (21S01): Column count doesn't match value count) or am i missing something? Regards ./chris On Thu, Sep 24, 2009 at 12:39 PM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
Good question Ashok.
@ Thea, why infinity?
--- On *Thu, 9/24/09, ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info> <ashok+skunkworks@parliaments.info <ashok%2Bskunkworks@parliaments.info>>*wrote:
From: ashok+skunkworks@parliaments.info<ashok%2Bskunkworks@parliaments.info>< ashok+skunkworks@parliaments.info <ashok%2Bskunkworks@parliaments.info>> Subject: Re: [Skunkworks] Iterate this for infinity To: "Skunkworks Forum" <skunkworks@lists.my.co.ke> Date: Thursday, September 24, 2009, 9:21 AM
On Thu, Sep 24, 2009 at 9:14 AM, thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
maybe this ?
while (TRUE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { } }
but are you dealing with infinite data ? _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke<http://de.mc1120.mail.yahoo.com/mc/compose?to=Skunkworks@lists.my.co.ke> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
On Thu, Sep 24, 2009 at 9:14 AM, thea maina <theamaina@gmail.com> wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks
Are you trying to read a constantly updated log file and write the log file content to the db ?
This code is horrible. The coding should be done in a better way because as it is, its not extensible.... basically a maintenance nightmare. Its no wonder you have hit a mind lock. SKYPE: sobbayi US: +1 202 470 0525 KE: +254 722 627 691 thea maina wrote:
Iterate this for infinity. - Hi guys, i hit a mind lock.. How can i iterate this for infinity. thanks ----------------------------------------------------------------
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if($arraysize=1) { $import="INSERT into $table values('$data[0]')"; } elseif($arraysize=2) { $import="INSERT into $table values('$data[0]','$data[1]')"; } elseif($arraysize=3) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]')"; } elseif($arraysize=4) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]')"; } elseif($arraysize=5) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')"; } elseif($arraysize=6) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]')"; } elseif($arraysize=7) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')"; } elseif($arraysize=8) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]')"; } elseif($arraysize=9) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]')"; } elseif($arraysize=10) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]')"; } elseif($arraysize=11) {
$import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]')"; } elseif($arraysize=12) { echo "YIPEEEEE"; $import="INSERT into $table values('$data[0]', '$data[1]' ,'$data[2]','$data[3]','$data[4]','$data[5]', '$data[6]','$data[7]', '$data[8]','$data[9]','$data[10]','$data[11]')"; } elseif($arraysize=13) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]')"; } elseif($arraysize=14) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]')"; } elseif($arraysize=15) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]')"; } elseif($arraysize=16) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]')"; } elseif($arraysize=17) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]')"; } elseif($arraysize=18) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]')"; } elseif($arraysize=19) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]')"; } elseif($arraysize=20) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]')"; } elseif($arraysize=21) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]','$data[20]')"; } elseif($arraysize=22) { $import="INSERT into $table values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]',,'$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]')"; } else { echo "Call your DBA - Mark"; }
/** if($arraysize=12) { echo "YIPEEEEE"; $import="INSERT into $table values('$data[0]', '$data[1]' ,'$data[2]','$data[3]','$data[4]','$data[5]', '$data[6]','$data[7]', '$data[8]','$data[9]','$data[10]','$data[11]')"; } **/ mysql_query($import) or die(mysql_error());
} ?>
-- --------------------------------------------------------------------- Thea Maina Nairobi Kenya http://www.mafans.com skype: thea.mnairobi ------------------------------------------------------------------------
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
participants (10)
-
Ashford Kuria -
ashok+skunkworks＠parliaments.info -
Chris Mwirigi -
Emmanuel Taban -
Frankline Chitwa -
Nicholas Loki -
Oj G -
Steve Obbayi -
thea maina -
wesley kirinya