PHP Classes

File: test.php

Recommend this page to a friend!
  Classes of markitos  >  cmysql_mset  >  test.php  >  Download  
File: test.php
Role: ???
Content type: text/plain
Description: Test
Class: cmysql_mset
Author: By
Last change:
Date: 21 years ago
Size: 5,480 bytes
 

Contents

Class file image Download
<? #: Test de la clase CMySQL_MSet. #: |[|mArKitos|]| ]]xP[[ Style ?><HTML> <HEAD> <TITLE>Test De La Clase CMySQL_MSet</TITLE> </HEAD> <BODY BGCOLOR="#FFCC00"><? #: Incluimos clase y creamos un objeto instanciando la clase. include ("./CMySQL_MSet.class.inc"); $Exito = $Fallo = 0; #: TEST 1 echo "<H3> TEST 1 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); #: Preparamos sentencia y la ejecutamos $Test_SQL = "Select * From test"; $Resultado = $TCMySQL -> ExecSQL($Test_SQL); if ($Resultado != 0){ echo " OK</H3>\n"; $Exito += 1; } else { $Fallo += 1; echo " Failed</H3>\n"; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 2 echo "<H3><H3> TEST 2 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); #: Preparamos sentencia y la ejecutamos $Test_SQL = "Select nombres From test Where nombres='Markitos'"; $Resultado = $TCMySQL -> ExecSQL($Test_SQL); if ($Resultado != 0){ echo " OK</H3>\n"; $Exito += 1; } else { echo " Failed</H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 3 echo "<H3> TEST 3 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchIn("test", "id, nombres","markitos", "1"); if (count ($Resultado) == 1){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 4 echo "<H3> TEST 4 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchIn("test", "id, nombres", "pepitos", "2"); if (count ($Resultado) == 1){ echo " Failed </H3>\n"; $Fallo += 1; } else { echo " OK </H3>\n"; $Exito += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 5 echo "<H3> TEST 5 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchIn("test", "id, nombres", "I", "2"); if (count ($Resultado) == 3){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 6 echo "<H3> TEST 6 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchIn("test", "id, nombres", "pEpItO", "1"); if ($Resultado[0] == 2){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 7 echo "<H3> TEST 7 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchAdv("test", "id, nombres", "pEpItO", "1", "1", "0", ""); if (!$Resultado){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 8 echo "<H3> TEST 8 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchAdv("test", "id, nombres", "Pepito", "1", "1", "0", ""); if ($Resultado[0] == 2){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 9 echo "<H3> TEST 9 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchAdv("test", "id, nombres", "Pep", "0", "1", "0", ""); if ($Resultado[0] == 2){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 10 echo "<H3> TEST 10 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Resultado = $TCMySQL->SearchAdv("test", "id, nombres", "pEpItO", "1", "1", "0", ""); if (!$Resultado){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); #: TEST 11 echo "<H3> TEST 11 => "; $TCMySQL = new CMySQL_MSet ('cmysql_mset', 'cmysql_mset', 'cmysql_mset', 'localhost'); $TCMySQL->OpenConnection(); $Clausula = "WHERE id='1'"; $Resultado = $TCMySQL->SearchAdv("test", "id, nombres", "mArKitos", "1", "0", "1", "$Clausula"); if ($Resultado[0] == 1){ echo " OK </H3>\n"; $Exito += 1; } else { echo " Failed </H3>\n"; $Fallo += 1; } #: Cerramos conexion $TCMySQL -> CloseConnection(); ?><BR><HR><BR><? $Porc = ($Exito*100)/11; if (eregi ("([0-9]+)\.[0-9]*",$Porc, $Items)){ $Porc = $Items[1]; } echo "<H3>Test Pasados...........: $Exito</H3>\n"; echo "<H3>Test Fallidos..........: $Fallo</H3><HR>\n"; echo "<H1>Porcentaje De Exito: ", $Porc , "% <H1><HR>\n"; ?></BODY> </HTML><? ?>