Reply to thread

Message

<blockquote data-quote="marles" data-source="post: 311940" data-attributes="member: 2333">Here's a simple class to manage your database.[PHP]&lt;?php&nbsp; &nbsp; class Database {&nbsp; &nbsp; &nbsp; &nbsp; protected $_con;&nbsp; &nbsp; &nbsp; &nbsp; protected $_query = '';&nbsp; &nbsp; &nbsp; &nbsp; protected $_where = array();&nbsp; &nbsp; &nbsp; &nbsp; protected $_whereTypeList = '';&nbsp; &nbsp; &nbsp; &nbsp; protected $_paramTypeList = '';&nbsp; &nbsp; &nbsp; &nbsp; protected $_bindParams = array('');&nbsp; &nbsp; &nbsp; &nbsp; public $queries_count;&nbsp; &nbsp; &nbsp; &nbsp; public function __construct($username = '',$password = '',$host = '',$database = '') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;con = new mysqli($host,$username,$password,$database);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;queries_count = 0;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Reset states after an execution&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return object Returns the current instance.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; protected function reset()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_where = array();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_bindParams = array('');&nbsp; &nbsp; &nbsp; &nbsp; // Create the empty 0 index&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_query = '';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_whereTypeList = '';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_paramTypeList = '';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; *&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @param string $query Contains a user-provided select query.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @param int $numRows The number of rows total to return.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return array Contains the returned rows from the query.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function query($query, $numRows = NULL)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_query = filter_var($query, FILTER_SANITIZE_STRING);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $stmt = mysqli_stmt_init($this-&gt;con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;prepare($query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $stmt-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;reset();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results = $stmt-&gt;get_result();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;queries_count = $this-&gt;queries_count + 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $results;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }?&gt;[/PHP]Call this[CODE]&lt;?phprequire 'connect.php';// Create's Connection$conn = new Database($db_host, $db_user, $db_pass, $db_database);// Gets into database &amp; posts data.$sql = &quot;SELECT id, username FROM users&quot;;$result = $conn-&gt;query($sql);if ($result-&gt;num_rows &gt; 0) {&nbsp; &nbsp; // Data is now posted.&nbsp; &nbsp; while($row = $result-&gt;fetch_assoc()) {&nbsp; &nbsp; &nbsp;&nbsp; echo 'User ID: &lt;b&gt;' . $row[&quot;id&quot;] . '&lt;/b&gt; - Username: &lt;b&gt;&lt;a href=&quot;' . $row[&quot;username&quot;] . '.php&quot;&gt;' . $row[&quot;username&quot;] . '&lt;/a&gt;&lt;/b&gt;&lt;br /&gt;';&nbsp; &nbsp; }} else {&nbsp; &nbsp; echo &quot;There are no registered users!&quot;;&nbsp;&nbsp; }?&gt;[/CODE]Don't know if it's secure or not... Been using it in my project...</blockquote>

[QUOTE="marles, post: 311940, member: 2333"] Here's a simple class to manage your database. [PHP]<?php class Database { protected $_con; protected $_query = ''; protected $_where = array(); protected $_whereTypeList = ''; protected $_paramTypeList = ''; protected $_bindParams = array(''); public $queries_count; public function __construct($username = '',$password = '',$host = '',$database = '') { $this->con = new mysqli($host,$username,$password,$database); $this->queries_count = 0; } /** * Reset states after an execution * @return object Returns the current instance. */ protected function reset() { $this->_where = array(); $this->_bindParams = array(''); // Create the empty 0 index $this->_query = ''; $this->_whereTypeList = ''; $this->_paramTypeList = ''; } /** * * @param string $query Contains a user-provided select query. * @param int $numRows The number of rows total to return. * @return array Contains the returned rows from the query. */ public function query($query, $numRows = NULL) { $this->_query = filter_var($query, FILTER_SANITIZE_STRING); $stmt = mysqli_stmt_init($this->con); $stmt->prepare($query); $stmt->execute(); $this->reset(); $results = $stmt->get_result(); $this->queries_count = $this->queries_count + 1; return $results; } } ?>[/PHP] Call this [CODE]<?php require 'connect.php'; // Create's Connection $conn = new Database($db_host, $db_user, $db_pass, $db_database); // Gets into database & posts data. $sql = "SELECT id, username FROM users"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Data is now posted. while($row = $result->fetch_assoc()) { echo 'User ID: ' . $row["id"] . ' - Username: <a href="' . $row["username"] . '.php">' . $row["username"] . '</a> '; } } else { echo "There are no registered users!"; } ?>[/CODE] Don't know if it's secure or not... Been using it in my project... [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members