lonkarprajakta29

December 8, 2011

Yes. Create a new topic and post your question/the code you are working with.

i have crated nw topic as u said ben...but m nt getting proper respons..u pls take a luk at that topic...else just suggest me simple editing code for drop down list.its very urgent

December 8, 2011

if you can post your code for this I'll take a look at it.

<?php include "../includes/drop.php";

include_once "common.php";

_checkSession();

//include "includes/function.php";

function renderForm($srno,$mou,$name,$day,$date,$coord,$client,$tel,$mob,$fb,$sex,$sell,$firstadvance,$balreceived,$shootreceived,$rolls,$cheque,$shootdate,$postshoot,$error)

{

$result=mysql_query("SELECT day,date,sex,rolls,shootdate,postshoot FROM shoot_details WHERE Sr_no=$srno");

?>

<html>

<head>

<title>MOU Entry</title>

</head>

<body>

<br>

<tr>

</tr>

<tr>

<td>

<tr>

<td height="20" colspan="2" class="blue_links1"> Memorandum Of Understanding(MOU) </td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Day</td

</select><?php drop("arr_day","$day");?>

</td>

</tr>

<tr>

<td height="30" class="txt1"><?php drop("arr_date",$datearr[2],"sign_date" );?><select name="sign_month" class="form1"><option value="">-Select-</option>

<option value="01"<?php if ($datearr[1]=="01") echo "selected";?>>January</option>

<option value="02"<?php if ($datearr[1]=="02") echo "selected";?>>February</option>

<option value="03"<?php if ($datearr[1]=="03") echo "selected";?>>March</option>

<option value="04"<?php if ($datearr[1]=="04") echo "selected";?>>April</option>

<option value="08"<?php if ($datearr[1]=="08") echo "selected";?>>August</option>

<option value="09"<?php if ($datearr[1]=="09") echo "selected";?>>September</option>

<option value="10"<?php if ($datearr[1]=="10") echo "selected";?>>October</option>

<option value="11"<?php if ($datearr[1]=="11") echo "selected";?>>November</option>

<option value="12"<?php if ($datearr[1]=="12") echo "selected";?>>December</option>

</select>

<?php drop("arr_year",$datearr[0],"sign_year");?>

</tr>

<tr>

<td height="30" class="txt1"> Co-Ordinator Name</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Client's Name</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Telephone No.</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Mobile No.</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Feedback</td>

</tr>

<tr>

<?php drop("arr_sex","$sex");?>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Number Of Rolls</td>

<?php drop("arr_rolls","$rolls");?>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Selling Price</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> First Advance Received</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> On Shoot Received</td>

</td>

</tr>

<tr>

<td height="30" class="txt1"> Cheque Details</td>

</tr>

<tr>

<td height="30" class="txt1"> Shoot Date</td>

<?php drop("arr_date",$shootarr[2],"shoot_date");?><select name="shoot_month" class="form1"><option value="00">-Select-</option>

<option value="01"<?php if ($shootarr[1]=="01") echo "selected";?>>January</option>

<option value="02"<?php if ($shootarr[1]=="02") echo "selected";?>>February</option>

<option value="03"<?php if ($shootarr[1]=="03") echo "selected";?>>March</option>

<option value="04"<?php if ($shootarr[1]=="04") echo "selected";?>>April</option>

<option value="08"<?php if ($shootarr[1]=="08") echo "selected";?>>August</option>

<option value="09"<?php if ($shootarr[1]=="09") echo "selected";?>>September</option>

<option value="10"<?php if ($shootarr[1]=="10") echo "selected";?>>October</option>

<option value="11"<?php if ($shootarr[1]=="11") echo "selected";?>>November</option>

<option value="12"<?php if ($shootarr[1]=="12") echo "selected";?>>December</option>

</select>

<?php drop("arr_year",$shootarr[0],"shoot_year");?>

</tr>

<tr>

<td height="30" class="txt1"> Postpond Shoot</td>

<td height="30" class="txt1"><?php drop("arr_date",$postarr[2],"post_date" );?><select name="post_month" class="form1"><option value="">-Select-</option>

<option value="01"<?php if ($postarr[1]=="01") echo "selected";?>>January</option>

<option value="02"<?php if ($postarr[1]=="02") echo "selected";?>>February</option>

<option value="03"<?php if ($postarr[1]=="03") echo "selected";?>>March</option>

<option value="04"<?php if ($postarr[1]=="04") echo "selected";?>>April</option>

<option value="08"<?php if ($postarr[1]=="08") echo "selected";?>>August</option>

<option value="09"<?php if ($postarr[1]=="09") echo "selected";?>>September</option>

<option value="10"<?php if ($postarr[1]=="10") echo "selected";?>>October</option>

<option value="11"<?php if ($postarr[1]=="11") echo "selected";?>>November</option>

<option value="12"<?php if ($postarr[1]=="12") echo "selected";?>>December</option>

</select>

<?php drop("arr_year",$postarr[0],"post_year");?>

</tr>

<tr>

</td>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</form>

</td>

</tr>

</table>

</body>

</html>

<?php

}

// check if the form has been submitted. If it has, process the form and save it to the database

if (isset($_POST['submit']))

{

// confirm that the 'id' value is a valid integer before getting the form data

if (is_numeric($_POST['Sr_no']))

{

// get form data, making sure it is valid

$srno = $_POST['Sr_no'];

$mou = mysql_real_escape_string(htmlspecialchars($_POST['mou']));

$name = mysql_real_escape_string(htmlspecialchars($_POST['name']));

$day = mysql_real_escape_string(htmlspecialchars($_POST['day']));

$date=mysql_real_escape_string(htmlspecialchars($_POST['sign_year']))."-".mysql_real_escape_string(htmlspecialchars($_POST['sign_month']))."-" .mysql_real_escape_string(htmlspecialchars($_POST['sign_date']));

$coord = mysql_real_escape_string(htmlspecialchars($_POST['coord']));

$client = mysql_real_escape_string(htmlspecialchars($_POST['client']));

$tel = mysql_real_escape_string(htmlspecialchars($_POST['tel']));

$mob = mysql_real_escape_string(htmlspecialchars($_POST['mob']));

$fb = mysql_real_escape_string(htmlspecialchars($_POST['fb']));

$sex = mysql_real_escape_string(htmlspecialchars($_POST['sex']));

$rolls = mysql_real_escape_string(htmlspecialchars($_POST['rolls']));

$sell = mysql_real_escape_string(htmlspecialchars($_POST['sell']));

$firstadvance = mysql_real_escape_string(htmlspecialchars($_POST['firstadvance']));

$shootreceived = mysql_real_escape_string(htmlspecialchars($_POST['shootreceived']));

$balreceived = mysql_real_escape_string(htmlspecialchars($_POST['balreceived']));

$cheque = mysql_real_escape_string(htmlspecialchars($_POST['cheque']));

$shootdate = mysql_real_escape_string(htmlspecialchars($_POST['shootdate']));

$postshoot = mysql_real_escape_string(htmlspecialchars($_POST['postshoot']));

if($a=$_POST['firstadvance']||$a=$_POST['shootreceived'])

{$balreceived=$sell-$firstadvance-$shootreceived;

}

// check that firstname/lastname fields are both filled in

if ($mou == '')

{

// generate error message

$error = 'ERROR: Please fill in all required fields!';

//error, display form

renderForm($srno,$mou,$name,$day,$date,$coord,$client,$tel,$mob,$fb,$sex,$sell,$firstadvance,$balreceived,$shootreceived,$rolls,$cheque,$shootdate,$postshoot, $error);

}

else

{

// save the data to the database

mysql_query("UPDATE shoot_details SET mou='$mou', day=' $day ', date=' $date', coord=' $coord ', client=' $client ', tel=' $tel . ', mob=' $mob', fb=' . $fb ', sex=' $sex ', sell=' $sell ', firstadvance=' $firstadvance ', balreceived=' $balreceived ', shootreceived=' $shootreceived ',cheque='$cheque', rolls='$rolls', shootdate='$shootdate ', postshoot='$postshoot ' WHERE Sr_no='$srno'")

or die(mysql_error());

// once saved, redirect back to the view page

// header("Location: view.php");

}

else

{

// if the 'id' isn't valid, display an error

echo 'Error!';

}

else

// if the form hasn't been submitted, get the data from the db and display the form

{

// get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)

if (isset($_GET['Sr_no']) && is_numeric($_GET['Sr_no']) && $_GET['Sr_no'] > 0)

{

// query db

$srno = $_GET['Sr_no'];

$result = mysql_query("SELECT * FROM shoot_details WHERE Sr_no=$srno")

or die(mysql_error());

$row = mysql_fetch_array($result);

// check that the 'id' matches up with a row in the databse

if($row)

{

// get data from db

$srno=$row['Sr_no'];

$mou=$row['mou'];

$name=$row['name'];

$day = $row['arr_day'];

$date=$row['date'];

$coord=$row['coord'];

$client=$row['client'];

$tel=$row['tel'];

$mob=$row['mobile'];

$fb=$row['fb'];

$sex=$row['arr_sex'];

$sell=$row['sell'];

$firstadvance=$row['firstadvance'];

$balreceived=$row['balreceived'];

$shootreceived=$row['shootreceived'];

$rolls=$row['arr_rolls'];

$cheque=$row['cheque'];

$shootdate=$row['shootdate'];

$postshoot=$row['postshoot'];

// show form

renderForm($srno,$mou,$name,$day,$date,$coord,$client,$tel,$mob,$fb,$sex,$sell,$firstadvance,$balreceived,$shootreceived,$rolls,$cheque,$shootdate,$postshoot,'');

}

else

// if no match, display result

{

echo "No results!";

}

else

// if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error

{

echo 'Error!';

}

?>

December 8, 2011

i have used the code posted in this forum for editing the form so help me for drop down list in reference with earlier code only

December 8, 2011

hey awsm work....it really helped me a lot...but in this i m facing one problem in edit.php....In my form i have used drop down list. I am not able to retrieve the result of that drop down list while editing the form. When i redirected to edit.php the fields having drop down list show first option in drop down list instead of showing selecting option while adding data...plsss help me in this....should i post my code?

i have attached my file where i want to insert this changes...if u r finding this code quite complicated then just help me with simple example

suppose i make a drop down menu having value 1, 2, 3, 4, 5, one option can be selected, and selected option is stored in database.

now i create an edit page, how do i display the selected value in the menu and other values in drop down,

for example,

Menu is like

Select One

1

2

3

4

5

and i select 3, this 3 is stored in database, now on the edit page i want to show 3 as already selected,

something like that..

<select name="select_thing">
<option value="1">1</option>

<option value="2">2</option>

<option value="3" selected>3</option>

<option value="4">4</option>

<option value="5">5</option>

</select>

I will be very thankful, if someone could help by explaining how do i make option 3 as selected.. eg. how i know option 3 is selected and stored in db.

December 8, 2011

hey awsm work....it really helped me a lot...but in this i m facing one problem in edit.php....In my form i have used drop down list. I am not able to retrieve the result of that drop down list while editing the form. When i redirected to edit.php the fields having drop down list show first option in drop down list instead of showing selecting option while adding data...plsss help me in this....should i post my code?

Sign In

lonkarprajakta29

Posts

Joined

Last visited

Content Type

Profiles

Forums

Events

Downloads

Gallery

Store

Posts posted by lonkarprajakta29

Basic Php System: View/edit/delete/add Records

RETRIVE DROPDOWN RESULT WHILE EDITING IN PHP

RETRIVE DROPDOWN RESULT WHILE EDITING IN PHP

RETRIVE DROPDOWN RESULT WHILE EDITING IN PHP

Basic Php System: View/edit/delete/add Records

Browse

Activity

Store

Support