Posteet: mysql,php

Mostrar todas las tablas de una base de datos

jacinmontava — Fri, 28 Nov 2008 12:26:38 +0000

";
} ?>

[mysql] [php]

mysql dump with delete more then 3 backups

sx — Tue, 08 Jul 2008 21:01:19 +0000

DATUM=`date '+%Y-%m-%d'`
mysqldump -u USER --password=PASSWORD DATABASE TABLE > /home/backup/db.sql
gzip /home/backup/db.sql
mv /home/backup/db.sql.gz /home/backup/db-${DATUM}.sql.gz
find /home/backup/ -mtime +2 -type f -print0 | xargs -0 rm

[mysql] [php]

Extraer un dato de la BD

jacinmontava — Wed, 26 Dec 2007 15:03:33 +0000

function dime_datos($tabla, $campo, $id_recibida)
{
   $link = conectarse();
   $consulta_sql = "SELECT $campo FROM $tabla WHERE id = '$id_recibida'";
   $consultar = mysql_query($consulta_sql, $link);
   return mysql_result($consultar, 0);
}

[mysql] [php]

Conexion Base de Datos

jacinmontava — Wed, 26 Dec 2007 14:35:53 +0000

$localhost = "localhost";
$usuario = "nombre usuario BD";
$password = "password BD";
$nombreBD = "nombre BD"

function conectarse()
{
   if (!($link=mysql_connect($localhost,$usuario,$password)))
   {
      echo "Error conectando a la base de datos.";
      exit();
   }
   if (!mysql_select_db($nombreBD,$link))
   {
      echo "Error seleccionando la base de datos.";
      exit();
   }
   return $link;
}

[mysql] [php]

Recuperar la ultima id insertada

jacinmontava — Thu, 20 Dec 2007 11:55:09 +0000

mysql_query("INSERT INTO table (nom_table) values ('ex')");
   $ultima_id =  mysql_insert_id();
   echo $ultima_id;

[mysql] [php]

Récupérer le dernier id inséré

xillon — Mon, 10 Dec 2007 06:35:46 +0000

[mysql] [php]

Construct select (HTML) dynamic with any table SQL

xillon — Mon, 05 Nov 2007 11:52:08 +0000

function selectTable($nomtable, $where = NULL, $order = NULL)
         {
            $sql = "SELECT * FROM $nomtable";
            if ( $where !== NULL ) $sql .= " WHERE $where";
            if ($order !== NULL)$sql.=" ORDER BY $order ";
            
            $query=mysql_query($sql);
            
            $ret = array();
            while ( $donnee = mysql_fetch_assoc($query))
            {
               $ret[] = $donnee;
            }
            return $ret;
         }
         
         function sqlSelect($sqlDonnee, $nomCol, $valCol)
         {
            for($i = 0 ; $i".$options["name"][$i]."\n";
               else
                  $select .= "\n";
            }
            $select .= "\n";

            return $select;
         }

/*** Exemple utilisation ***/
/*