DBookatay

January 6, 2012

You'd want to define $surcharge above the if condition. You'll also want to change if ($surcharge) to if (!empty($surcharge)) to make sure there were actually item(s) added to the array.

I'm sorry, I am not understand this... If I do this:

$surcharge = array();
if (!empty($surcharge)){$surcharges = array_sum($surcharge);}
$extended = '$'.number_format(1380 + $surcharges);

none of the surchages get added...

January 6, 2012

You need to initialize $surcharge to an empty array at the start of each new car -
$surcharge = array();

Where? If I do this:

$surcharge = array();
if ($surcharge) {$surcharges = array_sum($surcharge);}
$extended = '$'.number_format(1380 + $surcharges);

it no longer calculates the surcharges, if I do this:

if ($surcharge) {$surcharges = array_sum($surcharge);}
$surcharge = array();
$extended = '$'.number_format(1380 + $surcharges);

I get the same problem as I posted.

January 6, 2012

I am making a price sheet for extended warranties that my company sells and am having a problem with the math.

There is a base price of $1380, plus certain surcharges and certain exclusions. The exclusions are working properly, but something funky is happening with the surcharges...

This link more clearly explains the problem I am having:

http://www.carcityofdanbury.com/New/01/Resources/printable_list_Admin.php

Here is the code, then I'll explain the problem

// TMU
if ($row['TMU'] == "x") {
$extended = 'N/A';

// Salvage Title
} elseif ($row['cleantitle'] != "x") {
$extended = 'N/A';

// 150,000+ miles
} elseif ($row['mileage'] > "150000") {
$extended = 'N/A';

// Snowplow
} elseif ($row['ftr003'] == "x") {
$extended = 'N/A';

// Category 3
} elseif ($row['make'] == "Jaguar" || $row['make'] == "Land Rover") {
$extended = 'N/A';

// 10+ cyls
} elseif ($row['engine_cylinders'] > "8") {
$extended = 'N/A';

// Older than 13 years
} elseif ($year < date("Y")-12) {
$extended = 'N/A';

// Qualifies for warranty
} else {

if ($row['mileage'] > "99999" && $row['mileage'] < "125000") {$surcharge[] = 200;}
if ($row['mileage'] > "125000" && $row['mileage'] < "150001") {$surcharge[] = 400;}
if ($row['drivetrain'] == "AWD" || $row['drivetrain'] == "4x4") {$surcharge[] = 150;}
if ($row['fuel'] == "Diesel") {$surcharge[] = 100;}
if ($row['make'] == "Audi" || $row['make'] == "BMW" || $row['make'] == "Cadillac" || $row['make'] == "Infiniti" || $row['make'] == "Lexus" || $row['make'] == "Lincoln" || $row['make'] == "Mercedes-Benz" || $row['make'] == "Mini" || $row['make'] == "Saab" || $row['make'] == "Volvo") {$surcharge[] = 550;}
if (date("Y")-11 == $year) {$surcharge[] = 50;}
if (date("Y")-12 == $year) {$surcharge[] = 100;} 
if (date("Y")-13 == $year) {$surcharge[] = 200;}

if ($surcharge) {$surcharges = array_sum($surcharge);}
$extended = '$'.number_format(1380 + $surcharges);

}

The 9th vehicle on the list: 08 Hyundai Sante Fe SE the warranty price is correct, but the vehicle after, the 08 Honda Accord EX should be 1,380, yet its adding the surcharges from the the Hyundai, and it keeps repeating down the list.

Where is the error?

December 28, 2011

If this don't solve your problem at lest it should point you in the right direction. Tell me how it works out for you OK?

<?php

$pictures = '';
$id = '7';  // <====  This is your product id
$pnum = 14;    // <==== This is the query returned number of pictures per the product

for($i = 1; $i < $pnum+1; $i++)
{
$picnum = $id.'_'.substr('000' . $i, -3).'.jpg';
$pictures .= '<img src="pictures/'.$picnum.'" width="200" alt="" />';
}
echo $pictures;  // <=== This shoud be your pictures

?>

This did the job, thanks!

December 28, 2011

I have 23 products in a db, all with a unique ID that Im creating a user site for. Some of the items have 1 or 2 images and others have as many as 30 images.

In my db I have a field called "pics". All the images are saved as a .jpg, according to their id on the server. So if item 1 has 10 images the files are: "1_001.jpg," "1_002.jpg," ect.

How do I create a script that will display the correct amount of images based on the number in the db.

I was going to do something like this:

if ($row['pics'] =="1") {
$pictures = '<img src="pictures/'.$id.'_001.jpg" width="200" alt="" />';
} elseif ($row['pics'] =="2") {
$pictures = '<img src="pictures/'.$id.'_001.jpg" width="200" alt="" /><img src="pictures/'.$id.'_002.jpg" width="200" alt="" />';
} elseif ($row['pics'] =="3") {
$pictures = '<img src="pictures/'.$id.'_001.jpg" width="200" alt="" /><img src="pictures/'.$id.'_002.jpg" width="200" alt="" /><img src="pictures/'.$id.'_003.jpg" width="200" alt="" />';
}

but that would just be retarded...

Thank you!

December 15, 2011

So... The person that agreed to do the job for me last month is now MIA.

Anyone else looking for work?

November 10, 2011

I am currently looking for a freelancer to help implement new features on our 2 websites: (The new layout) carcityofdanbury.com/New and the admin area login.carcityofdanbury.com.

[*]1st project:

Looking for an image upload/editor script (similar to Aurigma Image Uploader, or simply implementing Aurigma) that can upload pics of the vehicles, resize them into 2 or 3 different sizes (thumb, med, large) and display them on the 2 sites.

Screen cap of a site that uses what I want:

Our current page to add the script

[*]2nd project:

Looking to make the navigation panel on the left of this page: http://www.carcityofdanbury.com/New/?cat=01&do=Search&category=Foreign work correctly.

[*]3rd project:

By far the most intense... Create or implement a calendar for the service repairs of the service dept. Pulling sold or active vehicles and customer information from the database.

Looking for someone who has the ability to do these projects, knows PHP, MySQL and AJAX, will work directly with me (doing the things I

don't have the knowledge to do,) and is reasonably priced.

Money is an issue, I am willing to pay for the job, but we are also a struggling business that was hit very hard by the economy...

We have been in business since 1988 and have had a website since 1993. There are also several other projects that need to be completed, including sever features of the redesigned site (currently in progress: www.carcityofdanbury.com/New) as well as other sites that we plan on creating, as a way to attempt to draw more business.

Please email or PM me with estimated costs per project, or per hour and the number of hours for each project.

Brad Guy

brad-AT-carcityofdanbury.com

April 9, 2011

You'll want to look at array_sum, instead of implode(). Implode() forms a string . . .

Solved! Thanks!!!

April 7, 2011

I'm creating a script for warranty rates, and am having a problem with the "math" aspect of it.

Different factors (year/ mileage/ 4x4) determines the surcharges that has to be added to the base price: $1380.

Here is what I mean:

$base = 1380;
if ($class == "2") {$surcharge[] = 550;}
if ($row['mileage'] > "99999" && $row['mileage'] < "125000") {$surcharge[] = 200;}
if ($row['mileage'] > "125000" && $row['mileage'] < "150001") {$surcharge[] = 400;}
if ($row['drivetrain'] == "AWD" || $row['drivetrain'] == "4x4") {$surcharge[] = 150;}
if ($row['fuel'] == "Diesel") {$surcharge[] = 100;}

if ($row['year'] = date("Y")-11) {
$surcharge[] = 50;
} elseif ($row['year'] = date("Y")-12) {
$surcharge[] = 100;
} elseif ($row['year'] = date("Y")-13) {
$surcharge[] = 200;
}

if ($surcharge) {$surcharges = implode("+", $surcharge);}
$warr_Extended = $base + $surcharges;

The issue is that "$surcharges" is displaying like "200+100+50," instead of adding the values of the "surcharges", in this case 350.

Is there a better way that I should be doing this?

February 23, 2011

Are you looking for something like this: http://www.login.carcityofdanbury.com/passed/index2.php ?

The values for year, make, model, and trim are pulled from my dB.

If you are I can send the files over...

February 23, 2011

I have the following script which is attached to a <select> input, that updates a <div>

function getBody(yearId,makeId,modelId,trimId) {
var strURL="001/AJAX/Add/getBody.php?year="+yearId+"&make="+makeId+"&model="+modelId+"&trim="+trimId;
var req = getXMLHTTP();
if (req) {req.onreadystatechange = function() {if (req.readyState == 4) {if (req.status == 200) {document.getElementById('bodyHldr').innerHTML=req.responseText;}}}
	req.open("GET", strURL, true);
	req.send(null);
}
}

How do I make it so that when the script gets executed it loads 2 different pages into 2 different divs?

"001/AJAX/Add/getBody.php?" loads into "bodyHldr" and "001/AJAX/Add/getEngine.php?" loads into "engineHldr"

February 20, 2011

	function selfURL() {
	$s = empty($_SERVER["HTTPS"]) ? ''
		: ($_SERVER["HTTPS"] == "on") ? "s"
		: "";
	$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
	$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
		: (":".$_SERVER["SERVER_PORT"]); return $protocol."://".$_SERVER['SERVER_NAME'].$port.$_SERVER['REQUEST_URI']; } function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); 
}
$thisPage = (selfURL());

February 20, 2011

@PFMaBiSmAd - This works perfect... SOOOOOOOO much less code to write.

Thanks!

February 20, 2011

Forget using a switch statement here. Put all the states into an array, then do something like
<?php
foreach ($states as $state) {
$selected = ($row['pri_add4']  == $state)?'selected="selected"':'';
echo "<option value='$state' $selected>$state</option>\n";
}
?>
Ken

Will this also give the user the option to change states, if the incorrect value was first inserted, or will this only display the state that was selected?

February 20, 2011

As the title says, I'm looking for a better way to create a switch statement on an "edit" form.

Since there are 3 of the same types of <selects>, all using the values of US states. Billing state, shipping state, drivers license state.

Currently I am using this:

	switch($row['pri_add4']){
		case 'AK': $pri_add4 = '<option value="AK" selected="selected">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'AL': $pri_add4 = '<option value="AK">AK</option><option value="AL" selected="selected">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'AR': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR" selected="selected">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'AZ': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ" selected="selected">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'CA': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA" selected="selected">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'CO': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO" selected="selected">CO</option><option value="CT">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'CT': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT" selected="selected">CT</option><option value="DC">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;
		case 'DC': $pri_add4 = '<option value="AK">AK</option><option value="AL">AL</option><option value="AR">AR</option><option value="AZ">AZ</option><option value="CA">CA</option><option value="CO">CO</option><option value="CT">CT</option><option value="DC" selected="selected">DC</option><option value="DE">DE</option><option value="FL">FL</option><option value="GA">GA</option><option value="HI">HI</option><option value="IA">IA</option><option value="ID">ID</option><option value="IL">IL</option><option value="IN">IN</option><option value="KS">KS</option><option value="KY">KY</option><option value="LA">LA</option><option value="MA">MA</option><option value="MD">MD</option><option value="ME">ME</option><option value="MI">MI</option><option value="MN">MN</option><option value="MO">MO</option><option value="MS">MS</option><option value="MT">MT</option><option value="NC">NC</option><option value="ND">ND</option><option value="NE">NE</option><option value="NH">NH</option><option value="NJ">NJ</option><option value="NM">NM</option><option value="NV">NV</option><option value="NY">NY</option><option value="OH">OH</option><option value="OK">OK</option><option value="OR">OR</option><option value="PA">PA</option><option value="RI">RI</option><option value="SC">SC</option><option value="SD">SD</option><option value="TN">TN</option><option value="TX">TX</option><option value="UT">UT</option><option value="VA">VA</option><option value="VT">VT</option><option value="WA">WA</option><option value="WI">WI</option><option value="WV">WV</option><option value="WY">WY</option>'; break;

	}

NOTE: I had to remove a lot of the state options so the post wouldn't exceed the 40000 characters limit.

February 5, 2011

Before the loop, if the $_GET var is empty, assign 2011 to it.
if( empty($_GET['date']) ) {
     $_GET['date'] = 2011;
}

Wow that easy hunh? Thanks!

February 5, 2011

I have a script that pulls data from my dB based on the year selected from 2006 - 2011, and if no year is selected it automatically loads the current year, 2011.

I have a css that changes the design of the "tab" based on the year selected, but how do I make it so that the "On" style reflects the current year tab if no year is selected?

Confused yet? I created an image of what I mean as well as the php script.


if ($_GET['date']) {$year = ($_GET['date']);} else {$year = date("Y");}

$query = "select DISTINCT YEAR(sold_date) AS `sold_date` FROM Sold WHERE sold_date ORDER BY sold_date DESC";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){

$year = $row['sold_date'];

if ($_GET['date'] == $year) {
	$class = "On";
} elseif ($_GET['date'] != $year) {
	$class = "";
}

$miniNav .= '<a class="'.$class.'" href="index.php?date='.$year.'">'.$year.'</a>';
}

[attachment deleted by admin]

February 3, 2011

Anyone?

February 3, 2011

I'm using IE9 beta and FF 3.6.3 and was not getting any errors on my pc.

I used a different pc with IE 7 and got the following error:

Message: Object expected

Line: 131

Char: 1

Code: 0

URI: http://www.login.carcityofdanbury.com/passed/index.php?category=001&display=Sold&stock=17561

Line 131 is: <select name="dealType" class="select-content" onchange="getFile(this.value)">

February 2, 2011

I replaced my "getFile" function with yours and nothing is happening either...

February 2, 2011

// the javascript needs to be able to get the result

echo $bank;

I though we were on to something here, and got super excited when I saw your post.... but no dice.

I added your echo statement and am still in the same boat.

February 2, 2011

As the title say, I can not for the life of me get the "$bank" content to display, no matter HOW much I try...

Does anyone see any errors. I am sooooooo wiped out at this!

main page

<?
$body = '

		<script type="text/javascript" src="change-content.js"></script>

		<div id="addSold">
		<form action="'.$_SERVER['REQUEST_URI'].'" method="post" name="form" autocomplete="off">

			<fieldset id="Vehicle">
				<legend>Vehicle</legend>
				<ul>
					<li><label for="Year">Year</label>'.$Year.'</li>
					<li><label for="Make">Make</label>'.$Make.'</li>
					<li><label for="Model">Model</label>'.$Model.'</li>
					<li><label for="Trim">Trim</label><input type="text" name="Trim" id="Trim" size="10" value="'.$trim.'" disabled="disabled"></li>
				</ul>
				<ul>
					<li><label for="Mileage">Mileage</label><input type="text" name="Mileage" id="Mileage" size="5" maxlength="6" value="'.$row['mileage'].'"></li>
					<li><label for="VIN">VIN</label><input type="text" name="VIN" id="VIN" size="23" maxlength="17" value="'.$row['vin'].'" disabled="disabled"></li>
					<li><label for="Color">Color</label>'.$Exterior.'</li>
				</ul>
			</fieldset>

			<fieldset id="Deal">
				<legend>Deal</legend>
				<ul>
					<li>
						<label for="soldDte1">Date</label>
						<input type="text" name="soldDte1" id="soldDte1" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="08"> / 
						<input type="text" name="soldDte2" id="soldDte2" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="30"> / 
						<input type="text" name="soldDte3" id="soldDte3" size="1" maxlength="2" value="'.$year.'">
						<a href="#"><img id="date_'.$row[stock].'" src="images/Icons/dateOff.png" onfocus="this.select();lcs(this)" onmouseover="MM_swapImage(\'date_'.$row[stock].'\',\'\',\'images/Icons/dateOn.png\',1)" onmouseout="MM_swapImgRestore()" alt="Choose Date"></a>
					</li>
					<li>
						<label for="salesman">Salesman</label> 
						<select name="salesman" id="salesman">
							<option></option>
							'.$salesmen.'
						</select>
					</li>
				</ul>
				<ul>
					<li>
						<label for="dealType">Deal Type</label>
						<select name="dealType" class="select-content" onchange="getFile(this.value)">
							<option></option>
							<option value="AL">Auto Loan</option>
							<option value="Cash">Cash</option>
							<option value="CAC">Credit Acceptance</option>
							<option value="IH">In House</option>
							<option value="SAL">Sensible Auto</option>
						</select>
					</li>
					<li>
						<label for="tradeDrop">Trade</label> 
						<select name="tradein" id="tradeDrop" onchange="show_hide_trade(this.value);">
							<option value="No">No</option>
							<option value="Yes">Yes</option>
						</select>
					</li>
				</ul>
			</fieldset>

			<div id="Bank" class="view">'.$bank.'</div>
		</form>
		</div>
	';
?>

get_Bank.php

<?
if ($_GET['dealType'] == "AL") {
	$bank = '
		<fieldset id="AL">
			<legend>Auto Loan Figures</legend>
			<ul>
				<li><label for="price">Price</label><input type="text" name="price" id="price" class="price" size="7" onchange="currency(this)"></li>
				<li><label for="down">Down</label><input type="text" name="down" id="down" class="price" size="6" onchange="currency(this)"></li>
				<li><label for="tax">Tax</label><input type="text" name="tax" id="tax" class="price" size="6" onchange="currency(this)"></li>
				<li><label for="reg">Plates</label><input type="text" name="reg" id="reg" class="price" size="4" onchange="currency(this)"></li>
				<li><label for="gap">Gap</label><input type="text" name="gap" id="gap" class="price" size="4" onchange="currency(this)"></li>
			</ul>
			<ul>
				<li>
					<label for="pymtNum">--------------- Payment ---------------</label>
					<input type="text" name="pymtNum" id="pymtNum" size="3" maxlength="3" onkeyup="return autoTab(this, 3, event)"> @ 
					<input type="text" name="pymtAmnt" id="pymtAmnt" class="price" size="5" onchange="currency(this)"> per 
					<select name="pymtType">
						<option value="Weekly" selected="selected">Week</option>
						<option value="Monthly">Month</option>
					</select>
				</li>
				<li><label for="APR">APR</label><input type="text" name="APR" id="APR" class="rate" size="6" value="19.00"></li>
			</ul>
		</fieldset>
	';
} elseif ($_GET['dealType'] == "CAC") {
	$bank = '
		Credit Acceptance stuff goes here
	';
} else {
	$bank = 'You must choose a bank before continuing';
}

?>

change-content.js

window.onload = init;

// finds all <select> tags will class="select-content" and activates function
function init() {
var sel = document.getElementsByTagName("select");
for (var i=0; i<sel.length; i++){
	if (sel[i].className == "select-content") {
		sel[i].onchange = getFile;
	}
	sel[i].selectedIndex = 0;	
}
}

function getFile (url) {
var url = "AJAX/get_Bank.php?dealType="+ this.value;
if (window.XMLHttpRequest) {xmlhttp=new XMLHttpRequest();}
else {xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}

xmlhttp.open("GET",url,false);
xmlhttp.send();

// a loop that looks through all <div>s on the page
// and then replaces the id with the value and gets that file
var divs = document.getElementsByTagName("div");
for (var i=0; i<divs.length; i++) {
	if(divs[i].id == "bank") {
		divs[i].id = this.value;
		divs[i].innerHTML=xmlhttp.responseText;
	}
}
}

January 29, 2011

I am trying to add a 4th <select></select> to Roshan's Triple Ajax dropdown script, based on "year", "make", "model" and "trim" of a vehicle, but can not get the "trim" options to correctly pull from the dB.

Does anyone see anything that is preventing this?

Index.php

<html>
<head>
<title>Roshan's Triple Ajax dropdown code</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<script language="javascript" type="text/javascript">
function getXMLHTTP() {
	var xmlhttp=false;	
	try{
		xmlhttp=new XMLHttpRequest();
	}
	catch(e)	{		
		try{			
			xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
		}
		catch(e){
			try{
			xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
			}
			catch(e1){
				xmlhttp=false;
			}
		}
	}
	return xmlhttp;
    }

// Get Make
function getMake(yearId) {		
	var strURL="get_Make.php?year="+yearId;
	var req = getXMLHTTP();
	if (req) {
		req.onreadystatechange = function() {
			if (req.readyState == 4) {
				if (req.status == 200) {						
					document.getElementById('make_div').innerHTML=req.responseText;						
				} else {
					alert("There was a problem while using XMLHTTP:\n" + req.statusText);
				}
			}				
		}			
		req.open("GET", strURL, true);
		req.send(null);
	}		
}

// Get Model
function getModel(yearId,makeId) {		
	var strURL="get_Model.php?year="+yearId+"&make="+makeId;
	var req = getXMLHTTP();
	if (req) {
		req.onreadystatechange = function() {
			if (req.readyState == 4) {
				if (req.status == 200) {						
					document.getElementById('model_div').innerHTML=req.responseText;						
				} else {
					alert("There was a problem while using XMLHTTP:\n" + req.statusText);
				}
			}				
		}			
		req.open("GET", strURL, true);
		req.send(null);
	}
}

// Get Trim
function getTrim(yearId,makeId,modelId) {
	var strURL="get_Trim.php?year="+yearId+"&make="+makeId+"&model="+modelId;
	var req = getXMLHTTP();
	if (req) {
		req.onreadystatechange = function() {
			if (req.readyState == 4) {
				if (req.status == 200) {						
					document.getElementById('trim_div').innerHTML=req.responseText;						
				} else {
					alert("There was a problem while using XMLHTTP:\n" + req.statusText);
				}
			}				
		}			
		req.open("GET", strURL, true);
		req.send(null);
	}
}
</script>

<?
include_once ('include/page_files/mysql_connect.php');

// Get Years
$query = "SELECT DISTINCT year FROM vehicle_Data order by year DESC";
$result = mysql_query($query); 
$numrows = mysql_num_rows($result);
for($x = 0; $row = mysql_fetch_array($result); $x++) {
	$years .= '<option value="'.$row['year'].'">'.$row['year'].'</option>';
}

// Insert Into Database
if ($_POST['edit']){
	$year = $_POST['year'];
	$make = $_POST['make'];
	$model = $_POST['model'];
	$purchased = substr($_POST['purchased'], 6).'-'.substr($_POST['purchased'], 0, 2).'-'.substr($_POST['purchased'], 3, 2);

	mysql_query("INSERT INTO test_Inventory (
		year, make, model, purchased
	) VALUES (
		'$year', '$make', '$model', '$purchased'
	)") or die(mysql_error()); header('Location:'.$_SERVER['REQUEST_URI'].'');
}

?>
</head>

<body>

<form action="<? echo $_SERVER['REQUEST_URI'] ?>" method="post" name="form" autocomplete="off">

<select name="year" onchange="getMake(this.value)">
	<option></option>
	<? echo $years ?>
</select>
<div id="make_div"><select name="make" disabled="disabled" style="width:100px"></select></div>
<div id="model_div"><select name="model" disabled="disabled" style="width:100px"></select></div>
<div id="trim_div"><select name="trim" disabled="disabled" style="width:100px"></select></div>
<input type="text" name="purchased" id="purchased">
<input type="submit" id="frmBtnOff" value="Update Profile" name="edit">

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

get_Make.php

<?
include_once ('include/page_files/mysql_connect.php');

$year = $_GET['year'];

$query="SELECT DISTINCT make FROM vehicle_Data WHERE year = '$year'";
$result=mysql_query($query);
?>

<select name="make" onchange="getModel(<?=$year?>,this.value)" style="width:100px">
<? while($row=mysql_fetch_array($result)) { ?>
<option value=<?=$row['make']?>><?=$row['make']?></option>
<? } ?>
</select>

get_Model.php

<?
include_once ('include/page_files/mysql_connect.php');

$year = $_GET['year'];
$make = $_GET['make'];

$query = "SELECT DISTINCT model FROM vehicle_Data WHERE year='$year' AND make ='$make' order by model DESC";
$result = mysql_query($query); 
$numrows = mysql_num_rows($result);
for($x = 0; $row = mysql_fetch_array($result); $x++) {
	$models .= '<option value="'.$row['model'].'">'.$row['model'].'</option>';
}

?>

<select name="model" id="model" onchange="getTrim(<?=$model?>,this.value)" style="width:100px">
<? echo $models ?>
</select>

get_Trim.php

<?
include_once ('include/page_files/mysql_connect.php');

$year = $_GET['year'];
$make = $_GET['make'];
$model = $_GET['model'];

$query = "SELECT DISTINCT trim FROM vehicle_Data WHERE year='$year' AND make='$make' AND model='$model'";
$result = mysql_query($query); 
$numrows = mysql_num_rows($result);
for($x = 0; $row = mysql_fetch_array($result); $x++) {
	$trims .= '<option value="'.$row['trim'].'">'.$row['trim'].'</option>';
}


?>

<select name="trim" id="trim">
<? echo $trims ?>
</select>

I've been screwing around with this as my 1st real ajax venture and after 3 hours I am officially stumped...

Any help would GREATLY be appreciated.

Thanks,

Brad

January 20, 2011

What would you do if the persons name was OBrien or McCarthy?

January 19, 2011

Anyone?

Sign In

DBookatay

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by DBookatay

Help with an "array_sum" not adding correctly

Help with an "array_sum" not adding correctly

Help with an "array_sum" not adding correctly

Help with an image script

Help with an image script

Looking for freelancer for numerious projects

Looking for freelancer for numerious projects

Help with "implode"

Help with "implode"

Trying to duplicate an ajax function - stuck!

How do you change 2 ID's with one script

get current page name as displayed in URL

Looking for a better way to make a "switch" statement

Looking for a better way to make a "switch" statement

Looking for a better way to make a "switch" statement

Help with nav tabs and css

Help with nav tabs and css

Problem getting Ajax value to pass... Is it a php error or an Ajax error

Problem getting Ajax value to pass... Is it a php error or an Ajax error

Problem getting Ajax value to pass... Is it a php error or an Ajax error

Problem getting Ajax value to pass... Is it a php error or an Ajax error

Problem getting Ajax value to pass... Is it a php error or an Ajax error

Can make 3 of 4 <select> reload... but not the 4th

ucwords not working

Can not figure out this DATE query

Browse

Activity

Important Information