RE: [PHP-DB] inserting mysql data using php array???

Interesting. A bit tiedious, I suppose. Seems like it'd be a bit more overhead than I'd care to have, but an interesting technique nonetheless. TIM -I date this girl for two years and then the nagging starts: "I wanna know your name." - Mike Binder > -----Original Message----- > From: Ubaidul Khan [mailto:ubaidulkhan@hotmail.com] > Sent: Wednesday, November 28, 2001 10:04 AM > To: Tim Foster > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] inserting mysql data using php array??? > > > Actually, there is another way of doing it. The prerequisite for this > method, is that you have an auto_incremented column. If you have that, then > all you have to do is insert a value into one of the columns, then grab > mysql_insert_id, and update all columns, corresponding to that > auto_incremented value. That's what I ended up doing. > > > ----- Original Message ----- > From: "Tim Foster" <tfoster@pdxinc.com> > To: <php-db@lists.php.net> > Sent: Wednesday, November 28, 2001 10:37 > Subject: RE: [PHP-DB] inserting mysql data using php array??? > > > > Very interesting. I didn't know you could use SET with an INSERT. I tried > this on MySQL > > and it worked. Dunno if it's standard SQL, but it didn't work on MSAccess > and MS SQLServer > > (the only other DBs I have at hand to test it with). I wonder what other > DBs it works on, > > because you could be painting yourself into a corner if you had to move to > another > > platform. > > > > TIM > > -What if the Hokey-Pokey really is what it's all about? > > > > > > > -----Original Message----- > > > From: Jonathan Hilgeman [mailto:JHilgeman@ecx.com] > > > > > I actually have an easy way to do INSERTs like this. > > > > > > First I create the array: > > > > > > $MyArray["field"] = value; > > > $MyArray["name"] = "Jonathan"; > > > $MyArray["age"] = 123; > > > $MyArray["email"] = $email_address; > > > > > > and then I define this function somewhere in a function library: > > > > > > function Array2Query($dbArray) > > > { > > > foreach($dbArray as $dbField => $dbValue) > > > { > > > $dbQuery .= "$dbField='$dbValue',"; > > > } > > > > > > $dbQuery = substr($dbQuery,0,strlen($dbQuery)-1); > > > > > > return $dbQuery; > > > } > > > > > > and then I just create the query: > > > > > > $Query = "INSERT INTO table SET " . Array2Query($MyArray); > > > $Result = mysql_query($Query); > > > > > > Hope it helps. > > > > > > - Jonathan > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > >