[SOLVED] inserting an IF statement

[textbox]

<?php
include "global/db.php";

$username = $_GET["username"];
if (!preg_match('/^[\w\d\s\-_]+$/', $username)) die('wrong username');

$q = mysql_query("SELECT * FROM users WHERE username = '$username'");
$are = mysql_fetch_assoc($q);

//echo "Welcome to ".$username."'s profile page.";


$sql = "SELECT * FROM users WHERE username = '$username'";

$result = mysql_query($sql) OR die(mysql_error());

$num=mysql_num_rows($result); 

$about=mysql_result($result,0,"about");
$interests=mysql_result($result,0,"interests");
$music=mysql_result($result,0,"music");
$film=mysql_result($result,0,"film");
$quote=mysql_result($result,0,"quote");
$headline=mysql_result($result,0,"headline");
?>

 

How, and where would i include an IF statement that would redirect to another page if the username has not been found.

Thanks

 

[ryeman98]

I'm not entirely sure but I think it would be like this:

*Note - I haven't tested this and I'm not sure if it will work but I'll try.

<?php
include "global/db.php";

$username = $_GET["username"];
if (!preg_match('/^[\w\d\s\-_]+$/', $username)) die("Location: index.php");

$q = mysql_query("SELECT * FROM users WHERE username = '$username'");
$are = mysql_fetch_assoc($q);

//echo "Welcome to ".$username."'s profile page.";


$sql = "SELECT * FROM users WHERE username = '$username'";

$result = mysql_query($sql) OR die(mysql_error());

$num=mysql_num_rows($result); 

$about=mysql_result($result,0,"about");
$interests=mysql_result($result,0,"interests");
$music=mysql_result($result,0,"music");
$film=mysql_result($result,0,"film");
$quote=mysql_result($result,0,"quote");
$headline=mysql_result($result,0,"headline");
?>

 

Again, I have no idea if this will work at all but hey, I'm tryin.

[textbox]

Sadly, it did not.

Ive tried that already thinking 'yeah, this work'

 

 

Ah well, thanks for having a go anyway!!

[ryeman98]

No problem. At least I didn't make a fool of myself

[OOP]

Hi there,

it will be somthing like this

<?php
include "global/db.php";

$username = $_GET["username"];

if(empty($username)){
   header("Location: http://www.example.com/");
   exit();
}

if (!preg_match('/^[\w\d\s\-_]+$/', $username)) die("Location: index.php");

$q = mysql_query("SELECT * FROM users WHERE username = '$username'");
$are = mysql_fetch_assoc($q);

//echo "Welcome to ".$username."'s profile page.";


$sql = "SELECT * FROM users WHERE username = '$username'";

$result = mysql_query($sql) OR die(mysql_error());

$num=mysql_num_rows($result); 

$about=mysql_result($result,0,"about");
$interests=mysql_result($result,0,"interests");
$music=mysql_result($result,0,"music");
$film=mysql_result($result,0,"film");
$quote=mysql_result($result,0,"quote");
$headline=mysql_result($result,0,"headline");
?>

[textbox]

Hello, no luck on that front either!

I wonder if the original code is wrong?!

[textbox]

Am i right in trying to do it here

 

if(empty($username)){
   header("Location: http://www.example.com/");
   exit();
}

 

Or do i need to do something like check how many results are returned, if its 0, forward to  my error page?!

 

Thanks

 

[JakeTheSnake3.0]

<?php
include "global/db.php";

if (isset($_GET["username"])) {
$username = $_GET["username"];

if (!preg_match('/^[\w\d\s\-_]+$/', $username)) die("Location: index.php");

$q = mysql_query("SELECT * FROM users WHERE username = '$username'");
$are = mysql_fetch_assoc($q);

//echo "Welcome to ".$username."'s profile page.";


$sql = "SELECT * FROM users WHERE username = '$username'";

$result = mysql_query($sql) OR die(mysql_error());

$num=mysql_num_rows($result); 

$about=mysql_result($result,0,"about");
$interests=mysql_result($result,0,"interests");
$music=mysql_result($result,0,"music");
$film=mysql_result($result,0,"film");
$quote=mysql_result($result,0,"quote");
$headline=mysql_result($result,0,"headline");
} else {
header("Location: http://www.example.com/");
exit();
}
?>

[trq]

<?php

  include "global/db.php";
  $username = $_GET["username"];

  if ($result = mysql_query("SELECT * FROM users WHERE username = '$username'")) {
    if (!mysql_num_rows($result)) {
      // username not found, do redirect.
      header("Location: usernotfound.php");
    } else {
      $row = mysql_fetch_assoc($result);
      //echo "Welcome to ".$username."'s profile page."; 
      $about = $row["about"];
      $interests = $row["interests"];
      $music = $row["music"];
      $film = $row["film"];
      $quote = $row["quote"];
      $headline = $row["headline"];
    }
  }

?>

[textbox]

Thanks Thorpe.

Sorted