Results 1 to 6 of 6
Thread: PHP MySQL -
Hybrid View
-
24th February 2007 16:58 #1
PHP MySQL -
:
FName - varchar 30, null, LName - varchar 30, null, UserName - varchar 20, not null (primary key) password - varchar 16, not nullPHP Code:<?php
$self = $_SERVER['PHP_SELF'];
$FName = $_POST['FName'];
$LName = $_POST['LName'];
$UserName = $_POST['UserName'];
$password = $_POST['password'];
if( (!$FName) or (!$LName) or (!$UserName) or (!$password))
{
$form = " ";
$form.= "<form action=\"$self\"";
$form.= "method=\"post\"><table border=0><tr><td>: </td>";
$form.= "<td><input type=\"text\" name=\"FName\"";
$form.= "value=\"$FName\"></td></tr><tr><td>: </td>";
$form.= "<td><input type=\"text\" name=\"LName\"";
$form.= "value=\"$LName\"></td></tr><tr><td> : </td>";
$form.= "<td><input type=\"text\" name=\"UserName\"";
$form.= "value=\"$UserName\"></td></tr><tr><td>: </td>";
$form.= "<td><input type=\"password\" name=\"password\"";
$form.= "value=\"$password\"></td></tr>";
$form.= "<tr><td colspan=2><input type=\"submit\" value=\"\"></td></tr></table>";
$form.= "</form>";
echo($form);
}
else
{ #connecting to MySQL
$conn = mysql_connect("localhost", "root", "rootpassword")
or die(" MySQL");
#Selecting a DB
$DB = mysql_select_db("dostyp", $conn)
or die(" ");
#Creating an SQL query
$zaiavka = "insert into users (FName, LName, UserName, password) values (\"$FName\", \"$LName\", \"$UserName\", \"$password\") )";
#Executing query
$rez = mysql_query($zaiavka, $conn)
or die(" $UserName");
if($rez)
{
echo(" $UserName ");
}
}
?>
" xxx". , SQL , . ?
-
24th February 2007 18:37 #2Registered User
Join Date: Aug:2006
Location: Sofia
Posts: 37
password ( ) MySQL. : `password`.
-
24th February 2007 19:20 #3
-
24th February 2007 19:24 #4
-
24th February 2007 19:32 #5Registered User
Join Date: Aug:2006
Location: Sofia
Posts: 37
, : MySQL - , .
-
24th February 2007 20:07 #6




Reply With Quote
.

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in