Exemplu de utilizare PHP cu mySQL

[Home]		Exemplu de utilizare PHP cu mySQL
[Home]		Exemplu de utilizare PHP cu mySQL

Pagina pentru înregistrarea utilizatorilor unei aplicaţii (pentru varianta ASP click aici):
Aceasta pagina poate fi vizualizata aici.

<?
/* Pentru crearea tablelei Utilizatori, in fereastra mySQL se executa codul:

CREATE TABLE Utilizatori
(
ID INT PRIMARY KEY AUTO_INCREMENT,
Login VARCHAR (12) NOT NULL,
Password VARCHAR (20) NOT NULL,
Email VARCHAR (50)
);
*/

$link = mysql_connect ("server_name", "user_name", "password") or die ("Could not connect");
mysql_select_db ("db_name") or die ("Could not select database");

//********************************************************************************
// INITIALIZARE VARIABILE
//********************************************************************************
$for    = $HTTP_POST_VARS['hdnFor'];
$id     = $HTTP_POST_VARS['hdnID'];
$login = $HTTP_POST_VARS['txtLogin'];
$pass = $HTTP_POST_VARS['txtPassword'];
$email = $HTTP_POST_VARS['txtEmail'];

//********************************************************************************
// EDIT
//********************************************************************************
if ($for == "EDIT")
{
    $query = "SELECT Login, Password, Email FROM Utilizatori WHERE ID = ".$id;
    $result = mysql_query ($query) or die ("Error! Select failed!");
    if ($row = mysql_fetch_array ($result))
    {
        $login = $row[0];
        $pass = $row[1];
        $email = $row[2];
    }
}

//********************************************************************************
// SAVE
//********************************************************************************
if ($for == "SAVE")
{
    if ($id == "")
    {
        $query = "INSERT INTO Utilizatori (Login, Password, Email) VALUES ('".$login."', '".$pass."', '".$email."')";
        mysql_query ($query) or die ("Error! Insert failed!");
        $id = mysql_insert_id ($link);
    }
    else
    {
        $query = "UPDATE Utilizatori SET Login = '".$login."', Password = '".$pass."', Email = '".$email."' WHERE ID = ".$id;
        mysql_query ($query) or die ("Error! Update failed!");
    }
}

//********************************************************************************
// DELETE
//********************************************************************************
if ($for == "DELETE")
{
    $query = "DELETE FROM Utilizatori WHERE ID = ".$id;
    $result = mysql_query ($query) or die ("Error! Delete operation failed!");
}
?>

<HTML>
<HEAD>
<script language=javascript>
function Save()
{
if(document.frmForm.txtLogin.value == ""){
    alert("Please complete login name!");
    return;
}
if(document.frmForm.txtPassword.value == "")
{
    alert("Please complete an opinion!");
    return;
}
if(document.frmForm.txtEmail.value == ""){
    alert("Please complete an e-mail address!");
    return;
}
document.frmForm.hdnFor.value = "SAVE";
document.frmForm.submit();
}
function Clear()
{
document.frmForm.hdnFor.value = "";
document.frmForm.hdnID.value = "";
document.frmForm.txtLogin.value = "";
document.frmForm.txtPassword.value = "";
document.frmForm.txtEmail.value = "";
document.frmForm.submit();
}
function Edit(i)
{
document.frmForm.hdnFor.value = "EDIT";
document.frmForm.hdnID.value = i;
document.frmForm.submit();
}
function Delete(i)
{
if(!confirm("Confirm deletion..."))
{
    return;
}
document.frmForm.hdnFor.value = "DELETE";
document.frmForm.txtLogin.value = "";
document.frmForm.txtPassword.value = "";
document.frmForm.txtEmail.value = "";
document.frmForm.submit();
}
</script>
</HEAD>

<BODY>

<FORM ID="frmForm" NAME="frmForm" METHOD="post">
    <table border=0 bgcolor=#c0c0c0 width=30%>
        <tr>
            <td WIDTH=30%>Login Name: </td>
            <td><INPUT TYPE=text ID="txtLogin" NAME="txtLogin" MAXLENGTH="12" VALUE="<? print($login) ?>"></td>
        </tr>
        <tr>
            <td>Password: </td>
            <td><INPUT TYPE=text ID="txtPassword" NAME="txtPassword" MAXLENGTH="20" VALUE="<? print($pass) ?>"></td>
        </tr>
        <tr>
            <td>Email:             <td><INPUT TYPE=text ID="txtEmail" NAME="txtEmail" MAXLENGTH="50" VALUE="<? print($email) ?>"></td>
        </tr>
        <tr>
            <td colspan=2 align=right>
                <INPUT TYPE=button ID="btnSave" ONCLICK="Save()" VALUE="Save">
                <INPUT TYPE=button ID="btnClear" ONCLICK="Clear()" VALUE="Clear">
                <INPUT TYPE=button ID="btnDelete" ONCLICK="Delete()" VALUE="Delete">
            </td>
        </tr>
    </table>

    <INPUT TYPE=hidden ID="hdnID" NAME="hdnID" VALUE="<? print($id) ?>">
    <INPUT TYPE=hidden ID="hdnFor" NAME="hdnFor">
</FORM>
<hr>

<?
//********************************************************************************
// AFISEAZA
//********************************************************************************
$query = "SELECT ID, Login, Password, Email FROM Utilizatori ORDER BY Login";
$result = mysql_query ($query) or die ("Query failed");

print "<table width=30% bgcolor=#abcabc cellspacing=1 border=0>\n";
print "<tr bgcolor=#abcabc>";
print "<td>#</td>";
print "<td>Login</td>";
print "<td>Password</td>";
print "<td>E-mail</td>";
print "</tr>";

while ($row = mysql_fetch_array ($result))
{
    if ($row[0] == $id)
        $bgcolor = "#abcdef";
    else
        $bgcolor = "#ffffff";
    print "<tr bgcolor=$bgcolor>";
    print "<td><a href='javascript:Edit(".$row[0].")'>***</a></td>";
    print "<td>".$row[1]."</td>";
    print "<td>".$row[2]."</td>";
    print "<td>".$row[3]."</td>";
    print "</tr>";
}

print "</table>";

mysql_free_result ($result);
mysql_close ($link);
?>
</BODY>
</HTML>