Jump to content

need help to create a case !!


qxygene

Recommended Posts

hi;

 

i made a case ;

case 1:
if ($form) {
	$query="INSERT INTO emlak (type,sqm,loc,price,info1,info2,bedr,bath,car,tarih,buy) VALUES ('$type','$sqm','$loc','$price','$info1','$info2','$bedr','$bath','$car',now(),'$buy')";
	MYSQL_QUERY($query);	
	$strSQL = "SELECT max(ref) FROM emlak";
	$result = mysql_query($strSQL);
	$row = mysql_fetch_row($result);
	$ref = $row[0];
	header("location:?step=2&ref=$ref");
} else { 
	echo "STEP1<br>";
	require ("inc/step1.inc.php");
}
break;

 

this case sends data to database , it works properly.

 

also here is inc/step1.inc.php

 

 

<form method="post" enctype="multipart/form-data">
<table>
<tr>
<td>Ref:</td>
<td><? echo $ref ?></td>
</tr>
<tr>
<td>Type:</td>
<td>
	<select style="background-color:#ffffff; color:#333333; font-size: 12pt;" name=type>
	<option>Apartment</option>
	<option>Villa</option>
	<option>Commercal</option>
	<option>Land</option>
	</select>
</td>
</tr>
<tr>
<td>Sale or Rent?:</td>
<td>
	<select cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" name=buy>
	<option value=1>For Sale</option>
	<option value=0>For Rent</option>
	</select>
</td>	
</tr>
<tr>
<td>S.Q.M.:</td>
<td><input cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=sqm value=></td>
</tr>
<tr>
<td>Location:</td>
<td>
	<select name=loc cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;">
	<option>Bozburun</option>
	<option>Marmaris</option>
	</select>
</td>
</tr>
<tr>
<td>Price £:</td>
<td><textarea cols="48" rows="1" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=price value=></textarea></td></tr>
</tr>
<tr>
<td>Info Head:</td>
<td><textarea cols="48" rows="2" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=info1 value=></textarea></td></tr>
<tr>
<td>Info Main:</td>
<td><textarea cols="48" rows="10" style="background-color:#ffffff; color:#333333; font-size: 12pt;"></textarea></td>
</tr>
<tr>
<td>Bedrooms:</td>
<td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-size: 12pt;" type=text name=bedr value=></textarea></td>
</tr>
<tr>
<td>Bathrooms:</td>
<td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-weight: bold; font-size: 12pt;" type=text name=bath value=></textarea></td>
</tr>
<tr>
<td>Car Parking:</td>
<td><textarea cols="2" rows="1" style="background-color:#ffffff; color:#333333; font-weight: bold; font-size: 12pt;" type=text name=car value=></textarea></td>
</tr>
<tr>
<td colspan=2 align=right><input type=submit value="Go to Step2" name=form></td>
</tr>

 

now i want to make and edit/modify like this;

 

i think i need a new case and step2.inc.php.. but i dont know how to do it..

 

any help..

 

Note:i also attached files.

 

[attachment deleted by admin]

Link to comment
https://forums.phpfreaks.com/topic/41784-need-help-to-create-a-case/
Share on other sites

here'a an example ..hope it helps..

 

 

$query = "UPDATE customer SET

username= '" . $_POST['username'] . "',

fname= '" . $first . "',

lname= '" . $last . "',

email= '" . $_POST['email'] . "',

tel= '" . $_POST['tel'] . "',

fax= '" . $_POST['fax'] . "',

cell= '" . $_POST['cell'] . "',

hnum= '" . $_POST['hnum'] . "',

street= '" . $_POST['street'] . "',

city= '" . $city . "',

province= '" . $_POST['province'] . "' ,

post_code= '" . $_POST['post_code'] . "'

WHERE id = '".$_SESSION['userid']."'";

$result = mysql_query($query) or die(mysql_error());

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.