Learn VBA & Macros in 1 Week!

PHP - Passing New Mysql Values To Form

Full Excel VBA Course - Beginner to Expert

Passing New Mysql Values To Form	View Content

I have managed to create an update script that allows a user to submit changes to their details but I need help to finish of the code. I'm using sessions to login in members, here is my update.php code.

After while($member = mysql_fetch_array($result)) { I would like to retrieve the new values entered by them to be displayed back to the previous form which uses $_SESSION to hold their information when they previously login.

Any suggestions or ideas, as I think it's to do with clearing the session but unfamiliar on how to proceed.

<?php

include("config.php");

mysql_connect("$dbhost","$dbuser","$dbpass") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());

$id= mysql_real_escape_string($_POST['member_id']);
$fname= mysql_real_escape_string($_POST['firstname']);
$lname= mysql_real_escape_string($_POST['lastname']);
$address= mysql_real_escape_string($_POST['address']);
$town= mysql_real_escape_string($_POST['address2']);
$county= mysql_real_escape_string($_POST['county']);
$postcode= mysql_real_escape_string($_POST['postcode']);
$telephone= mysql_real_escape_string($_POST['telephone']);
$mobile= mysql_real_escape_string($_POST['mobile']);
$username= mysql_real_escape_string($_POST['login']);
$email=mysql_real_escape_string($_POST['email']);

$id= $_POST['member_id'];

$sql="UPDATE members SET firstname='$fname', lastname='$lname', address='$address', address2='$town', county='$county', postcode='$postcode', telephone='$telephone', mobile='$mobile', login='$username', email='$email' WHERE member_id='$id' LIMIT 1";

$result=mysql_query($sql) or die ("Error: ". mysql_error(). " with query ". $sql);

$query = "SELECT * FROM members WHERE member_id = '$id'";
$result = mysql_query($query) or die(mysql_error());

while($member = mysql_fetch_array($result)) {

}
?>

Full Excel VBA Course - Beginner to Expert

Values Not Passing To Form?

Similar Tutorials

View Content

On one of my calculators : https://bizztools.net/2017/qccu/bizztools2015_budgetTest.php

When you press on the envelope in the middle you can send a form to yourself.
Currently it sends all the subtotals for each section .. Income, Personal, Debts etc and I wanted it to now send each individual value.

I've added the code in the file that gets used to send the form to the person's email.

Header section:

for ($i = 0; $i <= 79; $i++) {
$item_Annual[$i]  = number_format($_REQUEST['itemAnnualDisplay[$i]']); 
}

Body: (each line of the form has a different value for $item_Annual) from 1 to 79

		<TD bgcolor="#EEEEEE" align="left"  valign="middle" height="1"><Font style="font-family:Arial; font-size: 12px;"><font color="#000000">&nbsp;&nbsp;'.$currencySymbol.$item_Annual[1].' &nbsp;</TD>

I've also added the return code in the calculations php file.
This section of code is just for the Income sub section

for ($i = 0; $i <= 6; $i++) {
    $incomeSubtotal += $values[$i] * $periods[$i];
    $itemAnnual[$i] = $values[$i] * $periods[$i]; 
    $return['itemAnnualDisplay[$i]'] = $itemAnnual[$i]; 
}
                    
                    //New addtions are lines 3 and 4, the others were already there

Now, I've done some process of elimination and when testing to see if $periods[$i] and values[$i] would show up on the form, the values were zero for each. So each $itemAnnual[$i]is calculated to be $0.

You can see from the form screenshot, the subtotals are calculating, but the individual items are not.

Could this have anything to do with the form on the calculator page? It's in bootstrap.

Help please!!

Form Passing Incorrect Values.

Similar Tutorials

View Content

i am writing this script for use as an include in joomla and the directphp plugin so in my joomla article i have:
Code: [Select]
<?php
include 'test/conducttest.php';
conducttest();
?>
Ok now my issue!
the form in this function is passing only the values for the last item in the loop rather than for the selected radio item when submitted.
so when say for example the radio selected is:
ID TEST TYPE UNIQUE TEST ID AVAILABLE 5    Adolescent Clinical 50021629 1
and the last item in the list is:
ID TEST TYPE UNIQUE TEST ID AVAILABLE 4 Adult Clinical 12341629 1
When the form is submitted even if the 1st item is selected, it returns the value for the second one. I am sorta new to php so any suggestions will be appreciated.
Here is my full code:
Code: [Select]
<?php
function conducttest() {
    //GET JOOMLA USER ID & USERNAME FOR LOGGED USER
    $user =& JFactory::getUser();
    $userID = $user->id;

    //GET JOOMLA DATABASE OBJECTS
    $db =& JFactory::getDBO();

    //NEW TESTS QUERY (what purchased test are available for use with 'item_available' == '1' {unused test} and matching current 'user_id')
    $new_query =    "
                SELECT *
                FROM crt_transactionHistory
                WHERE user_id = ".$userID." AND item_available = '1'
                ORDER BY item_name, id
                ";
    $db->setQuery($new_query);
    $new = $db->loadAssocList();

    //OPEN TESTS QUERY (what purchased test are available for use with 'item_available' == '2' {resume test} and matching current 'user_id')
    $resume_query =    "
                SELECT *
                FROM crt_transactionHistory
                WHERE user_id = ".$userID." AND item_available = '2'
                ORDER BY item_name, id
                ";
    $db->setQuery($resume_query);
    $resume = $db->loadAssocList();

        //DISPLAY use_test FORM
        if(!isset($_POST['test'])) {
            //SELECT FORM: WHICH TEST WOULD YOU LIKE TO USE?
            echo '
                <fieldset>
                <table>
                <form method="post" action="'.$PHP_SELF.'">';
                if (empty($new)) {
                    echo '
                    <th colspan="3"align="left">NO NEW TESTS AVAILABLE</th>';
                }
                else {
                    echo '
                    <th colspan="3"align="left">NEW TESTS AVAILABLE</th>
                    <tr>
                        <td width="75px">SELECT</td>
                        <td width="50px">ID</td>
                        <td width="150px">TEST TYPE</td>
                        <td width="150px">UNIQUE TEST ID</td>
                    <tr>';
                    foreach ($new as $result1) {
                    echo '
                    <tr>
                        <td><input type="radio" value="' .$result1['id']. '" name="test_id"></td>
                        <td>'.$result1['id'].'</td>
                        <td><input type="hidden" value="'.$result1['item_name'].'" name="item_name">'.$result1['item_name'].'</td>
                        <td><input type="hidden" value="'.$result1['item_number'].'" name="item_number">'.$result1['item_number'].'</td>
                        <input type="hidden" value="'.$result1['item_available'].'" name="item_available">
                        <input type="hidden" value="'.$userID.'" name="userID">
                    <tr>';
                    }
                }
                echo '
                </table>
                <hr />
                <table>';
                if (empty($resume)) {
                    echo '
                    <th colspan="3"align="left">NO TESTS TO RESUME</th>';
                }
                else {
                    echo '
                    <th colspan="3"align="left">RESUME TEST</th>
                    <tr>
                        <td width="75px">SELECT</td>
                        <td width="50px">ID</td>
                        <td width="150px">TEST TYPE</td>
                        <td width="150px">UNIQUE TEST ID</td>
                    <tr>';
                    foreach ($resume as $result2) {
                    echo '
                    <tr>
                        <td><input type="radio" value="' .$result2['id']. '" name="test_id"></td>
                        <td>'.$result2['id'].'</td>
                        <td><input type="hidden" value="'.$result2['item_name'].'" name="item_name">'.$result2['item_name'].'</td>
                        <td><input type="hidden" value="'.$result2['item_number'].'" name="item_number">'.$result2['item_number'].'</td>
                        <input type="hidden" value="'.$result2['item_available'].'" name="item_available">
                        <input type="hidden" value="'.$userID.'" name="userID">
                    <tr>';
                    }
                }
                echo '
                </table>
                </fieldset>
                <input type="submit" name="test" value="Conduct Test" />
                </form>
                ';
            }
        //NOW A TEST HAS BEEN SELECTED FOR USE
        if(isset($_POST['test'])) {
            $test_id = $_POST['test_id'];
            $item_name = $_POST['item_name'];
            $item_number = $_POST['item_number'];
            $item_available = $_POST['item_available'];
            $userID = $_POST['userID'];
            echo $test_id.'<br />';
            echo $item_name.'<br />';
            echo $item_number.'<br />';
            echo $item_available.'<br />';
            echo $userID.'<br />';
            //IF THIS IS A NEW TEST...
            if ($item_available == "1") {
                echo 'new test';
            }
            //IF WE ARE RESUMING A TEST...
            elseif ($item_available == "2") {
                echo 'resume test';
            }
        }
}
?>

Passing Values

Similar Tutorials

View Content

hey guys
i am stuck at one part. i am coding a site where on the index page there are 5 categories. Now on click of these it takes me to a page where i can search within a particular category. i can do it by statically giving <href="localhost/xampp/abc.php">and a fixed page path. but i want the name of the category passed when i click and the search page to open when i open search.

thanks

Passing On Values

Similar Tutorials

View Content

Hi guys I would like to get whole content of html file after I submitted a password. The problem is that the my code doesn't access the value for the file. I tried to create a session but i doesn't work. What other option do I have to get the content of the html file?

session_start();
  	$selected_file = $_POST['radio1'];
  	// get the filename of the file
    $fileinfo = pathinfo($selected_file);
    $filename = $fileinfo['dirname'] . DIRECTORY_SEPARATOR . $fileinfo['filename'];
    $password = 'code';
    $lines = file("$filename.html");
    $_SESSION['selectedfile'] = $selected_file;
    $_SESSION['file'] =  $filename;
    $_SESSION['Scipt'] =  ("$filename.html");
    $_SESSION['Scipttext'] =  $lines;
  	$_SESSION['file2'] = $fileinfo;
	

if (isset($_POST['submitradio']))
{ 
 	 echo '<div class="imageselected">';
	 echo '<img src="'.$_SESSION['selectedfile'].'" /></br>'.PHP_EOL;
	 echo '</div>';
    // check to see if a html file named the same also exists
    if(file_exists($_SESSION['Scipt']))
    {
    	
    	echo "<form action='test_result.php' method='post'>";
    	echo '<div class="Password">';
    	echo 'Type in password to view full Script';
    	
		echo "<label><div class=\"Input\"><input type='password' name='passIT' value='passit'/></div>";
		echo "<input type='submit' name='submitPasswordIT' value='Submit Password'/></div>";
		echo '</div>';
		echo "$filename.html shares the same name as $selected_file";
		

		for($x = 1;$x<=15;$x++) {
		header( "Content-Type: file/html" );
		$lines = ($_SESSION['Scipttext']);
		$new = strip_tags($lines); 
		echo $lines[rand(0, count($lines)-1)]."<br>";
        }
    	// end of forloop
 
		}
  		// end of check
		  // start Sorrytext
		 
    		else
    		{
    		 echo '<div class="NoScript">';
        		echo "Nothing available at the moment.";
        		echo '</div>';
    		}
    		
		 // end Sorrytext
}
// End of submitradio
if($_POST['submitPasswordIT']){
if ($_POST['passIT']== $password ){
echo "You entered correct password";
readfile($_SESSION['Scipt']);
}
else{
echo "You entered wrong password";
}
}
echo '</form>';

Folks,

I have a dropdown, once values are selcted, these values should be put in a URL structure so that it matches with the one MoD_rewrite rule in my .htaccess.

Here is my Mod_Rewrite Rule:

RewriteRule ^(.*)/([^/]*)\.html$ search.php?q=$1&sc=$2 [QSA,L]

Here is my Dropdown Code:

<div id="search" >

<form id="searchform" method="get" action="search.php">
<label>Search By Brand/ Manufacturer: </label>

<select name="q">

<option value="SelectBrand">Select Brand</option>

<?php if(isset($this->search->options)): ?>
<?php foreach($mfg as $lolachild): ?>

</select>

<option value="All"><?php eprint(LangAll); ?></option>
<?php if(isset($this->search->options)): ?>
<?php foreach($this->search->options as $cat): ?>

<option value="<?php echo $cat->value; ?>"><?php echo $cat->name; ?></option>
<?php endforeach; ?>
<?php endif; ?>

</select>

<input type="submit" value="<?php eprint(LangSearch); ?>" />

</form>

</div>

Problem is, upon Submit, it goes to this link structu

http://mydomain.co.uk/search.php?q=fisher&sc=302

It should rather be:

http://au2.co.uk/fisher/302.html

What am i missing or doing wrong?

Cheer
Natasha

Moved: Passing Multiple Values To Javascript Function From Onclick() Action

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=359130.0

In Php, Retrieving Value From Db(mysql) And Passing It To Other Pages

Similar Tutorials

View Content

i am making a website and some part of which is to show user information...for this i had make a class and functions within it...one of the function is for retrieving values from database(im using mysql)...i know a variable is limited only in function,also tried $_session for this too..the function works fine ....but it is not sendind the information to the page from where im calling it...here is my code.....

in xyz.php file

<?php
class book{

public $v1;
public $v2;
public $v3;

function book(){

}

function page1(){

$this->con=mysql_connect("localhost","root","usa");
   $this->db=mysql_select_db("truth",$this->con);

     }

function page2($xyz){
$this->page1();
$query="SELECT * FROM member_signup WHERE Uid=$xyz";
$result=mysql_query($query,$this->con);
    $result1=mysql_fetch_array($result);
    $_SESSION['info']=$result1;
    return $_SESSION['info'];
    return $result1;
}
}?>

in show.php file

<?
require_once("xyz.php");

$pen = new book;

if($pen->page2(100011))
{ session_start();
if (mysql_error())
     { print "Database ERROR: " . mysql_error(); }
else{
echo "cows";

echo "<br>cows<br>";
echo "my name is'".$_SESSION['info']."'";
echo "my name is'".$_SESSION['FIRST_NAME']."'"; //i have a fied is db named FIRST_NAME

}
}
else{echo "happy";}

?>

Passing $string Variable Into Mysql Query

Similar Tutorials

View Content

I am trying to pass in a $string variable into my query like so but it is returning a warning:

Code: [Select]
$string = "clientName == '$input'";
$input = "Sam";

$table_id = 'booking';
$query ="SELECT *
FROM booking
WHERE. '$string' ";

$test = mysql_query($query);

echo $test;

Passing Session Variables To A Mysql Database !!!help!!!

Similar Tutorials

View Content

Hola,

I'm trying to create a web form to insert info into my database using session variables. I'm at my wits end at this point. The reset button does its job but when you click submit it doesn't do anything. I'm using the template from the lynda.com essential php web form tutorials. Any help would be appreciated

Here is the client-side header code I'm working with,

<?php
header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
   header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
header ("Pragma: no-cache");                          // HTTP/1.0
session_start();

if (!isset($_SESSION['SESSION'])) require ( "include/session_init.php");

$arVal = array();
require_once("include/session_funcs1.php");

// make sure the seesion vars are initialized...
reset ($arVal);
while (list ($key, $val) = each ($arVal)) {
if (!isset($_SESSION[$key])) $_SESSION[$key] = "";
}

if ($_SESSION["eventgenre_sel"] == "") $_SESSION["eventgenre_sel"] = 0;

// if the bFlg is true then some validation problems in the data.
// namely a blank field or a submission without the feedback page.
// just present a general error...

$flg = "";
$error = "";
if (isset($HTTP_GET_VARS["flg"])) $flg = $HTTP_GET_VARS["flg"];

switch ($flg) {
case "red":
$error = "<br><font class=\"txt12_red\">Please fill out all the required fields.<br>Please Try Again.<BR></font>";
break;
case "blue":
$error = "<br><font class=\"txt12_red\">Your Session has Expired.<br>Please Try Again.</font><BR>";
break;
case "pink":
$error = "<br><font class=\"txt12_red\"><BR>The Special Code you entered is not valid.<br>Please Try Again or Leave that field blank.</font><BR>";
break;
case "white":
$error = "<br><font class=\"txt12_red\"><BR>The fields are too long for our Database.<br>Please correct your data via this form.</font><BR>";
break;
default:
$error = "";
}

?>

<?php  echo $_SERVER['SCRIPT_NAME']."<BR>"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<link rel="stylesheet" type="text/css" href="detect800.css"/>
<link rel="stylesheet" type="text/css" href="detect1024.css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="detect.js"></script>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/base/ui.all.css" rel="stylesheet" type="text/css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.0/jquery-ui.min.js" type="text/javascript"></script>
<script src="jquery.ui.datetimepicker.js" type="text/javascript"></script>
<script type="text/javascript">
     $(function() {
        $('#eventdate').datetimepicker();
     });
</script>
<script src="imageflow.js" type="text/javascript"></script>
<script src="highslide-full.js" type="text/javascript"></script>
<script src="autosuggest.js" type="text/javascript"></script>
<script type="text/javascript">
hs.graphicsDir = 'graphics/';
</script>

<script language="javascript">
function SubmitForm() {
var form = document.forms[0];
var bRequired = true;
if((form.eventname.value.length < 1) ||
(form.eventvenue.value.length < 1) ||
(form.eventdate.value.length < 1) ||
(form.eventgenre.value.length < 1) ||
(form.eventprice.value.length < 1) ||
(form.eventpromoter.value.length < 1) ||
(form.eventflyer.value.length < 1)) {
alert("Please fill out all the required fields.");
bRequired = false;
}

if (!bRequired) return false;

form.eventgenre_sel.value = form.state.selectedIndex;

form.submit();
}

function ResetForm() {
var form = document.forms[0];
form.eventname.value = "";
form.eventvenue.value = "";
form.eventdate.value = "";
form.eventgenre.value = "";
form.eventprice.value = "";
form.eventpromoter.value = "";
form.eventflyer.value = "";

form.eventgenre_sel.value = "";
}

</script>
</head>

This is the client side form code

<form action="scripts/register.php" method="post" name="userevent" id="userevent">
     <input name="eventgenre_sel" type="hidden" id="eventgenre_sel" value="<?php echo $_SESSION['eventgenre_sel'] ?>" />

<?php echo $error; ?>

<fieldset>
<label for="eventname" accesskey="n" ><span>Event Name</span>
<input type="text" name="eventname" id="eventname" value="<?php echo $_SESSION['eventname_sel']  ?>" size="32" maxlength="30" /></label>

<div id="autosuggest"><ul><li></li></ul></div>
<label for="eventvenue" accesskey="v" ><span>Event Venue</span>
<input type="text" name="eventvenue" id="eventvenue" size="32" value="<?php echo $_SESSION['eventvenue']  ?>" maxlength="30" /></label>

<script type="text/javascript">
var venues = new Array("Republik", "HiFi Club", "Bamboo Tiki Room", "Tantra", "Jubilee Auditorium", "Ironwood Stage & Grill", "Broken City", "Soda", "Amsterdam Rhino", "Olympic Plaza", "Stampede Casino", "Habitat Living Sound", "Cantos Music Foundation", "Flames Central", "Prince's Island Park", "Beat Niq Jazz & Social Club", "Giuseppe's Italian Market", "BLVD", "Fourth on 4th", "Opus on 8th", "Local 510", "Local 522", "Raw Bar", "Jupiter Restaurant & Bar", "Vern's", "Lord Nelson's", "Kings Head Pub", "Blind Beggar Pub", "Viscous Circle", "Milk Tiger Lounge", "Pengrowth Saddledome", "Tubby Dog", "Marquee Room", "Distillery Public House", "Cafe Koi", "Mikey's Juke Joint & Eatery", "Palomino", "Atlantic Trap & Gill", "Drake Inn", "Radiopark Music Room", "Rusty Cage South", "Big Al's Good Times Bar", "Rose & Crown", "Tudor Rose Pub", "Elbow River Casino & Lounge", "Rusty Cage Central", "Rusty Cage South", "Rusty Cage North", "Olive Grove", "Shamrock Hotel", "Woody's Taphouse Southland", "Woody's Taphouse Country Hills", "Murrieta's West Coast Bar & Grill", "Stageline Saloon", "Pig & Pint", "Ranchman's", "Red Pepper Pub", "Stavro's Steak House & Lounge Ranchlands", "Stageline Saloon", "Whiskey");
new AutoSuggest(document.getElementById("eventvenue"),venues);
</script>

<label for="eventdate" accesskey="d" ><span>Event Date</span>
<input type="text" name="eventdate" id="eventdate" value="<?php echo $_SESSION['eventdate']  ?>" size="32" maxlength="30" /></label>

<label for="eventgenre" accesskey="g" ><span>Event Genre</span>
<select name="eventgenre" id="eventgenre">
<option value="none">--select one--</option>
<option value="HipHop">Hip-Hop</option>
<option value="Funk">Funk</option>
<option value="Soul">Soul</option>
<option value="Metal">Metal</option>
<option value="Punk">Punk</option>
<option value="Blues">Blues</option>
<option value="Jazz">Jazz</option>
<option value="Trance">Trance</option>
<option value="Breaks">Breaks</option>
<option value="Electro">Electro</option>
<option value="House">House</option>
<option value="DNB">Drum'N'Bass</option>
<option value="Dubstep">Dubstep</option>
<option value="Lounge">Lounge</option>
<option value="Top40">Top 40</option>
</select>
</label>

<label for="eventprice" accesskey="p" ><span id="eventprice">Event Price</span>
<input type="text" name="eventprice" id="eventprice" value="<?php echo $_SESSION['eventprice']  ?>" size="6" maxlength="4"/></label>

<label for="eventpromoter" accesskey="c" ><span id="eventpromoter">Event Promoter</span>
<input type="text" name="eventpromoter" id="eventpromoter" value="<?php echo $_SESSION['eventpromoter']  ?>" size="25" maxlength="23"/></label>

<label for="eventflyer" accesskey="f" ><span id="eventflyer">Event Flyer (jpg or png MAX 300kb)</span>
<input type="file" name="eventflyer" id="eventflyer" value="<?php echo $_SESSION['eventflyer']  ?>" size="25" maxlength="23"/></label>

<input type="button" name="Reset" value="Reset" onclick="ResetForm();">                           
<input type="button" name="Submit" value="Submit" onsubmit="return validateForm(this);" onclick="SubmitForm();  return false; " >

</fieldset>
</form>
<script language="javascript">
// set the selection box values...

var form = document.forms[0];
form.eventgenre.selectedIndex = parseInt("<?php echo $_SESSION['eventgenre_sel'] ?>");

</script>

And this is the server-side code.

<?php

$debug = FALSE;

/************************************************************
   Adjust the headers...
************************************************************/
header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
   header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
header ("Pragma: no-cache");                          // HTTP/1.0

/*****************************************************************************
   Check the session details.
   we will store all the post variables in session variables
   this will make it easier to work with the verification routines
*****************************************************************************/
session_start();

if (!isset($_SESSION['SESSION'])) require_once( "include/session_init.php" );

$arVal = array();
require_once("include/session_funcs1.php");

reset ($_POST);
while (list ($key, $val) = each ($_POST)) {
if ($val == "") $val = "NULL";
$arVals[$key] = (get_magic_quotes_gpc()) ? $val : addslashes($val);
if ($val == "NULL")
$_SESSION[$key] = NULL;
else
$_SESSION[$key] = $val;

if ($debug) echo $key . " : " . $arVals[$key] . "<br>";
}

/**********************************************************************************************
   Make sure session variables have been set and then check for required fields
   otherwise return to the registration form to fix the errors.
**********************************************************************************************/

// check to see if these variables have been set...
if ((!isset($_SESSION["eventname"])) || (!isset($_SESSION["eventvenue"])) || (!isset($_SESSION["eventdate"])) ||  (!isset($_SESSION["eventgenre"]))
|| (!isset($_SESSION["eventprice"])) || (!isset($_SESSION["eventpromoter"])) || (!isset($_SESSION["eventflyer"]))) {
resendToForm("?flg=red");
}
// form variables must have something in them...
if ($_SESSION['eventname'] == "" || $_SESSION['eventvenue'] == "" || $_SESSION['eventdate'] == "" || $_SESSION['eventgenre'] == "" || $_SESSION['eventprice'] == "" || $_SESSION['eventpromoter'] == "" || $_SESSION['eventflyer'] == "") {
resendToForm("?flg=red");
}

// make sure fields are within the proper range...
if (strlen($_SESSION['eventname']) > 35 || strlen($_SESSION['eventvenue']) > 35
|| strlen($_SESSION['eventdate']) > 35 || strlen($_SESSION['eventgenre']) > 35
|| strlen($_SESSION['eventprice']) > 35 || strlen($_SESSION['eventpromoter']) > 35
|| strlen($_SESSION['eventflyer']) > 35 ) {
resendToForm("?flg=white");
}

/**********************************************************************************************
  Insert into the database...
**********************************************************************************************/

$query = "INSERT INTO td_events (seventname, seventvenue, seventdate, seventgenre, seventprice, seventpromoter, seventflyer) "
."VALUES (".$arVals['eventname'].", ".$arVals['eventvenue'].", ".$arVals['eventdate'].", ".$arVals['eventgenre']
.", ".$arVals['eventprice'].", ".$arVals['eventpromoter'].", ".$arVals['eventflyer'].")";

//echo $query;

$result = mysql_query($query) or die("Invalid query: " . mysql_error() . "<br><br>". $query);
$insertid = mysql_insert_id();

/*** This following function will update session variables and resend to the form so the user can fix errors ***/

function resendToForm($flags) {
reset ($_POST);
// store variables in session...
while (list ($key, $val) = each ($_POST)) {
$_SESSION[$key] = $val;
}
// go back to the form...
//echo $flags;
header("Location: ./user_registration.php".$flags);
exit;
}

?>
<p>SUCCESS!<br>
  The event was entered in the database!<br>
  You probably want to redirect to a thank you page or send an email to the user for confirmation.<br>
  <br>
  <br>
  Here are the variables...<br>

<?php
reset ($arVals);
while (list ($key, $val) = each ($arVals)) {
echo $key . " : " . $arVals[$key] . "<br>";
}

echo "<br><br>The SQL Statment was:<br>";
echo $query."<br><br><br><br>";
?>
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>

<?php
/**********************************************************************************************

   CREATES THUMBNAIL

**********************************************************************************************/

//define a maxim size for the uploaded images
define ("MAX_SIZE","1024");
// define the width and height for the thumbnail
// note that theese dimmensions are considered the maximum dimmension and are not fixed,
// because we have to keep the image ratio intact or it will be deformed
define ("WIDTH","500");
define ("HEIGHT","650");

  // this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get image extension.
$ext=getExtension($img_name);
//creates the new image using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext) || !strcmp("JPG",$ext))
$src_img=imagecreatefromjpeg($img_name);

   if(!strcmp("png",$ext) || !strcmp("PNG",$ext))
$src_img=imagecreatefrompng($img_name);

//gets the dimmensions of the image
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);

// next we will calculate the new dimmensions for the thumbnail image
// the next steps will be taken:
// 1. calculate the ratio by dividing the old dimmensions with the new ones
// 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
// and the height will be calculated so the image ratio will not change
// 3. otherwise we will use the height ratio for the image
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2) {
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else {
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}

   // we create a new image with the new dimmensions
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

// resize the big image to the new created one
imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);

// output the created image to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename);
else
imagejpeg($dst_img,$filename);

   //destroys source and destination images.
imagedestroy($dst_img);
imagedestroy($src_img);
}

// This function reads the extension of the file.
// It is used to determine if the file is an image by checking the extension.
function getExtension($str) {
         $i = strrpos($str,".");
         if (!$i) { return ""; }
         $l = strlen($str) - $i;
         $ext = substr($str,$i+1,$l);
         return $ext;
}
// This variable is used as a flag. The value is initialized with 0 (meaning no error found)
// and it will be changed to 1 if an error occurs. If the error occurs the file will not be uploaded.
$errors=0;
// checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['eventflyer']['name'];
// if it is not empty
if ($image)
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['eventflyer']['name']);

// get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message
// and will not upload the file, otherwise we continue
if (($extension != "jpg")  && ($extension != "jpeg") && ($extension != "JPG") && ($extension != "PNG") && ($extension != "png"))
{
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
// get the size of the image in bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which
// the uploaded file was stored on the server
$size=getimagesize($_FILES['eventflyer']['tmp_name']);
$sizekb=filesize($_FILES['eventflyer']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*500)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

   //we will give an unique name, for example the time in unix time format
$image_name=$filename;
//the new name will be containing the full path where will be stored (images folder)
$newname="flyers/".$image_name;
$copied = copy($_FILES['eventflyer']['tmp_name'], $newname);
//we verify if the image has been uploaded, and print error instead
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name='flyers/thumb_'.$image_name;
// call the function that will create the thumbnail. The function will get as parameters
// the image name, the thumbnail name and the width and height desired for the thumbnail
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

  //If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors)
{
echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
}
?>