Posted by "Mark Rees" on 09/14/05 17:37

> I tried to use the final array values in a insert statement, but the
values are not inserted.
> the code is
>
> foreach ($final as $subnum){
> $res = $db->query("INSERT INTO
substrate_protocoll(substrate_type,substrate_num,operator,location,solvent,u
ltrasonic,duration,cdate,ctime,comment)
>
VALUES('$substrate_type1',$subnum,'$operator','$location','$solvent',$uv,$du
ration,'$cdate','$sctime','$comment')");
> if(!$res){
> echo "insert failed";
> }
> }
> the values of array ($subnum)are not inserted , can you tell me where the
problem is.

the problem is probably in this line:

echo ("INSERT INTO
substrate_protocoll(substrate_type,substrate_num,operator,location,solvent,u
ltrasonic,duration,cdate,ctime,comment)

VALUES('$substrate_type1',$subnum,'$operator','$location','$solvent',$uv,$du
ration,'$cdate','$sctime','$comment')");

and the problem is that you haven't done this to see what is wrong with the
SQL.

The next problem is that this line is also missing:

echo mysql_error();




>
> Jordan Miller <jmil@hymiegladstone.com> wrote:
> I think I finally understand what you are trying to do. I don't see
> any reason why you need to use the token functions, and I would
> recommend using array functions instead (also, it is exceedingly easy
> to sort the elements of an array... see the end).
>
> I believe this will do what you are trying to do:
> //Tokenizer for Babu
> $str = '10,12,14-18';
> $commas = explode(',', $str); // $commas will be an array of three
> items in this case
>
> // Final Values will go into the $final array
> $final = array();
> foreach ($commas as $value) {
> // If one of the $commas elements contains a dash, we need to
> get the range between them!
> if (strstr($value, '-')) {
> // Explode based on the dash. This code assumes there will
> only be a single dash
> $rangeValues = explode('-', $value);
> foreach (range($rangeValues[0], $rangeValues[1]) as $number) {
> $final[] = $number;
> }
> } else {
> // If $value does not contain a dash, add it directly to the
> $final array
> $final[] = $value;
> }
> }
> echo "All your values in the range $str are ".implode(' ', $final);
> // Prints "All your values in the range 10,12,14-18 are 10 12 14 15
> 16 17 18"
>
>
> In your last email, you had some of the values given out of order:
> 1. 20,21-24
> 2. 21-24,20
> 3. 10,20,21-24,25,26,30
>
> To make sure the $final values are always ascending, just do this at
> the end:
> sort($final);
>
> Done!!
>
> Jordan
>
>
>
>
> On Sep 13, 2005, at 7:16 PM, babu wrote:
>
> > $str=10,12,14-18;
> >
> > $tok = strtok($str, ',');
> > while ($tok !== false) {
> > $toks[] = $tok;
> > $tok = strtok(',');
> > }
> >
> > foreach ($toks as $token){
> > if (strpos($token,'-')){
> > stringtokenize($token);
> > }else{
> > $finaltokens[]= $token;
> > }
> > }
> >
> > function stringtokenize($nstr){
> > $ntok1= strtok($nstr,'-');
> > $ntok2=strtok('-');
> > for($i=$ntok1;$i<=$ntok2;$i++){
> > $finaltokens[]= $i;
> > }
> > }
> >
> > foreach ($finaltokens as $ftoken){
> > echo $ftoken;
> > echo "
> ";
> > }
> >
> > the ouput prints only 10,12 but not 14,15,16,17,18. where is the
> > problem.
> >
> >
> >
> > ---------------------------------
> > To help you stay safe and secure online, we've developed the all
> > new Yahoo! Security Centre.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> ---------------------------------
> How much free photo storage do you get? Store your holiday snaps for FREE
with Yahoo! Photos. Get Yahoo! Photos

[Back to original message]