Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Carteras
/
fpdf
/
tutorial
:
limpiar.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?PHP //header("Content-type: application/octet-stream"); //header("Content-Disposition: attachment; filename=CXP.xls"); //header("Pragma: no-cache"); / header("Expires: 0"); // Datos de la base de datos $usuario = "SANMARINO"; $password = "sanmarino2021*"; $servidor = "localhost"; $basededatos = "pagos"; // creación de la conexión a la base de datos con mysql_connect() $conexion = mysqli_connect( $servidor, $usuario, "$password" ) or die ("No se ha podido conectar al servidor de Base de datos"); // Selección del a base de datos a utilizar $db = mysqli_select_db( $conexion, $basededatos ) or die ( "No se ha podido conectar a la base de datos" ); $n=1; $NITA=""; $SUMA=0; $SUMAT=0; $VRC=" Total Cliente ."; $DATO="+"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE INI = '$DATO' "); $DATO="|"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE INI = '$DATO' "); $DATO="C"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE INI = '$DATO' "); $DATO="V"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE INI = '$DATO' "); $DATO="______________"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE CARTERA1 = '$DATO' "); $DATO="--------------"; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE CARTERA1 = '$DATO' "); $DATO=""; $sql = mysqli_query($conexion,"DELETE FROM edades WHERE CARTERA1 = '$DATO' "); $tabla = $conexion->query("SELECT * FROM edades ; "); while ($row_consulta_form = $tabla->fetch_array()) { $CEDULA = $row_consulta_form['cedula']; $INI = $row_consulta_form['INI']; while($CEDULA<>" Total Cliente .") {$tabla = $conexion->query("SELECT * FROM edades ; "); while ($row_consulta_form = $tabla->fetch_array()) { $UpdateProd = "UPDATE edades SET INI = '$CEDULA' WHERE CEDULA = '$VRC'"; $result = mysqli_query($conexion, $UpdateProd); }} } ?>