Código:
Me podrian ayudar???<?php require_once('Connections/postgrados.php'); ?> <html> <head> <?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_Recordset2 = 1; $pageNum_Recordset2 = 0; if (isset($_GET['pageNum_Recordset2'])) { $pageNum_Recordset2 = $_GET['pageNum_Recordset2']; } $startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2; mysql_select_db($database_postgrados, $postgrados); $query_Recordset2 = "SELECT * FROM estudiante WHERE apellido LIKE '%$buscar%' or nombre LIKE '%$buscar%' or especializacion LIKE '%$buscar%' or rango LIKE '%$buscar%' or ciudadcasa LIKE '%$buscar%' or empresa LIKE '%$buscar%' or ciudadjob LIKE '%$buscar%' or cargo LIKE '%$buscar%' or usuario LIKE '%$buscar%' ORDER BY apellido"; $query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2); $Recordset2 = mysql_query($query_limit_Recordset2, $postgrados) or die(mysql_error()); $row_Recordset2 = mysql_fetch_assoc($Recordset2); if (isset($_GET['totalRows_Recordset2'])) { $totalRows_Recordset2 = $_GET['totalRows_Recordset2']; } else { $all_Recordset2 = mysql_query($query_Recordset2); $totalRows_Recordset2 = mysql_num_rows($all_Recordset2); } $totalPages_Recordset2 = ceil($totalRows_Recordset2/$maxRows_Recordset2)-1; $queryString_Recordset2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Recordset2") == false && stristr($param, "totalRows_Recordset2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Recordset2 = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Recordset2 = sprintf("&totalRows_Recordset2=%d%s", $totalRows_Recordset2, $queryString_Recordset2); ?> </head> <style type="text/css"> <!-- body,td,th { color: #FFFFFF; } body { background-color: #000000; } --> </style> <body> <?php if (!isset($buscar)){ echo "<p>Debe especificar </p>"; echo "<p><a href=formulario.php>Volver</p>"; echo "</html></body>"; exit; } $link = mysql_connect("localhost", "root","123456"); mysql_select_db("postgrados", $link); $sql = "SELECT * FROM estudiante WHERE apellido LIKE '%$buscar%' or nombre LIKE '%$buscar%' or especializacion LIKE '%$buscar%' or rango LIKE '%$buscar%' or ciudadcasa LIKE '%$buscar%' or empresa LIKE '%$buscar%' or ciudadjob LIKE '%$buscar%' or cargo LIKE '%$buscar%' or usuario LIKE '%$buscar%' ORDER BY apellido"; $result = mysql_query($sql, $link); if ($row = mysql_fetch_array($result)){ echo "<table border='1' align='left' cellpadding='1' cellspacing='1' bordercolor='#FFFFFF' bgcolor='#000000'>"; mysql_field_seek($result,0); while ($field = mysql_fetch_field($result)) do { echo "<tr>"; echo "<th>Apellido</th>"; echo "<th>:</th>"; echo "<th>".$row["apellido"]."</th>"; echo "<th>Nombre</th>"; echo "<th>:</th>"; echo "<th>".$row["nombre"]."</th>"; echo "</tr>"; echo "<tr>"; echo "<th>Cedula</th>"; echo "<th>:</th>"; echo "<td>".$row["cedula"]."</td>"; echo "<th>Codigo</th>"; echo "<th>:</th>"; echo "<td>".$row["codigo"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Ragon</th>"; echo "<th>:</th>"; echo "<td>".$row["rango"]."</td>"; echo "<th>Especializacion</th>"; echo "<th>:</th>"; echo "<td>".$row["especializacion"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Ciudad Res</th>"; echo "<th>:</th>"; echo "<td>".$row["ciudadcasa"]."</td>"; echo "<th>Direccion Casa</th>"; echo "<th>:</th>"; echo "<td>".$row["dircasa"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Tel Casa</th>"; echo "<th>:</th>"; echo "<td>".$row["telcasa"]."</td>"; echo "<th>Celular 1</th>"; echo "<th>:</th>"; echo "<td>".$row["celular1"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Celular 2</th>"; echo "<th>:</th>"; echo "<td>".$row["celular2"]."</td>"; echo "<th>Email 1</th>"; echo "<th>:</th>"; echo "<td>".$row["email1"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Email 2</th>"; echo "<th>:</th>"; echo "<td>".$row["email2"]."</td>"; echo "<th>Empresa</th>"; echo "<th>:</th>"; echo "<td>".$row["empresa"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Ciudad Trabajo</th>"; echo "<th>:</th>"; echo "<td>".$row["ciudadjob"]."</td>"; echo "<th>Cargo Emp</th>"; echo "<th>:</th>"; echo "<td>".$row["cargo"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Tel Job</th>"; echo "<th>:</th>"; echo "<td>".$row["teljob"]."</td>"; echo "<th>Observacion</th>"; echo "<th>:</th>"; echo "<td>".$row["observacion"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Fecha Ingreso</th>"; echo "<th>:</th>"; echo "<td>".$row["ingresoyear"]."</td>"; echo "<th>Usuario</th>"; echo "<th>:</th>"; echo "<td>".$row["usuario"]."</td>"; echo "</tr>"; echo "<tr>"; echo "<th>Password</th>"; echo "<th>:</th>"; echo "<td>".$row["password"]."</td>"; echo "<th>Nivel Acceso</th>"; echo "<th>:</th>"; echo "<td>".$row["nivel"]."</td>"; echo "</tr>"; } while ($row = mysql_fetch_array($result)); while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); echo "<p><a href=formulario.php>Volver</p>"; echo "</table>"; } else { echo "<p>¡Cambie el campo a buscar!</p>"; echo "<p><a href=formulario.php>Volver</p>"; } ?> <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, max(0, $pageNum_Recordset2 - 1), $queryString_Recordset2); ?>"></a> <table border="0" width="50%" align="LEFT"> <tr> <td width="23%" align="center"><?php if ($pageNum_Recordset2 > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, 0, $queryString_Recordset2); ?>"><img src="First.gif" border=0></a> <?php } // Show if not first page ?> </td> <td width="31%" align="center"><?php if ($pageNum_Recordset2 > 0) { // Show if not first page ?> <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, max(0, $pageNum_Recordset2 - 1), $queryString_Recordset2); ?>"><img src="Previous.gif" border=0></a> <?php } // Show if not first page ?> </td> <td width="23%" align="center"> <?php if ($pageNum_Recordset2 < $totalPages_Recordset2) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, min($totalPages_Recordset2, $pageNum_Recordset2 + 1), $queryString_Recordset2); ?>"><img src="Next.gif" border=0></a> <?php } // Show if not last page ?> </td> <td width="23%" align="center"><?php if ($pageNum_Recordset2 < $totalPages_Recordset2) { // Show if not last page ?> <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, $totalPages_Recordset2, $queryString_Recordset2); ?>"><img src="Last.gif" border=0></a> <?php } // Show if not last page ?> </td> </tr> </table> <p><a href="main.html" target="_self"><img src="First.gif" alt="PRINCIPIO" border="0"/></a></p> </body> </html> <?php mysql_free_result($Recordset2); ?>
No se que estoy haciendo mal...
Como inserto el strtoupper aqui:
Código:
En verdad nadie me puede ayudar?$insertSQL = sprintf("INSERT INTO estudiante (apellido, nombre, cedula, codigo, rango, especializacion, ciudadcasa, dircasa, telcasa, celular1, celular2, email1, email2, empresa, ciudadjob, cargo, teljob, observacion, ingresoyear, usuario, password, nivel) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['apellido'], "text"), GetSQLValueString($_POST['nombre'], "text"), GetSQLValueString($_POST['cedula'], "text"), GetSQLValueString($_POST['codigo'], "text"), GetSQLValueString($_POST['rango'], "text"), GetSQLValueString($_POST['especializacion'], "text"), GetSQLValueString($_POST['ciudadcasa'], "text"), GetSQLValueString($_POST['dircasa'], "text"), GetSQLValueString($_POST['telcasa'], "text"), GetSQLValueString($_POST['celular1'], "text"), GetSQLValueString($_POST['celular2'], "text"), GetSQLValueString($_POST['email1'], "text"), GetSQLValueString($_POST['email2'], "text"), GetSQLValueString($_POST['empresa'], "text"), GetSQLValueString($_POST['ciudadjob'], "text"), GetSQLValueString($_POST['cargo'], "text"), GetSQLValueString($_POST['teljob'], "text"), GetSQLValueString($_POST['observacion'], "text"), GetSQLValueString($_POST['ingresoyear'], "date"), GetSQLValueString($_POST['usuario'], "text"), GetSQLValueString($_POST['password'], "text"), GetSQLValueString($_POST['nivel'], "text"));
T_T