<?php
require_once('auth.php');
require_once("../_private/password.php");
//create new connection
echo $_SESSION['SESS_NAME'];
echo "<br /><a href='index.php'>صفحه نخست</a><br />";
$con = mysqli_connect($myhost,$myuser,$mypasswd,$mydb);
if(mysqli_connect_errno()) {
echo "<strong>خطا در برقراری ارتباط با پایگاه داده</strong>";
exit();
}
/*---------------------------------------------------*/
if($_REQUEST[form] == 'insert'){
$query ="SELECT * FROM rez_clinic";
$result = mysqli_query($con,$query);
if(mysqli_num_rows($result) == 1){
echo "<script>alert('امکان ثبت بیش از یک کلینیک وجود ندارد..!');</script>";
echo "<script>window.location = 'clinic.php';</script>";
} else {
?>
<form action="clinic.php?check=insert" method="POST">
<label for="name" >عنوان</label>
<input name="name" type="text" />
<br />
<label for="tel1" >شماره تماس 1</label>
<input name="tel1" type="text" />
<br />
<label for="tel2" >شماره تماس 2</label>
<input name="tel2" type="text" />
<br />
<label for="tel3" >شماره تماس 3</label>
<input name="tel3" type="text" />
<br />
<label for="fax" >شماره فکس</label>
<input name="fax" type="text" />
<br />
<label for="address" >آدرس</label>
<input name="address" type="text" />
<br />
<input type="submit" value="ثبت" />
</form>
<?php
}
/*---------------------------------------------------*/
} elseif($_REQUEST[check] == 'insert'){
$id= 1;
$name= $_POST['name'];
$tel1= $_POST['tel1'];
$tel2= $_POST['tel2'];
$tel3= $_POST['tel3'];
$fax= $_POST['fax'];
$address= $_POST['address'];
mysqli_set_charset($con,"utf8");
$query ="SELECT * FROM rez_clinic";
$result = mysqli_query($con,$query);
if(mysqli_num_rows($result) == 1){
echo "امکان ثبت بیش از یک کلینیک وجود ندارد..!";
}else{
mysqli_set_charset($con,"utf8");
$query= mysqli_query($con,"insert into rez_clinic (clinic_id,clinic_name,clinic_tel1,clinic_tel2,cli nic_tel3,clinic_fax,clinic_address)
values('$id','$name','$tel1','$tel2','$tel3','$fax ','$address');");
if(mysqli_affected_rows($con)>0){
header(location: clinic.php);
exit();
} else {
die('مشکلی بوجود آمده است !');
}
}
/*---------------------------------------------------*/
} elseif($_REQUEST[form] == 'edit'){
mysqli_set_charset($con,"utf8");
$query ="SELECT * FROM rez_clinic WHERE clinic_id=1";
$result = mysqli_query($con,$query);
$fech = mysqli_fetch_assoc($result);
?>
<form action="clinic.php?ckeck=edit" method="POST">
<label for="name" >عنوان</label>
<input name="name" type="text" value="<?php echo $fech['clinic_name']; ?>" />
<br />
<label for="tel1" >شماره تماس 1</label>
<input name="tel1" type="text" value="<?php echo $fech['clinic_tel1']; ?>" />
<br />
<label for="tel2" >شماره تماس 2</label>
<input name="tel2" type="text" value="<?php echo $fech['clinic_tel2']; ?>" />
<br />
<label for="tel3" >شماره تماس 3</label>
<input name="tel3" type="text" value="<?php echo $fech['clinic_tel3']; ?>" />
<br />
<label for="fax" >شماره فکس</label>
<input name="fax" type="text" value="<?php echo $fech['clinic_fax']; ?>" />
<br />
<label for="address" >آدرس</label>
<input name="address" type="text" value="<?php echo $fech['clinic_address']; ?>" />
<br />
<input type="submit" value="ویرایش" />
</form>
<?php
/*---------------------------------------------------*/
} elseif($_REQUEST[ckeck] == 'edit'){
$id= 1;
$name= $_POST['name'];
$tel1= $_POST['tel1'];
$tel2= $_POST['tel2'];
$tel3= $_POST['tel3'];
$fax= $_POST['fax'];
$address= $_POST['address'];
mysqli_set_charset($con,"utf8");
$query= mysqli_query($con,"UPDATE rez_clinic SET clinic_id='".$id."' , clinic_name='".$name."' , clinic_tel1='".$tel1."' , clinic_tel2='".$tel2."' , clinic_tel3='".$tel3."' , clinic_fax='".$fax."' , clinic_address='".$address."' WHERE clinic_id=1");
header(location: clinic.php);
exit();
/*---------------------------------------------------*/
} elseif($_REQUEST[form] == 'delete'){
$query ="DELETE FROM rez_clinic WHERE clinic_id=1";
$result = mysqli_query($con,$query);
header(location: clinic.php);
exit();
} else {
mysqli_set_charset($con,"utf8");
$query ="SELECT * FROM rez_clinic WHERE clinic_id=1";
$result = mysqli_query($con,$query);
$fech = mysqli_fetch_assoc($result);
echo "<br /><a href='clinic.php?form=insert'>ثبت اطلاعات</a><br />";
echo "<br /><a href='clinic.php?form=edit'>ویرایش اطلاعات</a><br />";
echo "<br /><a href='clinic.php?form=delete'>حذف اطلاعات</a><br />";
?>
نام : <?php echo $fech['clinic_name']; ?><br />
شماره تماس 1 : <?php echo $fech['clinic_tel1']; ?><br />
شماره تماس 2 : <?php echo $fech['clinic_tel2']; ?><br />
شماره تماس 3 : <?php echo $fech['clinic_tel3']; ?><br />
شماره فکس : <?php echo $fech['clinic_fax']; ?><br />
آدرس : <?php echo $fech['clinic_address']; ?><br />
<?php } ?>