[Resolved] inserting a big record

[delphipgmr]

is there some easy programming trick anyone know to insert record with a lot of fields.

like i'm working with table that has 75 fields, and most of them are on a form.

it just so awkward to use and hard to read an:

insert into table values (75 values).

since PHP has so many neat routines to make life easier, there must be a way to do this more effeciently. I've named the form fields similar (like if a table field is called for example "cust_name", ive named the form field "add_rec_cust_name" )

but i have to be able to use those fields as well as some defaults.

same thing with updating a record...

Thanks
--Karl

[maxpup979]

there are a couple of programming tricks to do what you are wanting--such as making the formfield name the same as the DB column name--strip out the extra form fields, loop across the post or get vars...and you are set--

But with the setup you have described, nothing comes to mind--I think you may be stuck writing out that query

[delphipgmr]

got an example?

i can easily change the form names.

[maxpup979]

<?php
if(isset($sentinal)){
if($sentinal=="asdf"){
$insert="insert into tablename(";
foreach ($HTTP_POST_VARS as $fieldname => $value) {
if(!(eregi("submit|sentinal",$fieldname))){
$insert2.="'".$value."',";
$insert1.=$fieldname.",";
}
}
$insert1=substr($insert1,0,-1);
$insert2=substr($insert2,0,-1);
$ni=$insert.$insert1.")values(".$insert2.");";
print $ni;
}
exit;
}
?>

First off--sorry bout the lousy formatting-
second--The ereg statement is used to ignore the elements I don't want inserted
third--this makes the assumption that the formfield names match the formfields in the DB
and finally--Depending on the data, you may need to take numerics into account--its easy, but I didnt want to throw too much at you at once...🙂

[delphipgmr]

Thank you so much.

that makes my life a whole lot easier now