Using PHP Object with SQL Query

I've got a User form, upon submission, it consumes a web service, and the response is a contract vehicle.

This is the returned object:

stdClass Object ( [contractVehicle] => Array ( [1] => ITCommodityProgram ) )

There are several contract vehicles.

I then need to use the returned contract vehicle, query my Products table like so:

SELECT * FROM `product` WHERE `contract_vehicle` = 2


The important point is the WHERE needs to be dynamic, , not hard coded, because the returned contract vehicle will be different with each User submission.
sandshakimiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mankowitzCommented:
how do you get from your returned object to the number 2 for the ID of the contract vehicle?

You will want to use php pdo to connect to the database. Something like this

$stmt = $dbh->prepare("SELECT * FROM `product` WHERE `contract_vehicle` = ?");
if ($stmt->execute(___YOUR VARIABLE GOES HERE___) {
  while ($row = $stmt->fetch()) {
    print_r($row);
  }
}

see http://php.net/manual/en/pdo.prepared-statements.php for more information
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sandshakimiAuthor Commented:
The database has a contract_vehicles table with unique IDs.

So for example, newyorkcom, has a contract_vehicle ID of 3, but it's in [2] in the array.
0
Ray PaseurCommented:
In the contract_vehicles table, what is the column name you want to find?

Please post the CREATE TABLE statement for this table, thanks.  It may be something lie this, but we will need more specifics to give a certain answer.
<?php // demo/temp_sandshakimi.php
error_reporting(E_ALL);

// SEE http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/Q_28517944.html
// stdClass Object ( [contractVehicle] => Array ( [1] => ITCommodityProgram ) ) 
// SELECT * FROM `product` WHERE `contract_vehicle` = 2

// USE A DATA ELEMENT IN A QUERY
$cv = (string)$obj->contractVehicle[1];
$sq = "SELECT column_name FROM `product` WHERE `contract_vehicle` = '$cv' LIMIT 1";

Open in new window

0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

sandshakimiAuthor Commented:
Here is the existing Contract Vehicles table.

Contract Vehicles Table
0
sandshakimiAuthor Commented:
Here is the web service call creating the return object.

Once it is refined, it should only return one contract vehicle. So there's only three right now.

$param = array('commodity' => 'LAPTOP',  'placeOfPerformance' => array('location' => 'LSA' , 'lsaStates' => 'NY', 'VA', 'TX', 'oconusStates' => 'ALASKA', 'EMEA'),  'equipmentType' => 'ANY', 'socioEconomicObjective' => 'NONE', 'agencyCode' => '007',);

$client = new SoapClient('https://sso-test.fas.gsa.gov/mpdev/navigator/wsdl');  
$results = $client->__soapCall('retrieveContractVehicles', array('parameters' => $param));  
  
print_r($results);

Open in new window

0
sandshakimiAuthor Commented:
Forgot to mention in the last post, for prototyp purposes I obviously, hard coded the values.

But on production it will be a user form.
0
Ray PaseurCommented:
I'm confused.  The SOAP call returns data that looks like ITCommodityProgram but there is nothing that matches that in the contract vehicles table.
0
sandshakimiAuthor Commented:
Ray, you're right. I'm told the ITCommodityProgram will be the next record, perhaps I'm guessing contract_vehicle_id of 4, and vehicle_name of IT Commodity.

I'm developing out the PHP faster then the team on the db is doing their stuff.
0
sandshakimiAuthor Commented:
Also, I'm told that it is legitimate to have more than one Contract Vehicle. So in the above SOAP call prototype, I'm returning two.

But on the form, it may return nothing, one or all four.
0
mankowitzCommented:
I think we can help you much more if you can provide an example of the objects that are returned. For example, in you question you gave a field that is probably the vehicle_name, not the ID.

You know what they say, walking on water and writing to a specification is easy, as long as they are frozen.
0
sandshakimiAuthor Commented:
This form has the SOAP call in it. If run, you will get the Object back.
0
sandshakimiAuthor Commented:
Revised. The final form.

<!DOCTYPE html>
<html>


<link rel="stylesheet" href="sites/all/scripts/bootstrap-3.1.1.min.css" type="text/css"/>
<script type="text/javascript" src="sites/all/scripts/jquery-2.1.0.min.js"></script>
<script type="text/javascript" src="sites/all/scripts/bootstrap-3.1.1.min.js"></script>


<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>

<script type="text/javascript" src="bootstrap-multiselect.js"></script>
<link rel="stylesheet" href="bootstrap-multiselect.css" type="text/css"/>


<!-- START FORM -->
<!-- Post the values to SOAP request -->
<body>

<br />
<b>Notice</b>:  Undefined index: commodity in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>24</b><br />
<br />
<b>Notice</b>:  Undefined index: location in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>25</b><br />
<br />
<b>Notice</b>:  Undefined index: lsaStates in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>26</b><br />
<br />
<b>Notice</b>:  Undefined index: oconusStates in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>27</b><br />
<br />
<b>Notice</b>:  Undefined index: equipmentType in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>28</b><br />
<br />
<b>Notice</b>:  Undefined index: socioEconomicObjective in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>29</b><br />
<br />
<b>Notice</b>:  Undefined index: agencyCode in <b>C:\apache\htdocs\process-form\process-form.php</b> on line <b>30</b><br />

<form method="post" action="">

<div class="col-xs-12" style="border:solid 0px #666; padding:8px; margin-bottom:20px; border-radius: 10px;">
         <div class="col-xs-12 col-md-8">
        <div class="row">
          <div class="row"><div class="col-sm-6"><ul class="list-group">
            <li class="list-group-item"><strong>Location</strong></li>
            <li class="list-group-item">
			
			<!-- Pass the commodity: Laptop -->
			<input name="commodity" id="commodity" type="hidden" value="LAPTOP" />
			
			<!-- Pass the agency: 006 -->
			<input name="agencyCode" id="agencyCode" type="hidden" value="006" />
			
			<!-- Capture the Location: Conus -->
            <input name="location" id="location" type="radio" checked="checked" value="CONUS">CONUS</li>
			
            <li class="list-group-item">Local Service Areas. Select all that apply from 48 States and the District of Columbia:<br>
            
			<!-- Capture the Location: LSA -->
			<input name="location" id="lsa" type="radio" value="LSA">Local Service Areas<br />
			
			<!-- Capture the LSA States -->
			<div style="border:2px solid #ccc; width:350px; height: 90px; overflow-y: scroll;">
			<input type="checkbox" name="lsaStates" value="AL" />Alabama <br />
			<input type="checkbox" name="lsaStates" value="AZ" />Arizona <br />
			<input type="checkbox" name="lsaStates" value="AR" />Arkansas <br />
			<input type="checkbox" name="lsaStates" value="CA" />California <br />
			<input type="checkbox" name="lsaStates" value="CO" />Colorado <br />
			<input type="checkbox" name="lsaStates" value="CT" />Connecticut <br />
			<input type="checkbox" name="lsaStates" value="DC" />DC (including MD and VA areas in Metro DC) <br />
			<input type="checkbox" name="lsaStates" value="DE" />Delaware <br />
			<input type="checkbox" name="lsaStates" value="FL" />Florida <br />
			<input type="checkbox" name="lsaStates" value="GA" />Georgia <br />
			<input type="checkbox" name="lsaStates" value="ID" />Idaho <br />
			<input type="checkbox" name="lsaStates" value="IL" />Illinois <br />
			<input type="checkbox" name="lsaStates" value="IN" />Indiana <br />
			<input type="checkbox" name="lsaStates" value="IA" />Iowa <br />
			<input type="checkbox" name="lsaStates" value="KS" />Kansas <br />
			<input type="checkbox" name="lsaStates" value="KY" />Kentucky <br />
			<input type="checkbox" name="lsaStates" value="LA" />Louisiana <br />
			<input type="checkbox" name="lsaStates" value="ME" />Maine <br />
			<input type="checkbox" name="lsaStates" value="MD" />Maryland <br />
			<input type="checkbox" name="lsaStates" value="MA" />Massachusetts <br />
			<input type="checkbox" name="lsaStates" value="MI" />Michigan <br />
			<input type="checkbox" name="lsaStates" value="MN" />Minnesota <br />
			<input type="checkbox" name="lsaStates" value="MS" />Mississippi <br />
			<input type="checkbox" name="lsaStates" value="MO" />Missouri <br />
			<input type="checkbox" name="lsaStates" value="MT" />Montana <br />
			<input type="checkbox" name="lsaStates" value="NE" />Nebraska <br />
			<input type="checkbox" name="lsaStates" value="NV" />Nevada <br />
			<input type="checkbox" name="lsaStates" value="NH" />New Hampshire <br />
			<input type="checkbox" name="lsaStates" value="NJ" />New Jersey <br />
			<input type="checkbox" name="lsaStates" value="NM" />New Mexico <br />
			<input type="checkbox" name="lsaStates" value="NY" />New York <br />
			<input type="checkbox" name="lsaStates" value="NC" />North Carolina <br />
			<input type="checkbox" name="lsaStates" value="ND" />North Dakota <br />
			<input type="checkbox" name="lsaStates" value="OH" />Ohio <br />
			<input type="checkbox" name="lsaStates" value="OK" />Oklahoma <br />
			<input type="checkbox" name="lsaStates" value="OR" />Oregon <br />
			<input type="checkbox" name="lsaStates" value="PA" />Pennsylvania <br />
			<input type="checkbox" name="lsaStates" value="RI" />Rhode Island <br />
			<input type="checkbox" name="lsaStates" value="SC" />South Carolina <br />
			<input type="checkbox" name="lsaStates" value="SD" />South Dakota <br />
			<input type="checkbox" name="lsaStates" value="TN" />Tennessee <br />
			<input type="checkbox" name="lsaStates" value="TX" />Texas <br />
			<input type="checkbox" name="lsaStates" value="UT" />Utah <br />
			<input type="checkbox" name="lsaStates" value="VT" />Vermont <br />
			<input type="checkbox" name="lsaStates" value="VA" />Virginia <br />
			<input type="checkbox" name="lsaStates" value="WA" />Washington <br />
			<input type="checkbox" name="lsaStates" value="WV" />West Virginia <br />
			<input type="checkbox" name="lsaStates" value="WI" />Wisconsin <br />
			<input type="checkbox" name="lsaStates" value="WY" />Wyoming
			</div>
			  
			 </li>
            
			<li class="list-group-item">Specific Outside of Continental United States (OCONUS). Select all that apply:<br>
			<!-- Pass value of Oconus area -->
			<input type="checkbox" name="oconusStates" value="ALASKA" />Alaska and Arctic Region <br />
			<input type="checkbox" name="oconusStates" value="CARIBBEAN" />Caribbean (Puerto Rico and US Virgin Islands) <br />
			<input type="checkbox" name="oconusStates" value="EMEA" />Europe, Africa and Middle East <br />
			<input type="checkbox" name="oconusStates" value="HAWAII" />Hawaii and Pacific Rim <br />

            <li class="list-group-item">
			
            <!-- Pass the Location: Global -->
			<input name="location" id="global" type="radio" value="GLOBAL">Global</li>
			
			<!-- Pass the socio economic indicators -->
			</ul></div>
			<div class="col-sm-6"><ul class="list-group">
            <li class="list-group-item"><strong>Socio Economic Indicators</strong></li>
			
            <li class="list-group-item">
			<label for=""  style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" value="SB" id="SB" data-ptag="sb1" class="check_box"></code>&nbsp;Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="womenBus" value="WOB" data-ptag="sb2" class="check_box"></code>&nbsp;Women Owned Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="womOSB" value="WOSB" data-ptag="sb3" class="check_box"></code>&nbsp;Women Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="Eco_DWOSB" value="EDWOSB" data-ptag="sb4" class="check_box"></code>&nbsp;Economically Disadvantaged Women Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="VetOSB" value="VOSB" data-ptag="sb5" class="check_box"></code>&nbsp;Veteran Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="SerDVOSB" value="SDVOSB" data-ptag="sb6" class="check_box"></code>&nbsp;Service Disabled Veteran Owned Small Business</li></label>
			
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" id="SBA_Certified" value="SBACSDB" data-ptag="sb7" class="check_box"></code>&nbsp;SBA Certified Small Disadvantaged Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" id="SBA_8" value="SBA8ACB" data-ptag="sb8" class="check_box"></code>&nbsp;SBA 8(a) Certified Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" value="SBCHSB" id="SBA_Cert" data-ptag="sb9" class="check_box"></code>&nbsp;SBA Certified HUBZone Small Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" value="NOPREFERENCE" id="NoPref" data-ptag="sb10" class="check_box"></code>&nbsp;No Preference</li></label>
            
			<!-- Pass value of equipmentype -->
			<p><strong>Equipment Type</strong></p>
			<input type="checkbox" name="equipmentType" value="NEW" />New Laptop <br />
			<input type="checkbox" name="equipmentType" value="REFURBISHED" />Refurbished Laptop <br />
			<input type="checkbox" name="equipmentType" value="ANY" />Any Laptop <br />

          </ul></div>
        
          </div>
		  <!-- Submit the form, for now just display the results on the screen -->
		  <p><input class="btn btn-sm btn-success" type="submit" name="submit" value="Update Pricing"></p>
		  </div>
		  </div>
          <div class="col-xs-6 col-md-4">
         
           <div class="well">
           <h3><strong>Advice & Definitions</strong></h3>
                         <p id="sb1" class="p_element">Small Business - Privately owned corporations, Partnerships. or sole proprietrorships.  </p>
            <p id="sb2" class="p_element">Women Owned Business - Business which is majority owned by one or more female American citizens.  </p>
            <p id="sb3" class="p_element">Women Owned Small Business - Small Business which is majority owned by one or more female American citizens.  </p>
            <p id="sb4" class="p_element">Economically Disadvantage Women Owned Small Business - Small Business which is majority owned by one or more female American citizens who are economically disadvantaged.  </p>
            <p id="sb5" class="p_element">Veteran Owned Small Business - Small Business which is majority owned by one or more veterans.  </p>
            <p id="sb6" class="p_element">Service Disabled Veteran Owned Small Business - Small Business which is majority owned by one or more service disabled veterans.  </p>
            <p id="sb7" class="p_element">SBA Certified Small Disadvantaged Business - Government certified Small Business which is majority owned by disadvantaged persons.  </p>
            <p id="sb8" class="p_element">SBA 8 (a) Certified Business - Government certified Small Business which is majority owned by socially and economically disadvantaged individuals who are American citizens.   </p>
            <p id="sb9" class="p_element">SBA Certified HUBZONE Small Business - Government certified Small Business which is majority owned by disadvantaged persons in urban and rural communities .  </p>
            <p id="sb10" class="p_element">No Preference -  No preference on socio economic.  </p>
           
          </div>
          </div>  
		  </form><!-- END OF PROCESS FORM -->

<!-- Initialize the plugin: -->
<script type="text/javascript">
$(document).ready(function() 
{
    $('.multiselect').multiselect
    ({
        maxHeight: 300
    });

});

$(document).ready(function() 
{
    $("#conusid").click(function(){
        $("#localserviceid").attr('checked',false);
        $("#worldid").attr('checked',false);
    });
  $("#localserviceid").click(function(){ 
      $("#conusid").attr('checked',false);
  });
       $("#worldid").click(function(){ 
      $("#conusid").attr('checked',false);
  });

   $("#stand , #stand1").click(function()
   { 
      $("#lap_spec").show(1000);
      $("#lite_wt").hide(1000);
      $("#perormance_spec").hide(1000);
   });
  
  
   $("#ltwt, #ltwt1").click(function()
   { 
      $("#lap_spec").hide(1000);
      $("#lite_wt").show(1000);
      $("#perormance_spec").hide(1000);
   });
   
   
    $("#perform, #perform1").click(function()
   { 
      $("#lap_spec").hide(1000);
      $("#lite_wt").hide(1000);
      $("#perormance_spec").show(1000);
   });


}); 
</script>

<code style="background: none;">
 <script>
$('.check_box').change(function()
{
    if($('.check_box:checked').length==0)
    {
        $('.p_element').show();
    }
    else
    {
    $('.p_element').hide();
        $('.check_box:checked').each(function()
        {
            $('#'+$(this).attr('data-ptag')).show();
        });
    }

});
</script>
</code>


 
 </body>
 </html>

Open in new window

0
sandshakimiAuthor Commented:
Sorry, I goofed again.

Here's the PHP form.

<link rel="stylesheet" href="sites/all/scripts/bootstrap-3.1.1.min.css" type="text/css"/>
<script type="text/javascript" src="sites/all/scripts/jquery-2.1.0.min.js"></script>
<script type="text/javascript" src="sites/all/scripts/bootstrap-3.1.1.min.js"></script>
<script type="text/javascript" src="sites/all/scripts/bootstrap-multiselect.js"></script>
<link rel="stylesheet" href="sites/all/scripts/bootstrap-multiselect.css" type="text/css"/>


<!-- START FORM -->
<!-- Post the values to SOAP request on soapcall.php -->
<?php
// Define the location of the WSDL, and create an instance of the SoapClient class to access the web service -->
$client = new SoapClient('https://sso-test.fas.gsa.gov/mpdev/navigator/wsdl');  
$commodity = $_POST['commodity'];
$location = $_POST['location'];
$lsaStates = $_POST['lsaStates'];
$oconusStates = $_POST['oconusStates'];
$equipmentType = $_POST['equipmentType'];
$socioEconomicObjective = $_POST['socioEconomicObjective'];
$agencyCode = $_POST['agencyCode'];

// If empty, pass Null
if (!empty($_POST['commodity'])) {
   $commodity = $_POST['commodity'];
} else {
   $commodity = null;
}

if (!empty($_POST['location'])) {
   $location = $_POST['location'];
} else {
   $location = null;
}

if (!empty($_POST['lsaStates'])) {
   $lsaStates = $_POST['lsaStates'];
} else {
   $lsaStates = null;
}

if (!empty($_POST['oconusStates'])) {
   $oconusStates = $_POST['oconusStates'];
} else {
   $oconusStates = null;
}

if (!empty($_POST['equipmentType'])) {
   $equipmentType = $_POST['equipmentType'];
} else {
   $equipmentType = null;
}

if (!empty($_POST['socioEconomicObjective'])) {
   $socioEconomicObjective = $_POST['socioEconomicObjective'];
} else {
   $socioEconomicObjective = null;
}

if (!empty($_POST['agencyCode'])) {
   $agencyCode = $_POST['agencyCode'];
} else {
   $agencyCode = null;
}

// Sent the parameters through the SOAP client
$param = array(
'commodity' => $commodity,
'placeOfPerformance' => array('location' => $location , 'lsaStates' => $lsaStates, 'oconusStates' => $oconusStates),
'equipmentType' => $equipmentType,
'socioEconomicObjective' => $socioEconomicObjective,
'agencyCode' => $agencyCode,
);

// Return results
$resultsProcess = $client->__soapCall('retrieveContractVehicles', array('parameters' => $param));  
?>

<form method="post" action="">

<div class="col-xs-12" style="border:solid 0px #666; padding:8px; margin-bottom:20px; border-radius: 10px;">
         <div class="col-xs-12 col-md-8">
        <div class="row">
          <div class="row"><div class="col-sm-6"><ul class="list-group">
            <li class="list-group-item"><strong>Location</strong></li>
            <li class="list-group-item">
			
			<!-- Pass the commodity: Laptop -->
			<input name="commodity" id="commodity" type="hidden" value="LAPTOP" />
			
			<!-- Pass the agency: 006 -->
			<input name="agencyCode" id="agencyCode" type="hidden" value="006" />
			
			<!-- Capture the Location: Conus -->
            <input name="location" id="location" type="radio" checked="checked" value="CONUS">CONUS</li>
			
            <li class="list-group-item">Local Service Areas. Select all that apply from 48 States and the District of Columbia:<br>
            
			<!-- Capture the Location: LSA -->
			<input name="location" id="lsa" type="radio" value="LSA">Local Service Areas<br />
			
			<!-- Capture the LSA States -->
			<div style="border:2px solid #ccc; width:350px; height: 90px; overflow-y: scroll;">
			<input type="checkbox" name="lsaStates" value="AL" />Alabama <br />
			<input type="checkbox" name="lsaStates" value="AZ" />Arizona <br />
			<input type="checkbox" name="lsaStates" value="AR" />Arkansas <br />
			<input type="checkbox" name="lsaStates" value="CA" />California <br />
			<input type="checkbox" name="lsaStates" value="CO" />Colorado <br />
			<input type="checkbox" name="lsaStates" value="CT" />Connecticut <br />
			<input type="checkbox" name="lsaStates" value="DC" />DC (including MD and VA areas in Metro DC) <br />
			<input type="checkbox" name="lsaStates" value="DE" />Delaware <br />
			<input type="checkbox" name="lsaStates" value="FL" />Florida <br />
			<input type="checkbox" name="lsaStates" value="GA" />Georgia <br />
			<input type="checkbox" name="lsaStates" value="ID" />Idaho <br />
			<input type="checkbox" name="lsaStates" value="IL" />Illinois <br />
			<input type="checkbox" name="lsaStates" value="IN" />Indiana <br />
			<input type="checkbox" name="lsaStates" value="IA" />Iowa <br />
			<input type="checkbox" name="lsaStates" value="KS" />Kansas <br />
			<input type="checkbox" name="lsaStates" value="KY" />Kentucky <br />
			<input type="checkbox" name="lsaStates" value="LA" />Louisiana <br />
			<input type="checkbox" name="lsaStates" value="ME" />Maine <br />
			<input type="checkbox" name="lsaStates" value="MD" />Maryland <br />
			<input type="checkbox" name="lsaStates" value="MA" />Massachusetts <br />
			<input type="checkbox" name="lsaStates" value="MI" />Michigan <br />
			<input type="checkbox" name="lsaStates" value="MN" />Minnesota <br />
			<input type="checkbox" name="lsaStates" value="MS" />Mississippi <br />
			<input type="checkbox" name="lsaStates" value="MO" />Missouri <br />
			<input type="checkbox" name="lsaStates" value="MT" />Montana <br />
			<input type="checkbox" name="lsaStates" value="NE" />Nebraska <br />
			<input type="checkbox" name="lsaStates" value="NV" />Nevada <br />
			<input type="checkbox" name="lsaStates" value="NH" />New Hampshire <br />
			<input type="checkbox" name="lsaStates" value="NJ" />New Jersey <br />
			<input type="checkbox" name="lsaStates" value="NM" />New Mexico <br />
			<input type="checkbox" name="lsaStates" value="NY" />New York <br />
			<input type="checkbox" name="lsaStates" value="NC" />North Carolina <br />
			<input type="checkbox" name="lsaStates" value="ND" />North Dakota <br />
			<input type="checkbox" name="lsaStates" value="OH" />Ohio <br />
			<input type="checkbox" name="lsaStates" value="OK" />Oklahoma <br />
			<input type="checkbox" name="lsaStates" value="OR" />Oregon <br />
			<input type="checkbox" name="lsaStates" value="PA" />Pennsylvania <br />
			<input type="checkbox" name="lsaStates" value="RI" />Rhode Island <br />
			<input type="checkbox" name="lsaStates" value="SC" />South Carolina <br />
			<input type="checkbox" name="lsaStates" value="SD" />South Dakota <br />
			<input type="checkbox" name="lsaStates" value="TN" />Tennessee <br />
			<input type="checkbox" name="lsaStates" value="TX" />Texas <br />
			<input type="checkbox" name="lsaStates" value="UT" />Utah <br />
			<input type="checkbox" name="lsaStates" value="VT" />Vermont <br />
			<input type="checkbox" name="lsaStates" value="VA" />Virginia <br />
			<input type="checkbox" name="lsaStates" value="WA" />Washington <br />
			<input type="checkbox" name="lsaStates" value="WV" />West Virginia <br />
			<input type="checkbox" name="lsaStates" value="WI" />Wisconsin <br />
			<input type="checkbox" name="lsaStates" value="WY" />Wyoming
			</div>
			  
			 </li>
            
			<li class="list-group-item">Specific Outside of Continental United States (OCONUS). Select all that apply:<br>
			<!-- Pass value of Oconus area -->
			<input type="checkbox" name="oconusStates" value="ALASKA" />Alaska and Arctic Region <br />
			<input type="checkbox" name="oconusStates" value="CARIBBEAN" />Caribbean (Puerto Rico and US Virgin Islands) <br />
			<input type="checkbox" name="oconusStates" value="EMEA" />Europe, Africa and Middle East <br />
			<input type="checkbox" name="oconusStates" value="HAWAII" />Hawaii and Pacific Rim <br />

            <li class="list-group-item">
			
            <!-- Pass the Location: Global -->
			<input name="location" id="global" type="radio" value="GLOBAL">Global</li>
			
			<!-- Pass the socio economic indicators -->
			</ul></div>
			<div class="col-sm-6"><ul class="list-group">
            <li class="list-group-item"><strong>Socio Economic Indicators</strong></li>
			
            <li class="list-group-item">
			<label for=""  style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" value="SB" id="SB" data-ptag="sb1" class="check_box"></code>&nbsp;Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="womenBus" value="WOB" data-ptag="sb2" class="check_box"></code>&nbsp;Women Owned Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="womOSB" value="WOSB" data-ptag="sb3" class="check_box"></code>&nbsp;Women Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="Eco_DWOSB" value="EDWOSB" data-ptag="sb4" class="check_box"></code>&nbsp;Economically Disadvantaged Women Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="VetOSB" value="VOSB" data-ptag="sb5" class="check_box"></code>&nbsp;Veteran Owned Small Business</li></label>
			
            <li class="list-group-item">
			<label for="checkbox" style="font-weight:normal">
			<code style="background: none;">
			<input name="socioEconomicObjective" type="checkbox" id="SerDVOSB" value="SDVOSB" data-ptag="sb6" class="check_box"></code>&nbsp;Service Disabled Veteran Owned Small Business</li></label>
			
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" id="SBA_Certified" value="SBACSDB" data-ptag="sb7" class="check_box"></code>&nbsp;SBA Certified Small Disadvantaged Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" id="SBA_8" value="SBA8ACB" data-ptag="sb8" class="check_box"></code>&nbsp;SBA 8(a) Certified Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" value="SBCHSB" id="SBA_Cert" data-ptag="sb9" class="check_box"></code>&nbsp;SBA Certified HUBZone Small Business</li></label>
		   
           <li class="list-group-item">
		   <label for="checkbox" style="font-weight:normal">
		   <code style="background: none;">
		   <input name="socioEconomicObjective" type="checkbox" value="NOPREFERENCE" id="NoPref" data-ptag="sb10" class="check_box"></code>&nbsp;No Preference</li></label>
            
			<!-- Pass value of equipmentype -->
			<p><strong>Equipment Type</strong></p>
			<input type="checkbox" name="equipmentType" value="NEW" />New Laptop <br />
			<input type="checkbox" name="equipmentType" value="REFURBISHED" />Refurbished Laptop <br />
			<input type="checkbox" name="equipmentType" value="ANY" />Any Laptop <br />

          </ul></div>
        
          </div>
		  <!-- Submit the form, for now just display the results on the screen -->
		  <p><input class="btn btn-sm btn-success" type="submit" name="submit" value="Update Pricing"></p>
		  </div>
		  </div>
          <div class="col-xs-6 col-md-4">
         
           <div class="well">
           <h3><strong>Advice & Definitions</strong></h3>
                         <p id="sb1" class="p_element">Small Business - Privately owned corporations, Partnerships. or sole proprietrorships.  </p>
            <p id="sb2" class="p_element">Women Owned Business - Business which is majority owned by one or more female American citizens.  </p>
            <p id="sb3" class="p_element">Women Owned Small Business - Small Business which is majority owned by one or more female American citizens.  </p>
            <p id="sb4" class="p_element">Economically Disadvantage Women Owned Small Business - Small Business which is majority owned by one or more female American citizens who are economically disadvantaged.  </p>
            <p id="sb5" class="p_element">Veteran Owned Small Business - Small Business which is majority owned by one or more veterans.  </p>
            <p id="sb6" class="p_element">Service Disabled Veteran Owned Small Business - Small Business which is majority owned by one or more service disabled veterans.  </p>
            <p id="sb7" class="p_element">SBA Certified Small Disadvantaged Business - Government certified Small Business which is majority owned by disadvantaged persons.  </p>
            <p id="sb8" class="p_element">SBA 8 (a) Certified Business - Government certified Small Business which is majority owned by socially and economically disadvantaged individuals who are American citizens.   </p>
            <p id="sb9" class="p_element">SBA Certified HUBZONE Small Business - Government certified Small Business which is majority owned by disadvantaged persons in urban and rural communities .  </p>
            <p id="sb10" class="p_element">No Preference -  No preference on socio economic.  </p>
           
          </div>
          </div>  
		  </form><!-- END OF PROCESS FORM -->

<div style="border: 1px solid #000; width: 600px;">
		  <?php
		  print_r($resultsProcess);  
		  echo "<p>Contract Vehicles:</p>"; 

		  ?>
</div>

<!-- Initialize the plugin: -->
<script type="text/javascript">
$(document).ready(function() 
{
    $('.multiselect').multiselect
    ({
        maxHeight: 300
    });

});

$(document).ready(function() 
{
    $("#conusid").click(function(){
        $("#localserviceid").attr('checked',false);
        $("#worldid").attr('checked',false);
    });
  $("#localserviceid").click(function(){ 
      $("#conusid").attr('checked',false);
  });
       $("#worldid").click(function(){ 
      $("#conusid").attr('checked',false);
  });

   $("#stand , #stand1").click(function()
   { 
      $("#lap_spec").show(1000);
      $("#lite_wt").hide(1000);
      $("#perormance_spec").hide(1000);
   });
  
  
   $("#ltwt, #ltwt1").click(function()
   { 
      $("#lap_spec").hide(1000);
      $("#lite_wt").show(1000);
      $("#perormance_spec").hide(1000);
   });
   
   
    $("#perform, #perform1").click(function()
   { 
      $("#lap_spec").hide(1000);
      $("#lite_wt").hide(1000);
      $("#perormance_spec").show(1000);
   });


}); 
</script>

<code style="background: none;">
 <script>
$('.check_box').change(function()
{
    if($('.check_box:checked').length==0)
    {
        $('.p_element').show();
    }
    else
    {
    $('.p_element').hide();
        $('.check_box:checked').each(function()
        {
            $('#'+$(this).attr('data-ptag')).show();
        });
    }

});
</script>
</code>
 

Open in new window

0
Ray PaseurCommented:
Is that supposed to be working code?  It looks like the action script for a POST-method request, but without the POSTed data, it doesn't seem to work correctly.
http://iconoun.com/demo/temp_sandshakimi.php
0
sandshakimiAuthor Commented:
Well, the intent of my form was simply to get back the Object.

I figured once I have that, I can use it with a SQL query like so:

$qry = SELECT * FROM contract_vehicle  WHERE vehicle_name = $somevariable?

Didn't think that far, so I should be POSTing this to a new file, run-sql.php to run the above SQL?

I will still need to understand how to pass the selected contract vehicle.
0
sandshakimiAuthor Commented:
The form does return an Object, and it works on your link also.
0
Ray PaseurCommented:
I've deleted the copy of the script on my server since it was filling up the error logs every time someone used it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.