codemonkey2480
asked on
PHP code Spot the error
Please take a look at the attached code. There is no error reported when I hit the URL, but no output shows up too. Even the ECHO or PRINT statement don't output anything.
Can you please help me find out what the issue is?
Can you please help me find out what the issue is?
<?php
// Setup
$testing = true; // in development
require_once(dirname(__FILE__).'/../config.inc');
$db = new OCIDatabase();
// Start/End dates
if($testing)
{
$yesterday = mktime(0, 0, 0, 12, 27, 2010); // determin what yesterday was
$now = time();
//$now = mktime(0, 0, 0, 12, 28, 2010); // determin what yesterday was
}
else
{
$yesterday = mktime(0, 0, 0, date('m'), date('d')-1, date('Y')); // determin what yesterday was
$now = time();
}
// 1. send QES log[report] emails to IT address(es)
// - select ClientId,TableName,Count from admin_log_qes order by TableName,clientid
$reports_sql = "Select log.ClientId,log.TableName,log.Count
From
admin_log_qes log
Where
log.logstamp >= TO_TIMESTAMP('".date('d', $yesterday).".".date('m', $yesterday).".".date('Y', $yesterday).":18:00:00','DD.MM.YYYY:HH24:MI:SS')
AND
log.logstamp < TO_TIMESTAMP('".date('d', $now).".".date('m', $now).".".date('Y', $now).":".date('H', $now).":".date('i', $now).":00','DD.MM.YYYY:HH24:MI:SS')";
Print "Test";
if($db->select($reports_sql))
{
$message = "Report logs from " . date("m/d/Y H:i", strtotime("-24 hours")) . " to " . date("m/d/Y H:i") . ":\n\n";
while($log = $db->fetch_assoc())
{
$message .= " --" . $log['TABLENAME'] . "\n";
}
if($testing)
{
echo $message . "\n\n";
//Util::sendEMail(EMAIL_IT, "no-reply@" . $_SERVER['HTTP_HOST'], 'Report Logs', $message);
}
else
{
Util::sendEMail(EMAIL_IT, "no-reply@" . $_SERVER['HTTP_HOST'], 'Report Logs', $message);
}
}
?>
ASKER
How do I find out? I have not worked with PHP much.
add between lines 6/7
if (!is_object($db)) {
die("no object");
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, if you have access, check your server's error logs
ASKER
added these 2 lines
ini_set('display_errors',1 );
error_reporting( E_ALL );
and found out there was an issue referencing a config file.
Fixed the issue.
thanks all.
ini_set('display_errors',1
error_reporting( E_ALL );
and found out there was an issue referencing a config file.
Fixed the issue.
thanks all.
Darren