Posted: Wed Nov 26, 2003 5:54 pm
Sorry please replace db_query with mysql_query
I use a db wrapper and habits are hard to break
I use a db wrapper and habits are hard to break
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<? session_start(); ?>
<?php include "header.php"; ?>
<?
// Global settings, please change these
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123 // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$sql = "SELECT * user Username,Password,Email,Name,Age,Sex,Hobbies";
$res = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($res)) {
$Username = $row['username'];
$Password = $row['password'];
$Email = $row['email'];
$Name = $row['name'];
$Age = $row['age'];
$hobbies = $row['hobbies'];
}
?>
<html>
<head>
<title>adad</title>
</head>
<body>
<form method="POST" ACTION="editpro.php">
<p>Username : <input type="text" NAME="username" VALUE =" <? echo $username; ?>" size=35 maxlength=50></p>
<p>Password : <input type="text" NAME="password" VALUE ="<? echo $password; ?>" size=35 maxlength=50></p>
<p>Email : <input type="text" NAME="email" VALUE ="<? echo $email; ?>" size=35 maxlength=50></p>
<p>Name : <input type="text" NAME="name" VALUE ="<? echo $name; ?>" size=35 maxlength=50></p>
<p>Age : <input type="text" NAME="age" VALUE ="<? echo $age; ?>" size=35 maxlength=50></p>
<p>Hobbies : <input type="text" NAME="hobbies" VALUE ="<? echo $hobbies; ?>" size=35 maxlength=50></p>
<br><br>
<input type="Submit" name="submit" VALUE="Update Profile"><br><br>
</form>
</body>
</html>
<?php include "end.php"; ?>Code: Select all
<?php include "header.php"; ?>
<font face="verdana" size="2"><br><center><b>All BHS member, please register now to use our member access area.<br></b></font></center><br>
<?php
// Global settings, please change these
$dbserver="127.0.0.1"; // Server to connect to, leave this unchanged
$dbuser="charmed_bhs"; // Username, change this to whatever you need
$dbpass="123"; // Same for pass
$db="charmed_bhs"; // Database name, u need to change this
// End settings
if($_POST['check']=="Register"){
mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db($db);
$_SESSION['myuser']=$username;$_SESSION['mypass']=$password;$_SESSION['myemail']=$email;$_SESSION['myname']=$myname;$_SESSION['myage']=$age;$_SESSION['myhobbies']=$hobbies;
if (!$username) {echo "<font face=verdana size=2>You did not provide a username!<br></font>"; $signup="no";}
if (!$password) {echo "<font face=verdana size=2>You did not provide a password!<br></font>"; $signup="no";}
if (!$email) {echo "<font face=verdana size=2>You did not provide a email address!<br></font>"; $signup="no";}
if (!$name) {echo "<font face=verdana size=2>You did not enter your name!<br></font>"; $signup="no";}
if (!$age) {echo "<font face=verdana size=2>You did not enter your age!<br></font>"; $signup="no";}
if (!$hobbies) {echo "<font face=verdana size=2>You did not enter your hobbies!</font>"; $signup="no";}
if ($signup=="no"){echo "<font face=verdana size=2><br><br><--<a href=register.php>Go</a> back and try again</font>";}
else {
$query="SELECT * FROM users WHERE username='$username'";
$result=mysql_query($query); $num_rows = mysql_num_rows($result);
if ($num_rows!="0"){mysql_close(); echo "<br><center><font face=verdana size=2>User exists.<br><br>Please go [<a href=./register.php>back</a>] and try again</font></center>";}
else {
mysql_query("INSERT INTO users (Username,Password,Email,Name,Age,Sex,Hobbies) VALUES ( '$username','$password','$email','$name','$age','$sex','$hobbies')"); mysql_close();
echo "<br><br><center><font face=verdana size=2>Username '$username' has been successfully added to our member database.<br>Thank you for verifying as a member of BHS<br></font><br>";}}}
// Form code
else{
echo "<form action=register.php method=post><font face=verdana size=2>Username : </font><input type=text name=username value=$myuser><font face=verdana size=2><br>Password : </font><input type=password name=password value=$mypass><font face=verdana size=2><br>Email : </font><input type=text name=email value=$myemail><font face=verdana size=2><br>Name : </font><input type=text name=name value=$myname><font face=verdana size=2><br>Age : </font><input type=text name=age value=$myage><font face=verdana size=2><br>Sex : </font><select name=sex><option>Male</option><option>Female</option></select><font face=verdana size=2><br>Hobbies : </font><input type=text name=hobbies value=$myhobbies><br><br><input type=submit name=check value=Register><input type=reset value=Reset name=reset></form>";}
?>
<?php include "end.php"; ?>Code: Select all
$sql = "SELECT * user Username,Password,Email,Name,Age,Sex,Hobbies";Code: Select all
$sql = "SELECT * FROM user";Code: Select all
$sql = "SELECT Username,Password,Email,Name,Age,Sex,Hobbies FROM user";