Forums

PHP

This topic is locked

PHP Registration page

Stuart Ashdown

Posted 17 Nov 2006 17:58:57

has voted

Vote

17 Nov 2006 17:58:57 Stuart Ashdown posted:

Trying to create a php registration page linking to my hosted mySQL database in Dreamweaver 8

I can create the page ok, upload it and it's fine, but as soon as insert the username/password fields recordsets from db in the form and upload again, I get page cannot be found.

Anyone got any ideas?

Replies

Roddy Dairion

Replied 20 Nov 2006 18:46:46

20 Nov 2006 18:46:46 Roddy Dairion replied:

Check where your page is being redirected to once the registration is completed.

Edited by - roders22 on 20 Nov 2006 18:47:17

Stuart Ashdown

Replied 21 Nov 2006 10:47:56

21 Nov 2006 10:47:56 Stuart Ashdown replied:

ok yep, that's sorted. For some reason now though, my Submit button isn't showing up

Stuart Ashdown

Replied 21 Nov 2006 11:19:18

21 Nov 2006 11:19:18 Stuart Ashdown replied:

grrrrrrr, got lots of stupid errors. I can add the insert record and point it to a success page and works. Add Submit button and it fails. Create the page with button and it works, add the record again and it fails.

Here is my code if it's any use. Starting to frustrate me now. All I'm after is a simple registration page to put on my site which enters their user details, then another page so they can email some configuration settings to themselves.

<pre id=code><font face=courier size=2 id=code><?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "reg"

) {
$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['username'], "text"

,
GetSQLValueString($_POST['password'], "text"

,
GetSQLValueString($_POST['email'], "text"

);

mysql_select_db($database_Simpilots, $Simpilots);
$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error());

$insertGoTo = "/regsuccess.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST">
<p>username
<input name="username" type="text" id="username" />
<br />
password
<input name="password" type="text" id="password" />
<br />
email
<input name="email" type="text" id="email" />
</p>
<p>submit
<input type="submit" name="Submit" value="Submit" />
</p>
<p></p>
<input type="hidden" name="MM_insert" value="reg">
</form>
</body>
</html>
</font id=code></pre id=code>

Roddy Dairion

Replied 21 Nov 2006 17:02:33

21 Nov 2006 17:02:33 Roddy Dairion replied:

Just give me a brief of what you do/did and what happen you do/did it?

Stuart Ashdown

Replied 21 Nov 2006 17:13:25

21 Nov 2006 17:13:25 Stuart Ashdown replied:

had my original page which I was using when I posted the original message. I realised that I forgot to put the success page in so did this and it worked. Realised then that I forgot to put on the submit button. As soon as I did this I had page not found again.

Roddy Dairion

Replied 21 Nov 2006 17:19:05

21 Nov 2006 17:19:05 Roddy Dairion replied:

<pre id=code><font face=courier size=2 id=code>
<?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

) {
$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['username'], "text"

,
GetSQLValueString($_POST['password'], "text"

,
GetSQLValueString($_POST['email'], "text"

);

mysql_select_db($database_Simpilots, $Simpilots);
$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error());

$insertGoTo = "regsuccess.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST">
<p>username
<input name="username" type="text" id="username" />
<br />
password
<input name="password" type="text" id="password" />
<br />
email
<input name="email" type="text" id="email" />
</p>
<p>submit
<input type="submit" name="Submit" value="Submit" />
</p>
<p></p>
<input type="hidden" name="MM_insert" value="reg">
</form>
</body>
</html>
</font id=code></pre id=code>
Just try this out.

Stuart Ashdown

Replied 21 Nov 2006 17:40:08

21 Nov 2006 17:40:08 Stuart Ashdown replied:

to start off with i copied and pasted it, it went into one block and i got a UNEXPECTED T_STRING on line 1

I broke it down a bit and then got page not found

<pre id=code><font face=courier size=2 id=code><?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":case "int":$theValue = ($theValue != ""

? intval($theValue) : "NULL";break;case "double":$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";break;case "date":$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";break;case "defined":$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;break;}return $theValue;}$editFormAction = $_SERVER['PHP_SELF'];if (isset($_SERVER['QUERY_STRING'])) {$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);}if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "reg"

) {$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",GetSQLValueString($_POST['username'], "text"

,GetSQLValueString($_POST['password'], "text"

,GetSQLValueString($_POST['email'], "text"

);mysql_select_db($database_Simpilots, $Simpilots);$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error());$insertGoTo = "regsuccess.php";if (isset($_SERVER['QUERY_STRING'])) {$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";$insertGoTo .= $_SERVER['QUERY_STRING'];}header(sprintf("Location: %s", $insertGoTo));}?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title></head><body><form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST"><p>username<input name="username" type="text" id="username" /><br />password<input name="password" type="text" id="password" /><br />email<input name="email" type="text" id="email" /></p><p>submit<input type="submit" name="Submit" value="Submit" /></p><p></p><input type="hidden" name="MM_insert" value="reg"></form></body></html> </font id=code></pre id=code>

Stuart Ashdown

Replied 21 Nov 2006 17:40:10

21 Nov 2006 17:40:10 Stuart Ashdown replied:

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":case "int":$theValue = ($theValue != ""

? intval($theValue) : "NULL";break;case "double":$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";break;case "date":$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";break;case "defined":$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;break;}return $theValue;}$editFormAction = $_SERVER['PHP_SELF'];if (isset($_SERVER['QUERY_STRING'])) {$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);}if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "reg"

) {$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",GetSQLValueString($_POST['username'], "text"

,GetSQLValueString($_POST['password'], "text"

,GetSQLValueString($_POST['email'], "text"

);mysql_select_db($database_Simpilots, $Simpilots);$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error());$insertGoTo = "regsuccess.php";if (isset($_SERVER['QUERY_STRING'])) {$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";$insertGoTo .= $_SERVER['QUERY_STRING'];}header(sprintf("Location: %s", $insertGoTo));}?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title></head><body><form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST"><p>username<input name="username" type="text" id="username" /><br />password<input name="password" type="text" id="password" /><br />email<input name="email" type="text" id="email" /></p><p>submit<input type="submit" name="Submit" value="Submit" /></p><p></p><input type="hidden" name="MM_insert" value="reg"></form></body></html> </font id=code></pre id=code>

Roddy Dairion

Replied 21 Nov 2006 17:57:16

21 Nov 2006 17:57:16 Roddy Dairion replied:

Line 1 of which file?
<pre id=code><font face=courier size=2 id=code>
<?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

) {
$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['username'], "text"

,
GetSQLValueString($_POST['password'], "text"

,
GetSQLValueString($_POST['email'], "text"

Stuart Ashdown

Replied 21 Nov 2006 18:05:57

21 Nov 2006 18:05:57 Stuart Ashdown replied:

ok got this now and getting same page not found. Page is at www.simpilots.co.uk/test3.php

<pre id=code><font face=courier size=2 id=code><?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities ($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "reg"

)
{
$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['username'], "text"

,
GetSQLValueString($_POST['password'], "text"

,
GetSQLValueString($_POST['email'], "text"

);
mysql_select_db($database_Simpilots, $Simpilots);
$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error())
;$insertGoTo = "regsuccess.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST">
<p>username
<input name="username" type="text" id="username" />
<br />
password
<input name="password" type="text" id="password" />
<br />
email
<input name="email" type="text" id="email" />
</p>
<p>submit
<input type="submit" name="Submit" value="Submit" />
</p>
<p></p>
<input type="hidden" name="MM_insert" value="reg">
</form>
</body>
</html> </font id=code></pre id=code>

Roddy Dairion

Replied 21 Nov 2006 18:11:38

21 Nov 2006 18:11:38 Roddy Dairion replied:

i see..
<pre id=code><font face=courier size=2 id=code>
<?php virtual('/Connections/Simpilots.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities ($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "reg"

)
{
$insertSQL = sprintf("INSERT INTO user_profile (UserName, Password, Email) VALUES (%s, %s, %s)",
GetSQLValueString($_POST['username'], "text"

,
GetSQLValueString($_POST['password'], "text"

,
GetSQLValueString($_POST['email'], "text"

);
mysql_select_db($database_Simpilots, $Simpilots);
$Result1 = mysql_query($insertSQL, $Simpilots) or die(mysql_error());
$insertGoTo = "regsuccess.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form action="<?php echo $editFormAction; ?>" id="reg" name="reg" method="POST">
<p>username
<input name="username" type="text" id="username" />
<br />
password
<input name="password" type="text" id="password" />
<br />
email
<input name="email" type="text" id="email" />
</p>
<p>submit
<input type="submit" name="Submit" value="Submit" />
</p>
<p></p>
<input type="hidden" name="MM_insert" value="reg">
</form>
</body>
</html>
</font id=code></pre id=code>
For some reason there was 2 line mixed 2geva.

Reply to this topic

Latest Extensions

App Connect Summernote File Upload Upload different files in Summernote Editor
App Connect Summernote Simple, yet powerful and modern WYSIWYG Editor
Bootstrap 4 Dynamic Table Generator 2 Automatically generate dynamic data tables
Bootstrap 4 Dynamic Form Generator 2 Auto generate perfect Bootstrap 4 dynamic forms in seconds
App Connect Bootstrap 4 Dynamic Paging Generator Auto generate awesome dynamic Bootstrap 4 paging in seconds
App Connect Event Calendar The most powerful full-sized event calendar for Dreamweaver
DMXzone App Connect Next generation client side framework for data-driven web sites and apps
DMXzone Database Custom Query Create advanced, complex custom SQL queries with ease

Latest Videos

Using App Connect Autocomplete Learn how to add autocomplete functionality on your page, using the App Connect Autocomplete
Creating Custom SQL Queries Learn how to create custom SQL Queries with DMXzone Database Custom Query
Restricting Access to Your Pages Learn how to restrict access to your pages, using DMXzone Security Provider 2
Adding Log Out Functionality with DMXzone Security Provider 2 Learn how to add log out functionality to your page with DMXzone Security Provider 2
Creating a Log In Page with DMXzone Security Provider 2 Learn how to create a log in page with DMXzone Security Provider 2
Setting Up Site Security Settings Learn how to setup your site security, using DMXzone Security Provider 2
Generating an Update Record Form Learn how to create an update record form, using the Bootstrap 4 Dynamic Form Generator 2
Generating an Insert Record Form Learn how to create an insert record form, using the Bootstrap 4 Dynamic Form Generator 2