Hi can some one help me myphpadmin info was deleted and i have no back up nore my host since it was a free host n all info is lost , but i still have the forms and information to collect script , how ddo i create a table database or is there away upload my scrip and auto do it , i created new database but have no idea to collect information from the forms i have please help desperate house husband lol
<? include_once "connect.php"; include_once "../functions.php"; if (isset ( $_GET ["logout"] )) { $_SESSION ['compid'] = 0; header('location: index.php'); exit("Logged Out"); } if ($compid) { $msg = "Already Logged"; header('location: index.php'); exit(); } elseif (!empty ( $_POST ["password"] ) && !empty ( $_POST ["username"] )) { $inUser = fixquotes ( $_POST ["username"] ); $inPassword = fixquotes ( $_POST ["password"] ); $rs = mysql_query ( "SELECT id FROM companies AS u WHERE username='$inUser' AND password='$inPassword'" ) or die ( "Error" ); if (mysql_num_rows ( $rs )) { list($compid) = mysql_fetch_array ( $rs ); $_SESSION ['compid'] = $compid; header('location: index.php'); exit("Logged in"); } elseif (0&&$_REQUEST['register']) { $inName = fixquotes($_REQUEST['name']); $street = fixquotes($_REQUEST['street']); $city = fixquotes($_REQUEST['city']); $state = fixquotes($_REQUEST['state']); $zipcode = fixquotes($_REQUEST['zipcode']); $website = fixquotes($_REQUEST['website']); $firstName = fixquotes($_REQUEST['firstName']); $lastName = fixquotes($_REQUEST['lastName']); $workPhone = fixquotes($_REQUEST['workPhone']); $cellPhone = fixquotes($_REQUEST['cellPhone']); $fax = fixquotes($_REQUEST['fax']); $dot = fixquotes($_REQUEST['dot']); $mc = fixquotes($_REQUEST['mc']); $trucks = intval($_REQUEST['trucks']); $website = "http://".str_replace("http://", "", $website); if (!$inName || !$inEmail || !$inPassword || !checkEmail($inEmail) || !$state || !$firstName || !$workPhone || !$dot) { $msg = "Invalid Registery Details"; } else { mysql_query("INSERT INTO users (name, email, password, street, city, state, zipcode, website, firstName, lastName, workPhone, cellPhone, fax, dot, mc, trucks) VALUES('$inName', '$inEmail', '$inPassword', '$street', '$city', '$state', '$zipcode', '$website', '$firstName', '$lastName', '$workPhone', '$cellPhone', '$fax', '$dot', '$mc', '$trucks')") or die("Error"); $rs = mysql_query ( "SELECT id FROM users AS u WHERE email='$inEmail' AND password='$inPassword'" ) or die ( "Error" ); list($compid) = mysql_fetch_array ( $rs ); if ($compid) { $_SESSION ['compid'] = $compid; $msg = "Registered Successfully"; $headers = "MIME-Version: 1.0\n"; $headers .= "Content-type: text/html; charset=windows-1255\n"; $headers .= "From: Movers Community \n"; $MSG = "
Thank you for registering to MoversCommunity.com
These are your user details:
Company Name: $inName,
Contact Email: $inEmail,
Password: $inPassword,
Street: $street,
City: $city,
State: $state,
Zipcode: $zipcode,
Website: $website,
Contact First Name: $firstName,
Contact Last Name: $lastName,
Work Phone: $workPhone,
Cell Phone: $cellPhone,
Fax: $fax,
DOT#: $dot,
MC#: $mc,
# of Trucks: $trucks
";
mail($inEmail, "Registered Successfully", $MSG, $headers);
}
else {
$msg = "Invalid Registery Details";
}
}
}
else {
$_SESSION ['compid'] = 0;
$msg = "Invalid Details";
}
}
include_once "header.php";
?>
These are your user details:
Company Name: $inName,
Contact Email: $inEmail,
Password: $inPassword,
Street: $street,
City: $city,
State: $state,
Zipcode: $zipcode,
Website: $website,
Contact First Name: $firstName,
Contact Last Name: $lastName,
Work Phone: $workPhone,
Cell Phone: $cellPhone,
Fax: $fax,
DOT#: $dot,
MC#: $mc,
# of Trucks: $trucks
![]()
Login
<?
if (!empty($msg)) {
echo "$msg
";
if ($_SESSION['compid']!=0) {//logged
include "footer.php";
exit();
}
}
?>
LOGIN
|
Username: '> Password: |