PHP INSERT data MySQL -


i'm trying add values database (mysql) using form. can connect table values not registered, empty fields. everytime execute, row of empty files added table. if can tellme part of code have modified in order register fields of form , send text table appreciate! have file(indextodoenuno.html):

<!doctype html> <html> <head>  <title>formulario de registro</title>  </head>  <body>  <?php $server="localhost";  // aqui abajo escribe el nombre de la base de datos. // si tu servidor tiene cpanel normalmente va primero tu nombre de username, // por ejemplo: username_nombredelabasededatos $database = "cartago_basedepruebas";  // aqui abajo el nombre de username de la base de datos para acceder ella. $db_user = "root";  // y ahora la contraseña: $db_pass = "";  // conexión con el servidor mysql_connect($server, $db_user, $db_pass) or die ("error1".mysql_error());  // selección de base de datos mysql_select_db($database) or die ("error2".mysql_error());  mysql_query ("insert `cartago_basedepruebas`.`usuarios` (`nombre`, `email`, `url`) values ('$_post[nombre]', '$_post[email]', '$_post[url]')"); //mysql_query ("insert `usuarios` (`nombre`, `email`, `url`) values ('$_post[nombre]', '$_post[email]', '$_post[url]')");   ?>      <div class="group">  <form method="post" action="insertardatosentabla.php">   <input type="text" name="nombre" id="nombre" />   <input type="text" name="email" id="email" />   <input type="text" name="url" id="url" />   <center> <input class="form-btn" name="submit" type="submit" value="suscribirse" /></center> </form> </div> </body> </html>

update:

<!doctype html> <html> <head>  <title>formulario de registro</title>  </head>  <body>  <div class="group">  <form method="post" action="indextodoenuno3.php">   <input type="text" name="nombre" id="nombre" />   <input type="text" name="email" id="email" />   <input type="text" name="url" id="url" />   <center> <input class="form-btn" name="submit" type="submit" value="suscribirse" /></center> </form> </div> </body> </html>

and php file:

<?php $server="localhost";  // aqui abajo escribe el nombre de la base de datos. // si tu servidor tiene cpanel normalmente va primero tu nombre de username, // por ejemplo: username_nombredelabasededatos $database = "cartago_basedepruebas";  // aqui abajo el nombre de username de la base de datos para acceder ella. $db_user = "root";  // y ahora la contraseña: $db_pass = ""; $nombre= $_post['nombre']; $email= $_post['email']; $url= $_post['url']; // conexión con el servidor mysql_connect($server, $db_user, $db_pass) or die ("error1".mysql_error());  // selección de base de datos mysql_select_db($database) or die ("error2".mysql_error());  mysql_query ("insert usuarios (nombre,email,url) values ('".$nombre."', '".$email."', '".$url."')"); //mysql_query ("insert `usuarios` (`nombre`, `email`, `url`) values ('$_post[nombre]', '$_post[email]', '$_post[url]')");   ?>

right if execute php file in cmd:

php notice: undefined index: nombre in c:\users\f80shv0\desktop\indextodoenuno3 .php on line 14 php notice: undefined index: email in c:\users\f80shv0\desktop\indextodoenuno3. php on line 15 php notice: undefined index: url in c:\users\f80shv0\desktop\indextodoenuno3.ph p on line 16

mysql_query ("insert intocartago_basedepruebas.usuarios(nombre,email,url) values ('".$_post[nombre]."', '".$_post[email]."', '".$_post[url]."')");

use hope solve problem


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more