این کل کد این صفحه:
<?php
ob_start();
require_once 'config.php';
?>
<style type="text/css">
*{
font-family:tahoma;
font-size:12px;
color:#000;
}
.pb_container{
direction:rtl;
margin-top:10px;
margin-right:auto;
margin-bottom:10px;
margin-left:auto;
width:950px;
border:1px solid #fe791c;
padding:0 10px;
}
fieldset, legend{
-moz-border-radius:5px;
-khtml-border-radius:5px;
-webkit-border-radius:5px;
border-radius:5px;
border:1px solid #fe791c;
}
fieldset, legend{
-moz-border-radius:5px;
-khtml-border-radius:5px;
-webkit-border-radius:5px;
border-radius:5px;
border:1px solid #fe791c;
margin:3px;
padding:3px;
}
.even{
background-color:#e1e1e1;
}
.detail{
background-color:#fe791c;
width:950px;
display:none;
}
.moreDetail{
height:30px;
font-size:10px;
}
a{
text-decoration:none;
}
</style>
<!-----------START DETAIL SCRIPT---------------->
<!---------------------------------------------->
<div class="pb_container"><br>
<a href="?import=1">ورود اطلاعات</a> |
<a href="?export=1">نمایش اطلاعات</a> |
<a href="#">دانلود با فرمت اکسل</a>
<br />
<form action="<?php echo $SCRIPT_NAME ?>" method="post">
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0" dir="rtl">
<tr>
<br><br>
</tr>
<?php
$name = $_POST['name'];
$responsibleName = $_POST['responsibleName'];
$responsiblePosition = $_POST['responsiblePosition'];
$type = $_POST['type'];
$activityField = $_POST['activityField'];
$servicesType = $_POST['servicesType'];
$otherDesc = $_POST['otherDesc'];
$tel1 = $_POST['tel1'];
$tel2 = $_POST['tel2'];
$tel3 = $_POST['tel3'];
$mobile1 = $_POST['mobile1'];
$mobile2 = $_POST['mobile2'];
$fax = $_POST['fax'];
$address1 = $_POST['address1'];
$postalCode1 = $_POST['postalCode1'];
$address2 = $_POST['address2'];
$postalCode2 = $_POST['postalCode2'];
$otherAddresses = $_POST['otherAddresses'];
$webSite = $_POST['webSite'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$otherE = $_POST['otherE'];
$description = $_POST['description'];
######################ُSTART DELETE RECORD###############################
if($_GET['id']){
$sql = 'DELETE FROM phonebook WHERE id=' .$_GET["id"];
mysql_query($sql) or die(mysql_error());
header("Location:" .$SCRIPT_NAME." ?export=1");
}
######################END DELETE RECORD###############################
######################START TABLE COLOR SCRIPT###############################
echo '
<script language="javascript" src="js/jquery-1.7.1.min.js"></script>
<script language="javascript">
$(document).ready(function(){
$("table#tb tr:even").addClass("even");
});
</script>
';
######################END TABLE COLOR SCRIPT###############################
######################START EDIT RECORD###############################کامل نیست
if($_GET['edit_id']){
session_register('edit_id');
$_SESSION['edit_id'] = $_GET['edit_id'];
header("Location:" .$SCRIPT_NAME." ?import=1");
$editSql = "SELECT * FROM phonebook WHERE id =" .$_SESSION['edit_id'];
$editResult = mysql_query($editSql) or die(mysql_error());
if($editRow = mysql_fetch_assoc($editResult)){
$name = $editRow['name'];
$responsibleName = $editRow['responsibleName'];
echo $editRow['name'];
echo 'fffffffffffffffffffffffffffffffffffffffffffffffff ffffffffff<br><br><br><br><br><br><br><br><br><br>';
}else{
echo 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv';
}
}
######################END EDIT RECORD###############################
echo "
<script language='javascript'>
$(document).ready(function(){
$('img.toggle').click(function(){
//$(this).parent().parent().siblings('div.detail').s lideToggle('slow');
//$('.detail',this).slideToggle('slow');
//$('div.detail').slideToggle('slow');
$(this).nextAll('.detail:first').slideToggle('slow ');
});
})
</script>
";
if($_GET['import'] or !$_GET['export']){
if($_POST['submit']){
if($name != ""){
$sql = 'INSERT INTO phonebook(id,
name,
responsibleName,
responsiblePosition,
type,
activityField,
servicesType,
otherDesc,
tel1,
tel2,
tel3,
mobile1,
mobile2,
fax,
address1,
postalCode1,
address2,
postalCode2,
otherAddresses,
webSite,
email1,
email2,
otherE,
description
)
VALUES(
"",
"'.$name.'",
"'.$responsibleName.'",
"'.$responsiblePosition.'",
"'.$type.'",
"'.$activityField.'",
"'.$servicesType.'",
"'.$otherDesc.'",
"'.$tel1.'",
"'.$tel2.'",
"'.$tel3.'",
"'.$mobile1.'",
"'.$mobile2.'",
"'.$fax.'",
"'.$address1.'",
"'.$postalCode1.'",
"'.$address2.'",
"'.$postalCode2.'",
"'.$otherAddresses.'",
"'.$webSite.'",
"'.$email1.'",
"'.$email2.'",
"'.$otherE.'",
"'.$description.'"
);';
$result = mysql_query($sql) or die(mysql_error());
if($result){
echo 'ذخیره شد';
}else{
echo 'ذخیره سازه با مشکل مواجه شد';
}
}else{
echo 'فیلد نام شخص/شرکت را پر کنید';
}
echo ' <a href="phonebook.php">بازگشت</a>';
}else{
echo '
<tr>
<td width="300" valign="top">
<fieldset>
<legend>اطلاعات پایه</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="39%" align="left">نام شخص/شرکت:</td>
<td width="61%" align="right">
<input type="text" name="name" value="'.$name.'" />
</td>
</tr>
<tr>
<td width="39%" align="left">نام مسئول:</td>
<td width="61%" align="right">
<input type="text" name="responsibleName" value="'.$responsibleName.'" />
</td>
</tr>
<tr>
<td width="39%" align="left">پست مسئول:</td>
<td width="61%" align="right">
<input type="text" name="responsiblePosition" value="'.$responsiblePosition.'" />
</td>
</tr>
<tr>
<td align="left">نوع شرکت:</td>
<td align="right"><input type="text" name="type" value="'.$type.'" /></td>
</tr>
<tr>
<td align="left">زمینه فعالیت:</td>
<td align="right"><input type="text" name="activityField" value="'.$activityField.'" /></td>
</tr>
<tr>
<td align="left">نوع خدمات:</td>
<td align="right"><input type="text" name="servicesType" value="'.$servicesType.'" /></td>
</tr>
<tr>
<td align="left">سایر:</td>
<td align="right"><input type="text" name="otherDesc" value="'.$otherDesc.'" /></td>
</tr>
</table>
</fieldset>
</td>
<td width="300" valign="top">
<fieldset>
<legend>شماره های تماس</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="34%" align="left">تلفن 1:</td>
<td width="66%" align="right">
<input type="text" name="tel1" dir="ltr" value="'.$tel1.'" />
</td>
</tr>
<tr>
<td width="34%" align="left">تلفن 2:</td>
<td width="66%" align="right">
<input type="text" name="tel2" dir="ltr" value="'.$tel2.'" />
</td>
</tr>
<tr>
<td width="34%" align="left">تلفن 3:</td>
<td width="66%" align="right">
<input type="text" name="tel3" dir="ltr" value="'.$tel3.'" />
</td>
</tr>
<tr>
<td align="left">همراه 1:</td>
<td align="right"><input type="text" name="mobile1" dir="ltr" value="'.$mobile1.'" /></td>
</tr>
<tr>
<td align="left">همراه 2:</td>
<td align="right"><input type="text" name="mobile2" dir="ltr" value="'.$mobile2.'" /></td>
</tr>
<tr>
<td align="left">فکس:</td>
<td align="right"><input type="text" name="fax" dir="ltr" value="'.$fax.'" /></td>
</tr>
</table>
</fieldset>
</td>
<td width="300" valign="top">
<fieldset>
<legend>اطلاعات پستی</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="34%" align="left">آدرس پستی1:</td>
<td width="66%" align="right"><textarea name="address1" cols="30" rows="3">'.$address1.'</textarea></td>
</tr>
<tr>
<td width="34%" align="left">کد پستی1:</td>
<td width="66%" align="right"><input type="text" name="postalCode1" dir="ltr" value="'.$postalCode1.'" /></td>
</tr>
<tr>
<td width="34%" align="left">آدرس پستی2:</td>
<td width="66%" align="right"><textarea name="address2" cols="30" rows="3">'.$address2.'</textarea></td>
</tr>
<tr>
<td width="34%" align="left">کد پستی2:</td>
<td width="66%" align="right"><input type="text" name="postalCode2" dir="ltr" value="'.$postalCode2.'" /></td>
</tr>
<tr>
<td align="left">سایر آدرس ها:</td>
<td align="right"><textarea name="otherAddresses" cols="30" rows="3">'.$otherAddresses.'</textarea></td>
</tr>
</table>
</fieldset>
</td>
</tr>
<tr>
<td valign="top">
<fieldset>
<legend>اطلاعات الکترونیک</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="39%" align="left">آدرس وبسایت:</td>
<td width="61%" align="right"><input type="text" name="webSite" dir="ltr" value="'.$webSite.'" /></td>
</tr>
<tr>
<td width="39%" align="left">ایمیل1:</td>
<td width="61%" align="right"><input type="text" name="email1" dir="ltr" value="'.$email1.'" /></td>
</tr>
<tr>
<td width="39%" align="left">ایمیل2:</td>
<td width="61%" align="right"><input type="text" name="email2" dir="ltr" value="'.$email2.'" /></td>
</tr>
<tr>
<td align="left">سایر:</td>
<td align="right"><input type="text" name="otherE" dir="ltr" value="'.$otherE.'" /></td>
</tr>
</table>
</fieldset>
</td>
<td valign="top">
<fieldset>
<legend>توضیحات تکمیلی</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="39%" align="right" valign="top">توضیحات:</td>
</tr>
<tr>
<td width="39%" align="right" valign="top"><textarea name="description" cols="50" rows="6">'.$description.'</textarea></td>
</tr>
</table>
</fieldset>
</td>
<td align="right" valign="top">
<fieldset>
<legend>ارسال اطلاعات</legend>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="39%" align="center" valign="middle"><br /><br /><br />
<input type="submit" name="submit" value="ذخیره شود...!" style="height:40px; width:100px" /><br /><br /><br /><br />
</td>
</tr>
</table>
</fieldset>
</td>
</tr>
';
}
};
if($_GET['export']){
$sql = 'SELECT * FROM phonebook';
$result = mysql_query($sql) or die(mysql_error());
$i = 0;
echo '<table id="tb" width="900" border="0" align="center" cellpadding="0" cellspacing="0" dir="rtl">';
echo '<tr>';
echo '<td align="center" width="30" height="25"><strong>ردیف</strong></td>';
echo '<td align="center" width="200"><strong>نام شخص یا شرکت</strong></td>';
echo '<td align="center" width="120"><strong>نام مسئول</strong></td>';
echo '<td align="center" width="80"><strong>تلفن</strong></td>';
echo '<td align="center" width="80"><strong>همراه</strong></td>';
echo '<td align="center" width="160"><strong>پست الکترونیک</strong></td>';
echo '<td align="center"><strong>آدرس</strong></td>';
echo '<td align="center"><strong>امکانات</strong></td>';
echo '</tr>';
while($row = mysql_fetch_assoc($result)){
$i = $i + 1;
echo '<tr>';
echo '<td align="center">'.$i.'</td>';
echo '<td align="center">'.$row["name"].'</td>';
echo '<td align="center">'.$row["responsibleName"].'</td>';
echo '<td align="center">'.$row["tel1"].'</td>';
echo '<td align="center">'.$row["mobile1"].'</td>';
echo '<td align="center">'.$row["email1"].'</td>';
echo '<td align="center">'.$row["address1"].'</td>';
echo '<td align="center">
<a href="?id=' .$row['id']. '"><img src="images/delete.png" border="0" title="حذف این رکورد" width="20" height="20" alt="delete" style="margin:5px auto 0 auto"></a>
<a href="?edit_id='.$row['id'].'"><img src="images/edit.png" border="0" title="ویرایش رکورد" width="20" height="20" alt="delete" style="margin:2px auto"></a>
<a href="#"><img class="toggle" src="images/more.png" border="0" title="اطلاعات بیشتر" width="20" height="20" alt="delete" style="margin:0 auto 5px auto"></a>
</td>';
echo '</tr>';
echo '<tr>
<td colspan="9">
<div class="detail">
<button class="moreDetail">پست مسئول: <b>'.$row["responsiblePosition"].'</b></button>
<button class="moreDetail">نوع شرکت: <b>'.$row["type"].'</b></button>
<button class="moreDetail">زمینه فعالیت: <b>'.$row["activityField"].'</b></button>
<button class="moreDetail">نوع خدمات: <b>'.$row["servicesType"].'</b></button>
<button class="moreDetail">سایر: <b>'.$row["otherDesc"].'</b></button>
<br>
<button class="moreDetail">تلفن 2: <b>'.$row["tel2"].'</b></button>
<button class="moreDetail">تلفن 3: <b>'.$row["tel3"].'</b></button>
<button class="moreDetail">موبایل 2: <b>'.$row["mobile2"].'</b></button>
<button class="moreDetail">فکس: <b>'.$row["fax"].'</b></button>
<br>
<button class="moreDetail">کد پستی 1: <b>'.$row["postalCode1"].'</b></button>
<button class="moreDetail">آدرس 2: <b>'.$row["address2"].'</b></button>
<button class="moreDetail">کد پستی 2: <b>'.$row["postalCode2"].'</b></button>
<button class="moreDetail">سایر آدرس ها: <b>'.$row["otherAddresses"].'</b></button>
<br>
<button class="moreDetail">وبسایت: <b>'.$row["webSite"].'</b></button>
<button class="moreDetail">ایمیل 2: <b>'.$row["email2"].'</b></button>
<button class="moreDetail">سایر: <b>'.$row["otherE"].'</b></button>
<br>
<button class="moreDetail">توضیحات: <b>'.$row["description"].'</b></button>
</div>
</td>
</tr>
';
echo '<tr></tr>';
}
echo '</table>';
}
?>
</table>
</form>
</div>
<br />
<?php
ob_flush();
?>