[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/feed.php on line 173: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/feed.php on line 174: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
Codigueando El mejor sitio de programación. 2017-11-09T06:10:41-05:00 http://codigueando.com/foro/feed.php?f=26 2017-11-09T06:10:41-05:00 2017-11-09T06:10:41-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=9015#p9015 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]> Estadísticas: Publicado por miquelresu11 — Jue Nov 09, 2017 6:10 am


]]>
2017-09-27T08:38:07-05:00 2017-09-27T08:38:07-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=9008#p9008 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]> Salu2

Estadísticas: Publicado por Mannnuel — Mié Sep 27, 2017 8:38 am


]]>
2017-09-27T08:28:26-05:00 2017-09-27T08:28:26-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=9007#p9007 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]>
Os copio el codigo PHP por si alguien me puede ayudar. Soy nuevo en esto (por cierto) así que si el error es muy evidente no seáis duros conmigo.

Sketch ======================================================
#include <SPI.h>
#include <Ethernet.h>

byte mac[] = { 0x90, 0xA2, 0xDA, 0x0D, 0x96, 0xB4 };
byte ip[] = { 192,168,1,10 }; // Direccion ip local
byte gw[] = { 192,168,1,1 };
byte sr[] = { 255,255,255,0};
char server[]={"192.168.1.3"};

EthernetClient client;
// Definicion de pines
//int sensorPin = A0;

void setup()
{
Serial.begin(9600);
Ethernet.begin(mac, ip, gw, sr); // inicializa ethernet shield
delay(1000); // espera 1 segundo despues de inicializar
Serial.print("My IP address: ");
Serial.println(Ethernet.localIP());
}

void loop()
{
float celsius = 81; // getTemperaturaC(); // 10 mV por grado celsius
Serial.print(celsius); // Escribe en el puerto serial para monitorear
Serial.print(" grados Celsius");

Serial.println("Conectando..");

if (client.connect(server, 80)) { // Se conecta al servidor
client.print("GET http://192.168.1.3/DataArduino.php?v="); // Envia los datos utilizando GET
client.print(celsius);
client.println(" HTTP/1.0");
client.println("User-Agent: Arduino 1.0");
client.println();
Serial.println("Conexion exitosa");
}
else
{
Serial.println("Falla en la conexion");
}
if (client.connected())
{}
else
{
Serial.println("Desconectado");
}
client.stop();
client.flush();
delay(5000); // espera 15 segundos antes de volver a sensar la temperatura
}

Codigo PHP==================================================
<?php
$mysql_servidor = "localhost";
$mysql_base = "shop";
$mysql_usuario = "root";
$mysql_clave = "";

$hora = time();
$fechaRegistro="".date("d-m-Y H:i:s", $hora);
$valor = htmlspecialchars($_GET["v"],ENT_QUOTES);
echo "".$fechaRegistro."---".$valor;
// Valida que esten presente todos los parametros
if (($fechaRegistro!="") and ($valor!=""))
{
mysql_connect($mysql_servidor,$mysql_usuario,$mysql_clave) or die("Imposible conectarse al servidor.");
mysql_select_db($mysql_base) or die("Imposible abrir Base de datos");
$sql = "insert into data (IdReg, Temp) values ('$fechaRegistro','$valor')";
mysql_query($sql);
}
else
{
echo "aqui";
}
?>

Recomendaciones de manuales o de blogs de Mysql también son bien recibidas :)

Estadísticas: Publicado por quiquelopez — Mié Sep 27, 2017 8:28 am


]]>
2016-07-28T09:41:26-05:00 2016-07-28T09:41:26-05:00 http://codigueando.com/foro/viewtopic.php?t=5079&p=8966#p8966 <![CDATA[SQL • Re: MYSQL ERROR 1215]]> Estadísticas: Publicado por ines1985 — Jue Jul 28, 2016 9:41 am


]]>
2016-07-28T09:30:06-05:00 2016-07-28T09:30:06-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=8965#p8965 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]> Estadísticas: Publicado por ines1985 — Jue Jul 28, 2016 9:30 am


]]>
2016-03-02T09:48:55-05:00 2016-03-02T09:48:55-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=8934#p8934 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]> Estadísticas: Publicado por hen1987 — Mié Mar 02, 2016 9:48 am


]]>
2015-09-22T05:15:43-05:00 2015-09-22T05:15:43-05:00 http://codigueando.com/foro/viewtopic.php?t=5079&p=8907#p8907 <![CDATA[SQL • Re: MYSQL ERROR 1215]]> Estadísticas: Publicado por quiquelopez — Mar Sep 22, 2015 5:15 am


]]>
2015-09-06T20:41:05-05:00 2015-09-06T20:41:05-05:00 http://codigueando.com/foro/viewtopic.php?t=5079&p=8904#p8904 <![CDATA[SQL • MYSQL ERROR 1215]]> Estadísticas: Publicado por Alexis — Dom Sep 06, 2015 8:41 pm


]]>
2015-07-14T16:58:28-05:00 2015-07-14T16:58:28-05:00 http://codigueando.com/foro/viewtopic.php?t=5070&p=8895#p8895 <![CDATA[SQL • ayuda visual fox pro 6.0 (no coinciden los tipos de datos)]]> SET STATUS OFF
CLEAR
DO WHILE .T.
DEFINE WINDOW A FROM 0,0 TO 60,300
ACTIVATE WINDOW A
@4, 60 SAY "DATOS PERSONALES"FONT "ARIAL",30
@10,30 PROMPT "INGRESO" FONT "ARIAL",30
@14,30 PROMPT "CONSULTA"FONT "ARIAL",30
@18,30 PROMPT "MODIFICACION"FONT "ARIAL",30
@22,30 PROMPT "ELIMINACION"FONT "ARIAL",30
@26,30 PROMPT "REPORTE"FONT "ARIAL",30
@30,30 PROMPT "SALIR"FONT "ARIAL",30
MENU TO OP
DO CASE
CASE OP=1
DO INGRESO
CASE OP=2
DO CONSULTA
CASE OP=3
DO MODIFICACION
CASE OP=4
DO ELIMACION
CASE OP=5
DO REPORTE
CASE OP=6
EXIT
ENDCASE
ENDDO
DEACTIVATE WINDOW A
PROCEDURE INGRESO
SET TALK OFF
SET STATUS OFF
CLEAR
USE aplicaciones1
OP="S"
DO WHILE OP="S"
MAPELLIDOS = SPACE(25)
MNOMBRES = SPACE (25)
MTELEFONO = SPACE(10)
MESTADOCIVI = SPACE(25)
MNACIONALID = SPACE (25)
MPAISPROCED = SPACE(25)
MDIRECCION = SPACE (25)
MPROFESION = SPACE (25)
MOCUPACION = SPACE (25)
DEFINE WINDOW B FROM 0,0 TO 100,300 TITLE "DATOS PERSONALES"font"ARIAL",15
ACTIVATE WINDOW B
@4,30 SAY "DATOS PERSONALES"FONT"ARIAL",20
@6,10 SAY "APELLIDOS"font"ARIAL",10GET MAPELLIDOS font"ARIAL",10
@6,50 SAY "NOMBRES"font"ARIAL",10 GET MNOMBRES font"ARIAL",10
@6,90 SAY "TELEFONO"FONT "ARIAL",10 GET MTELEFONO FONT "ARIAL",10 AQUI ES DONDE MUESTRA ES ERROR
@8,10 SAY "ESTADOCIVI"font"ARIAL",10 GET MESTADOCIVI font"ARIAL",10
@8,50 SAY "NACIONALID"font"ARIAL",10 GET MNACIONALID font"ARIAL",10
@8,90 SAY "PAISPROCED "font"ARIAL",10 GET MPAISPROCED font"ARIAL",10
@10,10 SAY "DIRECCION"font"ARIAL",10 GET MDIRECCION font"ARIAL",10
@10,50 SAY "PROFESION"font"ARIAL",10 GET MPROFESION font"ARIAL",10
@10,90 SAY "OCUPACION"font"ARIAL",10 GET MOCUPACION font"ARIAL",10
READ
APPEND BLANK
REPLACE APELLIDOS WITH MAPELLIDOS
REPLACE NOMBRES WITH MNOMBRES
REPLACE TELEFONO WITH MTELEFONO
REPLACE ESTADOCIVI WITH MESTADOCIVI
REPLACE NACIONALID WITH MNACIONALID
REPLACE PAISPROCED WITH MPAISPROCED
REPLACE DIRECCION WITH MDIRECCION
REPLACE PROFESION WITH MPROFESION
REPLACE OCUPACION WITH MOCUPACION
@12,40 SAY "DESEA CONTINUAR S/N"font"ARIAL",15 GET OP
READ
IF OP="S"
LOOP
ELSE
EXIT
ENDIF
ENDDO
DEACTIVATE WINDOW B
PROCEDURE CONSULTA
SET TALK OFF
SET STATUS OFF
CLEAR
USE aplicaciones1
GO TOP
OP="S"
DO WHILE OP="S"
DEFINE WINDOW C FROM 0,0 TO 80,300 TITLE "DATOS PERSONALES"FONT"ARIAL",30
ACTIVATE WINDOW C
MAPELLIDOS=SPACE(25)
@2,20 SAY"CONSULTA DE DATOS"FONT"ARIAL",20
@3,10 SAY "APELLIDOS"font"ARIAL",15 GET MAPELLIDOS font"ARIAL",15
READ
LOCATE FOR APELLIDOS=MAPELLIDOS
IF APELLIDOS=MAPELLIDOS
@4,10 SAY "NOMBRES " + NOMBRES font"ARIAL",15
@5,10 SAY "TELEFONO " + TELEFONO font"ARIAL",15
@6,10 SAY "ESTADOCIVI " + ESTADOCIVI font"ARIAL",15
@7,10 SAY "NACIONALID " + NACIONALID font"ARIAL",15
@8,10 SAY "PAISPROCED " + PAISPROCED font"ARIAL",15
@9,10 SAY "DIRECCION " + DIRECCION font"ARIAL",15
@10,10 SAY "PROFESION " + PROFESION font"ARIAL",15
@11,10 SAY "OCUPACION " + OCUPACION font"ARIAL",15
READ
ELSE
WAIT WINDOW "APELLIDO NO EXISTE"TIME 3
ENDIF
@12,10 SAY "DESEA CONTINUAR S/N"font"ARIAL"GET OP
READ
IF OP="S"
LOOP
EXIT
ENDIF
ENDDO
DEACTIVATE WINDOW C

Estadísticas: Publicado por FREDDYBU014 — Mar Jul 14, 2015 4:58 pm


]]>
2015-05-17T01:05:22-05:00 2015-05-17T01:05:22-05:00 http://codigueando.com/foro/viewtopic.php?t=5062&p=8886#p8886 <![CDATA[SQL • Triggers en Procedimiento almacenado SQL]]> Estadísticas: Publicado por HenBAlerer — Dom May 17, 2015 1:05 am


]]>
2014-05-05T22:19:18-05:00 2014-05-05T22:19:18-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=8448#p8448 <![CDATA[SQL • Re: como realizar una base de datos en mysql]]>

Estadísticas: Publicado por damasta — Lun May 05, 2014 10:19 pm


]]>
2014-05-05T22:15:37-05:00 2014-05-05T22:15:37-05:00 http://codigueando.com/foro/viewtopic.php?t=4856&p=8447#p8447 <![CDATA[SQL • como realizar una base de datos en mysql]]> Estadísticas: Publicado por julian_montezuma — Lun May 05, 2014 10:15 pm


]]>
2014-04-29T17:57:43-05:00 2014-04-29T17:57:43-05:00 http://codigueando.com/foro/viewtopic.php?t=4770&p=8264#p8264 <![CDATA[SQL • Re: Llave Foranea]]> Estadísticas: Publicado por damasta — Mar Abr 29, 2014 5:57 pm


]]>
2014-04-29T17:50:41-05:00 2014-04-29T17:50:41-05:00 http://codigueando.com/foro/viewtopic.php?t=4770&p=8263#p8263 <![CDATA[SQL • Llave Foranea]]> Estadísticas: Publicado por juanpocho98 — Mar Abr 29, 2014 5:50 pm


]]>
2014-04-27T18:29:22-05:00 2014-04-27T18:29:22-05:00 http://codigueando.com/foro/viewtopic.php?t=4755&p=8219#p8219 <![CDATA[SQL • Re: ¿sentencia SQL para la creación de un trigger en SQLDEVE]]> Estadísticas: Publicado por damasta — Dom Abr 27, 2014 6:29 pm


]]>