| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Feb | ||||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | ||||||
pay
add_cart_rent.php:
<?
include_once “currency.php”;
$cur_enc=new curr;
if(isset($_POST['adddb']))
{
include_once “sale_rent_process.php”;
}
?>
<form action=”<? echo $_SERVER['PHP_SELF']; ?>” method=”post” name=”addrentfrm” >
<br>
<table width=”100%” border=”0″ cellpadding=”3″ cellspacing=”0″>
<tr>
<td width=”40%” height=”48″> <div align=”right” class=”stylereq”><strong>Country Name</strong></div></td>
<td width=”60%”><div align=”left”> <select name=”country_name” onchange=”document.addrentfrm.submit()” class=”stylereq”>
<option>select</option>
<? unset($_POST['adddb']);
$cnt=$_POST['country_name'];
$res=mysql_query(“select country from $table_name[4]“);
while($row=mysql_fetch_array($res))
{
echo $row[0];
$str.=”<option value=\”$row[0]\”>”.$row[0].”</option>”;
}
$str=ereg_replace(“value=\”$cnt\”",”value=\”$cnt\” selected”,$str);
echo $str;
?>
</select>
</div> </td>
</tr>
<tr>
<td height=”65″><div align=”right” class=”stylereq”><strong>State/County</strong></div></td>
<td><div align=”left”>
<? $sta=($_POST['country_name']) ? $_POST['state_name1'] :”Select”;
if($sta!=’Others’) {
//$sta=$_POST['state_name1'];
?>
<select name=”state_name1″ onChange=”document.addrentfrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$sta=($_POST['state_name1']) ? $_POST['state_name1'] : “select”;
$cn_res=mysql_query(“select id from $table_name[4] where country=’$cnt’”);
$coid=@mysql_result($cn_res,0,0);
$query1=”select state from $table_name[5] where cid=$coid”;
$res1=mysql_query($query1);
//echo mysql_error();
//if(($no_rows1=mysql_num_rows($res1))>0)
//{
//$str1.=”<option=\”select\”>select</option>”;
while($row31=mysql_fetch_array($res1))
{
$str31.=”<option value=\”$row31[0]\”>”.$row31[0].”</option>”;
}
//}
$str31.=”<option value=\”Others\”>Others</option>”;
$str31=ereg_replace(“value=\”$sta\”",”value=\”$sta\” selected”,$str31);
echo $str31;
?>
</select>
<br><span class=”style5″>(If State not in the list,Please Select Others)</span><strong><br><? } ?>
<? if($sta==’Others’) { ?>
<input name=”state_name1″ type=”text” id=”state_name1″>
</strong><br><span class=”style5″>Enter the State</span>
</div></td>
</tr><? } ?>
<tr>
<td height=”30″><div align=”right” class=”stylereq”><strong>City Name</strong></div></td>
<td><div align=”left”>
<? $city1=$_POST['city_name1'];
if($sta!=’Others’) { if($city1!=’Others’) {?>
<select name=”city_name1″ onChange=”document.addrentfrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$st_res=mysql_query(“select id from $table_name[5] where state=’$sta’”);
$stid=@mysql_result($st_res,0,0);
$query3=”select city from $table_name[6] where sid=$stid and cid=$coid”;
$city1=$_POST['city_name1'];
$res2=mysql_query($query3);
while($row32=mysql_fetch_array($res2))
{
$str32.=”<option value=\”$row32[0]\”>”.$row32[0].”</option>”;
}
$str32.=”<option value=\”Others\”>Others</option>”;
$str32=ereg_replace(“value=\”$city1\”",”value=\”$city1\” selected”,$str32);
echo $str32;
?>
</select>
<br><span class=”style5″>(If City not in the list,Please Select Others)</span><br>
<strong>
<? } } ?>
<? if(($sta==’Others’) or ($city1==’Others’)) { ?>
<input name=”city_name1″ type=”text” id=”city_name”>
</strong><br><span class=”style5″>Enter the City</span>
</div></td>
</tr>
<? } ?>
<tr>
<td height=”85″><div align=”right” class=”stylereq”><strong>Area</strong></div></td>
<td><div align=”left”>
<? $area=$_POST['area_name1'];
if($sta!=’Others’) { if($city1!=’Others’) { if($area!=’Others’) {?>
<select name=”area_name1″ onChange=”document.addrentfrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$cit_res=mysql_query(“select id from $table_name[6] where city=’$city1′”);
$citid=@mysql_result($cit_res,0,0);
$query4=”select area from $table_name[7] where ctid=$citid and sid=$stid and cid=$coid”;
$area=$_POST['area_name1'];
$res3=mysql_query($query4);
while($row34=mysql_fetch_array($res3))
{
$str34.=”<option value=\”$row34[0]\”>”.$row34[0].”</option>”;
}
$str34.=”<option value=\”Others\”>Others</option>”;
$str34=ereg_replace(“value=\”$area\”",”value=\”$area\” selected”,$str34);
echo $str34;
?>
</select>
<strong></strong><br>
<span class=”style5″>(If Area not in the list,Please Select Others)</span><strong>
<br><? } } }?>
<? if(($sta==’Others’) or ($city1==’Others’) or ($area==’Others’)) { ?>
<input name=”area_name1″ type=”text” id=”area_name”>
</strong><br>
<span class=”style5″>Describe the area</span><strong></td>
</tr>
<? } ?>
<tr>
<td height=”44″> <div align=”right” class=”stylereq”><strong>Building Number </strong></div></td>
<td><strong> </strong><strong>
<input name=”unit_num” type=”text” id=”unit_num2″>
</strong></td>
</tr>
<tr>
<td height=”40″><div align=”right” class=”stylereq”><strong>Street Name</strong></div></td>
<td><div align=”left”><strong>
<input name=”address” type=”text” id=”address”>
</strong></div></td>
</tr>
<tr>
<td rowspan=”2″><div align=”right” class=”stylereq”><strong>Write A Brief Description</strong></div></td>
<td bordercolor=”#FF0000″><p align=”left”>
<textarea name=”spot_detail” cols=”35″ rows=”5″ id=”textarea” class=”stylereq”></textarea>
</p> </td>
</tr>
<tr>
<td bordercolor=”#FF0000″><span class=”style5″>(Maximum 200 Chars)</span></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Is this Car Parking Space undercover? <span class=”style5″>(Yes/No)</span></strong></div></td>
<td><label>
<input name=”undercover” type=”radio” value=”Undercover” checked>
<span class=”stylereq”>Yes</span></label>
<label>
<input name=”undercover” type=”radio” value=”x”>
<span class=”stylereq”>NO </span></label></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Is this Car Parking Space in a secure garage?<span class=”style5″> (Yes/No)</span></strong></div></td>
<td><label>
<input name=”secure” type=”radio” value=”Secure Garage” checked>
<span class=”stylereq”>Yes</span></label>
<label>
<input type=”radio” name=”secure” value=”x”>
<span class=”stylereq”>NO</span> </label></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Does this Car Parking Space offer 24 hour access?<span class=”style5″> (Yes/No)</span></strong></div></td>
<td>
<div align=”left”>
<label>
<input name=”access” type=”radio” value=”24 Hour Access” checked>
<span class=”stylereq”>Yes</span></label>
<label>
<input type=”radio” name=”access” value=”x”>
<span class=”stylereq”>NO </span></label>
</div></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Price per week</strong></div></td>
<td><div align=”left”>
<input name=”price_week” type=”text” id=”price_week” class=”stylereq”>
<strong><span class=”stylereq”><? $cur_enc->currency($cnt); ?>
</span></strong></div></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Deposit </strong></div></td>
<td><div align=”left”>
<input name=”bond_amt” type=”text” id=”bond_amt” class=”stylereq”>
<strong><span class=”stylereq”> <? $cur_enc->currency($cnt); ?>
</span></strong></div></td>
</tr>
<tr>
<td><div align=”right” class=”stylereq”><strong>Preferred contact methods<br>
<span class=”style5″>(Tick Phone or Email)</span></strong></div></td>
<td><p align=”left”>
<input name=”phone_ch” type=”checkbox” id=”phone_ch” value=”1″>
<span class=”stylereq”>Phone</span>
<input name=”email_ch” type=”checkbox” id=”email_ch” value=”1″>
<span class=”stylereq”> Email</span> </p>
</td>
</tr>
<tr>
<td><div align=”right”></div></td>
<td>
<div align=”left”>
<input name=”adddb” type=”submit” id=”adddb” value=”Submit” onClick=”<? echo $_SERVER['PHP_SELF'];?>”>
<input name=”reset” type=”reset” id=”reset” value=”Reset”>
</div></td>
</tr>
</table>
<p> </p>
</form>
add_carspot_sale.php:
<?
include_once “currency.php”;
$cur_enc=new curr;
?>
<form action=”" method=”post” name=”addsalefrm” >
<br>
<table width=”100%” border=”0″ cellpadding=”5″ cellspacing=”0″>
<tr>
<td width=”41%”> <div align=”right”><strong> <span class=”stylereq”>Country Name</span></strong></div></td>
<td width=”59%”><div align=”left”>
<select name=”country_name” id=”country_name” onChange=”document.addsalefrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$cnt=$_POST['country_name'];
$res=mysql_query(“select country from $table_name[4] “);
while($row=mysql_fetch_array($res))
{
$str.=”<option value=\”$row[0]\”>”.$row[0].”</option>”;
}
$str=ereg_replace(“value=\”$cnt\”",”value=\”$cnt\” selected”,$str);
echo $str;
?>
</select>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>State/County</span>
</strong></div></td>
<td>
<br><? $state=($_POST['country_name']) ? $_POST['state_name1'] : “select”;
if(($state!=’Others’)){ ?>
<select name=”state_name1″ id=”state_name” onChange=”document.addsalefrm.submit()” class=”stylereq”>
<option>select</option>
<?
$state=($_POST['state_name1']) ? $_POST['state_name1'] : “select”;
//$state=$_POST['state_name1'];
//if(!empty($_POST['country_name'])) { $state=”"; }
$cn_res=mysql_query(“select id from $table_name[4] where country=’$cnt’”);
$coid=@mysql_result($cn_res,0,0);
$query1=”select state from $table_name[5] where cid=$coid”;
$res2=mysql_query($query1);
// $str2.=”<option value=\”select\”>Select</option>”;
while($row42=mysql_fetch_array($res2))
{
$str42.=”<option value=\”$row42[0]\”>”.$row42[0].”</option>”;
}
$str42.=”<option value=\”Others\”>Others</option>”;
$str42=ereg_replace(“value=\”$state\”",”value=\”$state\” selected”,$str42);
echo $str42;
?>
</select><br>
<span class=”style5″>(If State not in the list,Please Select Others)</span>
<br><strong>
<? } ?>
<? if($state==’Others’ ) { ?>
<input name=”state_name1″ type=”text” id=”state_name4″ class=”stylereq” >
</strong><br><span class=”style5″>Enter the State name</span></td>
</tr>
<? } ?>
<tr>
<td height=”53″><div align=”right”><strong><span class=”stylereq”>City Name</span>
</strong></div></td>
<td><p>
<br><? $city1=$_POST['city_name1'];
if($state!=’Others’) { if($city1!=’Others’) { ?>
<select name=”city_name1″ id=”select2″ onChange=”document.addsalefrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$st_res=mysql_query(“select id from $table_name[5] where state=’$state’”);
$stid=@mysql_result($st_res,0,0);
$query3=”select city from $table_name[6] where sid=$stid and cid=$coid”;
$_SESSION['city2']=$_POST['city_name1'];
$city1=$_POST['city_name1'];
$res3=mysql_query($query3);
while($row43=mysql_fetch_array($res3))
{
$str43.=”<option value=\”$row43[0]\”>”.$row43[0].”</option>”;
}
$str43.=”<option value=\”Others\”>Others</option>”;
$str43=ereg_replace(“value=\”$city1\”",”value=\”$city1\” selected”,$str43);
echo $str43;
?>
</select>
</strong><br><span class=”style5″>(If City not in the list,Please Select Others)<br></span><strong>
<? } } ?>
<? if(($state==’Others’) or ($city1==’Others’)) { ?>
<input name=”city_name1″ type=”text” id=”city_name3″>
</strong><br>
<span class=”style5″>Enter the City Name </span></p>
</td>
</tr>
<? } ?>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Area</span></strong></div></td>
<td>
<br><? $area=$_POST['area_name1']; if($state!=’Others’){ if($city1!=’Others’) { if ($area!=’Others’) { ?>
<select name=”area_name1″ id=”area_name” onChange=”document.addsalefrm.submit()” class=”stylereq”>
<option>Select</option>
<?
$cit_res=mysql_query(“select id from $table_name[6] where city=’$city1′”);
$citid=@mysql_result($cit_res,0,0);
$query4=”select area from $table_name[7] where ctid=$citid and sid=$stid and cid=$coid”;
$area=$_POST['area_name1'];
$res4=mysql_query($query4);
while($row44=mysql_fetch_array($res4))
{
$str44.=”<option value=\”$row44[0]\”>”.$row44[0].”</option>”;
}
$str44.=”<option value=\”Others\”>Others</option>”;
$str44=ereg_replace(“value=\”$area\”",”value=\”$area\” selected”,$str44);
echo $str44;
?>
</select>
<div align=”justify” class=”style5″>(If Area not in the list,Please Select Others)</div>
<strong>
<? } }}?>
<? if (($state==’Others’) or ($city1==’Others’) or($area==’Others’)) { ?>
<input name=”area_name1″ type=”text” id=”area_name5″>
</strong>
<span class=”style5″>Describe the area</span><strong></td>
</tr>
<? } ?>
<tr>
<td><div align=”right”></div></td>
<td rowspan=”2″><div align=”left”>
<br><input name=”unit_num” type=”text” id=”unit_num2″ class=”stylereq” >
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Building Number </span> </strong></div></td>
</tr>
<tr>
<td><div align=”right”></div></td>
<td rowspan=”2″><div align=”left”>
<br><input name=”address” type=”text” id=”address” class=”stylereq”>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Street Name</span></strong></div></td>
</tr>
<tr>
<td><p align=”right”> </p></td>
<td rowspan=”4″>
<div align=”left”>
<p>
<textarea name=”spot_detail” cols=”35″ rows=”5″ id=”textarea” class=”stylereq”></textarea>
<br><span class=”style5″>(Maximum 200 Characters)</span> </p>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Write A Brief Description</span> </strong></div></td>
</tr>
<tr>
<td><div align=”right”></div></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Is this Car Parking Space underco ver?<span class=”style5″> (Yes/No)</span></span></strong></div></td>
<td>
<div align=”left”>
<label>
<input name=”undercover” type=”radio” value=”Undercover” checked>
<span class=”stylereq”> Yes</span> </label>
<label>
<input name=”undercover” type=”radio” value=”x”>
<span class=”stylereq”> NO</span> </label>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Is this Car Parking Space in a secure garage?<span class=”style5″> (Yes/No)</span>
</span>
</strong></div></td>
<td>
<div align=”left”>
<label>
<input name=”secure” type=”radio” value=”Secure Garage” checked>
<span class=”stylereq”> Yes</span></label>
<label>
<input type=”radio” name=”secure” value=”x”>
<span class=”stylereq”> NO</span></label>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong>
<label><span class=”stylereq”>Does this Car Parking Space offer 24 hour access?<span class=”style5″> (Yes/No)</span></span></label>
</strong></div></td>
<td>
<div align=”left”>
<label>
<input name=”access” type=”radio” value=”24 Hour Access” checked>
<span class=”stylereq”> Yes</span></label>
<label>
<input type=”radio” name=”access” value=”x”>
<span class=”stylereq”> NO </span></label>
</div></td>
</tr>
<tr>
<td><div align=”right”><strong><span class=”stylereq”>Price Per Week</span>
</strong></div></td>
<td><div align=”left”> <input name=”sale_cost” type=”text” id=”sale_cost2″ class=”stylereq”>
<span class=”stylereq”><strong>
<?
$cur_enc->currency($cnt);
?>
</strong></span></div></td>
</tr>
<tr>
<td><p align=”right”><strong><span class=”stylereq”>Preferred contact methods<br><span class=”style5″>(Tick phone,cell,or email)</span></span></strong></p></td>
<td><p align=”left”>
<input name=”phone_ch” type=”checkbox” id=”phone_ch2″ value=”checkbox”>
<span class=”stylereq”> Phone</span>
<input name=”email_ch” type=”checkbox” id=”email_ch2″ value=”checkbox”>
<span class=”stylereq”> Email </span></p>
</td>
</tr>
<tr>
<td colspan=”2″>
<div align=”center”>
<input name=”adddb1″ type=”button” id=”adddb1″ value=”Submit” onclick=”addsale()” class=”stylereq”>
<input name=”reset” type=”reset” id=”reset” value=”Reset” class=”stylereq”>
</div> <div align=”left”></div></td>
</tr>
<tr>
<td><div align=”right”></div></td>
<td><div align=”center”></div></td>
</tr>
</table>
<p> </p>
</form>
sale_rent_process.php:
<?
session_start();
include_once “table_name.php”;
include_once ‘db_conn.php’;
include “insert_class.php”;
$ins1=new ins();
//if(isset($_POST['adddb'])or isset($_POST['adddb1']))
if(isset($_POST['sale_cost']) or isset($_POST['bond_amt']))
{
$countryname=$_POST['country_name'];
$statename=$_POST['state_name1'];
$area_name=$_POST['area_name1'];
$cityname=$_POST['city_name1'];
//$zipcode=$_POST['zip_code'];
$unitnum=$_POST['unit_num'];
$addres=$_POST['address'];
$spotdetail=$_POST['spot_detail'];
$undercover=$_POST['undercover'];
$secure=$_POST['secure'];
$access=$_POST['access'];
$weekamt=$_POST['price_week'];
$bondamt=$_POST['bond_amt'];
$salescost=$_POST['sale_cost'];
$id=$_SESSION['id'];
if($_POST['state_name1']==’Others’ or $_POST['state_name1']==”)
{
$statename=$_POST['state_name'];
}
if($_POST['city_name1']==’Others’ or $_POST['state_name1']==’Others’ or $_POST['state_name1']==”)
{
$cityname=$_POST['city_name'];
}
if( $_POST['state_name1']==’Others’ or $_POST['city_name1']==’Others’ or $_POST['area_name1']==’Others’ or $_POST['state_name1']==”)
{
$area_name=$_POST['area_name'];
}
$statename=$ins1->str2fmat($statename);
$cityname=$ins1->str2fmat($cityname);
$area_name=$ins1->str2fmat($area_name);
$spotdetail=$ins1->str2ucf($spotdetail);
if(!empty($_POST['bond_amt']))
{
$entry_type=’rent’;
$res=mysql_query(“select unix_timestamp(now())”);
$addtime=mysql_result($res,0);
$res1=mysql_query(“select phone_num,mob_num,mail_id from $table_name[1] where user_id=$id”);
if(isset($_POST['phone_ch']))
{
$phone=mysql_result($res1,0,0);
}
else
$phone=0;
if(isset($_POST['mobile_ch']))
{
$mobile=mysql_result($res1,0,1);
//echo “mobile”.$mobile;
}
else
$mobile=0;
if(isset($_POST['email_ch']))
{
$mail=mysql_result($res1,0,2);
//echo “email”.$mail;
}
else
$mail=’x';
$myres1=@mysql_query(“select payment from $table_name[1] where user_id=$id”);
$payment=@mysql_result($myres1,0,0);
@mysql_query(“insert into $table_name[0] (user_id,cont_name,state,city,
unit_num,address,head_details,spot_cover,spot_secure,spot_access
,price_week,bond_amt,cont_phn,cont_mob,cont_email,add_time,entry_type,area,status,expire,paid,payment)
values ($id,’$countryname’,'$statename’,'$cityname’,$unitnum,’$addres’
,’$spotdetail’,'$undercover’,'$secure’,'$access’,$weekamt,$bondamt,’$phone’,$mobile,’$mail’,
$addtime,’$entry_type’,'$area_name’,0,0,0,$payment)”);
$_SESSION['add_id']=@mysql_insert_id();
//echo mysql_error();
/*echo “insert into $table_name[0] (user_id,cont_name,state,city,
unit_num,address,head_details,spot_cover,spot_secure,spot_access
,price_week,bond_amt,cont_phn,cont_mob,cont_email,add_time,entry_type,area,status,expire,paid,payment)
values ($id,’$countryname’,'$statename’,'$cityname’,$unitnum,’$addres’
,’$spotdetail’,'$undercover’,'$secure’,'$access’,$weekamt,$bondamt,’$phone’,$mobile,’$mail’,
$addtime,’$entry_type’,'$area_name’,1,0,0,$payment”; */
//$con=mysql_query(“select * from $table_name[3] where country=’$countryname’ and state=’$statename’ and city=’$cityname’ and area=’$area_name’”);
//echo “select * from $table_name[3] where country=’$countryname’ and state=’$statename’ and city=’$cityname’ and area=’$area_name’”;
//echo mysql_error();
//$num_rows=mysql_num_rows($con);
//if($num_rows==0)
//{
//mysql_query(“insert into $table_name[3](country,state,city,area) values(‘$countryname’,'$statename’,'$cityname’,'$area_name’)”);
//}
$det[5]=$statename;
$det[6]=$cityname;
$det[7]=$area_name;
$contres=mysql_query(“select id from $table_name[4] where country=’$countryname’”);
$x=@mysql_result($contres,0,0);
$myset[5]=$x;
for($y=5;$y<=7;$y++)
{
$x=$ins1->ins_fun($table_name[$y],$det[$y],$x,$y);
$myset[$y+1]=$x;
}
$sres1=@mysql_query(“select sid from city where city=’$cityname’”);
$myset[6]=@mysql_result($sres1,0,0);
//print_r($myset);
mysql_query(“update $table_name[6] set cid=$myset[5] where sid=$myset[6]“);
mysql_query(“update $table_name[7] set cid=$myset[5],sid=$myset[6] where ctid=$myset[7]“);
/*$lastid=mysql_insert_id();
$res5=mysql_query(“select payment from $table_name[1] where user_id=$id”);
if(mysql_result($res5,0)>0)
{
header(“location:index.php?payp=1″);
}
else
{
mysql_query(“update set paid=0 where aid=$lastid”);
header(“location:index.php?addrent=1&th=1″);
}*/
}
elseif(!empty($_POST['sale_cost']))
{
$entry_type=’sale’;
$res=mysql_query(“select unix_timestamp(now())”);
$addtime=mysql_result($res,0);
$res1=mysql_query(“select phone_num,mob_num,mail_id from $table_name[1] where user_id=$id”);
if(isset($_POST['phone_ch']))
{
$phone=mysql_result($res1,0,0);
}
else
$phone=0;
if(isset($_POST['mobile_ch']))
{
$mobile=mysql_result($res1,0,1);
//echo “mobile”.$mobile;
}
else
$mobile=0;
if(isset($_POST['email_ch']))
{
$mail=mysql_result($res1,0,2);
//echo “email”.$mail;
}
else
$mail=’x';
$myres1=@mysql_query(“select payment from $table_name[1] where user_id=$id”);
$payment=@mysql_result($myres1,0,0);
@mysql_query(“insert into $table_name[0] (user_id,cont_name,state,city,
unit_num,address,head_details,spot_cover,spot_secure,spot_access
,spot_cost,cont_phn,cont_mob,cont_email,add_time,entry_type,area,status,expire,paid,payment)
values ($id,’$countryname’,'$statename’,'$cityname’,$unitnum,’$addres’
,’$spotdetail’,'$undercover’,'$secure’,'$access’,$salescost,’$phone’,$mobile,’$mail’,
$addtime,’$entry_type’,'$area_name’,0,0,0,$payment)”);
$_SESSION['add_id']=@mysql_insert_id();
//$con=mysql_query(“select * from $table_name[3] where country=’$countryname’ and state=’$statename’ and city=’$cityname’ and area=’$area_name’”);
//echo “select * from $table_name[3] where country=’$countryname’ and state=’$statename’ and city=’$cityname’ and area=’$area_name’”;
//echo mysql_error();
//$num_rows=mysql_num_rows($con);
//if($num_rows==0)
//{
//mysql_query(“insert into $table_name[3](country,state,city,area) values(‘$countryname’,'$statename’,'$cityname’,'$area_name’)”);
//}
$det[5]=$statename;
$det[6]=$cityname;
$det[7]=$area_name;
$contres=mysql_query(“select id from $table_name[4] where country=’$countryname’”);
$x=@mysql_result($contres,0,0);
$myset[5]=$x;
for($y=5;$y<=7;$y++)
{
$x=$ins1->ins_fun($table_name[$y],$det[$y],$x,$y);
$myset[$y+1]=$x;
}
//print_r($myset);
$sres1=@mysql_query(“select sid from city where city=’$cityname’”);
$myset[6]=@mysql_result($sres1,0,0);
mysql_query(“update $table_name[6] set cid=$myset[5] where sid=$myset[6]“);
mysql_query(“update $table_name[7] set cid=$myset[5],sid=$myset[6] where ctid=$myset[7]“);
/*$lastid=mysql_insert_id();
$res5=mysql_query(“select payment from $table_name[1] where user_id=$id”);
if(mysql_result($res5,0)>0)
{
header(“location:index.php?payp=1″);
}
else
{
mysql_query(“update set paid=0 where aid=$lastid”);
header(“location:index.php?addsale=1&th=1″);
}*/
}
}
//else
//{
//if(!isset($_POST['adddb1']))
//header(“location:http://localhost/carspot/index.php?sh=asale”);
//else
//header(“location:http://localhost/carspot/index.php?sh=arent”);
//}
$sql55=@mysql_query(“select distinct(payment) from $table_name[1]“);
$pay1=@mysql_result($sql55,0,0);
if($pay1==0 && $salescost!=0)
header(“location:index.php?addsale=1&th=$pay1″);
elseif($pay1==0 && $bondamt!=0)
header(“location:index.php?addrent=1&th=$pay1″);
else
{?>
<? if(!isset($_GET['sh']) ) { include_once “post_time.php”;
$md1=new posttime();
include “table_name.php”;
include “db_conn.php”;
$sql22=mysql_query(“select distinct(payment) from $table_name[1]“);
$pay=@mysql_result($sql22,0,0);
//if(isset($_GET['paynow']))
//{
$i22=$_GET['paynow'];
$i22=$md1->mdtopl($i22,aid,$table_name[0]);
$_SESSION['add_id']=$i22; ?>
<table width=”100%”><td>Your Ad added Sucessfully Kindly Click the pay button to Pay it costs only <? echo $pay;?> AUD </td></table><? } ?>
<input type=”hidden” name=”cmd” value=”_xclick”>
<input type=”hidden” name=”business” value=”jmeery@yahoo.com”>
<input type=”hidden” name=”item_name” value=”FindAParkingspace”>
<input type=”hidden” name=”item_number” value=”1002″>
<input type=”hidden” name=”amount” value=”2″>
<input type=”hidden” name=”no_shipping” value=”1″>
<input type=”hidden” name=”return” value=”http://www.arc-max.com/carspot/index.php?paid=yes”>
<input type=”hidden” name=”no_note” value=”1″>
<input type=”hidden” name=”currency_code” value=”AUD”>
<input type=”hidden” name=”lc” value=”AU”>
<input type=”hidden” name=”bn” value=”PP-BuyNowBF”>
<input type=”image” value=”Pay” src=”images/x-click-but6.gif” alt=”Make payments with PayPal – it’s fast, free and secure!”>
<?
echo “<script>”;
echo “document.addrentfrm.action=\”https://www.paypal.com/cgi-bin/webscr\”;”;
echo “document.addrentfrm.submit();”;
echo “</script>”;
}
?>
