PHP - Web Interface For Displaying Various Service States

Okay,

On my original problem, I have been able to authenticate with the web service login service, and extract a cookie as follows from the web-service:

$s_Cookie = $agLoginService->agGetCookie();
$s_Cookie = AGSESSION=oxhbjcKtPw5sOymAD8m8KcKR6JL4i+TIE5mZxwOrXLwCRr8iTOvPxA==;

Now, I create data access soapclient:

$agDataService = new SoapClient($s_DataURL, $a_SoapOptions);   //yes I know I should build my own class wrapper around soapClient, but I am trying to make sure I know what to build before I do

next in the process I need to set the cookie for the data access service.

I tried using:
<b>$agDataService->__setCookie('cookie', $s_Cookie);</b>

but I don't think it's right because when I call any of the service's functions, I get no data back.

This is what their engineer had to say ( he is no help in php at all)

This is a question referring the http headers.  He needs to set the cookies as given in the examples on the wiki page.  The cookie is specified in a response http header as: Set-Cookie.  So the http headers he got back are correct.  The cookie he has to set is AGSESSION=oxhbjcKtPw5sOymAD8m8KcKR6JL4i+TIE5mZxwOrXLwCRr8iTOvPxA==;  There should be an api for setting the cookie if not there is one for setting the http header.  Set the http header name for the request (cookie - notice that is different than what you get back from an http response - read the rfc spec for http for all of the details) then set the value.  The semi colon at the end is the delimiter for http headers (in the rfc).  That is all he needs to do if he gets back some login error that means the cookies did not get set correctly.

Any ideas or help will be great. Thank you.

I'm needing some direction in how to start this...  I have a page with the 50 U.S. states listed.  I have a column in my mysql database that holds each state's name called:  source

There's a few thousands rows in my database, so the state names vary in the record count. 

How can I query the database and have a little count by each one of my 50 states that shows how many results exist in the db for that state?  I know how to query for total rows and show that number... but confused on how I would do it for individual line items.

Thanks for any suggestions. 

I've got 2 database tables (states, stores) and I want to output all the states with a list of specific locations under each state.

My 'states' table has a 'state_id' and 'state' while my 'stores' table has all the store information along with the 'state_id' to work with the 'states' table.

How would I ago about formulating a loop to display all locations organized by each state, etc.?

I am having a helluva time trying to populate my state option box with a state array.

I have the array set but now how does this get called into the foreach block where the select box is? I can populate it i guess with options manually but I want to get the array to display in the box instead.

I tried everything with the minimal experience I have so I need a little help, I got the select box up and displaying where I want it but I cant populate it with an array call.   See foreach block near the end of the code:

Thanks a bunch!

here is my include file code so far:

<?php
 /*  Program name: form_test_state.inc
  *  Description:  Defines a form that collects a user's
  *                name and mailing address.
  */
$rows = array( "first_name" => "First Name",
                 "last_name" => "Last Name",
                 "phone" => "Phone Number",
                 "city" => "City",
                 "state" => "State",
                 "address" => "Address",
                 "zip_code" => "ZIP Code",
                 "e_mail" => "E-Mail");
    
    $states_list = array('AL'=>"Alabama",'AK'=>"Alaska",'AZ'=>"Arizona",'AR'=>"Arkansas",'CA'=>"California",'CO'=>"Colorado",'CT'=>"Connecticut",'DE'=>"Delaware",'DC'=>"District Of Columbia",'FL'=>"Florida",'GA'=>"Georgia",'HI'=>"Hawaii",'ID'=>"Idaho",'IL'=>"Illinois", 'IN'=>"Indiana", 'IA'=>"Iowa",  'KS'=>"Kansas",'KY'=>"Kentucky",'LA'=>"Louisiana",'ME'=>"Maine",'MD'=>"Maryland", 'MA'=>"Massachusetts",'MI'=>"Michigan",'MN'=>"Minnesota",'MS'=>"Mississippi",'MO'=>"Missouri",'MT'=>"Montana",'NE'=>"Nebraska",'NV'=>"Nevada",'NH'=>"New Hampshire",'NJ'=>"New Jersey",'NM'=>"New Mexico",'NY'=>"New York",'NC'=>"North Carolina",'ND'=>"North Dakota",'OH'=>"Ohio",'OK'=>"Oklahoma", 'OR'=>"Oregon",'PA'=>"Pennsylvania",'RI'=>"Rhode Island",'SC'=>"South Carolina",'SD'=>"South Dakota",'TN'=>"Tennessee",'TX'=>"Texas",'UT'=>"Utah",'VT'=>"Vermont",'VA'=>"Virginia",'WA'=>"Washington",'WV'=>"West Virginia",'WI'=>"Wisconsin",'WY'=>"Wyoming");            
                
              
$submit = "Submit mailing information";
?>
<html>
<head>
  <style type='text/css'>
   <!--
body {
    background: #42413C;
    color: #000;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 90%;
}
      form {
        margin: 1em 2 2 2;
        padding: 1;
        width: 1100px;
        margin-left: 35%;

      }
      .field {padding-bottom: 1em;
    
}
        label {
        font-weight: bold;
        float: left;
       width: 10%;
margin-right: 1em;
        text-align: right;
        background-color: #9F6;
padding-right: 5px;
        
      }
      select {margin-bottom: 1em;}
      
      #submit {
        margin-left: 15%;
      }
h3 {
width: 500px;
margin-left: 35%;
}


   -->
 </style>
</head>
<body>
<h3>Please enter your mailing information below:</h3>
<?php
 /* loop that displays the form */

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

  foreach($rows as $field => $label)

  if($field == "state")
 {
      echo "<label for='$field'>$label</label>
      <select name='State'>                          <<<<  Insert $states_list array here I am trying to figure out >>>>
  <option value='state'>Alabama </option>
</select> ";
   }
   else  
  {
    echo "<div class='field'><label for='$field'>$label</label>
            <input id='$field' name='$field' type='text' value='".@$$field."'  
   size='25%' maxlength='65' /></div>\n";
  }
  echo "<div id='submit'>
    <input type='submit' value='$submit'></div>";
?>

</form>
</body>
</html>

I am just starting out with PHP.  I have resorted to doing some custom PHP programming because the plug-INs for a CMS I am using need a little customization.

The question I have is very simple and I am sure PHP programmers can answer this instantly.  I have successfully declared a global PHP variable.  All I need to know how to do for now is how to declare a button or a hyperlink or an input form element such that it can change the assignment of this variable.