MySQL MSSQL Connect: Execute queries on MySQL and Microsoft SQL queries

Recommend this page to a friend!

Download .zip

Info

Example

View files (3)

Download .zip

Reputation

Support forum (1)

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 179		All time: 8,702 This week: 106

Version		License		PHP version		Categories
`mysqlmssqlconn` 1.0		The PHP License		5		PHP 5, Databases

Description

Author

Milton de Jes�s Flores Torres

This is a simple class can that can execute queries on MySQL and Microsoft SQL queries.

It provides two separate classes that can connect respectively to a MySQL or a Microsoft SQL database server.

The classes also provide functions with the same names to execute database queries, retrieve then number of rows in the query results, and retrieve the query result records into an array.

In Spanish:

Estas dos sencillas Clases que permiten conectarse de igual manera a Servidores Mysql o servidores MS SQL SERVER.

Comparten la misma estrutura, funciones, solo se diferenc�an en dos cosas,en la instancia y la conectividad.

Milton de Jes�s Flores ...

Name:	Milton de Jes�s Flores ... `<contact>`
Classes:	1 package by Milton de Jes�s Flores ...
Country:	Mexico
Age:	46
All time rank:	4191	50 in Mexico
Week rank:	398	9 in Mexico

Example


<?php


include('ConexionMySQL_I.php');





$db = new mySQL; // Creamos la instancia del objeto mysql





$strSQL = "SELECT * FROM educators";


$result = $db->executeQuery($strSQL);





$educatorsN = getNumRows($result);





if($educatorsN > 0)


{


  while($row = $db->fetchArray($result))


  {


    echo "Educador No. {$row[0]}, Nombre: {$row[1]}";


  } // fin de while


}else{


   echo "No hay educadores en la DB";


}





?>








// MS SQL SERVER








<?php


include('ConexionMSSQL.php');





$db = new msSQL; // Creamos la instancia del objeto MS SQL SERVER





$strSQL = "SELECT * FROM educators";


$result = $db->executeQuery($strSQL);





$educatorsN = getNumRows($result);





if($educatorsN > 0)


{


  while($row = $db->fetchArray($result))


  {


    echo "Educador No. {$row[0]}, Nombre: {$row[1]}";


  } // fin de while


}else{


   echo "No hay educadores en la DB";


}





?>