تنبيه
يوجد جزئين لهذا الكود
عرض تحرير حذف و إضافة السجلات php كود ( الجزء الثاني)
انشاء او ادخال بيانات جديدة داخل قاعدة البيانات
/*
NEW.PHP
Allows user to create a new entry in the
database
*/
// creates the new record form
// since this form is used multiple times
in this file, I have made it a function that is easily reusable
function renderForm($first, $last, $error)
{
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD
HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>New Record</title>
</head>
<body>
<?php
// if there are any errors, display them
if ($error != '')
{
echo '<div style="padding:4px;
border:1px solid red; color:red;">'.$error.'</div>';
}
?>
<form action=""
method="post">
<div>
<strong>First Name: *</strong>
<input type="text" name="firstname" value="<?php
echo $first; ?>" /><br/>
<strong>Last Name: *</strong>
<input type="text" name="lastname" value="<?php
echo $last; ?>" /><br/>
<p>* required</p>
<input type="submit"
name="submit" value="Submit">
</div>
</form>
</body>
</html>
<?php
}
// connect to the database
include('connect-db.php');
// check if the form has been submitted.
If it has, start to process the form and save it to the database
if (isset($_POST['submit']))
{
// get form data, making sure it is valid
$firstname =
mysql_real_escape_string(htmlspecialchars($_POST['firstname']));
$lastname =
mysql_real_escape_string(htmlspecialchars($_POST['lastname']));
// check to make sure both fields are
entered
if ($firstname == '' || $lastname == '')
{
// generate error message
$error = 'ERROR: Please fill in all
required fields!';
// if either field is blank, display the
form again
renderForm($firstname, $lastname, $error);
}
else
{
// save the data to the database
mysql_query("INSERT players SET
firstname='$firstname', lastname='$lastname'")
or die(mysql_error());
// once saved, redirect back to the view
page
header("Location:
view.php");
}
}
else
// if the form hasn't been submitted,
display the form
{
renderForm('','','');
}
?
----------------------
نشاء ملف
يسمح للمستخدم لتحرير إدخال في قاعدة البيانات
/*
EDIT.PHP
Allows user to edit specific entry in
database
*/
// creates the edit record form
// since this form is used multiple times
in this file, I have made it a function that is easily reusable
function renderForm($id, $firstname,
$lastname, $error)
{
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD
HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Edit Record</title>
</head>
<body>
<?php
// if there are any errors, display them
if ($error != '')
{
echo '<div style="padding:4px;
border:1px solid red; color:red;">'.$error.'</div>';
}
?>
<form action=""
method="post">
<input type="hidden"
name="id" value="<?php echo $id; ?>"/>
<div>
<p><strong>ID:</strong>
<?php echo $id; ?></p>
<strong>First Name: *</strong>
<input type="text" name="firstname" value="<?php
echo $firstname; ?>"/><br/>
<strong>Last Name: *</strong>
<input type="text" name="lastname" value="<?php
echo $lastname; ?>"/><br/>
<p>* Required</p>
<input type="submit"
name="submit" value="Submit">
</div>
</form>
</body>
</html>
<?php
}
// connect to the database
include('connect-db.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['id']))
{
// get form data, making sure it is valid
$id = $_POST['id'];
$firstname =
mysql_real_escape_string(htmlspecialchars($_POST['firstname']));
$lastname =
mysql_real_escape_string(htmlspecialchars($_POST['lastname']));
// check that firstname/lastname fields
are both filled in
if ($firstname == '' || $lastname == '')
{
// generate error message
$error = 'ERROR: Please fill in all
required fields!';
//error, display form
renderForm($id, $firstname, $lastname, $error);
}
else
{
// save the data to the database
mysql_query("UPDATE players SET
firstname='$firstname', lastname='$lastname' WHERE id='$id'")
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['id']) &&
is_numeric($_GET['id']) && $_GET['id'] > 0)
{
// query db
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM
players WHERE id=$id")
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
$firstname = $row['firstname'];
$lastname = $row['lastname'];
// show form
renderForm($id, $firstname, $lastname,
'');
}
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!';
}
}
?>
-------------------
حذف البيانات من داخل قاعدة البيانات
<?php
/*
DELETE.PHP
Deletes a specific entry from the
'players' table
*/
// connect to the database
include('connect-db.php');
// check if the 'id' variable is set in
URL, and check that it is valid
if (isset($_GET['id']) &&
is_numeric($_GET['id']))
{
// get id value
$id = $_GET['id'];
// delete the entry
$result = mysql_query("DELETE FROM
players WHERE id=$id")
or die(mysql_error());
// redirect back to the view page
header("Location: view.php");
}
else
// if id isn't set, or isn't valid,
redirect back to view page
{
header("Location: view.php");
}
?>
-------
----------- END OF THE Basic PHP System:
View/Edit/Delete/Add Records
