/****************BEGIN MAIN PHP SECTION************************/ error_reporting(0); function Perform_Select_Query ($SQL, $db) { $Query = mysql_db_query($db, $SQL); $my_err=mysql_error(); if ($my_err) { $my_err = "Error: ".$my_err; mysql_free_result ($Query); return $my_err; } else { $row=0; $num_fields = mysql_num_fields($Query); for ($i=0;$i < $num_fields; $i++) { $fieldname[$i]=mysql_field_name($Query,$i); } while ($result_array_1 = mysql_fetch_array($Query)) { for ($i=0;$i < $num_fields; $i++) { $this_fieldname = $fieldname[$i]; $result_array[$this_fieldname][$row] = $result_array_1[$this_fieldname]; } $row++; } mysql_free_result ($Query); return $result_array; } } function Get_Rows ($SQL, $db) { $Query = mysql_db_query($db, $SQL); $my_err=mysql_error(); if ($my_err) { $my_err = "Error: ".$my_err; mysql_free_result ($Query); return $my_err; } else { $Query_Rows = mysql_num_rows($Query); mysql_free_result ($Query); return $Query_Rows; } } function Get_Fields ($SQL, $db) { $Query=mysql_db_query($db, $SQL); $my_err=mysql_error(); if ($my_err) { $my_err = "Error: ".$my_err; mysql_free_result ($Query); return $my_err; } else { $num_fields = mysql_num_fields($Query); mysql_free_result ($Query); return $num_fields; } } function Get_Field_Names ($SQL, $db) { $Query=mysql_db_query($db, $SQL); $my_err=mysql_error(); if ($my_err) { $my_err = "Error: ".$my_err; mysql_free_result ($Query); return $my_err; } else { $num_fields = mysql_num_fields($Query); for ($i=0; $i<$num_fields; $i++) { $field[$i] = mysql_fetch_field ($Query); } mysql_free_result ($Query); return $field; } } function Perform_Query ($SQL, $db) { $Query = mysql_db_query($db, $SQL); $my_err=mysql_error(); if ($my_err) { $my_err = "Error: ".$my_err; } return $my_err; } if ($Submit) { $dbname="smeber_com"; $dbuser="smeberco"; $dbpass="PaCo1939"; $hostname="localhost"; $lnk = mysql_connect($hostname, $dbuser, $dbpass); $lnk1 = mysql_select_db($dbname); $SQL=stripslashes($SQL); $tmpTable="tmp".substr(time(), 4, 4); if (($Monodrogasearch !="") or ($Comercialsearch !="") or ($Presentacionsearch !="") or ($Laboratoriosearch !="") ) { $tempSQL="CREATE TABLE $tmpTable Select Monodroga, Comercial, Presentacion, Laboratorio from VadeAmplio"; $tempSQL_Result=Perform_Query($tempSQL, $dbname); $SQL="select * from $tmpTable where Monodroga like '%$Monodrogasearch%' and Comercial like '%$Comercialsearch%' and Presentacion like '%$Presentacionsearch%' and Laboratorio like '%$Laboratoriosearch%' order by Comercial limit 0,40"; } else { $SQL="Select Monodroga, Comercial, Presentacion, Laboratorio from VadeAmplio order by Comercial limit 0,40"; } $SQL_rows = Get_Rows($SQL, $dbname); $row=0; $SQL_Result = Perform_Select_Query($SQL, $dbname); if (substr($SQL_Result, 0, 5)=="Error") $Error=1; $SQL_fields=Get_Fields($SQL, $dbname); $SQL_fieldnames=Get_Field_Names($SQL, $dbname); $tempDropSQL="DROP TABLE $tmpTable"; $tempDropSQL_Result = Perform_Query($tempDropSQL, $dbname); } // End of Submit Section /********************END MAIN PHP SECTION*********************/ ?> /****************BEGIN HTML SECTION************************/ ?> /**HTML CODE BELOW CAN BE MODIFIED TO FIT YOUR WEB SITE****/ ?> /**********DO NOT EDIT SECTIONS ENCLOSED BY ?> **********/ ?>
Vademécum OSBA
Ingrese en los casilleros de abajo, el dato que conozca (o parte), acerca del medicamento que desea buscar.
No es necesario completar todos los campos -
Monodroga:
Nombre Comercial
Presentacion
Laboratorio
Encontrados print ($SQL_rows); ?>
if ($Submit) { ?>
if ($Error) { ?>
Error buscando print ($SQL_Result); ?>
} else { ?>
} ?>
Monodroga
Nombre Comercial
Presentacion
Laboratorio
while ($row <$SQL_rows) { ?>
for ($fields=0; $fields < $SQL_fields; $fields++) { ?> $field=$SQL_fieldnames[$fields]->name; ?>
print ($SQL_Result[$field][$row]) ?>
} ?>
$row++; ?> } ?> } ?>