redho home | products | services

Programming Forums


Community for Java, PHP, Perl C, ASP and Python programmers
Wednesday 18 September 2019 17:43

Ask your IT question here

OOPS - MySQL



 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Programming Forums -> Database discussion forum
View previous topic :: View next topic  
Author Message
gilbertsavier
New Programmer


Joined: 02 Jul 2009
Posts: 21
Hey guys,
I am looking for help with my OOPS code for connecting to MySQL, just for people that don't know what OOPS is Object Oriented Programming.

I am trying to connect to my database (MSQL) using this technology, however all my coding just does not seem to be working

The first code I tried was this one, however since i am on a shared server it seems that mysqli does not work??? DONT ask me why.
and as i am trying to make something for other site owners to use i need it to work with out them having to contact there administrators asking them to allow mysqli
$mysqli = new mysqli("localhost", "desvisa_v", "******", "desvisa_site");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}


if ($result = $mysql->query("SELECT title FROM push_content LIMIT 10")) {
printf("Select returned %d rows.\n", $result->num_rows);

/* free result set */
$result->close();
}

$mysqli->close();
My second code, well i did not make the code, just copied and paste, BUT man it is way to confussing and i am just not understanding it.
class MyDatabase
{
// The var that stores the last
// used SQL statement
var $SQLStatement = "";

// The var that stores the error
// (if any)
var $Error = "";

function MyDatabase()
{
// Config for the database
// connection
$this->DBUser = "desvisa_v";
$this->DBPass = "*****";
$this->DBName = "desvisa_site";
$this->DBHost = "localhost";
}

function Connect()
{
//Connect to a mysql database
$this->db = mysql_connect($this->DBHost,
$this->DBUser, $this->DBPass) or
die("MYSQL ERROR: ".mysql_error());
// Select the database
mysql_select_db($this->DBName,
$this->db) or die("MYSQL ERROR:
".mysql_error());
}

// Disconnect from the MYSQL database
function Disconnect()
{
mysql_close($this->db) or die("MYSQL
ERROR: ".mysql_error());
}
}
So if any one can come up with a OOPS way to connect to a mysql database, I would be forever in your debt.
_________________
Thanks & regards
Lokananth

Live Chat Software By miOOt

Reply with quote
 
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Programming Forums -> Database discussion forum


Dubai Forums - Expat Help | Vegan Forum | Java Programming | 3d Design Resources | 3d Forum | 3D Jobs | 3D Textures | Paris Forum | Europe Forum
Dubai Classifieds | Dubai Property | Jobs in Dubai | Free London Classifieds | Jobs in London UK

High Quality, Custom 3d animation and Web Design solutions Royal Quality Web Hosting Services Vegetarian and Animal Rights news

© 2018 RedHo