Jump to content

Data base connect

andylord

By andylord
in PHP Coding Help

Recommended Posts

andylord Member

andylord

Posted
Posted

<?php

define('DB_HOST', 'localhost');

    define('DB_USER', '####################');

    define('DB_PASSWORD', '#######');

define('DB_DATABASE','##########');

define('TFX','members');

define('SERVER_URL','http://localhost');

define('APP_FOL','###########');

?>

 

#### are difened removed for my safety

 

this is the page i get http://andys-cop-help.com/register-form.php

 

as you can see it isnt finding these

 

    * First name missing

    * Last name missing

    * Login ID missing

    * Password missing

    * Confirm password missing

 

They are in the table so im wondering why it isnt finding it do i need some more code for this any help appreciated,

 

if this is in the wrong place im sorry im new here please move it to the correct place if it isnt.

thanks

 

Link to comment
https://forums.phpfreaks.com/topic/146894-data-base-connect/
Share on other sites
andylord Member

andylord

Posted
  • Author
Posted

which code is it that you need? (im new at this sorry) if it helps i cheated and took the info from http://phpsense.com/php/php-login-script.html the link to download and changed it to login but it isnt working

 

Login Form

<?php

session_start();

?>

<!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=iso-8859-1" />

<title>Login Form</title>

<link href="loginmodule.css" rel="stylesheet" type="text/css" />

</head>

<body>

<?php

if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) {

echo '<ul class="err">';

foreach($_SESSION['ERRMSG_ARR'] as $msg) {

echo '<li>',$msg,'</li>';

}

echo '</ul>';

unset($_SESSION['ERRMSG_ARR']);

}

?>

<form id="loginForm" name="loginForm" method="post" action="register-exec.php">

  <table width="300" border="0" align="center" cellpadding="2" cellspacing="0">

    <tr>

      <th>First Name </th>

      <td><input name="fname" type="text" class="textfield" id="fname" /></td>

    </tr>

    <tr>

      <th>Last Name </th>

      <td><input name="lname" type="text" class="textfield" id="lname" /></td>

    </tr>

    <tr>

      <th width="124">Login</th>

      <td width="168"><input name="login" type="text" class="textfield" id="login" /></td>

    </tr>

    <tr>

      <th>Password</th>

      <td><input name="password" type="password" class="textfield" id="password" /></td>

    </tr>

    <tr>

      <th>Confirm Password </th>

      <td><input name="cpassword" type="password" class="textfield" id="cpassword" /></td>

    </tr>

    <tr>

      <td> </td>

      <td><input type="submit" name="Submit" value="Register" /></td>

    </tr>

  </table>

</form>

</body>

</html>

 

Register Execute

 

<?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(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

die('Failed to connect to server: ' . mysql_error());

}

 

//Select database

$db = mysql_select_db(DB_DATABASE);

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

$fname = clean($_POST['fname']);

$lname = clean($_POST['lname']);

$login = clean($_POST['login']);

$password = clean($_POST['password']);

$cpassword = clean($_POST['cpassword']);

 

//Input Validations

if($fname == '') {

$errmsg_arr[] = 'First name missing';

$errflag = true;

}

if($lname == '') {

$errmsg_arr[] = 'Last name missing';

$errflag = true;

}

if($login == '') {

$errmsg_arr[] = 'Login ID missing';

$errflag = true;

}

if($password == '') {

$errmsg_arr[] = 'Password missing';

$errflag = true;

}

if($cpassword == '') {

$errmsg_arr[] = 'Confirm password missing';

$errflag = true;

}

if( strcmp($password, $cpassword) != 0 ) {

$errmsg_arr[] = 'Passwords do not match';

$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(firstname, lastname, login, passwd) VALUES('$fname','$lname','$login','".md5($_POST['password'])."')";

$result = @mysql_query($qry);

 

//Check whether the query was successful or not

if($result) {

header("location: register-success.php");

exit();

}else {

die("Query failed");

}

?>

 

Link to comment
https://forums.phpfreaks.com/topic/146894-data-base-connect/#findComment-771229
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.