Hi, I need to convert php to coldfusion. Would appreciate some help, thanks....
<?php
#First we include our credentials file
# FileName="connect.php"
$hostname = "localhost";
$database = "nimsoftslmdev";
$username = "root";
$password = "xxx";
#And now we connect to the database
//connection String
//connection String
$con = mysql_connect($hostname, $username, $password) or die('Could not
connect: ' . mysql_error());
//select database
mysql_select_db($database, $con);
//Select The database
$bool = mysql_select_db($database, $con);
if ($bool === False){
print "can't find $database";
}
$start = ($_REQUEST["start"] == null)? 0 : $_REQUEST["start"];
$limit = ($_REQUEST["limit"] == null)? 200 : $_REQUEST["limit"];
// Gather all pending requests
$query = "SELECT
nimid,
level,
message,
source
FROM nas_alarms" ;
$query .= " ORDER BY level ASC ";
$query .= " LIMIT ".$start.",".$limit;
$result = mysql_query($query, $con);
// Here we do the count
$query_c = "SELECT
nimid,
level,
message,
source
FROM nas_alarms" ;
//get total
$count_result = mysql_query($query_c, $con);
$total = mysql_num_rows($count_result);
if (mysql_num_rows($result) > 0){
while($obj = mysql_fetch_object($result))
{
$arr[] = $obj;
}
// Now create the json array to be sent to our datastore
$myData = array('myInventory' => $arr, 'totalCount' => $total);
echo json_encode($myData);
return;
exit();
}
else { // If no requests found, we return nothing
$myData = array('myInventory' => '', 'totalCount' => '0');
echo json_encode($myData);
return;
exit();
}
?>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349374
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
