Archive for the ‘Programming’ Category
How to connect to a Database from PHP
Thursday, January 3rd, 2008
A few days ago I posted a tutorial on How to connect to a Database from VB.Net, now I am showing you how to do the same with PHP.
The method I use is very similar to the one I use with VB, I have a class called db_interfase, and I create an object whenever I need to interact with the database.
-
class db_interfase
-
{
-
var $conn;
-
var $dataset;
-
-
function db_interfase($sql)
-
{
-
$this->executesql($sql);
-
}//db_interfase
-
-
function opendb()
-
{
-
$db_username="dbuser";
-
$db_password="dbpass";
-
$db_server="dbserver";
-
$db_database="db";
-
-
$this->conn = mysql_pconnect($db_server,$db_username,$db_password)or die ('Error connecting to mysql');
-
}//opendb
-
-
function executesql($sql)
-
{
-
$this->opendb();
-
$this->dataset = mysql_query($sql) or die('Error, query failed ' . $offset . $rowsperpage . mysql_error() . $sql );
-
}//executesql
-
-
}//Class
This is a live example, this code is running on Wiisteria.com
-
public function insert($user,$game,$fc)
-
{
-
$sql = "insert into usergames(user,game,fc) values($user,$game,$fc)";
-
-
$ds = new db_interfase($sql);
-
}//insert
The magic is done here
-
$ds = new db_interfase($sql);
There you create the db_interfase object with the query as the parameter, and then it returns a dataset ($ds) which you can manipulate whenever you see fit. That code also works for selects and updates, for example.
-
public function selectgamesbytitle($title)
-
{
-
$sql = "Select username from usergames ug join wifigames wfg on ug.game=wfg.game where wfg title = '$title' ";
-
-
$ds = new db_interfase($sql);
-
-
return $ds->dataset;
-
}//selectgamesbytitle
Then you could manipulate $ds like this.
The class can be downladed here, if you have questions just post them and Ill try to answer them.
How to connect to a Database from VB.Net
Saturday, December 29th, 2007
It's been a LONG time since my last programming "tutorial" so let's see how this goes.
When I was a noob (not like I am much of an expert now) I used to write code every time I wanted to connect to a database, as time went on I discovered the advantages of using classes and reusable functions or objects for repeatable tasks, like connecting to a database, and came up with a class named dbinterfase.
When to use it:
On middle to large projects I usually have a class for every table that the application will interact with and its in the methods of those classes that I create the dbinterfase object.
Example:
-
Public Sub jobcategory_insert(ByVal description As String)
-
Dim cmd As SqlCommand
-
Dim sql As String
-
Try
-
'Create the dbinterfase object
-
Dim dbOp As New dbinterfase
-
-
sql = "jobcategory_insert"
-
'Create a new command with the object connection
-
cmd = New SqlCommand(sql, dbOp.Conn)
-
cmd.CommandType = CommandType.StoredProcedure
-
cmd.Parameters.Add(New SqlParameter("@description", description))
-
-
cmd.ExecuteNonQuery()
-
'Close the database when done
-
dbOp.CloseDatabase()
-
Catch ex As Exception
-
Throw New Exception("job:jobcategory_insert " & ex.Message)
-
End Try
-
End Sub
-
<connectionstrings>
-
<remove name="LocalSqlServer"/>
-
<add name="dbConexion" connectionString="Server=KAISERLAPTOP\SQLEXPRESS;Database=clasificados;Uid=clasific;Pwd=clasific;Trusted_Connection=no"/>
-
</connectionstrings>
Very simple, clean and elegant. I have an equivalent class for PHP that I will be posting in a few days.
