+- Sinisterly (https://sinister.li)
+-- Forum: Coding (https://sinister.li/Forum-Coding)
+--- Forum: PHP (https://sinister.li/Forum-PHP)
+--- Thread: Simple Class For MySQL/PHP (/Thread-Simple-Class-For-MySQL-PHP)
Simple Class For MySQL/PHP - 3541642 - 01-16-2013
A brief Class of frequently used MySQL functions.
Code:
<?php
// Define for MySQL //////////////////////////////////////////////
define('LOCALHOST','localhost');
define('DB_USER','****');
define('DB_PASS','****');
define('DB_NAME','****');
////////////////////////////////////////////////////////
// Class
////////////////////////////////////////////////////////
class DB {
var $host; // host
var $user; // user
var $pass; // pass
var $db; // MySQL_LinkID
var $database; // DB name
///////////////////////////////////////////////////////
// construct
///////////////////////////////////////////////////////
function DB() {
$this->host = LOCALHOST;
$this->user = DB_USER;
$this->pass = DB_PASS;
$this->database = DB_NAME;
}
///////////////////////////////////////////////////////
// Connection
///////////////////////////////////////////////////////
function con() {
$this->db = mysql_connect($this->host,$this->user,$this->pass);
if ( !$this->db ) {
die ('mysql connect error : ' . mysql_error());
}
$db_selected = mysql_select_db($this->database,$this->db);
if (!$db_selected) {
die ('mysql select db error : ' . mysql_error());
}
}
///////////////////////////////////////////////////////
// Close
///////////////////////////////////////////////////////
function close() {
mysql_close($this->db);
}
///////////////////////////////////////////////////////
// Query
///////////////////////////////////////////////////////
function query($query) {
$res = mysql_query($query,$this->db) or die("error : " . mysql_error($this->db)."<br />".$query);
return $res;
}
}
////////////////////////////////////////////////////////
// ShortCut Function
////////////////////////////////////////////////////////
// mysql_num_rows
function mnr($res) {
$num = mysql_num_rows($res);
return $num;
}
// mysql_fetch_assoc
function mfa($res) {
$rec = mysql_fetch_assoc($res);
return $rec;
}
// mysql_fetch_array
function mfar($res) {
$rec = mysql_fetch_array($res);
return $rec;
}
?>Simple Class For MySQL/PHP - 3541642 - 01-16-2013
A brief Class of frequently used MySQL functions.
Code:
<?php
// Define for MySQL //////////////////////////////////////////////
define('LOCALHOST','localhost');
define('DB_USER','****');
define('DB_PASS','****');
define('DB_NAME','****');
////////////////////////////////////////////////////////
// Class
////////////////////////////////////////////////////////
class DB {
var $host; // host
var $user; // user
var $pass; // pass
var $db; // MySQL_LinkID
var $database; // DB name
///////////////////////////////////////////////////////
// construct
///////////////////////////////////////////////////////
function DB() {
$this->host = LOCALHOST;
$this->user = DB_USER;
$this->pass = DB_PASS;
$this->database = DB_NAME;
}
///////////////////////////////////////////////////////
// Connection
///////////////////////////////////////////////////////
function con() {
$this->db = mysql_connect($this->host,$this->user,$this->pass);
if ( !$this->db ) {
die ('mysql connect error : ' . mysql_error());
}
$db_selected = mysql_select_db($this->database,$this->db);
if (!$db_selected) {
die ('mysql select db error : ' . mysql_error());
}
}
///////////////////////////////////////////////////////
// Close
///////////////////////////////////////////////////////
function close() {
mysql_close($this->db);
}
///////////////////////////////////////////////////////
// Query
///////////////////////////////////////////////////////
function query($query) {
$res = mysql_query($query,$this->db) or die("error : " . mysql_error($this->db)."<br />".$query);
return $res;
}
}
////////////////////////////////////////////////////////
// ShortCut Function
////////////////////////////////////////////////////////
// mysql_num_rows
function mnr($res) {
$num = mysql_num_rows($res);
return $num;
}
// mysql_fetch_assoc
function mfa($res) {
$rec = mysql_fetch_assoc($res);
return $rec;
}
// mysql_fetch_array
function mfar($res) {
$rec = mysql_fetch_array($res);
return $rec;
}
?>Simple Class For MySQL/PHP - 3541642 - 01-16-2013
A brief Class of frequently used MySQL functions.
Code:
<?php
// Define for MySQL //////////////////////////////////////////////
define('LOCALHOST','localhost');
define('DB_USER','****');
define('DB_PASS','****');
define('DB_NAME','****');
////////////////////////////////////////////////////////
// Class
////////////////////////////////////////////////////////
class DB {
var $host; // host
var $user; // user
var $pass; // pass
var $db; // MySQL_LinkID
var $database; // DB name
///////////////////////////////////////////////////////
// construct
///////////////////////////////////////////////////////
function DB() {
$this->host = LOCALHOST;
$this->user = DB_USER;
$this->pass = DB_PASS;
$this->database = DB_NAME;
}
///////////////////////////////////////////////////////
// Connection
///////////////////////////////////////////////////////
function con() {
$this->db = mysql_connect($this->host,$this->user,$this->pass);
if ( !$this->db ) {
die ('mysql connect error : ' . mysql_error());
}
$db_selected = mysql_select_db($this->database,$this->db);
if (!$db_selected) {
die ('mysql select db error : ' . mysql_error());
}
}
///////////////////////////////////////////////////////
// Close
///////////////////////////////////////////////////////
function close() {
mysql_close($this->db);
}
///////////////////////////////////////////////////////
// Query
///////////////////////////////////////////////////////
function query($query) {
$res = mysql_query($query,$this->db) or die("error : " . mysql_error($this->db)."<br />".$query);
return $res;
}
}
////////////////////////////////////////////////////////
// ShortCut Function
////////////////////////////////////////////////////////
// mysql_num_rows
function mnr($res) {
$num = mysql_num_rows($res);
return $num;
}
// mysql_fetch_assoc
function mfa($res) {
$rec = mysql_fetch_assoc($res);
return $rec;
}
// mysql_fetch_array
function mfar($res) {
$rec = mysql_fetch_array($res);
return $rec;
}
?>RE: Simple Class For MySQL/PHP - The Alchemist - 01-16-2013
Nice... SELECT, INSERT, DELETE, UPDATE, etc everything will work. Good that you've given fetch_assoc, fetch_array and num_rows too. Could you make release the same class in PDO too?
You've used mysql. Its the oldest and quite outdated. PDO is faster and better.
RE: Simple Class For MySQL/PHP - The Alchemist - 01-16-2013
Nice... SELECT, INSERT, DELETE, UPDATE, etc everything will work. Good that you've given fetch_assoc, fetch_array and num_rows too. Could you make release the same class in PDO too?
You've used mysql. Its the oldest and quite outdated. PDO is faster and better.
RE: Simple Class For MySQL/PHP - The Alchemist - 01-16-2013
Nice... SELECT, INSERT, DELETE, UPDATE, etc everything will work. Good that you've given fetch_assoc, fetch_array and num_rows too. Could you make release the same class in PDO too?
You've used mysql. Its the oldest and quite outdated. PDO is faster and better.
RE: Simple Class For MySQL/PHP - hackarchives - 01-24-2013
I remember when i made my sql class..It was fun..Some opinion
Use mysqli or PDO
Add more functions..I just contains the basic ones
RE: Simple Class For MySQL/PHP - soldi3r - 01-24-2013
It's nice sql class. I always tried to learn sql but couldn't..
