SQL Class

//example of how to use at bottom
class mySQL
{

var $my_host;
var $my_username;
var $my_password;
var $my_port;
var $my_database;


var $my_connection;
var $is_alive;

var $sql_query;

var $default_field_sep = "|";

function mySQL($host, $un = "", $pw = "", $port = "") {

if (empty($port)) $port = "3306";
$this->my_host = $host;
$this->my_username = $un;
$this->my_password = $pw;
$this->my_port = $port;

$this->my_connection = mysql_connect($host . ":" . $port, $un, $pw) or die(mysql_error());
$this->is_alive = TRUE;
}

function SelectDB($db) {
$this->my_database = $db;
if ($this->is_alive !== TRUE) {
echo "You must be connected to a server before choosing a database.";
return;
}

mysql_select_db($this->my_database) or die(mysql_error());
}

function SqlClose() {
if ($this->is_alive === TRUE) {
mysql_close($this->my_connection) or die(mysql_error());
$this->is_alive = FALSE;
}
}

function SqlPut($table, $fields, $data) {

if ($this->is_alive !== TRUE) {
echo "You must be connected to a server before inputting data.";
return;
}

$seperator = $this->default_field_sep;
$tmp_query;

$field_arr = explode($seperator, $fields);
$data_arr = explode($seperator, $data);

if ( (count($field_arr)) != (count($data_arr)) ) {
echo "You must supply the same number of fields as data.";
return;
}

$tmp_query .= "INSERT INTO `" . $table . "` (";
for ($i = 0; $i < count($field_arr); $i++) {
$tmp_query .= "`" . $field_arr[$i] . "`";
if ($i < (count($field_arr) - 1)) $tmp_query .= ", ";
}
$tmp_query .= ") VALUES (";

for ($i = 0; $i < count($data_arr); $i++) {
$tmp_query .= "'" . $data_arr[$i] . "'";
if ($i < (count($data_arr) - 1)) $tmp_query .= ", ";
}
$tmp_query .= ");";

$this->SqlQuery($tmp_query);
}

function SqlFetchRow() {
if ($this->is_alive === TRUE) {
if (!empty($this->sql_query)) {
return @mysql_fetch_array($this->sql_query);
}
}
}

function SqlQuery($query) {
if ($this->is_alive === TRUE) {
$this->sql_query = "";
$this->sql_query = mysql_query($query) or die(mysql_error());
}
}

function SqlNumRows() {
if ($this->is_alive === TRUE) {
if (!empty($this->sql_query)) {
return @mysql_num_rows($this->sql_query);
}
}
}
}

$sql = new mySQL("db2.phenominet.com", "shantanuo", "");
$sql->SelectDB("shantanuo"); //selects database
$sql->SqlPut("ashprojects_users", "userid|fullname", "userboy|andhispassword");
$sql->SqlClose(); //closes sql connection

?>

test

योगस्चित्तव्रुत्ति निरोधह
कय मे मरथि मधे पत्र लिहु शक्तो?
हे खोओप सोपे आहे.
ज़र असेच चलोओ रेअहिले तर मे एन्ग्लिश ल दुम्प करोओन मरथि मधे सम्भशन सुद्द करु शकेन आसे वत्ते आहे.

Add to the links toolbar

Add to the links toolbar: "Click and drag these links to your Links Toolbar. If the links toolbar is not visible, click on View menu - Toolbars option and then click on Links. If you want to delete any link, right click and choose delete. If you want to change the sequence, click and drag the links on the links toolbar.
Increase Font refresh the page (F5) for normal font Hide Images makes images invisible - after they've loaded. Refresh the page to restore images.
view selection Open the selected text in a new browser window Stylesheet switches stylesheets on and off.
Find Displays all occurrences of a word on a page by highlighting each one with a yellow background. Select any word on the page and click on this link.** Thesaurus Find more words "