I have a website and I am using PHP to connect to MYSQL for login database. The code right now is just text and textboxes. I want to format it using tables like in HTML for positioning and some formatting in text and etc... How do I go about doing this? I have tried many ways with no success. The code for a customer profile is below:
"<?php
session_start();
include 'config.php';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Profile</title>
</head>
<body>
<?php
if(isset($REQUEST['logged'])){
$fname = $SESSION['first_name'];
$lname = $_SESSION['last_name'];
$query = "SELECT * FROM users WHERE email_address='$email_address'";
$results = mysql_query($query);
$num = mysql_num_rows($results);
while ($row= mysql_fetch_array($results)) {
$userid = $row["userid"];
$first_name = $row["first_name"];
$last_name = $row["last_name"];
$email_address = $row["email_address"];
$username = $row["username"];
$b_firstname = $row["b_firstname"];
$b_lastname = $row["b_lastname"];
$b_addr = $row["b_addr"];
$b_addr2 = $row["b_addr2"];
$b_city = $row["b_city"];
$b_state = $row["b_state"];
$b_zip = $row["b_zip"];
$b_phone = $row["b_phone"];
$b_fax = $row["b_fax"];
$b_email = $row["b_email"];
$s_firstname = $row["s_firstname"];
$s_lastname = $row["s_lastname"];
$s_addr = $row["s_addr"];
$s_addr2 = $row["s_addr2"];
$s_city = $row["s_city"];
$s_state = $row["s_state"];
$s_zip = $row["s_zip"];
$s_phone = $row["s_phone"];
$s_fax = $row["s_fax"];
$s_email = $row["s_email"];
$signup_date = $row["signup_date"];
$last_login = $row["last_login"];
echo "<b>Hello, $first_name $last_name.<br><br>";
echo "Your Profile.</b>";
echo "<br><br>";
echo "<form name=\"profile\" action=\"profile_update.php\" method=\"post\">";
echo "<table>";
echo "<tr><td>User ID:</td><td><input type=\"text\" name=\"userid\" value=\"$userid\" readonly></td></tr>";
echo "<tr><td>First Name:</td><td><input type=\"text\" name=\"first_name\" value=\"$first_name\"></td></tr>";
echo "<tr><td>Last Name:</td><td><input type=\"text\" name=\"last_name\" value=\"$last_name\"></td></tr>";
echo "<tr><td>Email Address:</td><td><input type=\"text\" name=\"email_address\" value=\"$email_address\"></td></tr>";
echo "<tr><td>Signup Date:</td><td><input type=\"text\" name=\"signup_date\" value=\"$signup_date\" readonly></td></tr>";
echo "<tr><td>Last Login Date:</td><td><input type=\"text\" name=\"last_login\" value=\"$last_login\" readonly></td></tr>";
echo "<tr><td>First Name:</td><td><input type=\"text\" name=\"b_firstname\" value=\"$b_firstname\"></td></tr>";
echo "<tr><td>Last Name:</td><td><input type=\"text\" name=\"b_lastname\" value=\"$b_lastname\"></td></tr>";
echo "<tr><td>Address:</td><td><input type=\"text\" name=\"b_addr\" value=\"$b_addr\"></td></tr>";
echo "<tr><td>Address:</td><td><input type=\"text\" name=\"b_addr2\" value=\"$b_addr2\"></td></tr>";
echo "<tr><td>City:</td><td><input type=\"text\" name=\"b_city\" value=\"$b_city\"></td></tr>";
echo "<tr><td>State:</td><td><input type=\"text\" name=\"b_state\" value=\"$b_state\"></td></tr>";
echo "<tr><td>Zip:</td><td><input type=\"text\" name=\"b_zip\" value=\"$b_zip\"></td></tr>";
echo "<tr><td>Phone:</td><td><input type=\"text\" name=\"b_phone\" value=\"$b_phone\"></td></tr>";
echo "<tr><td>Fax:</td><td><input type=\"text\" name=\"b_fax\" value=\"$b_fax\"></td></tr>";
echo "<tr><td>Email:</td><td><input type=\"text\" name=\"b_email\" value=\"$b_email\"></td></tr>";
echo "<tr><td>First Name:</td><td><input type=\"text\" name=\"s_firstname\" value=\"$s_firstname\"></td></tr>";
echo "<tr><td>Last Name:</td><td><input type=\"text\" name=\"s_lastname\" value=\"$s_lastname\"></td></tr>";
echo "<tr><td>Address:</td><td><input type=\"text\" name=\"s_addr\" value=\"$s_addr\"></td></tr>";
echo "<tr><td>Address:</td><td><input type=\"text\" name=\"s_addr2\" value=\"$s_addr2\"></td></tr>";
echo "<tr><td>City:</td><td><input type=\"text\" name=\"s_city\" value=\"$s_city\"></td></tr>";
echo "<tr><td>State:</td><td><input type=\"text\" name=\"s_state\" value=\"$s_state\"></td></tr>";
echo "<tr><td>Zip:</td><td><input type=\"text\" name=\"s_zip\" value=\"$s_zip\"></td></tr>";
echo "<tr><td>Phone:</td><td><input type=\"text\" name=\"s_phone\" value=\"$s_phone\"></td></tr>";
echo "<tr><td>Fax:</td><td><input type=\"text\" name=\"s_fax\" value=\"$s_fax\"></td></tr>";
echo "<tr><td>Email:</td><td><input type=\"text\" name=\"s_email\" value=\"$s_email\"></td></tr>";
echo "<input type=\"hidden\" name=\"update\" value=\"update\">";
echo "<tr><td><input type=\"submit\" value=\"Update Profile\"></td></tr></table>";
echo "</form><br><br>";
}
}
echo "<b>To change your password complete the form below</b>";
echo "<form name=\"pass_update\" action=\"profile_update.php\" method=\"post\">";
echo "<table>";
echo "<tr><td>Email Address:</td><td><input type=\"text\" name=\"email\">";
echo "<tr><td>Old Password:</td><td><input type=\"password\" name=\"old_pass\"></td></tr>";
echo "<tr><td>New Password:</td><td><input type=\"password\" name=\"new_pass\"></td></tr>";
echo "<input type=\"hidden\" name=\"pass\" value=\"pass\">";
echo "<tr><td><input type=\"submit\" value=\"Update Password\"></td></tr></table>";
echo "</form>";
echo "<br><br>";
include 'footer.php';
?>
</body>
</html>"
as one can see, it's text and textboxes. I would like to use some tables for positioning as right now, everything is tightly placed to the left, and I would like to use some color and formatting for the text.