PHP - Php Multiple Variables - Syntax Formatting Help

I have a form with multiple options to fill out (its a admin form) i want to make sure only one of the of the options are set, so im checking if the variable is empty with

if ($variable1 != NULL) {
$new_variable = "yep, this option was filled out";
}

so if the form sent anything from the form with the value 'variable1' it then sets a new variable ($new_variable)

Problem is i have multiple fields so i need to make sure if it finds a a variable is not empty, then too check if the others have anything in them too. If it does find another (meaning more than one has been filled out) echo an error (echo "you must only complete one option..")

What is the best way to check if more than one variable exists? Sorry if i explained it complicated.
Thank you

I have this function:
Code: [Select]
function echo_exist($pre1,$ee,$post1) {
if ($ee!='') {
return $pre1;
return $ee;
return $post1;
}
else {
//do nothing
}
}
But when I try to echo it
Code: [Select]
echo_exist("(","$row['payment_type']",")");
I get syntax error, unexpected T_ENCAPSED_AND_WHITESPACE
If $row['payment_type'] exists, I want it to be displayed in parentheses like:  (AUTO)

I suspect it has to do with my ' characters for the associative array, but I am new with functions so perhaps it is the multiple arguments that are wrong?

Hi, I want to send the following variable using the $_GET function:

hello, im wondering how to properly code the following.

Code: [Select]
$stdate = date( 'Ymd', strtotime($pdate) );
$sttime = date( 'His', strtotime($tstart1) );

$dtStart = ".$stdate.'T'.$sttime.'Z'";

echo "$dtStart";

i would like the echo to read 20110309T050000Z

Hello everyone, I'm sitting here in a position where I can't work on my site or test any code, but my mind is racing about what I can do to solve a particular problem that I have.  I won't get into the problem because it would take more time to type than I have right now, but I have an idea for a simple solution, just not sure if it will work or not.  So, here's my question: Is it possible to have multiple session variables during a session?

Such as:
$email=$_SESSION['email'];
$user=$_SESSION['userid'];

If this is possible, my problem is solved (I think)... otherwise, I have to keep thinking about it.  Thanks for any help!

hello i have built a webpage using tables.
i might have done something wrong (except using tables) and now the results are rendered chaotically on the webpage. also here is the attached file. after the 4th article it's all messy

i have a solution but that means to insert a php tag inside another php tag, but won't work

thankyou

When a user logs into my site I was to store the user_name, user_role, and user_id in a session variable, then store this in a regular variable to make querying easier, but I am having issues with my code as its causing issues with my queries.

Code: [Select]

if (mysqli_num_rows($data) > 0) {
  //set sessions
    $row = mysqli_fetch_array($data);
    $_SESSION['username'] = $row['username'];
    $_SESSION['user_role'] = $row['role'];
    $_SESSION['user_id'] = $row['user_id'];
         
           
  //set variables
    $username = $_SESSION['username'];
    $user_role = $_SESSION['user_role'];
    $user_id = $_SESSION['user_id'];

}


Any ideas whats wrong?!
Thanks for the help!!

I am creating a webpage for my golf league and some of the information(variables) such as Name, Address and email, must be reused across multiple pages for different outputs.  May question is "Can I, or is there a way to reUse variables across multiple pages.   "Do I need to create a session and make everything session variables"?  "Should I link to a database and call the information when needed"? 

Any explanation would be greatly appreciated. 

Hi Guys and Girls,

Long time lurker, first time poster!

I am usually able to read through the forums and find and answer without having to start a new thread but I've tried my best to no avail.

I am having trouble with the following code:
$afname="Gareth";
$alname="B";
$awayoption.="<OPTION VALUE=\"".$afname." \"".$alname."\">".$afname."&nbsp;".$alname;

I would want that to produce the following:

Code: [Select]
<OPTION VALUE=Gareth B">Gareth B
The actual result at the moment is:

Code: [Select]
<OPTION VALUE="Gareth "B">Gareth&nbsp;B
It has an extra " in the middle. Any ides or help would be great!

Cheers

    I have a webpage that I am working on that is now in construction mode. The url is: https://localbizseek.com/lbs/index6  The problem is that I want to it to be able to search 2 at the same time in the phpmyadmin database table which is named "places".  I also want to be able to get to search all 9 cities for that area.  There are a total of 36,000+ cities in the database.  However, I want it to be able to search just 2 or 9 specific cities of those cities.  Each city has a city_id which is an integer assigned to it in the database  Right now it will search only 1 city at a time or it will search every city in the database if I assign the search variable as "" or "0".  I don't know what to do on this page to solve it and on the related processing page.  Here is the code on the webpage:
   
              

        <form id="main-search-form" method="GET" action="<?= $baseurl; ?>/_searchresults.php" role="search">
         
        
        <select id="query-input" name="city_id" style="width:28.8%" style="height:69px" required>
                        
        <option value="">Select Area</option>
             
        <option value="3;1">Ches & VB</option>
        <option value="3">Chesapeake , VA</option>
        <option value="9">Hampton , VA</option> 
        <option value="10">Newport News , VA</option>   
        <option value="2">Norfolk , VA</option>   
        <option value="12">Poquoson , VA</option> 
        <option value="4">Portsmouth , VA</option>    
        <option value="5">Suffolk , VA</option>    
        <option value="1">Virginia Beach , VA</option> 
        <option value="11">Williamsburg , VA</option>
        <option value="0">All Active US Cities</option>
        </select>
        </form>

    You will notice that I have tried "3;1" up under the Ches & VB Select Option but that doesn't work because it will not work that way.  I can have it as "3 1" but then it just displays 1 which is VB's information.  I've tried everything possible and it won't search both variables.  It only will search one.
   
    So I'm thinking I need to do something at both ends on the code.  Here is the other end of the code which is the results processing page.  Note that there is also a third page of code which is the template page which I will add next:
   
             

      <form id="main-search-form" method="GET" action="<?= $baseurl; ?>/_searchresults.php" role="search">
         
        
          <select id="query-input" name="city_id" style="width:28.8%" style="height:69px" required>
                        
              <option value="">Select Area</option>
             
              <option value="3,1">Ches & VB</option>
              <option value="3">Chesapeake , VA</option>
        <option value="9">Hampton , VA</option> 
        <option value="10">Newport News , VA</option>   
        <option value="2">Norfolk , VA</option>   
        <option value="12">Poquoson , VA</option> 
        <option value="4">Portsmouth , VA</option>    
                    <option value="5">Suffolk , VA</option>    
                    <option value="1">Virginia Beach , VA</option> 
        <option value="11">Williamsburg , VA</option>
                    <option value="0">All Active US Cities</option>
   
      
           
        </select>

    Here is the final page of code which I'm not sure if this one needs changing but just in case here it is:
   

    <!DOCTYPE html>
    <!--[if IE 9]><html class="lt-ie10" lang="<?= $html_lang; ?>"> <![endif]-->
    <html class="no-js" lang="<?= $html_lang; ?>">
    <head>
    <title><?= $txt_html_title; ?> - <?= $site_name; ?></title>
    <meta name="description" content="<?= $txt_meta_desc; ?>" />
    <meta name="robots" content="noindex">
    <?php require_once('_html_head.php'); ?>
    </head>
    <body class="tpl-searchresults">
    <?php require_once('_header.php'); ?>
   
     <h1><?= $txt_main_title; ?></h1>
   
     <div class="full-block">
      <div class="content-col">
       <div class="list-items">
        <?php
        /*
        --------------------------------------------------
        BEGIN SHOW LIST
        --------------------------------------------------
        */
        if($total_rows > 0) {
         $count = ($page - 1) * $limit;
         $results_arr = array();
   
         foreach($list_items as $k => $v) {
          $count++;
          $place_id         = $v['place_id'];
          $place_name       = $v['place_name'];
          $place_slug       = $v['place_slug'];
          $address          = $v['address'];
          $cross_street     = $v['cross_street'];
          $place_city_name  = $v['place_city_name'];
          $place_city_slug  = $v['place_city_slug'];
          $place_state_abbr = $v['place_state_abbr'];
          $postal_code      = $v['postal_code'];
          $area_code        = $v['area_code'];
          $phone            = $v['phone'];
                                                    $phone = preg_replace("/[^0-9]/", "", $phone);
                                                    $phone = substr($phone, 0, 3) . '-' . substr($phone, 3);
          $lat              = $v['lat'];
          $lng              = $v['lng'];
          $cat_icon         = $v['cat_icon'];
          $photo_url        = $v['photo_url'];
          $rating           = $v['rating'];
          $description      = $v['description'];
   
          $results_arr[] = array(
           'ad_id'    => $place_id,
           'ad_lat'   => $lat,
           'ad_lng'   => $lng,
           'ad_title' => $place_name,
           'count'    => $count,
           'cat_icon' => $cat_icon);
          $places_names_arr[] = $place_name;
          ?>
          <div class="item" data-ad_id="<?= $place_id; ?>">
           <div class="item-pic" id="<?= $place_id; ?>">
            <img src="<?= $photo_url; ?>" />
           </div><!-- .item-pic -->
   
           <div class="item-description">
            <div class="item-title-row">
             <div class="item-counter"><div class="item-counter-inner"><?= $count; ?></div></div>
   
             <h2><a href="<?= $baseurl; ?>/<?= $place_city_slug; ?>/place/<?= $place_id; ?>/<?= $place_slug; ?>" title="<?= $place_name; ?>"><?= $place_name; ?></a></h2>
            </div>
            <div class="item-ratings-wrapper">
             <div class="item-rating" data-rating="<?= $rating; ?>">
              <!-- raty plugin placeholder -->
             </div>
             <div class="item-ratings-count">
              <?php // echo $count_rating; ?> <?php // echo ($count_rating == 1 ? 'review' : 'reviews'); ?>
             </div>
             <div class="clear"></div>
            </div><!-- .item-ratings-wrapper -->
            <div class="item-info">
             <div class="item-addr">
              <strong>
               <?= (!empty($address)) ? $address : ''; ?>
              </strong>
              <?= (!empty($cross_street)) ? "($cross_street)" : ''; ?>
              <br>
              <strong>
               <?= (!empty($place_city_name))  ? "$place_city_name," : ''; ?>
               <?= (!empty($place_state_abbr)) ? " $place_state_abbr " : ''; ?>
               <?= (!empty($postal_code))      ? $postal_code : ''; ?>
              </strong>
             </div>
   
             <div class="item-phone">
              <?= (!empty($phone)) ? '<i class="fa fa-phone-square"></i>' : ''; ?>
              <?= (!empty($area_code)) ? $area_code : ''; ?>
              <?= (!empty($phone)) ? $phone : ''; ?>
             </div>
            </div><!-- .item-info -->
   
            <?php
            echo (!empty($tip_text)) ? $tip_text : '';
            ?>
           </div><!-- .item-description -->
   
           <div class="clear"></div>
          </div><!-- .item  -->
          <?php
         } //  end foreach($response as $k => $v)
        } // end if($total_rows > 0)
       else {
        // else no results found
        ?>
        <div class="empty-cat-template">
         <p><?= $txt_empty_results; ?></p>
        </div>
        <?php
       }
       ?>
       </div><!-- .list-items -->
   
       <?php
       /*
       --------------------------------------------------
       BEGIN PAGER
       --------------------------------------------------
       */
       ?>
       <div id="pager">
        <ul class="pagination">
         <?php
         if(!empty($pager) && $pager->getTotalPages() > 1) {
          $curPage = $page;
   
          $startPage = ($curPage < 5)? 1 : $curPage - 4;
          $endPage = 8 + $startPage;
          $endPage = ($pager->getTotalPages() < $endPage) ? $pager->getTotalPages() : $endPage;
          $diff = $startPage - $endPage + 8;
          $startPage -= ($startPage - $diff > 0) ? $diff : 0;
   
          $startPage = ($startPage == 1) ? 2 : $startPage;
          $endPage = ($endPage == $pager->getTotalPages()) ? $endPage - 1 : $endPage;
   
          if($total_rows > 0) {
           $page_url = "$baseurl/_searchresults.php?city_id=$query_city_id&query=$query_query&page=";
   
           if ($curPage > 1) {
            ?>
            <li><a href="<?= $page_url; ?>1">Page 1</a></li>
            <?php
           }
   
           if ($curPage > 6) {
            ?>
            <li><span>...</span></li>
            <?php
           }
   
           if ($curPage == 1) {
            ?>
            <li class="active"><span>Page 1</span></li>
            <?php
           }
   
           for($i = $startPage; $i <= $endPage; $i++) {
            if($i == $page) {
             ?>
             <li class="active"><span><?= $i; ?></span></li>
             <?php
            }
            else {
             ?>
             <li><a href="<?php echo $page_url, $i; ?>"><?= $i; ?></a></li>
             <?php
            }
           }
   
           if($curPage + 5 < $pager->getTotalPages()) {
            ?>
            <li><span>...</span></li>
            <?php
           }
   
           if($pager->getTotalPages() > 5) {
            $last_page_txt = "Last Page";
           }
   
           $last_page_txt = ($pager->getTotalPages() > 5) ? "Last Page" : $pager->getTotalPages();
   
           if($curPage == $pager->getTotalPages()) {
            ?>
            <li class="active"><span><?= $last_page_txt; ?></span></li>
            <?php
           }
           else {
            ?>
            <li><a href="<?php echo $page_url, $pager->getTotalPages(); ?>"><?= $last_page_txt; ?></a></li>
            <?php
           }
          } //  end if($total_rows > 0)
         } //  end if(isset($pager) && $pager->getTotalPages() > 1)
   
         if(isset($pager) && $pager->getTotalPages() == 1) {
          ?>
   
          <?php
         }
         ?>
        </ul>
       </div><!-- #pager -->
      </div><!-- .content-col -->
      
   
      <div class="sidebar"><div class="clear"></div>
       <?php
       if($total_rows > 0) {
        ?>
          <div class="clear"></div>
        <div class="map-wrapper" id="sticker">
         <div id="map-canvas" style="width:100%; height:100%"></div>
        </div>
        <?php
       }
       ?>
      </div>
       <div class="clear"></div>
      
      
      <!-- #sidebar -->
   
      <div class="clear"></div>
     </div><!-- .content-full -->
   
    <?php require_once('_footer.php'); ?>
    <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=<?= $google_key; ?>"></script>
   
    <script type="text/javascript">
    // place markers
    var results_obj = <?php echo json_encode($results_arr); ?>;
    var infowindow;
    var map;
   
    function initialize() {
     markers = {};
     infoboxcontents = {};
   
     // set map options
     var mapOptions = {
      zoom: 1
     };
   
     // instantiate map
     var map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions);
     var bounds = new google.maps.LatLngBounds();
     var infowindow = new google.maps.InfoWindow();
   
     // $results_arr[] = array("ad_id" => $place_id, "ad_lat" => $ad_lat, "ad_lng" => $ad_lng, "ad_title" => $ad_title, "count" => $count);
   
     // set markers
     for (var k in results_obj) {
      var p = results_obj[k];
      var latlng = new google.maps.LatLng(p.ad_lat, p.ad_lng);
      bounds.extend(latlng);
   
      var marker_icon = '<?= $baseurl; ?>/imgs/marker1.png';
   
      // place markers
      var marker = new google.maps.Marker({
       position: latlng,
       map: map,
       animation: google.maps.Animation.DROP,
       title: p.ad_title,
       //icon: marker_icon
      });
   
      markers[p.ad_id] = marker;
      infoboxcontents[p.ad_id] = p.ad_title;
   
      // click event on markers to show infowindow
      google.maps.event.addListener(marker, 'click', function() {
       infowindow.setContent(this.title);
       infowindow.open(map, this);
      });
     } // end for (var k in results_obj)
   
     map.fitBounds(bounds);
   
     $(".list-items .item").mouseover(function() {
      marker = markers[this.getAttribute("data-ad_id")];
      // mycontent = infoboxcontents[this.getAttribute("data-ad_id")];
   
      mycontent =  '<div class="scrollFix">' + infoboxcontents[this.getAttribute("data-ad_id")] + '</div>';
      // console.log(mycontent);
   
      infowindow.setContent(mycontent);
      // infowindow.setOptions({maxWidth:300});
      infowindow.open(map, marker);
      marker.setZIndex(10000);
     }); // end mouseover
    } //  end initialize()
   
    google.maps.event.addDomListener(window, 'load', initialize);
    </script>
   
    <script type="text/javascript">
    $.fn.raty.defaults.path = '<?= $baseurl; ?>/templates/lib/raty/images';
    $('.item-rating').raty({
     readOnly: true,
     score: function(){
      return this.getAttribute('data-rating');
     }
    });
    </script>
    <script>
    $(document).ready(function(){
     $("#sidebar").sticky({topSpacing:0});
    });
    </script>
   
    <script>
      $(document).ready(function(){
        $("#sticker").sticky({topSpacing: 24});
      });
    </script>
    <script type="text/javascript">
    function getUrlVars() {
        var vars = [], hash;
        var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
        for(var i = 0; i < hashes.length; i++) {
            hash = hashes.split('=');
            vars.push(hash[0]);
            vars[hash[0]] = hash[1];
        }
        return vars;
    }
   
    $(document).ready(function() {
     var loc = '<?= e($_GET['loc']); ?>';
     var query = '<?= e($_GET['query']); ?>';
     if(loc !== '') {
      $("#city-input").val(loc);
     }
     if(query !== '') {
      $("#query-input").val(query);
     }
    });
   
    </script>
    </body>
    </html>

 

Edited April 13, 2019 by requinix
please use the Code <> button when posting code.

This will only send 1 goggles information into the database but I have a "adding" page that can actually add more than 1 goggles at once. I have no idea how to go about  saving multiple goggle's information using array or loop.


$name= $_POST['goggles_name'];
$price = $_POST['goggles_price'];
$des = $_POST['goggles_description'];
$file = $_FILES['goggles_image']['name'];
$chkbox = $_POST['upload'];
$id = $_POST['goggles_id'];
 

$query = "UPDATE goggles SET goggles_name = '$name' , goggles_price = '$price' ,goggles_description = '$des' WHERE goggles_id ='".$id."' "; 
$result = mysqli_query($link, $query) or die(mysqli_error($link));

As part of my User Profile, I have a series of open-ended questions that Members can answer, e.g...
Quote

1.) Why did you start your own business?
2.) If you could offer one piece of advice to other entrepreneurs, what would it be?
:
10.) How do you compete against large corporations?



I was leaning towards creating a many-to-many relationship like this...

member -||---------0<- answer ->0---------||- question


From a database standpoint this works great, HOWEVER, I just realized a big problem...

If run this query...

Code: [Select]
SELECT response
FROM answer
WHERE member_id = 1;
...then I would get TEN RECORDS back and I don't know of any way to maps those to the 10 Text Boxes on the "My Thoughts" page?!

(It would be a real PITA to have to create 10 separate Prepared Queries in PHP - one for each Field - to fill out my page?!)

So, is there a way to keep my table structure, but push the 10 records from above into 10 separate variables so I would have something like $response1, $response2,... $response10 ??

Thanks,


Debbie

Suppose I have two versions of the same website; one American and one Canadian.  This site has members with profiles etc.  The way my site is written, I think that if someone were to login to their account on, say, the American site, then a session variable would indicate that a user is logged in on the client machine.  Now if they visit the "profile" page, for example, or some other members-only page ON THE CANADIAN SITE, and start manipulating data etc., then this would affect the databases for the Canadian site, and everything would get screwed up (actually, I think mysql would just start spitting out errors, but that's not good either).

Does anyone have some simple way to deal this this kind of thing?  I don't really know exactly how session variables work.   Say I have two domains, somepage.com and somepage.ca on the same server/DNS.  If a page on somepage.com sets a session variable called $_SESSION['somevar'], and a page on somepage.ca also sets a variable called $_SESSION['somevar'], are the two variables somehow distinct because they are on different domains?  Like, if somepage.com sets the variable, then somepage.ca check if the variable is set, what will happen?  What if I wanted to set up the two pages in subfolders, like somepage.com/us and somepage.com/ca, how would I deal with distinguish session variables for the two sites?  Is one approach (i.e. distinct domains vs subfolders) better than the other?

Thanks,

Hi All,

I'm quite new to this PHP stuff and have been creating a site just for the hell of it really but i have a rather bizarre problem that has been driving me nuts for about a week...

I have two drops downs, the first gives a list of teams from a mysql table and then this populates the next drop down with a list of players from the selected team.. so far so good.

When I hit the select/submit button to select the player, what should happen is both the "team" and "player" are put into another query which gives the stats on the selected player for all the games that he has played in.

however, what actually happens in the Session variable sets the "team" variable to blank.

I can see this happening when I use

Print_r ($_SESSION);

So essentially when I click on either submit button from my drop down forms the other value is being removed from the Session array. Oh, the session is still valid (not being destroyed and replaced with another session).


First drop down

                          

                         $query_teams="select Team from $teams";

                          $team_result=mysql_query($query_teams);

                          $num_team=mysql_numrows($team_result);
                                      
                          
                       echo $num_team;
                       print_r ($row_team);
                       
                       $team_count = 0;
                          
                       echo  '<form method="post" action="map_selector.php">';


                       echo "<SELECT name='country'>";
                     
                     while ($row_team1 = mysql_fetch_assoc($team_result))


                               {
                               
                               $team_info = $row_team1["Team"];

                               echo "<OPTION value='$team_info'>$team_info </option>";

                               }
                               

                               echo '</select>';

                               echo '<center><input type="submit" value="Search"></center>';

                          $country = $_POST["country"];

                           $_SESSION["country"] = $country;
                           
                          echo '</form>';


So SCOTLAND is selected

Some sql queries to get the results for the possible players and then

Drop down 2


                       $row_full = array_unique($row_home);

                        echo  '<form method="post" action="map_selector.php">';


                       echo "<SELECT name='Player'>";

                       foreach ($row_full as $key => $value)

                               {

                               echo "<OPTION value='$value'> $value";

                               }

                               echo '</select>';
                               
                               echo "@";
                               echo $country;
                               echo "@";

                               echo '<center><input type="submit" value="Search"></center>';

                          $country=$_POST["country"];
                          $player=$_POST["Player"];
                          
                               echo "#";
                               echo $country;
                               echo "#";


                          echo '</form>';

                          $_SESSION["Player"] = $player;

                          $selected_player =  $_SESSION["Player"];

                          echo $player;
                          echo $selected_player;
                          
                          echo $country;

                          
                          Print_r ($_SESSION);


so Print_r ($_Session) returns:

Array ( [Player] => [country] => Scotland [] => )

then a player "Paul Hartley" is selected from the player list and submit is click and then Print_r($_Session) shows:

Array ( [Player] => Paul Hartley [country] => [] => )

Can anyone please help... I just can;t understand why this is happening when I'm using a Sessions which, I thought, would retain all variable values until a time-out or a destroy

Thanks
nhsal69

Hey guys,

Really dumb question, but I want to check if a bunch of variables are all not empty. Then, if they aren't, I want to execute a mySQL query. Right now I have this which I know is wrong because it doesn't work the right way:

Code: [Select]
if($album != null || $artist != null || $year != null || $genre != null) {
// stuff here...
}

Obviously I want all of those variables to be checked if they are empty or not. I did a quick Google and found that checking if the variables are null wouldn't be the correct way of solving this situation because an "empty string" is still not null?

Anyway, any help would be appreciated. I'm pretty sure it's really simple :p.