prepare("select REPLACE(REPLACE(lower(concat(i.year,'-',i.make,'-',i.model)),' ','-'),'+','') as checktitle, i.VIN, i.sold, i.md5val as cmd5val, i.type, i.category as vtype, p.photoname, i.options as optionslist, i.dealerComments as additionaltext, i.color, i.interiorcolor, i.stocknum, i.motor as engine, i.transmission, i.year, i.make, i.model, i.kms, i.oldprice as regprice, i.newprice as saleprice from inventory i left outer join inventory_photos p on p.md5val=i.md5val where i.id=:vid and (p.ismain=1 or p.ismain IS NULL) limit 1"); $sql->bindParam(':vid', $vID, PDO::PARAM_INT, 12); $sql->execute(); //check if input title is same as vehicle title. if not we redirect. //die('testing'); if($sql->rowCount()==0) { header('Location: /inventory'); exit; } $row = $sql->fetch(); if($checkTitle!==$row['checktitle']) { //die($checkTitle.'|'.$row['checktitle']); header('Location: /404.php'); exit; } $vstatus=$row['vstatus']; $vehicleName=$row['year'].' '.$row['make'].' '.$row['model']; $lastUpdated=$row['lastupdated']; $cmd5val=$row['cmd5val']; //if(!empty($row['vtype'])) $vehDetails.='Body Type'.$row['vtype'].''; /* if(!empty($row['vstatus'])) { if($row['vstatus']=='Sold') { $vehDetails.='StatusSOLD'; } else if($row['vstatus']=='Available') { $vehDetails.='Status'.$row['vstatus'].''; } else { $vehDetails.='Status'.$row['vstatus'].''; } } */ if($row['sold']==1) { $showStatus='SOLD'; } else { $showStatus='Available'; } $vehDetails.='Status'.$showStatus.''; $kilometers=$row['kms']; //for autoverify $year=trim($row['year']); $make=trim($row['make']); $model=trim($row['model']); $VIN=trim($row['VIN']); $isSold=$row['sold']; if(!empty($row['VIN'])) $vehDetails.='VIN'.$row['VIN'].''; if(!empty($row['color'])) $vehDetails.='Color'.$row['color'].''; if(!empty($row['interiorcolor'])) $vehDetails.='Interior'.$row['interiorcolor'].''; if(!empty($row['type'])) $vehDetails.='Type'.$row['type'].''; if(!empty($row['kms'])) $vehDetails.='KMs'.number_format($row['kms'],0).''; if(!empty($row['engine'])) $vehDetails.='Motor'.$row['engine'].''; if(!empty($row['stocknum'])) $vehDetails.='Stock #'.$row['stocknum'].''; if(!empty($row['transmission'])) $vehDetails.='Transmission'.$row['transmission'].''; if(!empty($row['year'])) $vehDetails.='Year'.$row['year'].''; if(!empty($row['make'])) $vehDetails.='Make'.$row['make'].''; if(!empty($row['model'])) $vehDetails.='Model'.$row['model'].''; if(!empty($row['paymentplan'])) $vehDetails.='Payment PlanYES'; $regPrice=$row['regprice']; $salePrice=$row['saleprice']; if($regPrice==$salePrice) { $vehPrice='$'.number_format($regPrice).''; $avPrice=$regPrice; } else if(!empty($regPrice) && !empty($salePrice)) { $avPrice=$salePrice; //if we have both $discountCost=$regPrice-$salePrice; $vehPrice='$'.number_format($regPrice).' $'.number_format($salePrice).' Save $'.number_format($discountCost,0).'! '; } else if(!empty($regPrice)) { $avPrice=$regPrice; //if we have both $vehPrice='$'.number_format($regPrice).''; } $vehOptionsText=$row['optionslist']; //break apart by newline if(!empty($vehOptionsText)) { $vehOptionsList=explode("\r\n",$vehOptionsText); foreach($vehOptionsList as $vehOption) { if(empty($vehOption)) $vehOption='--HR--'; $vehOptions.='
'.htmlentities($vehOption).'
'; } } $vehOptions=str_replace('--HR--','
',$vehOptions); $vehInfo=$row['additionaltext']; if(!empty($row['photoname'])) { $primaryImageName=$row['photoname']; $showPic=''.htmlentities($vehicleName).''; //now we get additional photos // $sql = $db->prepare("select * from inventory_photos where md5val=:cmd5val and ismain=0 order by id asc"); $sql->bindParam(':cmd5val', $cmd5val, PDO::PARAM_STR, 55); $sql->execute(); //print_r($sql->errorInfo()); $result = $sql->fetchAll(); $i=0; foreach($result as $row) { $i++; $showAdditionalPics.=''.htmlentities($vehicleName).' Photo '.$i.''; } //die($showAdditionalPics); } else { //uploads/image-not-available.png $showPic='Image Pending'; } //print_r($row); ?> -

Back
Upload Photos

Select one or more photos, and then click Attach Photos. If you select a new Primary Image, you will need to refresh the page before seeing it above.



prepare("select id, photoname, ismain from inventory_photos where md5val=:md5val order by ismain desc"); $sql->bindParam(':md5val', $cmd5val, PDO::PARAM_STR, 255); $sql->execute(); $result=$sql->fetchAll(); if($sql->rowCount()>0) { $count=0; foreach($result as $row) { $count++; $image_src=$row['photoname']; /* onclick="MakePrimary('','','')" */ ?>

delete




Schedule Test Drive
Apply for Financing

Vehicle Information
Dealer Comments
Features and Options