Tema: dw+php+mysql
Ver Mensaje Individual
  #8 (permalink)  
Antiguo 09/07/2007, 16:01
seres
 
Fecha de Ingreso: junio-2007
Mensajes: 10
Antigüedad: 16 años, 10 meses
Puntos: 0
Re: dw+php+mysql

la segunda parte
//----------------------------
$query_rssearch = sprintf("SELECT * FROM tp2000 WHERE aceptante LIKE CONCAT('%%', %s, '%%')", GetSQLValueString($colname_rssearch, "text"));
$query_limit_rssearch = sprintf("%s LIMIT %d, %d", $query_rssearch, $startRow_rssearch, $maxRows_rssearch);
$rssearch = mysql_query($query_limit_rssearch, $tp2000) or die(mysql_error());
$row_rssearch = mysql_fetch_assoc($rssearch);
if (isset($_GET['totalRows_rssearch'])) {
$totalRows_rssearch = $_GET['totalRows_rssearch'];
} else {
$all_rssearch = mysql_query($query_rssearch);
$totalRows_rssearch = mysql_num_rows($all_rssearch);
}
$totalPages_rssearch = ceil($totalRows_rssearch/$maxRows_rssearch)-1;

$queryString_rssearch = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_rssearch") == false &&
stristr($param, "totalRows_rssearch") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_rssearch = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_rssearch = sprintf("&totalRows_rssearch=%d%s", $totalRows_rssearch, $queryString_rssearch);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/madarina_rst.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>.:: Sistema de Informacion Crediticia ::. .:. E-Info .:.</title>
<!-- InstanceEndEditable -->
<link rel="stylesheet" type="text/css" href="gorotron1.css"/>
<style type="text/css">
<!--
body {
background-image: url(images/bg1b.gif);
}
.Estilo1 {
color: #FFFFFF;
font-weight: bold;
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 24px;
}
.Estilo2 {
font-size: 10px;
color: #FF9900;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.Estilo4 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
}
.Estilo5 {
font-size: 12px;
color: #FFFFFF;
}
.Estilo7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; }
.Estilo8 {color: #000066}
.Estilo11 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; color: #FFFFFF; }
.Estilo12 {color: #FFFFFF; }
.Estilo15 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 16px; color: #000066; }
.Estilo16 {font-size: 9px}
.Estilo18 {font-size: 10px; color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; }
.Estilo19 {font-size: 12px}
.Estilo20 {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; color: #000066; }
-->
</style><!-- InstanceEndEditable -->
</head>

<body>
<div align="center">
<table width="699" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<!--DWLayoutTable-->
<tr>
<td width="14" height="14"></td>
<td width="149"></td>
<td width="14"></td>
<td width="502"></td>
<td width="20"></td>
</tr>
<tr>
<td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="15" height="100">&nbsp;</td>
</tr>
</table></td>
<td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
<!--DWLayoutTable-->
<tr>
<td width="145" height="100" valign="top"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="149" height="100">
<param name="movie" value="flash/logo_einfo.swf" />
<param name="quality" value="high" />
<embed src="flash/logo_einfo.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="149" height="100"></embed>
</object></td>
</tr>
</table></td>
<td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="15" height="100">&nbsp;</td>
</tr>
</table></td>
<td height="100" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">
<!--DWLayoutTable-->
<tr>
<td width="26" height="43">&nbsp;</td>
<td width="411">&nbsp;</td>
<td width="65">&nbsp;</td>
</tr>
<tr>
<td height="42"></td>
<td valign="top"><div align="left"><span class="Estilo1">E - Info <br />
<span class="Estilo2">Sistema de informaci&oacute;n Crediticia </span></span></div></td>
<td></td>
</tr>
<tr>
<td height="15"></td>
<td></td>
<td></td>
</tr>

</table></td>
<td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="15" height="100">&nbsp;</td>
</tr>
</table></td>
</tr>
<tr>
<td height="6"></td>
</tr>


<tr>
<td height="15" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="699" height="15"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="846"></td>
<td colspan="3" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F0F0F0">
<!--DWLayoutTable-->
<tr>
<td width="11" height="81">&nbsp;</td>
<!-- InstanceBeginEditable name="resultados" -->

<td width="641" valign="top"><p class="Estilo8">Ingrese el nombre del Aceptante y presione Buscar.<br />
*Para una busqueda efectiva ingrese el nombre Completo y sus Apellidos*
</p>
<form id="form1" name="form1" method="get" action="search_.php">
<table width="610" height="0%" border="0" bordercolor="#006666">
<tr>
<td width="126" height="100%"><div align="center" class="Estilo15">
<div align="right">ACEPTANTE:</div>
</div></td>
<td width="364"><label>
<input name="nombre" type="text" id="nombre" size="60" />
</label></td>
<td width="106"><input type="submit" name="Submit" value="BUSCAR" /></td>
</tr>
<tr>
<td height="100%">&nbsp;</td>
<td><span class="Estilo20">||| <a href="<?php echo $logoutAction ?>" class="Estilo20">Salir</a> |||</span></td>
<td>&nbsp;</td>
</tr>
</table>
</form>