Sou a: Inici / Usuaris / jordifarrero / 2013-14 :: IAW :: ASIX2AB TARDA / Sourcerer :: Self - Submit DB Connect

Sourcerer :: Self - Submit DB Connect

<!DOCTYPE HTML>
<html>
<head>
<style>
.error {color: #FF0000;}
</style>
</head>
<body>

<?php
// define variables and set to empty values
$nameErr = $emailErr = $genderErr = $websiteErr = "";
$name = $email = $gender = $comment = $website = "";

if ($_SERVER["REQUEST_METHOD"] == "POST")
{
   if (empty($_POST["name"]))
     {$nameErr = "Name is required";}
   else
     {
     $name = test_input($_POST["name"]);
     // check if name only contains letters and whitespace
     if (!preg_match("/^[a-zA-Z ]*$/",$name))
       {
       $nameErr = "Only letters and white space allowed";
       }
     }
 
   if (empty($_POST["email"]))
     {$emailErr = "Email is required";}
   else
     {
     $email = test_input($_POST["email"]);
     // check if e-mail address syntax is valid
     if (!preg_match("/([\w\-]+\@[\w\-]+\.[\w\-]+)/",$email))
       {
       $emailErr = "Invalid email format";
       }
     }
    
   if (empty($_POST["website"]))
     {$website = "";}
   else
     {
     $website = test_input($_POST["website"]);
     // check if URL address syntax is valid (this regular expression also allows dashes in the URL)
     if (!preg_match("/\b(?:(?:https?|ftp):\/\/|www\.)[-a-z0-9+&@#\/%?=~_|!:,.;]*[-a-z0-9+&@#\/%=~_|]/i",$website))
       {
       $websiteErr = "Invalid URL";
       }
     }

   if (empty($_POST["comment"]))
     {$comment = "";}
   else
     {$comment = test_input($_POST["comment"]);}

   if (empty($_POST["gender"]))
     {$genderErr = "Gender is required";}
   else
     {$gender = test_input($_POST["gender"]);}
}

function test_input($data)
{
     $data = trim($data);
     $data = stripslashes($data);
     $data = htmlspecialchars($data);
     return $data;
}

if(!isset($_POST['submit']))
{
?>
<h2>PHP Form Validation Example</h2>
<p><span class="error">* required field.</span></p>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
   Name: <input type="text" name="name" value="<?php echo $name;?>">
   <span class="error">* <?php echo $nameErr;?></span>
   <br><br>
   E-mail: <input type="text" name="email" value="<?php echo $email;?>">
   <span class="error">* <?php echo $emailErr;?></span>
   <br><br>
   Website: <input type="text" name="website" value="<?php echo $website;?>">
   <span class="error"><?php echo $websiteErr;?></span>
   <br><br>
   Comment: <textarea name="comment" rows="5" cols="40"><?php echo $comment;?></textarea>
   <br><br>
   Gender:
   <input type="radio" name="gender" <?php if (isset($gender) && $gender=="female") echo "checked";?>  value="female">Female
   <input type="radio" name="gender" <?php if (isset($gender) && $gender=="male") echo "checked";?>  value="male">Male
   <span class="error">* <?php echo $genderErr;?></span>
   <br><br>
   <input type="submit" name="submit" value="Submit">
</form>
<?php
}
else{
    
echo $websiteErr . '<br>';
echo $nameErr . '<br>';
echo $emailErr . '<br>';
echo $genderErr . '<br>';

echo 'DATABASE CONNECT<br>';
$username = "root";
$password = "mipassword";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
  or die("Unable to connect to MySQL");
echo "<br>Connected to MySQL<br>";

//select a database to work with
$selected = mysql_select_db("ContrUGT",$dbhandle)
  or die("Could not select ContrUGT");

//execute the SQL query and return records
$result = mysql_query("SELECT name, username FROM Tabla_users");
//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {
   echo "Name:".$row{'name'}." <br>User:".$row{'username'}."<br>";
}

//close the connection
mysql_close($dbhandle);


    echo "<h2>Your Input:</h2>";
    echo $name;
    echo "<br>";
    echo $email;
    echo "<br>";
    echo $website;
    echo "<br>";
    echo $comment;
    echo "<br>";
    echo $gender;
    


}
?>
</body>
</html>

<?php
$user= &JFactory::getUser();

$usr_id = $user->get('id');
echo $usr_id;
print " <br>Editing not permitted";



$session =& JFactory::getSession();
$session->set( 'myvar', 'helloworld' );

echo 'Session variable myvar has value: ' . $session->get( 'myvar');

?>

<?php
class MyWebApp extends JApplicationWeb
{
                /**
                 * Display the application.
                 */
                protected function doExecute(){
 
                        $this->setBody(



                                '<h1>My Web Application</h1>'.
                                'The current URL is '.JUri::current().'<br/>'.
                                'The date is '. JFactory::getDate('now')
                        );
                }
}