MySQL Forums
Forum List  »  MyISAM

"Query failed"
Posted by: Olly Rogers
Date: December 13, 2010 01:50PM

Hey guys, I'm very new to MySQL and have done my first database for logins - long story short, whenever I test out the registration I get "Query failed" and am not sure what I've done. Here is the code, would be very grateful if someone could sort it out for me!

<?php
//Start session
session_start();

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(CONTENT REMOVED);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(gafferzo_clubdatabase);
if(!$db) {
die("Unable to select database");
}

//Function to sanitize values received from the form. Prevents SQL injection
function clean($str) {
$str = @trim($str);
if(get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

//Sanitize the POST values
$cname = clean($_POST['cname']);
$password = clean($_POST['password']);
$email = clean($_POST['email']);
$firstname = clean($_POST['firstname']);
$surname = clean($_POST['surname']);

//Input Validations
if($cname == '') {
$errmsg_arr[] = 'Club name missing';
$errflag = true;
}
if($password == '') {
$errmsg_arr[] = 'Password missing';
$errflag = true;
}
if($email == '') {
$errmsg_arr[] = 'Email missing';
$errflag = true;
}
if($firstname == '') {
$errmsg_arr[] = 'First name missing';
$errflag = true;
}
if($surname == '') {
$errmsg_arr[] = 'Surname missing';
$errflag = true;
}

//Check for duplicate login ID
if($login != '') {
$qry = "SELECT * FROM members WHERE login='$login'";
$result = mysql_query($qry);
if($result) {
if(mysql_num_rows($result) > 0) {
$errmsg_arr[] = 'Login ID already in use';
$errflag = true;
}
@mysql_free_result($result);
}
else {
die("Query failed");
}
}

//If there are input validations, redirect back to the registration form
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
header("location: register-form.php");
exit();
}

//Create INSERT query
$qry = "INSERT INTO members(clubname,password,email,firstname,surname) VALUES('$cname','".md5($_POST['password'])."','$email','$firstname','$surname'";
$result = @mysql_query($qry);

//Check whether the query was successful or not
if($result) {
header("location: register-success.php");
exit();
}else {
die("Query failed");
}
?>

Options: ReplyQuote


Subject
Views
Written By
Posted
"Query failed"
3618
December 13, 2010 01:50PM
1404
December 14, 2010 06:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.