Below is code of database.php file.
<?php
class Database
{
var $con;
var $db;
var $result;
var $data;
public function connect($server="localhost",$uname="cccsql",$pword="ccc123",$db="trainees_jinal")
{
try
{
$con=mysql_connect($server,$uname,$pword);
if(!$con)
{
throw new Exception("Error: Cannot connect to the server");
return;
}
$db=mysql_select_db($db,$con);
if(!$db)
{
throw new Exception("Error: Cannot connect to the database");
return;
}
return $this;
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function insert($sql)
{
try
{
$res=mysql_query($sql);
if(!$res)
throw new Exception("record insertion failed...");
if($res)
{
return mysql_insert_id();
}
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function update($sql)
{
try
{
$res=mysql_query($sql);
if(!$res)
throw new Exception("record updation failed...");
return $res;
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function delete($sql)
{
try
{
$res=mysql_query($sql);
if(!$res)
throw new Exception("record deletion failed...");
return $res;
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function fetchAll($sql)
{
try
{
$res=mysql_query($sql);
if(!$res)
throw new Exception("error on query execution record...");
$arr=array();
while($row=mysql_fetch_assoc($res))
{
array_push($arr,$row);
}
return $arr;
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function fetchRow($sql)
{
try
{
$res=mysql_query($sql);
if(!$res)
throw new Exception("error on query execution record...");
if($row=mysql_fetch_array($res))
{
return $row;
}
return NULL;
}
catch(Exception $e)
{
echo $e->getMessage();
}
}
public function num_fields($result)
{
return mysql_num_fields($result);
}
public function field_name($result,$i)
{
return mysql_field_name($result,$i);
}
private function wrap_with_quotes($data)
{
return sprintf('"%s"', $data);
}
?>
And now below is my code for display.php file.
<br/>
<a href="index.php"><button>New Registration</button></a>
<br><br><br/>
<form method="post">
<table width="" border="1" cellspacing="0" cellpadding="" align="center" >
<tr>
<th>Check</th>
<th> ID</th>
<th>Name</th>
<th>Age</th>
<th>Gender</th>
<th>Contact</th>
<th>Email</th>
<th>UserName</th>
<th>Password</th>
<th>Billing Address </th>
<th>Shipping Address </th>
<th>Action</th>
</tr>
<?php
require_once 'database.php';
$database = new Database;
$q="SELECT * FROM personalinfo INNER JOIN addrsinfo ON personalinfo.id=addrsinfo.id";
while($rows=$database->fetchRow($q))
{
?>
<tr>
<td align="center"><input name="checkbox[]" type="checkbox" value="<?php echo $rows['id']; ?>"></td>
<td ><? echo $rows['id']; ?></td>
<td width="40%" nowrap="2"><? echo $rows['name'];?> </td>
<td width="10%"><? echo $rows['age']; ?></td>
<td width="20%"><? echo $rows['gender']; ?></td>
<td width="30%"><? echo $rows['contact']; ?></td>
<td width="30%"><? echo $rows['email']; ?></td>
<td width="30%"><? echo $rows['uname']; ?></td>
<td width="20%"><? echo $rows['paswrd']; ?></td>
<td width="50%"><? echo $rows['billaddr']; ?></td>
<td width="50%"><? echo $rows['shipaddr']; ?></td>
<td><a href="edit.php?id=<?=$rows['id'] ?>">Edit</a></td>
</tr>
<?php }?>
</table>
<tr>
<td>
<input type="submit" name="submit" value="Multi Delete">
</td>
</tr>
<?php
if(isset($_POST['submit']))
{
$checkbox[] = $_POST['checkbox'];
if(sizeof($checkbox[0])>1)
{
$id=implode(",",$checkbox[0]);
$query = "DELETE FROM personalinfo WHERE id IN($id)";
$database->delete($query);
}
else
{
$id=$checkbox[0][0];
$query = "DELETE FROM personalinfo WHERE id='$id'";
$database->delete($query);
}
echo"<script>window.location='display.php';</script>";
}
if(isset($_POST['submit']))
{
$checkbox[] = $_POST['checkbox'];
if(sizeof($checkbox[0])>1)
{
$id=implode(",",$checkbox[0]);
$query = "DELETE FROM addrsinfo WHERE id IN($id)";
$database->delete($query);
}
else
{
$id=$checkbox[0][0];
$query = "DELETE FROM addrsinfo WHERE id='$id'";
$database->delete($query);
}
echo"<script>window.location='display.php';</script>";
}
?>
</form>
</table>
So my question is how can i use FetchRow and FetchAll method in my display.php file.I am a beginner and trying to learn OOP with PHP.Help me as soon as possible.
Please check the below code and help me as my loop goes in infinite mode.
<?php
require_once 'database.php';
$database = new Database;
$database->connect();
$q="SELECT * FROM personalinfo INNER JOIN addrsinfo ON personalinfo.id=addrsinfo.id";
?>
<?php
while($rows=$database->fetchRow($q))
{
?>
<tr>
<td align="center"><input name="checkbox[]" type="checkbox" value="<?php echo $rows['id']; ?>"></td>
<td ><? echo $rows['id']; ?></td>
<td width="40%" nowrap="2"><? echo $rows['name'];?> </td>
<td width="10%"><? echo $rows['age']; ?></td>
<td width="20%"><? echo $rows['gender']; ?></td>
<td width="30%"><? echo $rows['contact']; ?></td>
<td width="30%"><? echo $rows['email']; ?></td>
<td width="30%"><? echo $rows['uname']; ?></td>
<td width="20%"><? echo $rows['paswrd']; ?></td>
<td width="50%"><? echo $rows['billaddr']; ?></td>
<td width="50%"><? echo $rows['shipaddr']; ?></td>
</tr>
<?php }?>
