PHP - Take Away "," In Last Loop

I've searched but can't seem to find anything I can apply to this situation.  Most of the resources are dedicated to dropdown menu's from the same table. 

I have two tables 'regions' and 'cities' and I am looking to create a menu that lists all the cities within a region then moves on to do the same for the rest of the regions in that state:

State1
Region1
City1
City2
City3
Region2
City1
City2
City3
Region3
Etc

My tables:
States table: stateID, state
Regions table: regionID, region, stateID
Cities table: cityID, city, regionID

I currently have two pages- select region, then select city... I'd like to consolidate to one step after choosing a state.

I know I need a nested loop, (while?), and to count the results somehow to retrigger loop; also not sure how to handle two mySQL querries in the nested loop.  I'm having trouble wrapping my mind around it. Thank you.

I am trying to make a loop simply write "static" code...if that is the correct explanation....  But it seems PHP wants to "process" such things as 'IF' and other Conditions which is defeating the purpose.

The problem specifically is that I NEED for a dynamic write to happen based on a variable  that will put the following lines
that start with IF (! isset


 

 // Make sure the checkbox arrays exist 

 if (! isset($_POST['cp_checkbox_one'])) $_POST['cp_checkbox_one'] = array();
 if (! isset($_POST['cp_checkbox_two'])) $_POST['cp_checkbox_two'] = array();
 if (! isset($_POST['cp_checkbox_three'])) $_POST['cp_checkbox_three'] = array();


//    here in the lines below is one way I have tried to make the the LINES ABOVE get written Dynamically
//    THIS PART returns the values I need, the checkbox names ----  
//
//    foreach($_POST as $meta_key => $meta_value) {
// if(cp_str_starts_with($meta_key, 'cp_checkbox')) { echo $meta_key; }
//    } 

//  So that code WILL RETURN THE VALUES I NEED : 
//  cp_checkbox_one, cp_checkbox_two, cp_checkbox_three

//   BASED ON THIS I WROTE THE FOLLOWING CODE-- BUT IT DOES NOT WORK AS A REPLACEMENT FOR A LINE
//  SUCH AS---  if (! isset($_POST['cp_checkbox_one'])) $_POST['cp_checkbox_one'] = array();

//  

function checkboxloop() {
foreach($_POST as $meta_key => $meta_value) {
if(cp_str_starts_with($meta_key, 'cp_checkbox')) { 
if (! isset($_POST[$meta_key]))  $_POST[$meta_key] = array();
    }
  }
}

//  HERE I ASK FOR THE FUNCTION BUT WHILE I GET NO ERRORS I GET NO RESULTS
//  WHICH IS A PROPER SAVE OF UNCHECKED CHECKBOXES ON SUBMIT

checkboxloop;




I would very much appreciate knowing how to make the code keep looping whatever $meta_key names turn up on this page and then use those names to write the complete lines as STATIC PHP so that the IF conditions don't get "processed" while this function is called.

In effect, I want to duplicate the effect of having the code lines WRITTEN, so that they perform exactly as if I had written them as PHP hard-code, as many lines as there will be $meta_keys, but not SEE the code--- just have it valid PHP.  This function does NOT make the same thing happen internally.  As soon as I replace the function with the HARD CODE PHP then it works...but, I have reached the stage where these lines of code have to happen dynamically.

I am baffled how to get this to happen!  If I use Echo then I get errors about the "IF".

Thank you very much for your help!

hello

how do i pass a foreach loop through "Passing by Reference"

say i have a foreach loop in a function like this:

Code: [Select]

function findText(&$output){
  $word = Text::find_all(); 
  foreach ($word as $words){
  $output = $words->text;
  }
}

then one the page i put

Code: [Select]

findText($output);
echo $output;


that will just give me the last word in the database.

so how do i get it to echo out the array on the page ?

thanks

Hey guys,

Got another question im hoping someone can help me with.

I have a foreach loop (for use in a mysql query):

   foreach ($interests as $interest) {
       $query .= "($id, $interest), ";
   }

problem is i do not want the comma(,) in the last loop.

Is there some kinda of function i can use so it does not insert it on last loop?

Or should i just use a for loop with a nested if loop? something like ;

   for($i=0; $i < count($interests); $i++){
      $query .=
      "($id, '$interests[$i]')";
      if($i + 1 < count($interests)) {
         $query .= ", ";
      }
      }


Cheers guys

I am getting the following error when using composer: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Just started.  I am pretty sure composer.json wasn't changed.  journalctl doesn't show anything.  Maybe Doctrine related, however, nothing seems to help.

Any ideas?
 

[michael@devserver www]$ php -v
PHP 7.3.4 (cli) (built: Apr  2 2019 13:48:50) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies
    with DBG v9.1.9, (C) 2000,2018, by Dmitri Dmitrienko
[michael@devserver www]$ composer -V
Composer version 1.4.2 2017-05-17 08:17:52
[michael@devserver www]$ yum info composer
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.us.oneandone.net
 * epel: mirror.rnet.missouri.edu
 * extras: mirror.us.oneandone.net
 * remi-php73: mirror.bebout.net
 * remi-safe: mirror.bebout.net
 * updates: mirror.us.oneandone.net
Installed Packages
Name        : composer
Arch        : noarch
Version     : 1.8.4
Release     : 1.el7
Size        : 1.8 M
Repo        : installed
From repo   : epel
Summary     : Dependency Manager for PHP
URL         : https://getcomposer.org/
License     : MIT
Description : Composer helps you declare, manage and install dependencies of PHP projects,
            : ensuring you have the right stack everywhere.
            :
            : Documentation: https://getcomposer.org/doc/

[michael@devserver www]$ composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)


  [ErrorException]
  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?


update [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--lock] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [--with-dependencies] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--prefer-stable] [--prefer-lowest] [-i|--interactive] [--root-reqs] [--] [<packages>]...

[michael@devserver www]$

 

This topic has been moved to Linux.

http://www.phpfreaks.com/forums/index.php?topic=318175.0

question of perfomance ..


Code: [Select]
//take the names from table1
apply($sql1);
foreach($names as $name){
//grab other info about the current user from table2
apply($sql2);
}
is this fine ?

I'm getting an invalid argument error for my While loop.  I can't figure out why. 

Code: [Select]
$sql="SELECT * FROM schools ORDER BY class DESC,sectional ASC,team ASC";

$results = mysql_query($sql);

while ($team = mysql_fetch_assoc($results)) {

echo $team['school'] . '<br>';

}


Here is the error:

Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/******/public_html/hoosierhoopsmagazine.com/resources/sectional_assignments.php on line 7

Hi Guys

Ever had the feeling your being a spoon and can't see the wood for the trees? Well, that's how I feel today.

All I am trying to to is implement a variable in a "foreach" loop that increments by one through each iteration of the loop. I know how to do it in a "for" loop but can't for the life of me get it to work here. Here is the code:

foreach ($cart as $prodcode => $qty)
  {
    $item = get_product_details($prodcode);
    echo '<input type="hidden" name="item_name_'.[b]$needavariablehere[/b].'" value="'.$item['description'].$_SESSION['finish'][$prodcode].$_SESSION['handles'][$prodcode].'" />' . "\n";
}

Where I have highlighted $needavariablehere is where I want a number to appear i.e. if there is one item available and the foreach loop iterates once I want the number 1 here. If there are two items and the foreach loop iterates twice I want the output to have number 1 in the first line and number 2 the second time around and so on.

How many times the foreach loop iterates is based on the $cart array which contains items in a shopping cart.

Thanks for any help you can give guys.

Hi, I currently have an if, elseif, else program that starts off with

Code: [Select]
if( $v_name == "" || $v_msg == "" )
echo "something"
how do I turn this into a switch?

but the very next elseif I have

Code: [Select]
elseif( strcspn( $_REQUEST['msg'], '0123456789' ) == strlen( $_REQUEST['msg'] ) )
echo "something"

is it possible to turn this into a switch with 2 different strings like that to evaluate?

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=347922.0

I have a registration form on my website and after Registration I want the user to activate first his account. I don't have problem on sending this email to the user. What I want to appear is like this..

GoodDay "username",

Blah Blah!

how can you actually do that? I know that you can do that through session variables but the thing is email's can't accept scripts on sending emails. how can I get the value from a session variable for example and convert it to plain html text so that i can OUTPUT it to the email.. HELP PLEASE!

Hey guys!
I have the following doubt:

I have a php file that does the following alongside with other code not displayed he

$fp = fopen("emails.txt", "w");

It opens a txt file called emails.txt that is in the same folder where the php is saved but how do I tell $fp = fopen("/folderbefore/emails.txt", "w"); ??

In other words, how do I write the path on the script that the emails.txt is located in a previous folder where the php file is located??

Thanks in advance for your help
Cheers!

Hi all,

Using a form with check boxes divided into different categories, I collect data selected by the user.

I now want to combine each choice in each category with each choice in the other categories and list the combinations to the user.

If the user chooses one or more options in each category, it is relatively easy to nest foreach loops, since the number of categories will always be the same. For example, if the form contains three categories of options, the code will be:

Code: [Select]
foreach ($form['cat_1'] as $k1 => $val1)
{
foreach ($form['cat_2'] as $k2 => $val2)
{
foreach ($form['cat_3'] as $k3 => $val3)
{
echo  $val1.' _ '.$val2.' _ '.$val3.'<br/>';
}
}
}

Things get complicated if the user does not select options within a given category. More generally, I want to be able to generate the list regardless of the number of categories in which the user selects options.

Thank you in advance for your advice.