Patulong nmn po mga kasymbianize newbie po sa php. Maraming salamat po. Gumagana nmn po cya sa localhost. pero sa hosting yan po error.
Fatal error: Call to a member function prepare() on null in /srv/disk15/2514008/www/kawayan.co.nf/admin/Furniture.php on line 40
ito po code ko sa db:
<?php
$DB_HOST = 'fdb7.biz.nf';
$DB_USER = '2514008_kawayandb';
$DB_PASS = 'kawayan123';
$DB_NAME = 'kawayandb';
try{
$DB_con = new PDO("mysql:host={$DB_HOST};dbname={$DB_NAME}",$DB_USER,$DB_PASS);
$DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $DB_con;
}
catch(PDOException $e){
echo 'Connection failed: '.$e->getMessage();
}
at ito nmn po sa display:
<?php
$stmt = $DB_con->prepare('SELECT ID, Name, Description, Image FROM tbl_prod ORDER BY ID DESC'); // ito po ung error
$stmt->execute();
if($stmt->rowCount() > 0)
{
while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
extract($row);
?>
<div class="col-md-3 col-sm-12 text-center" >
<p class="page-header"><?php echo $Name." / ".$Description; ?></p>
<img src="user_images/<?php echo $row['Image']; ?>" class="img-rounded" width="250px" height="250px" />
<a class="btn btn-info" href="editform.php?edit_id=<?php echo $row['ID']; ?>" title="click for edit" onclick="return confirm('Are you sure you want to edit this record ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger" href="?delete_id=<?php echo $row['ID']; ?>" title="click for delete" onclick="return confirm('Are you sure to delete this record?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
</span>
</div>
<?php
}
Fatal error: Call to a member function prepare() on null in /srv/disk15/2514008/www/kawayan.co.nf/admin/Furniture.php on line 40
ito po code ko sa db:
<?php
$DB_HOST = 'fdb7.biz.nf';
$DB_USER = '2514008_kawayandb';
$DB_PASS = 'kawayan123';
$DB_NAME = 'kawayandb';
try{
$DB_con = new PDO("mysql:host={$DB_HOST};dbname={$DB_NAME}",$DB_USER,$DB_PASS);
$DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $DB_con;
}
catch(PDOException $e){
echo 'Connection failed: '.$e->getMessage();
}
at ito nmn po sa display:
<?php
$stmt = $DB_con->prepare('SELECT ID, Name, Description, Image FROM tbl_prod ORDER BY ID DESC'); // ito po ung error
$stmt->execute();
if($stmt->rowCount() > 0)
{
while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{
extract($row);
?>
<div class="col-md-3 col-sm-12 text-center" >
<p class="page-header"><?php echo $Name." / ".$Description; ?></p>
<img src="user_images/<?php echo $row['Image']; ?>" class="img-rounded" width="250px" height="250px" />
<a class="btn btn-info" href="editform.php?edit_id=<?php echo $row['ID']; ?>" title="click for edit" onclick="return confirm('Are you sure you want to edit this record ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger" href="?delete_id=<?php echo $row['ID']; ?>" title="click for delete" onclick="return confirm('Are you sure to delete this record?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
</span>
</div>
<?php
}
Last edited: