Re: RE: [PHP-DB] looped insert

> NOTE: I didn't read the entire post below...it's too early in the morning to > think about code. haha I did that the other day when I tried (and failed) to help out someone else - damn tired, hadn't even had a whiff of beer... Cheers for your help! Russ On Wed, 24 Oct 2001 09:10:59 -0400 Mike Frazer <mike@invertedmind.com> wrote: > Just thought this would be helpful... > > I've found the occassional problem with trying to insert a script-generated > null value (rare but it does happen). If this becomes a problem, remember > that NULL is just another word for "nothing". MySQL will accept either of > the following: > > INSERT INTO table VALUES ('value1', 'value2', NULL, 'value3'); > INSERT INTO table VALUES ('value1', 'value2', , 'value3'); > > NOTE: I didn't read the entire post below...it's too early in the morning to > think about code. I'm off to populate some site content until my brain > catches up with the clock. > > Mike Frazer > > > > > "Russ Michell" <r.j.michell@apu.ac.uk> wrote in message > news:SIMEON.10110231044.D@k1c. anglia.ac.uk... > > Hi Rick: > > > > Cheers for the info. Thwe following code almost does it, however, the NULL > value isn't inserted, if > > checkboxes are != to 'yes': > > > > //If submit button selected, process those ticked checkbox categories: > > if(isset($submit)) { > > //Start off sql > > $sql = "INSERT INTO $myanet02 > (staffdev,strategies,rules,news,information,policies) VALUES("; > > //loop while categories have been ticked > > for($i=0;$i<count($category);$i++) { > > if($category[$names] == 'yes') { > > $sql .= "'$email',"; > > } > > else { > > $sql .= "NULL,"; > > } > > } > > //Remove the last comma > > $sql = substr($sql,0,-1).")"; > > //$query = mysql_query($sql,$connect) or die(mysql_error()); > > echo $sql; > > } > > > > I believe the problem to be this line: > > 'if($category[$names] == 'yes') {' //Use this and NULL values > > aren't > inserted > > > > 'if($HTTP_POST_VARS["category${$i}"] == 'yes') {' //Use this > > and ONLY NULL > values are inserted > > > > The values are taken from the checkboxes thus: > > > > //Get all table column names, dynamically display them and use to process > subscriptions: > > $fields = mysql_list_fields("$dbName", "myanet_categories", $connect); > > $columns = mysql_num_fields($fields); > > for ($i=0; $i<$columns; $i++) { > > $names = mysql_field_name($fields, $i) . "\n"; > > $catselect .= "<b>$names </b><input type=\"checkbox\" > name=\"category[$names]\" value=\"yes\"><br>\n"; > > } > > > > You can see it happening at: > > http://gertrude.anglia.ac.uk/intranet/myanet/index.php > > > > Many thanks. > > Russ > > > > > > > > > > On Mon, 22 Oct 2001 12:28:38 -0500 Rick Emery <remery@excel.com> wrote: > > > > > Construct your INSERT a piece at a time. Something like: > > > > > > $sql = "INSERT INTO $myanet02 > > > (staffdev,strategies,rules,news,information,policies) VALUES("; > > > > > > for($i=0;$i<count($category);$i++) { > > > if($HTTP_POST_VARS["category{$i}"] == 'yes') { > > > $sql .= "\'$email\',"; > > > } > > > else { > > > $sql .= "NULL,"; > > > } > > > } > > > $sql = substring($sql,0,-1).")"; > > > //$query = mysql_query($sql,$connect) or die(mysql_error()); > > > echo $sql; > > > > > > -----Original Message----- > > > From: Russ Michell [mailto:r.j.michell@apu.ac.uk] > > > Sent: Monday, October 22, 2001 11:23 AM > > > To: php-db@lists.php.net > > > Subject: [PHP-DB] looped insert > > > > > > > > > Hi everyone: > > > > > > I've been fiddling with this all day, and well - if it was working you > > > wouldn't be reading this right now! ;-) > > > My script should take the selections made by users and process them via > > > straightforward MySQL inserts: > > > > > > //Get all table column names, dynamically display them as checkboxes. > Use to > > > process subscriptions: > > > $fields = mysql_list_fields("$dbName", "myanet_categories", > > > $connect); > > > $columns = mysql_num_fields($fields); > > > for ($i=0; $i<$columns; $i++) { > > > $names = mysql_field_name($fields, $i) . "\n"; > > > $catselect .= "<b>$names </b><input type=\"checkbox\" > > > name=\"category[$names]\" value=\"yes\"><br>\n"; > > > } > > > > > > > > > //If submit button selected, process those ticked checkbox categories: > > > if(isset($submit)) { > > > //loop while categories have been ticked > > > for($i=0;$i<count($category);$i++) { > > > if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure > > > about this bit... > > > $sql = "INSERT INTO $myanet02 > > > (staffdev,strategies,rules,news,information,policies) > > > > > > VALUES('$email','$email','$email','$email','$email','$email')"; > > > //$query = mysql_query($sql,$connect) or > > > die(mysql_error()); > > > echo $sql; > > > } > > > } > > > } > > > > > > At the moment not even echoing my $sql works. I know this aint gonna > work as > > > it is, because what I really need to know is: > > > > > > * How do I insert into only those categories that have been checked? > > > (default is 'null' in a VARCHAR(50) field) > > > * How do I only declare '$email' a single time as this is the only value > > > being inserted? > > > > > > Many thanks: > > > Russ > > > > > > #-------------------------------------------------------# > > > > > > "Believe nothing - consider everything" > > > > > > Russ Michell > > > Anglia Polytechnic University Webteam > > > Room 1C 'The Eastings' East Road, Cambridge > > > > > > e: r.j.michell@apu.ac.uk > > > w: www.apu.ac.uk/webteam > > > > > > www.theruss.com > > > > > > #-------------------------------------------------------# > > > > > > > > > -- > > > 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 > > > > > > > > > > > > -- > > > 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 > > > > > > > #-------------------------------------------------------# > > > > "Believe nothing - consider everything" > > > > Russ Michell > > Anglia Polytechnic University Webteam > > Room 1C 'The Eastings' East Road, Cambridge > > > > e: r.j.michell@apu.ac.uk > > w: www.apu.ac.uk/webteam > > > > www.theruss.com > > > > #-------------------------------------------------------# > > > > > > -- > 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 > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam www.theruss.com #-------------------------------------------------------#