UserLibrary - MySQL interface

Flype · Post by **Flype** » Mon Mar 26, 2007 7:18 pm

Here is an object oriented include for MySQL5.

those who are familiar with php/mysql might appreciate this way of coding.

this is free - as always.

ABOUT HELP:
sorry no doc at the moment.
just look at the include file which is clear enough.
if somebody is courageous enough to make a doc it will be much appreciated as i do not have time for this.

NOTE:
please adjust in the file 'libmysql.pbi', at line 92 your path for the libmysql.lib.

ARCHIVE:
UserLib_PB40_libmysql.zip

SAMPLE CODE:

Code: Select all

IncludeFile "libmysql.pbi"

db.IMYSQL = mysql("localhost", "root", "", "mysql")

If db
  
  If db\query("SELECT 'Hello' AS 'f1', 'World !' AS 'f2', NOW() as 'f3', 12345.6789")
    
    While db\row()
      
      Debug db\GetString("f1")
      Debug db\GetString("f2")
      
      Debug FormatDate("%dd.%mm.%yyyy", db\GetDate("f3"))
      
      Debug db\get_double(3)
      
    Wend
    
  Else
    
    Debug db\error()
    
  EndIf
  
  db\free()
  
EndIf

Beach · Post by **Beach** » Mon Mar 26, 2007 8:15 pm

Man, those French coders are awesome. Good job Flype! You are right, it does work similarly to the way PHP/MySQL code construction works, and that is perfect for me.

Post by **Fred** » Mon Mar 26, 2007 8:17 pm

Nice work !

benny · Post by **benny** » Mon Mar 26, 2007 8:28 pm

Didn't test it yet. But your example code looks just fantastic ! Thanks a lot
for sharing it

GeoTrail · Post by **GeoTrail** » Mon Mar 26, 2007 8:54 pm

Any ideas how I can hide my login and password?

Beach · Post by **Beach** » Mon Mar 26, 2007 9:01 pm

GeoTrail wrote:Any ideas how I can hide my login and password?

The connection to the MySQL server encrypts the password (I would think the username also but the docs do not say this...) Obviously, your code could be compromised. Maybe a quick MD5 (or similar) procedure would take care of that.

http://dev.mysql.com/doc/refman/5.0/en/ ... ttack.html

Flype · Post by **Flype** » Mon Mar 26, 2007 9:35 pm

@geotrail

i made a little function in the include :

Code: Select all

myDB.IMySQL = mysql_from_ini()

this way no user/pwd in your program.

the .ini file should look :

Code: Select all

[CONNECTION]
host = localhost
user = root
pass = 
base = mysql
port = 3306
opts = 0

as the include is totally open-source, you can improve this procedure (line 1105) if you need an encrypted one - but let us know...

Flype · Post by **Flype** » Mon Mar 26, 2007 9:47 pm

@linux users

does it works on linux (.lib not provided) ?

GeoTrail · Post by **GeoTrail** » Mon Mar 26, 2007 10:14 pm

Thanks Flype.
My worry is that someone might get the username and password to the mysql database and they could take over control of it.

JCV · Post by **JCV** » Tue Mar 27, 2007 2:28 am

wow thats nice! thanks

Thalius · Post by **Thalius** » Tue Mar 27, 2007 11:01 am

Flype .. i love you !

.. i was gonna write something like this for a customer Project ...

Thalius

Razon · Post by **Razon** » Sat May 19, 2007 1:56 pm

I can't access online MySQL database

Why?

JCV · Post by **JCV** » Sat May 19, 2007 2:33 pm

Razon wrote:I can't access online MySQL database Why?

Check your host if you are allowed to directly access your mySQL online. Also check if there is an option where you can add your IP address to allow you to directly access it.

Razon · Post by **Razon** » Sat May 19, 2007 3:45 pm

I think, it doesn't let me direct access it, only from the webpage. Do you know any MySQL server to use?

Razon · Post by **Razon** » Sat May 19, 2007 4:40 pm

Oh I found one: www.freemysql.net