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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is the existing Contract Vehicles table.
ASKER
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.
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);ASKER
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.
But on production it will be a user form.
I'm confused. The SOAP call returns data that looks like ITCommodityProgram but there is nothing that matches that in the contract vehicles table.
ASKER
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.
I'm developing out the PHP faster then the team on the db is doing their stuff.
ASKER
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.
But on the form, it may return nothing, one or all four.
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.
You know what they say, walking on water and writing to a specification is easy, as long as they are frozen.
ASKER
This form has the SOAP call in it. If run, you will get the Object back.
ASKER
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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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>ASKER
Sorry, I goofed again.
Here's the PHP form.
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> 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> 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> 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> 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> 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> 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> 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> 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> 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> 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>
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
http://iconoun.com/demo/temp_sandshakimi.php
ASKER
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.
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.
ASKER
The form does return an Object, and it works on your link also.
I've deleted the copy of the script on my server since it was filling up the error logs every time someone used it.
ASKER
So for example, newyorkcom, has a contract_vehicle ID of 3, but it's in [2] in the array.