Advanced Search

db_query PHP function for ddbb queries with ADOdb Library

/ Published in: PHP
Save to your folder(s)
A PHP function to get a Record Set using ADOdb Library.

It takes the (SQL) query as an argument. For SELECT,UPDATE and DELETE queries.

It also need next variables: $db_host,$db_user,$db_passwd,$db_name (data from de bbdd connexion). Can be declared in the document itself.

It returns the Record Set.

It needs the ADOdb Library for php.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. function db_query($sql){
  2. 	global $db_host,$db_user,$db_passwd,$db_name; //Agafa variables globals (fora de la funcio).
  3. 	$conn=ADONewConnection('mysql'); //Instancia de ADODB para proveedor MySQL. Es pot elegir motor (segons parametre, podria ser oracle...)
  4. 	$conn->Connect($db_host,$db_user,$db_passwd,$db_name) ; // Connexion a MySQL. Usa el metodo Connect..
  5. 	$result=$conn->Execute("SET lc_time_names = 'ca_ES'  ;"); //Per adoptar idioma castellano�  (Per errors...)
  6. 	$result=$conn->Execute("SET NAMES UTF8 ;"); //Pel joc de caracters
  7. 	$rs=$conn->Execute($sql); // Ejecutar SQL y devuelve un ADORecordSet
  8. 	$conn->Close();
  9. 	return $rs; //Funcion devuelve todo el ADORecordSet.
  10. }

URL: http://phplens.com/adodb/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.