shiamjiz Posted January 18, 2010 Share Posted January 18, 2010 Can anyone help me convert mysqli to mysql <?php // load configuration file require_once('config.php'); // load error handling file require_once('error_handler.php'); // class handles server side whiteboard support functionality class Whiteboard { // database handler private $mMysqli; // define the number of maximum records in the table private $mMaxLoad = 5000; /* constructor opens database connection */ function __construct() { $this->mMysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE); } /* destructor, closes database connection */ function __destruct() { $this->mMysqli->close(); } /* The checkLoad method clears the whiteboard table if it contains more than a specified number of records */ public function checkLoad() { // build the SQL query to get the number of lines $check_load = 'SELECT SUM(length) total_length FROM whiteboard'; // execute the SQL query $result = $this->mMysqli->query($check_load); $row = $result->fetch_array(MYSQLI_ASSOC); // if the number of lines exceeds the maximum number of lines // we delete all the entries in the table if($row['total_length'] > $this->mMaxLoad) { // clear the whiteboard $this->clearWhiteboard(); // flag that we cleared the whiteboard return true; } else return false; // we didn't clear the whiteboard } /* The insertLines method inserts new lines into the database - $lines contains the lines as received by the server as a string with separators - $session_id contains the id of the client's session */ public function insertLines($lines, $session_id) { // check to see if there are new lines sent if($lines) { // the lines are comma separated $array_lines = explode(',', $lines); // process each line for($i=0; $i<count($array_lines); $i++) { // each line is received in the form: // color:offsetx1:offsety1:offsetyx2:offsety2 list($color, $offsetx1, $offsety1, $offsetx2, $offsety2) = explode(':', $array_lines[$i]); // escape the input data $color = $this->mMysqli->real_escape_string($color); $offsetx1 = $this->mMysqli->real_escape_string($offsetx1); $offsetx2 = $this->mMysqli->real_escape_string($offsetx2); $offsety1 = $this->mMysqli->real_escape_string($offsety1); $offsety2 = $this->mMysqli->real_escape_string($offsety2); // build the SQL query to insert a new line $insert_line = 'INSERT INTO whiteboard ' . ' (offsetx1, offsety1, offsetx2, offsety2, length, color, session_id) ' . 'VALUES (' . $offsetx1 . ',' . $offsety1 . ',' . $offsetx2 . ',' . $offsety2 . ',' . sqrt(pow(($offsetx1-$offsetx2), 2) + pow(($offsety1-$offsety2), 2)) . ',"'.$color. '","' . $session_id . '")'; // execute the SQL query $this->mMysqli->query($insert_line); } } } /* The getNewLines method returns the lines that appeared since the last update - $id contains the id of the last updated line - $session_id contains the id of the client's session */ public function getNewLines($id, $session_id) { // escape the variable data $id = $this->mMysqli->real_escape_string($id); $session_id = $this->mMysqli->real_escape_string($session_id); // retrieve the latest ID in the database $last_id = $this->getLastId(); // build the SQL query to get the latest lines $get_lines = 'SELECT whiteboard_id, color, offsetx1, offsety1, offsetx2, offsety2 ' . 'FROM whiteboard ' . 'WHERE whiteboard_id IN ' . ' (SELECT MAX(whiteboard_id) ' . ' FROM whiteboard ' . ' WHERE whiteboard_id> ' . $id . ' GROUP BY offsetx1, offsety1, offsetx2, offsety2) ' . 'AND session_id<>"' . $session_id . '" ' . 'ORDER BY whiteboard_id ASC'; // execute the SQL query $result = $this->mMysqli->query($get_lines); // build the XML response $response = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'; $response .= '<response>'; // get the last id in the database $response .= '<last_id>' . $last_id . '</last_id>'; // send back the session id $response .= '<session_id>' . $session_id . '</session_id>'; // retrieve all lines and send them back to the client while($row = $result->fetch_array(MYSQLI_ASSOC)) { // get the details $id = $row['whiteboard_id']; $offsetx1 = $row['offsetx1']; $offsety1 = $row['offsety1']; $offsetx2 = $row['offsetx2']; $offsety2 = $row['offsety2']; $color = $row['color']; // generate the XML element $response .= '<id>' . $id . '</id>' . '<color>' . $color . '</color>' . '<offsetx1>' . $offsetx1 . '</offsetx1>' . '<offsety1>' . $offsety1 . '</offsety1>' . '<offsetx2>' . $offsetx2 . '</offsetx2>' . '<offsety2>' . $offsety2 . '</offsety2>'; } // close the database connection as soon as possible $result->close(); // finish the XML response $response .= '</response>'; // return the response return $response; } /* The clearWhiteboard method truncates the data table */ public function clearWhiteboard() { // build the SQL query to truncate the whiteboard table $clear_wb = 'TRUNCATE TABLE whiteboard'; // execute the SQL query $this->mMysqli->query($clear_wb); } /* The getLastId method returns the most recent whiteboard_id */ private function getLastId() { // build the SQL query to retrieve the last id in the whiteboard table $get_last_id = 'SELECT whiteboard_id ' . 'FROM whiteboard ' . 'ORDER BY whiteboard_id DESC ' . 'LIMIT 1'; // execute the SQL query $result = $this->mMysqli->query($get_last_id); // check to see if there are any results if($result->num_rows > 0) { // fetch the row containing the result $row = $result->fetch_array(MYSQLI_ASSOC); // return the xml element return $row['whiteboard_id']; } else // there are no records in the database so we return 0 as the id return '0'; } //end class Whiteboard } ?> Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/ Share on other sites More sharing options...
trq Posted January 18, 2010 Share Posted January 18, 2010 Can anyone help me convert mysqli to mysql Sure, where are you stuck? Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/#findComment-997010 Share on other sites More sharing options...
shiamjiz Posted January 18, 2010 Author Share Posted January 18, 2010 Thnks for replying me. This is how i have converted to an extend <?php // load configuration file require_once('config.php'); // load error handling file require_once('error_handler.php'); // class handles server side whiteboard support functionality class Whiteboard { // database handler var $dbc; var $result; // define the number of maximum records in the table var $mMaxLoad = 5000; /* constructor opens database connection */ function __construct() { $this->dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); mysql_select_db(DB_DATABASE, $this->dbc); } /* destructor, closes database connection */ function __destruct() { mysql_close($this->dbc); $this->dbc = null; } /* The checkLoad method clears the whiteboard table if it contains more than a specified number of records */ public function checkLoad() { // build the SQL query to get the number of lines $check_load = 'SELECT SUM(length) total_length FROM whiteboard'; // execute the SQL query $result = $this->result=mysql_query($check_load,$this->dbc); $row = mysql_fetch_array($this->result,MYSQL_ASSOC); // if the number of lines exceeds the maximum number of lines // we delete all the entries in the table if($row['total_length'] > $this->mMaxLoad) { // clear the whiteboard $this->clearWhiteboard(); // flag that we cleared the whiteboard return true; } else return false; // we didn't clear the whiteboard } /* The insertLines method inserts new lines into the database - $lines contains the lines as received by the server as a string with separators - $session_id contains the id of the client's session */ public function insertLines($lines, $session_id) { // check to see if there are new lines sent if($lines) { // the lines are comma separated $array_lines = explode(',', $lines); // process each line for($i=0; $i<count($array_lines); $i++) { // each line is received in the form: // color:offsetx1:offsety1:offsetyx2:offsety2 list($color, $offsetx1, $offsety1, $offsetx2, $offsety2) = explode(':', $array_lines[$i]); // escape the input data $color = mysql_real_escape_string($color,$this->dbc); $offsetx1 = mysql_real_escape_string($offsetx1,$this->dbc); $offsetx2 = mysql_real_escape_string($offsetx2,$this->dbc); $offsety1 = mysql_real_escape_string($offsety1,$this->dbc); $offsety2 = mysql_real_escape_string($offsety2,$this->dbc); // build the SQL query to insert a new line $insert_line = 'INSERT INTO whiteboard ' . ' (offsetx1, offsety1, offsetx2, offsety2, length, color, session_id) ' . 'VALUES (' . $offsetx1 . ',' . $offsety1 . ',' . $offsetx2 . ',' . $offsety2 . ',' . sqrt(pow(($offsetx1-$offsetx2), 2) + pow(($offsety1-$offsety2), 2)) . ',"'.$color. '","' . $session_id . '")'; // execute the SQL query $result = $this->result=mysql_query($insert_line,$this->dbc); } } } /* The getNewLines method returns the lines that appeared since the last update - $id contains the id of the last updated line - $session_id contains the id of the client's session */ public function getNewLines($id, $session_id) { // escape the variable data $id = mysql_real_escape_string($id,$this->dbc); $session_id = mysql_real_escape_string($session_id,$this->dbc); // retrieve the latest ID in the database $last_id = $this->getLastId(); // build the SQL query to get the latest lines $get_lines = 'SELECT whiteboard_id, color, offsetx1, offsety1, offsetx2, offsety2 ' . 'FROM whiteboard ' . 'WHERE whiteboard_id IN ' . ' (SELECT MAX(whiteboard_id) ' . ' FROM whiteboard ' . ' WHERE whiteboard_id> ' . $id . ' GROUP BY offsetx1, offsety1, offsetx2, offsety2) ' . 'AND session_id<>"' . $session_id . '" ' . 'ORDER BY whiteboard_id ASC'; // execute the SQL query $result = $this->result=mysql_query($get_lines,$this->dbc); // build the XML response $response = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'; $response .= '<response>'; // get the last id in the database $response .= '<last_id>' . $last_id . '</last_id>'; // send back the session id $response .= '<session_id>' . $session_id . '</session_id>'; // retrieve all lines and send them back to the client while($row = mysql_fetch_array($this->result,MYSQL_ASSOC)) { // get the details $id = $row['whiteboard_id']; $offsetx1 = $row['offsetx1']; $offsety1 = $row['offsety1']; $offsetx2 = $row['offsetx2']; $offsety2 = $row['offsety2']; $color = $row['color']; // generate the XML element $response .= '<id>' . $id . '</id>' . '<color>' . $color . '</color>' . '<offsetx1>' . $offsetx1 . '</offsetx1>' . '<offsety1>' . $offsety1 . '</offsety1>' . '<offsetx2>' . $offsetx2 . '</offsetx2>' . '<offsety2>' . $offsety2 . '</offsety2>'; } // close the database connection as soon as possible $result->close(); // finish the XML response $response .= '</response>'; // return the response return $response; } /* The clearWhiteboard method truncates the data table */ public function clearWhiteboard() { // build the SQL query to truncate the whiteboard table $clear_wb = 'TRUNCATE TABLE whiteboard'; // execute the SQL query $this->result=mysql_query($clear_wb,$this->dbc); } /* The getLastId method returns the most recent whiteboard_id */ private function getLastId() { // build the SQL query to retrieve the last id in the whiteboard table $get_last_id = 'SELECT whiteboard_id ' . 'FROM whiteboard ' . 'ORDER BY whiteboard_id DESC ' . 'LIMIT 1'; // execute the SQL query $result = $this->result=mysql_query($get_last_id,$this->dbc); // check to see if there are any results if($result->num_rows > 0) { // fetch the row containing the result $row = mysql_fetch_array($this->result,MYSQL_ASSOC); // return the xml element return $row['whiteboard_id']; } else // there are no records in the database so we return 0 as the id return '0'; } //end class Whiteboard } ?> It shows error on $row = mysql_fetch_array($this->result,MYSQL_ASSOC); saying supplied argument is not a valid mysql result source Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/#findComment-997026 Share on other sites More sharing options...
trq Posted January 18, 2010 Share Posted January 18, 2010 That error simply means your query has failed and you haven't checked it before passing its result to mysql_fetch_array. mysql_query does not return an object. this line.... if($result->num_rows > 0) should be.... if (mysql_num_rows($result)) Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/#findComment-997092 Share on other sites More sharing options...
shiamjiz Posted January 18, 2010 Author Share Posted January 18, 2010 Thanks for helping me..seems an urgent work for me.. can you have a look and check whether my conversions are correct?? The solution you does not solve it... Regards Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/#findComment-997105 Share on other sites More sharing options...
fenway Posted January 18, 2010 Share Posted January 18, 2010 Please use code tags next time... and don't as for help on skype. Link to comment https://forums.phpfreaks.com/topic/188848-help-me-to-convert-mysqli-to-mysql/#findComment-997509 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.