'Fatal error: Cannot redeclare my_iud() (previously declared in C:\xampp\htdocs\lifecare\dbconfigure.php:8)
im trying to log in to a specific user account but im getting this error while signing in
Fatal error: Cannot redeclare my_iud() (previously declared in C:\xampp\htdocs\lifecare\dbconfigure.php:8) in C:\xampp\htdocs\lifecare\dbconfigure.php on line 8
this is my patient login code
<section class="page_breadcrumbs ls ms section_padding_25 bg_image">
<div class="container">
<div class="row">
<div class="col-sm-12 text-center">
<h2 class="small">Patient Login</h2>
</div>
</div>
<ol class="breadcrumb bottom_breadcrumbs">
<li> <a href="./">
Home
</a> </li>
<li class="active">Patient Login</li>
</ol>
</div>
</section>
<section class="ls columns_padding_25 section_padding_top_100 section_padding_bottom_100">
<div class="container">
<div class="row">
<div class="col-sm-12">
<h3 class="module-header">Login</h3>
</div>
</div>
<div class="row">
<div class="col-md-8 to_animate" data-animation="scaleAppear">
<form method="post" enctype="multipart/form-data">
<div class="row">
<form method="POST" action='patientlogin.php'>
<div class="col-sm-12">
<div class="inpbox">
<!--<label for="email">Email address<span class="required">*</span></label>-->
  <i class="fa fa-envelope highlight2" aria-hidden="true"></i>
<input type="email" style="border:none;" name="emailid" placeholder="Email Address">
</div>
</div>
<div class="col-sm-12">
<div class="inpbox">
  <i class="fas fa-key highlight2" aria-hidden="true"></i>
<input type="password" size="30" style="border:none;" name="password" placeholder="Password">
</div>
</div>
<div class="col-sm-6 bottommargin_0 ">
<div>
<button type="submit" id="contact_form_submit" name="submit" class="theme_button color2 wide_button margin_0">Login</button> </div>
</div>
<div class="col-sm-6 bottommargin_0 ">
<div>
<a href="patientsignup.php" id="contact_form_submit" class="theme_button color2 wide_button margin_0">SignUp</a> </div>
</div>
</div>
</form>
</form>
</div>
<div class="col-md-4 to_animate" data-animation="scaleAppear">
<img src="images/loginphoto.jpg" style="height : 300px">
</div>
</div>
</div>
</section>
<!-- Start Footer -->
<?php include('./comnpages/footer.php'); ?>
<!-- End Footer -->
</div>
<!-- eof #box_wrapper -->
</div>
<!-- eof #canvas -->
<script src="js/compressed.js"></script>
<script src="js/main.js"></script>
<!-- Google Map Script -->
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=AIzaSyDTwYSMRGuTsmfl2z_zZDStYqMlKtrybxo"></script>
</body>
</html>
<?php
session_start();
include "dbconfigure.php";
if(isset($_POST['submit']))
{
$emailid = mysqli_real_escape_string($cid, $_POST['emailid']);
$password =mysqli_real_escape_string($cid, $_POST['password']);
$query = "SELECT count(*) from patient where emailid='$emailid' and password='$password'";
$n = my_one($query);
if($n==1)
{
echo $_SESSION['semailid']=$emailid;
echo $_SESSION['password']=$password;
if(isset($_GET['id']))
{
echo '<script>
window.location="patient/patienthome.php";
</script>';
header("location:patient/bookappointment.php?id=".$_GET['id']);
}
else
{
header("location:patient/patienthome.php");
}
}
else
{
echo '<script>alert("Invalid Login Credentials.")</script>';
}
}
?>
and this is the dbconfig file
<?php
$dbserver="localhost"; //localhost
$dbuser="root";
$dbpwd="";
$dbname="doctors_appointment";
function my_iud($query)//insert , update , delete
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid=mysqli_connect('localhost','root','','doctors_appointment','4306') or die("connection failed");
//mysql_select_db($dbname,$cid);
mysqli_query($cid,$query);
$n=mysqli_affected_rows($cid);
mysqli_close($cid);
return $n;
}
function my_select($query)
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid=mysqli_connect('localhost','root','','doctors_appointment','4306') or die("connection failed");
//mysql_select_db($dbname,$cid);
$rs=mysqli_query($cid,$query);
mysqli_close($cid);
return $rs;
}
//to be used when sql query returns a single value
function my_one($query)
{
global $dbserver,$dbuser,$dbpwd,$dbname;
$cid=mysqli_connect('localhost','root','','doctors_appointment','4306') or die("connection failed");
//mysql_select_db($dbname,$cid);
$rs=mysqli_query($cid,$query);
$row=mysqli_fetch_array($rs,MYSQLI_NUM);
mysqli_close($cid);
return $row[0];
}
function verifyuser()
{
$u="";
$p="";
/*if(isset($_COOKIE['cemailid']) && isset($_COOKIE['cpassword']))
{
$u=$_COOKIE['cemailid'];
$p=$_COOKIE['cpassword'];
}
else
{*/
if(isset($_SESSION['semailid']) && isset($_SESSION['spassword']))
{
$u=$_SESSION['semailid'];
$p=$_SESSION['spassword'];
}
//}
$query="select count(*) from patient where emailid='$u' and password='$p'";
$n=my_one($query);
if($n==1)
{
return true;
}
else
{
return false;
}
}
?>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
