Inserting logged in username to table
Posted: Fri Jan 09, 2009 3:54 pm
I'm building my first webpage with PHP and have finally ran into an issue I can't find a solution for. When submitting a form from a user, I want to also submit the currently logged in userid into the record. A session is created when the user logs in Can someone shed some light on this? Here is the code.
<?php
// Receiving variables
@$pfw_ip= $_SERVER['REMOTE_ADDR'];
@$Vmake = addslashes($_POST['Vmake']);
@$vmodel = addslashes($_POST['vmodel']);
@$vin = addslashes($_POST['vin']);
@$mileage = addslashes($_POST['mileage']);
@$probdescrip = addslashes($_POST['probdescrip']);
// Validation
if (strlen($Vmake) <2)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($Vmake) >20)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($Vmake) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($vmodel) <2)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vmodel) >20)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vmodel) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vin) !=17)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid vin</font></p>");
}
if (strlen($vin) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid vin</font></p>");
}
if (strlen($mileage) <1)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($mileage) >10)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($mileage) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($probdescrip) <5)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
if (strlen($probdescrip) >255)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
if (strlen($probdescrip) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
//Sending auto respond Email to visitor
$pfw_header = "From: sanfordss@hotmail.com\n"
. "Reply-To: \n";
$pfw_subject = "Hi";
$pfw_email_to = "";
$pfw_message = "Thanks";
@mail($pfw_email_to, $pfw_subject ,$pfw_message ,$pfw_header ) ;
//saving record to MySQL database
@$pfw_strQuery = "INSERT INTO `rrequest`(`vmake`,`vmodel`,`vin`,`mileage`,`probdescrip`)VALUES
(\"$Vmake\",\"$vmodel\",\"$vin\",\"$mileage\",\"$probdescrip\")" ;
@$pfw_host = "localhost";
@$pfw_user = "root";
@$pfw_pw = "";
@$pfw_db = "members";
$pfw_link = mysql_connect($pfw_host, $pfw_user, $pfw_pw);
if (!$pfw_link) {
die('Could not connect: ' . mysql_error());
}
$pfw_db_selected = mysql_select_db($pfw_db, $pfw_link);
if (!$pfw_db_selected) {
die ('Can not use $pfw_db : ' . mysql_error());
}
//insert new record
$pfw_result = mysql_query($pfw_strQuery);
if (!$pfw_result) {
die('Invalid query: ' . mysql_error());
}
mysql_close($pfw_link);
echo("<p align='center'><font face='Arial' size='3' color='#000000'>Your request has been submitted. Please check the
Request History page for status of your request.</font></p>");
?>
<?php
// Receiving variables
@$pfw_ip= $_SERVER['REMOTE_ADDR'];
@$Vmake = addslashes($_POST['Vmake']);
@$vmodel = addslashes($_POST['vmodel']);
@$vin = addslashes($_POST['vin']);
@$mileage = addslashes($_POST['mileage']);
@$probdescrip = addslashes($_POST['probdescrip']);
// Validation
if (strlen($Vmake) <2)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($Vmake) >20)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($Vmake) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid make</font></p>");
}
if (strlen($vmodel) <2)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vmodel) >20)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vmodel) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid model</font></p>");
}
if (strlen($vin) !=17)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid vin</font></p>");
}
if (strlen($vin) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid vin</font></p>");
}
if (strlen($mileage) <1)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($mileage) >10)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($mileage) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid mileage</font></p>");
}
if (strlen($probdescrip) <5)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
if (strlen($probdescrip) >255)
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
if (strlen($probdescrip) == 0 )
{
die("<p align='center'><font face='Arial' size='3' color='#FF0000'>Please enter a valid problem description. Muct be a
minimum of 5 characters</font></p>");
}
//Sending auto respond Email to visitor
$pfw_header = "From: sanfordss@hotmail.com\n"
. "Reply-To: \n";
$pfw_subject = "Hi";
$pfw_email_to = "";
$pfw_message = "Thanks";
@mail($pfw_email_to, $pfw_subject ,$pfw_message ,$pfw_header ) ;
//saving record to MySQL database
@$pfw_strQuery = "INSERT INTO `rrequest`(`vmake`,`vmodel`,`vin`,`mileage`,`probdescrip`)VALUES
(\"$Vmake\",\"$vmodel\",\"$vin\",\"$mileage\",\"$probdescrip\")" ;
@$pfw_host = "localhost";
@$pfw_user = "root";
@$pfw_pw = "";
@$pfw_db = "members";
$pfw_link = mysql_connect($pfw_host, $pfw_user, $pfw_pw);
if (!$pfw_link) {
die('Could not connect: ' . mysql_error());
}
$pfw_db_selected = mysql_select_db($pfw_db, $pfw_link);
if (!$pfw_db_selected) {
die ('Can not use $pfw_db : ' . mysql_error());
}
//insert new record
$pfw_result = mysql_query($pfw_strQuery);
if (!$pfw_result) {
die('Invalid query: ' . mysql_error());
}
mysql_close($pfw_link);
echo("<p align='center'><font face='Arial' size='3' color='#000000'>Your request has been submitted. Please check the
Request History page for status of your request.</font></p>");
?>