PHP HTML - .
HTML .
<html>
<head>
<title> </title>
<body>
<center> ? <p>
<table width = 400><tr><td align = right>
<form action="php28.php" metod="post">
:<BR>
<input type="text" name="name" size="20" maxlength="30">
<P>
email:<BR>
<input type="text" name="email" size="20" maxlength="30">
<p>
:
<select name="preference">
<option value = "">
<option value = "">
</select>
<p>
<input type="submit" value=" !">
</form>
</td></tr></table></center>
</body>
</html>
php28.htm. , php428.php.
php428.php :
<?// php428.php php428.htm
$hostname = "localhost";
$username = "myusername";
$password = "mypassword";
$dbName ="my_db";
/* MySQL, */
$userstable = "clients";
/* */
mysql_connect() or die(" ");
mysql_select_db("$dbName") or die(" ");
print "<CENTER>";
print ", $name.";
print "<BR><BR>";
print " .<BR><BR>";
print " $preference. email: $email.";
print "</CENTER>";
/* email */
mail($email, " ", "$namen\n
!\n
$preference\n. \n");
/* */
$query = "INSERT INTO $userstable VALUES('$name','$email', '$preference')";
$result = MYSQL_QUERY($query);
print " .";
/* */
mysql_close();
?>
: , valera.
.
. email: [email protected].
.
PHP. , MySQL.
, , "".
php429.php
<?/* , */
|
|
$dbName = "my_db";
/* MySQL, */
$userstable = "clients";
/* */
MYSQL_CONNECT() OR DIE(" ");
@mysql_select_db("$dbName") or die(" ");
/* - */
$query = "SELECT * FROM $userstable WHERE name='valera' OR
choise =''";
$result = MYSQL_QUERY($query);
/* */
$number = MYSQL_NUMROWS($result);
/* */
$i = 0;
IF ($number == 0) {
print "<CENTER><P> </CENTER>";
} ELSEIF ($number > 0) {
print "<CENTER><P> : $number<BR><BR>";
WHILE ($i < $number){
$name = mysql_result($result,$i,"name");
$email = mysql_result($result,$i,"email");
print " $name .<BR>";
print " Email: $email.";
print "<BR><BR>";
$i++;
}
print "</CENTER>";
}
?>