PHP 'SELECT' Loop.

Expand Post »

Hi all,
Been some time since my last post.
I'll get straight to it -

I have actual Id's being passed from the checkbox array to a page where I dump the post variables.

I'm using this to query the db.

PHP Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM test WHERE Id='$checkbox[0]';");
 
while($row = mysql_fetch_array($result))
  {
  echo $row['mobile'] . " " . $row['email'];
  echo "<br />";
  }
$result = mysql_query("SELECT * FROM test WHERE Id='$checkbox[0]';");

while($row = mysql_fetch_array($result))
  {
  echo $row['mobile'] . " " . $row['email'];
  echo "<br />";
  }

Which is fine if I manually create the array
like so

PHP Syntax (Toggle Plain Text)
$checkbox[]= array(0=>(1), 1=>(2));
$checkbox[]= array(0=>(1), 1=>(2));

In addition some of the numbers require formatting so -

PHP Syntax (Toggle Plain Text)
$mob = $sTestString;
$sPattern = '/\s*/m'; 
$sReplace = '';
$mob = str_replace ('-', '', $mob);
echo $mob . '<br />';
echo preg_replace($sPattern, $sReplace, $mob );
$mob = $sTestString;
$sPattern = '/\s*/m'; 
$sReplace = '';
$mob = str_replace ('-', '', $mob);
echo $mob . '<br />';
echo preg_replace($sPattern, $sReplace, $mob );

What I want to do is pass the checkbox array to the SELECT directly on form submit.
Then create an array with the mobile numbers and an array with the emails which will need to be processed to a comma sep string. (if more than one email or mobile number).

I need a loop here on the SELECT right and a counter to see how many checkboxes are checked ?
That's where I'm a bit foggy. ;-)
Is there an alternative more efficient way to do this ?

Regards.

Similar Threads

dynamic forms with php in PHP
EDIT table with SELECT MENU | Lookup Table in PHP
PHP FTP Loop (with dynamic inputs) in PHP
Advanced PHP Select Form Processing in PHP
Wierd PHP/MySql loop problem in PHP

Bob Arctor

Reputation Points: 14

Solved Threads: 1

Newbie Poster

Offline

17 posts
since Nov 2008

Permalink

Jul 6th, 2010

Re: PHP 'SELECT' Loop.

Apologies people for some reason I was looking at the wrong loop.
*slapping head*
It should be

PHP Syntax (Toggle Plain Text)
foreach ($checkbox as $value){
$result = mysql_query("SELECT * FROM test WHERE Id='$value';");
while($row = mysql_fetch_array($result))
  {
   echo "<br />";
   echo $row['mobile'] . " " . $row['email'];
   echo "<br />";
  }
}
mysql_close($con);
foreach ($checkbox as $value){
$result = mysql_query("SELECT * FROM test WHERE Id='$value';");
while($row = mysql_fetch_array($result))
  {
   echo "<br />";
   echo $row['mobile'] . " " . $row['email'];
   echo "<br />";
  }
}
mysql_close($con);

Bob Arctor

Reputation Points: 14

Solved Threads: 1

Newbie Poster

Offline

17 posts
since Nov 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Listbox item color

Next Thread in PHP Forum Timeline: How to insert names in db , when number isnt known

DaniWeb Message

Cancel Changes

User Name
Password