thanks you brother
thanks you brother
Thanks Shakeel Bhai
bohat khoob yar
//////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////
''''''''''''''''''''''''__________________________ _____________________________
Bank me 1 achi job he
For u
Rs 25000 pay milay gi
kaam sirf ye he k sara din cashier k
samne ZUBAN
nikal kr bethna
wo anghotha laga ker Note gine ga
__________________________________________________ ______________
بہت بہت اچھا لکھا ہے آپ نے
میں کوئی ایسا ہی کورس ڈہونڈ رہا تھا
Very Good Yar.
shahbaz348***********
www.bingpk.com
Shkeel Sahib Smaj Nhi Aa rhaa k kis trhaa aap ka shukria Adaa Krun
Main Ne Is Course k tmaam Pages Computer Main Save Kr liye Hain
Mujhy PHP aur SQL main Bohat Intrest hai
Aure Mujhy Umeed hai k main isy Achy Treeqy sy Seekh Skta houn
Umeed hai k aap is k baad koi aur Tutorial Shru krain gy
Shahbaz Ashraf
www.bingpk.com
Great work
Nice Brother Your Great Thanks
Shakeel Bahi ak masla hae
man nae jo edit.php banae hae us se man delete karta hoon to delete ho jata hae magar jab edit karta hoon to edit hone k bad save nahi hota . Bas ye lika howa ajata hae(Invalid Student ID).
mane jo lika hae wo man app ko send karta hoon app dakan k us man kiya ghalti hae.
<?php
//connection file
include "connection.php";
//getting query strings
$sid =$_GET['sid'];
$do = $_GET['do'];
//what to do
switch ($do) {
case "edit": //if editing record, show edit form
edit_Record_Form($sid);
break;
case "del": //if deleting record
del_Record($sid);
break;
case "save": //if saving edited record
save_Record();
break;
default;
error_Message("Invalid Page Request");
}
//validating requested id
function chkID($id) {
$sid = intval($id);
//if invalid
if (empty ($sid) OR !is_int ($sid)) {
error_Message("Invalid Student ID");
}
return $sid;
}
//edit form
function edit_Record_Form($id) {
//validating $id
$sid = chkID($id);
//query (select all record form result table associated with this $id)
$Query = "SELECT * FROM result WHERE sid = $sid";
//executing query
$Result = mysql_query ($Query) or error_Message(mysql_error());
//if no record found
if (mysql_num_rows ($Result) <=0) {
error_Message("No record Found");
}
//get return row in $Row array
$Row = mysql_fetch_assoc ($Result);
//print the edit form and set elements values
//using the $Row array
$Row = mysql_fetch_assoc ($Result);
//print the edit form and set elenents values
//using the $Row array
print "<form method=\"post\"action=\"{$_SERVER['PHP_SELF']}?do=save\">
<table border=1 cellpadding=3 cellspacing=3 width='50%'>
<tr><th colspan=2 align='left' bgcolor='#EAEAEA'>
Edit Result</th></tr>
<tr><td>Student Name</td><td>
<input type=\"text\"name=\"sName\"value=\"{$Row['sname']}\">
</td></tr><tr><td>MARKS</td><td>
<input type=\"text\"name=\"sMARKS\"value=\"{$Row['MARKS']}\">
</td></tr><tr><td colspan=2 align='center'>
<input type=\"submit\"value=\"Save\">
<input type=\"button\"value=\"Cancle\"onClick=\"history.g o(-1);\">
<input type=\"hidden\"value=\"{$Row['sid']}\"name=\"sid\">
</td></tr></table></form>";
}
//deleting record
function del_Record ($id) {
$sid = chkID($id);
//executing delete query
if (!mysql_query("DELETE FROM result WHERE sid=$sid")) {
error_Message("Could not delete record<br>" .mysql_error());
}
print "<div style='background:#FFFFCC;border:dashed 1px #CCCCCC'>
Record Deleted Successfully<a href='new_record.php'>Continue</a></div>";
}
//saving record
function save_Record() {
//getting form values
//note: the sid is hidden field in
//form contains the value of sid field
$ID = chkID($_POST['sid']);
$Name =cleanString($_POST['sName']);
$MARKS =(int) cleanString($_POST['sMARKS']);
//checking for empty values
if (empty ($Name) || empty ($MARKS)) {
error_Message("Cannot insert empty record");
}
//marks range
if ($MARKS < 0 || $MARKS > 99) {
error_Message("Marks must be between 1 - 99");
}
//max student name
if (strlen ($Name) > 40) {
error_Measage("Name is too long");
}
//query for unpating record
$query = "UPDATE result SET sname = '$Name',MARKS = $MARKS
WHERE sid = $ID";
//executing query
if (mysql_query($query)) {
print "<div style='background:#FFFFCC;border:dashed 1px #CCCCCC'>
Record Updated successfully
<a href='new_record.php'>Continue</a></div>";
}else {
error_Message(mysql_error()); //if error in query
}
}
//error message
function error_Message($error) {
$msg = "<div style='background:#FFFFCC;border:dashed 1px #CCCCCC'>
$error <a href='javascript:history.go(-1)'>Back</a></div>";
die($msg);
}
//cleaning string
function cleanString ($string) {
$string = htmlspecialchars (trim ($string));
if(!get_magic_quotes_gpc()) {
$string = addslashes ($string);
}
return $string;
}
?>
app is ko khod chek karan
man app k jawab k intezar karon ga.
Shokriya.
its good but hum ko mukamal project bana k dekhayien takay hum issee platform pe sab seekh jayein kaheen jana na paray
salmti ho aap per itnee achi sharing
Bookmarks