Linux, Apache, MySQL, PHP

Marc Firth wrote:

Title

song lyrics

$To = "webmaster@example-site.com";                   // Website Owners Email Address
$Headers = 'From:' . "<" . $frmEmail . ">" . "\r\n";  // Reply Address, Obtained from user input (via a form)
$Subject = 'Subject: '.$frmSubject;                   // The subject of the message, obtained from user input
$Message = 'Message: '.$frmMessage;                   // The Message of the email, obtained from user input 
if(mail($To, $Subject, $Message, $Headers))           // Attempt to send the email to the Website Owner
{ 
  echo "Message Sent!";         
}
else                                                  // Message could not be sent 
{ 
  echo "Error sending message!"; 
}

Artakazezs wrote:

into MSSQL database using formview in asp.net

wartotojas wrote:

die('{status: 0,txt:"This email address is already registered"}');

wartotojas wrote:

if($username_exist > 0){
die('{status:0,txt:"This email address is already registered"}');
unset($email);
include 'register.html';
exit();

// lf no errors present with the username
// use a query to insert the data into the database.

$query = "INSERT INTO users (name, lname, email, nickname, password)
VALUES('$name', '$lname', '$email', '$nickname', '$password')";
mysql_query($query) or die(mysql_error());
mysql_close();

echo "You have successfully Registered";

// If the username exists then:
// 1: Close the MySQL connection.
// 2: Output that the email has already been registered.
// 3: Include the registration file.
if ( $username_exist > 0 )
{
   mysql_close();
   echo 'Email already registered';
   include( 'register.html' );
}

// Otherwise (If the username doesn't exist):
// 1: Insert the new user.
// 2: Close the MySQL connection.
// 3: Output that the user has been registered.
else
{
   $query = "INSERT INTO users (name, lname, email, nickname, password)
     VALUES('$name', '$lname', '$email', '$nickname', '$password')";
   mysql_query( $query ) or die( mysql_error() );
   mysql_close();

   echo "You have successfully Registered";
}

<?php

// we check if everything is filled in

if(empty($_POST['fname']) || empty($_POST['lname']) || empty($_POST['email']) || empty($_POST['nickname']) || empty($_POST['pass']))
{
	die('{status:0,txt:"All the fields are required"}');
}



// is the email valid?

if(!(preg_match("/^[\.A-z0-9_\-\+]+[@][A-z0-9_\-]+([.][A-z0-9_\-]+)+[A-z]{1,4}$/", $_POST['email'])))
{	
	die('{status:0,txt:"You haven\'t provided a valid email"}');
}




$dbhost = "localhost";
$dbname = "register";
$dbuser = "*******";
$dbpass = "******";


mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

    
$name = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];    
$nickname = $_POST['nickname'];
$password = md5($_POST['password']);



$checkuser = mysql_query("SELECT email FROM users WHERE email='$email'"); 

$username_exist = mysql_num_rows($checkuser);
	
	if ( $username_exist > 0 ){   
		mysql_close();   
		echo 'Email already registered';   
		include( 'members.php' );
	}

	else{   
	$query = "INSERT INTO users (name, lname, email, nickname, password)
	VALUES('$name', '$lname', '$email', '$nickname', '$password')";
	mysql_query( $query) or die( mysql_error() );
	mysql_close();   
	echo "You have successfully Registered";
	}
?>

wartotojas wrote:

I tought it will work instead of echo statment

wartotojas wrote:

It is still doesnt work

<?php
// If the form has been submitted
if ( isset( $_POST[ 'submit' ] )
{
    // Check name and age are set.
    if ( isset( $_POST[ 'name' ] ) && isset( $_POST[ 'age' ] ) )
    {
        if ( strlen( $_POST[ 'name' ] ) > 0 && strlen( $_POST[ 'age' ] ) > 0 )
        {
            // Do more validation with name and age.
            // Do something with name and age.
            
            if ( *something* )
            {
                // Redirect.
                header( 'Location: redirect.php' );

                // Exit the script.
                exit();
            }
            else
                $result = 'Something went wrong!';
        }
        else
            $result = 'You must fill in name AND age.';
    }
    else
        $result = 'Name and age are not set';
}
?>
<html>
<head>
    ...
</head>
<body>

...

<!-- Output the result, if one is set. -->
<?php echo $result; ?>

<form action="" method="post">
    Name: <input type="text" name="name" />
    Age:  <input type="text" name="age" />
    <input type="submit" name="submit" />
</form

...

</body>
</html>

header( 'Location: members.php' );
echo 'This won\'t be output as it the page will have been redirected.';

echo 'This has been output, therefore headers cannot be set.';
header( 'Location: members.php' );

<?php
	$name_good = true;
	if(isset($_POST['reg'])
	{
		if(isset($_POST['name']))
		{
			$name = htmlspecialchars($_POST['name'],ENT_QUOTES);
		}
		else
		{
			$name = "";
		}
		if(strlen($name)>0)
		{
			/* form data is valid, proceed */
			
			
			/* add code to check name in db */
				
			if( /* if name is not in use */)
			{
				/* record the name, then.... */
				header("location: http://www.sitename.com/welcome.php');
			}
			else
			{
				$name_good = false;
			}
		}
	}
	$pg = "<html>\n";
	$pg.= "<head>\n";
	$pg.= "	<title>Register</title>\n";
	$pg.= "</head>\n";
	$pg.= "<body>\n";
	$pg.= "<form action='' method='post'>\n";
	$pg.= "Name: <input type='text' name='name'";
	if($name_good)
	{
		$pg.= " class='field_good' title='enter your name' ";
	}
	else
	{
		$pg.= " class='field_bad' title='name is in use' ";
	}
	$pg.= ">\n";
	$pg.= "<input type='submit' name='reg' value='Join Now!'>\n";
	$pg.= "</form>\n";
	$pg.= "</body>\n";
	$pg.= "</html>\n";
	print $pg;
?>

cjoki wrote:

$pg = "\n";
$pg.= "\n";
$pg.= " <title>Register\n";
$pg.= "\n";
$pg.= "\n";
$pg.= "\n";
$pg.= "Name:



Why are you assigning it to a variable? It's quicker just to output it directly onto the screen.

<head>
<title>Register</title>
</head>
<body>
<form action="" method="post">
Name: <input type="text" name="name"

<?
echo ($name_good) ? ' class="field_good" title="enter your name" ' : ' class="field_bad" title="name is in use" ';
?>

>
<input type="submit" name="reg" value="Join Now!">
</form>
</body>
</html>

Also use ' to encapsulate strings as they are quicker than ", as " marks compile the string to check for variables, hence why they are slower.

I suggest you look into using a template engine, such as Smarty[^], to format your pages.

If at first you don't succeed, you're not Chuck Norris.

cjoki wrote:

This style of code allows me to separate PHP and HTML from css and js.

<?
include('Smarty.class.php');
$Smarty = new Smarty();
$Smarty->assign( 'message' , 'Smarty Rocks!!!' );
$Smarty->display( 'index.tpl' );
?>

<html>
<head>
    <title>Smarty Example</title>
</head>
<body>

    {$message}

</body>
</html>

cjoki wrote:

Template engines just add another layer that IMHO is not needed and does little more than complicate a design and add to the learning.

cjoki wrote:

and why are you asking me to look into a template system when your concern is performance?

<?php
$msg = "Smarty What...?";

/* I know you like the echos... ;) */

echo "<html>";
echo "<head>";
echo "    <title>PHP Example</title>";
echo "</head>";
echo "<body>";
echo "<h1>".$msg."</h1>";
echo "</body>";
echo "</html>";
?>

<?
$msg = 'Smarty is cool';
?>

<html>
<head>
    <title>PHP Example</title>
</head>
<body>

    <h1><? echo $msg; ?></h1>

    <!-- OR -->

    <h1><?=$msg?></h1>

    <!-- If you have quick echoing enabled -->

</body>
</html>

cjoki wrote:

My file structure is also way more simplistic than a template engine. I do not have to hunt a templates code to find where they buried a code fragment.

/
   classes/
   logs/
   smarty/
       templates/
       templates_c/     // Where the template is compiled to.
   htdocs/
       css/
       js/
       img/

cjoki wrote:

With echo once something is echoed its gone to the browser.