Jump to content
ranshemer

How To Know If A Filed Is Empty And Make A Redireccion?

Recommended Posts

Hi i'm a newbie in this forum i like W3S is the best page ever for learning and be a web developer and i need help... how do i know if a filed is empty on php & mysql block code and make a redirection on the same page or other files for example... if we have a form called

persons.php
and have this code
<html><body><form action="insert.php" method="post">Firstname: <input type="text" name="firstname" />Lastname: <input type="text" name="lastname" />Age: <input type="text" name="age" /><input type="submit" /></form></body></html>

and then we have this file call it

insert.php
<?php$con = mysql_connect("localhost","peter","abc123");if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("my_db", $con);$sql="INSERT INTO Persons (FirstName, LastName, Age)VALUES('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";if (!mysql_query($sql,$con))  {  die('Error: ' . mysql_error());  }echo "1 record added";mysql_close($con)?>

and if a have fristname as a UNIQUE field in mysql... how do i know if a field is empty and make a redirection to a pages or file? (that includes same files on your root folder) i hope that you help me thx

Share this post


Link to post
Share on other sites

just check the value of the $_POST members you want to validate against. Since they come over as strings, if there was nothing submitted to them, you could use

if($_POST['firstname'] === ''){  //redirect logic here}else{  //all other code here};

  • Like 1

Share this post


Link to post
Share on other sites

ok thx i thing i have a idea how to do it ,i will show my real code: i have 2 files there name are in Spanish so sry (it is because is my native language)

  1. CrearUsario.php (Create User)
  2. proceso_usuario.php (user process) (with which make the insert to mysql)

This is CrearUsuario.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><link rel="stylesheet" href="user_estilo.css" type="text/css" /><title>Crear Usuario</title></head><body><div id="forma">	 <?php include("menu.php"); ?><h2 id="titulo_peque">cree su usario:</h2><form  name="datos" action="proceso_usuario.php" method="post" >	<p class="texto">username:<input type="text" name="username" id="username" /></p>	<p class="texto">password:<input type="password" name="password" id="password" /></p>	<p class="texto">Descripcion:</p>	<input type="text" name="descripcion" id="descripcion" />	<br />	<input type="submit" name="botonphp" value="Registrar" id="boton"/>	</form>	  </div></body></html>

This is proceso_usuario.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>proceso</title><link rel="stylesheet" href="user_estilo.css" type="text/css" /></head><body><div id="forma"><?php include("menu.php"); ?><?php$con = mysql_connect("localhost","root","1234");if (!$con)  {  die('Error en la coneccion de SQL: ' . mysql_error());  }mysql_select_db("rani", $con);$sql="INSERT INTO usuario (username, password, descripcion)VALUES ('$_POST[username]','$_POST[password]','$_POST[descripcion]')";if (!mysql_query($sql,$con))  {  die('Error con las tablas: ' . mysql_error());  }echo "Usuario Creado";mysql_close($con)?>

so it will be ... note: i what to redirect to CrearUsuario.php

<?php$sql="INSERT INTO usuario (username, password, descripcion)VALUES ('$_POST[username]','$_POST[password]','$_POST[descripcion]')";if($_POST['username'] && $_POST['password'] ==""){  //DONT KNOW THE REDIRECT CODE CANT YOU TELL}echo field can't be empty?>

Edited by ranishemer

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...