Help

[barcelona]

I think I have all the PHP code correct .... but the problem is the db file??
http://s92531444.onlinehome.us/register.php

I don't know how to create it here is what is needs to be

Thaks Guys

[barcelona]

here is the code

	<?php

// dbConfig.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
include ("dbConfig.php");


// ==== Input validation and PHP dBase code ===============================
//
// ========================================================================

if ( $_GET["op"] == "reg" )
	{
	$bInputFlag = false;
	foreach ( $_POST as $field )
		{
		if ($field == "")
			{
			$bInputFlag = false;
			}
		else
			{
			$bInputFlag = true;
			}
		}
	// If we had problems with the input, exit with error
	if ($bInputFlag == false)
		{
		die( "Problem with your registration info. "
			."Please go back and try again.");
		}

	// Fields are clear, add user to database
	//  Setup query
	$q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "
		."VALUES ('".$_POST["username"]."', "
		."PASSWORD('".$_POST["password"]."'), "
		."'".$_POST["email"]."')";
	//  Run query
	$r = mysql_query($q);

	// Make sure query inserted user successfully
	if (!$r)
		{
		die("Error: User not added to database.");
		}
	else
		{
		// Redirect to thank you page.
		Header("Location: register.php?op=thanks");
		}
	} // end if



// ==== Thank you page ====================================================
// 
// ========================================================================
elseif ( $_GET["op"] == "thanks" )
	{
	echo "<h2>Thanks for registering!</h2>";
	}



// ==== Main Form =========================================================
//
// ========================================================================
else
	{
	echo "<form action=\"?op=reg\" method=\"POST\">\n";
	echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";
	echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br />\n";
	echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n";
	echo "<input type=\"submit\">\n";
	echo "</form>\n";
	}
// EOF
?>

[Dvector]

You do have access to a database server, right? If so, here is some example code, based on MySQL that will build your table, you must be in MySQL to run this code:

CREATE TABLE dbUsers (
id INT NOT NULL AUTO_INCREMENT ,
username VARCHAR( 16 ) NOT NULL ,
password CHAR( 16 ) NOT NULL ,
email VARCHAR( 25 ) NOT NULL ,
PRIMARY KEY ( id ) ,
UNIQUE (
username
)
);

That should get you started.

[barcelona]

hmm... so I need MYSQL installed on my PC as well?

oops!! that will set me back

[barcelona]

Okay is this correct???
http://s92531444.onlinehome.us/dbusers.db

[Dvector]

You will need to install MySQL on your computer. There are several tutorials around to help get you started, but before you can go any further, you will need the basics of MySQL.

There is a book called Teach Yourself MySQL in 24 Hours that is a great tool for beginners. It will cover all the basics you need to know.

[barcelona]

Okay, now I am getting an error and I don't know what it means??

[Sxooter]

If you're looking into innodb types, it may be that the version of MySQL you have installed doesn't support them. If it throws an error that's a good thing, because it used to just silently create myisam tables and not tell you.

Why not try a database where transactionable tables are the default and only type, like firebird or postgresql? Both of those are available for Windows, linux, or BSD.

[gderoover]

If you are using a pc, I suggest you use easyPHP downlaod for free at http://easyphp.org/

Really easy install and almost no configuration required.

Giro

[barcelona]

thanks guys you are a source of indispensable information