Adunati informatia urmatoare intr-un folder APLICATIE
1. Realizati fisierul conn.php
<?php
mysql_connect('localhost', 'central5_vali', 'parola123')or
die("Could not connect: " . mysql_error());
mysql_select_db("central5_vali");
?>
2. Intr-un fisier text scrieti comenzile urmatoare mysql:
CREATE TABLE `tbllogin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`utilizator` varchar(45) NOT NULL,
`parola` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
----------
INSERT INTO `tbllogin` (`id`,`utilizator`,`parola`) VALUES
(1,'valentin','upadhyay'),
(2,'superadmin','q3allege');
3. Realizati un fisier delete.php
<?php
require_once('conn.php');
$idp= $_REQUEST['id'];
mysql_query("delete FROM tbllogin where id=$idp");
header("location:home.php?action");
?>
4. Realizati fisierul home.php cu structura urmatoare:
<html>
<title>Aplicatie PHP cu MySQL</title>
<h1>Aceasta este prima aplicatie web utilizand PHP, SQL si JavaScript</h1>
<script type="text/javascript">
function validateForm()
{ var utilizator=document.form1.utilizator.value;
var parola=document.form1.parola.value;
if(utilizator=="" && parola!="")
{
document.getElementById("errorMessage").innerHTML="Introduceti un utilizator";return false; }
if(utilizator!="" && parola=="")
{ document.getElementById("errorMessage").innerHTML="Introduceti o parola"; return false; }
if(utilizator=="" && parola=="")
{ document.getElementById("errorMessage").innerHTML="Ati uitat sa completati campurile";return false; }
}
</script>
<body>
<?PHP
if($_REQUEST['action']=='edit')
{
?>
<form id="form1" name="form1" method="post" action="update.php?id=<?PHP echo $_REQUEST['id']; ?>" onSubmit="return validateForm();">
<table width="200" border="1">
<tr>
<td>Utilizator</td>
<td><label for="utilizator"></label>
<input type="text" name="utilizator" id="utilizator" value="<?PHP echo $_REQUEST['utilizator']; ?>" /></td>
</tr>
<tr>
<td>Parola</td>
<td><label for="parola"></label>
<input type="text" name="parola" id="parola" value="<?PHP echo $_REQUEST['parola']; ?>" /></td>
</tr>
<tr>
<td><input type="submit" name="submit" id="submit" value="Trimite" /></td>
<td><input type="reset" name="Reset" id="Reset" value="Reset" /></td>
</tr>
</table>
</form>
<?PHP
}
else
{
?>
<form id="form1" name="form1" method="post" action="insert.php" onSubmit="return validateForm();">
<table width="200" border="1">
<tr>
<td>Utilizator</td>
<td><label for="utilizator"></label>
<input type="text" name="utilizator" id="utilizator" value="" /></td>
</tr>
<tr>
<td>Parola</td>
<td><label for="parola"></label>
<input type="text" name="parola" id="parola" value="" /></td>
</tr>
<tr>
<td><input type="submit" name="submit" id="submit" value="Trimite" /></td>
<td><input type="reset" name="Reset" id="Reset" value="Reset" /></td>
</tr>
</table>
</form>
<?PHP } ?>
<p id="errorMessage" style="color:#C00; font-style:italic;"></p>
<?php
require_once('conn.php');
$result = mysql_query("SELECT * FROM tbllogin");
echo "<table border='2'>";
echo "<th>Utilizator</th><th>Parola</th>";
while($row=mysql_fetch_array($result))
{ echo "<tr>";
$idn=$row['id'];$utilizator=$row['utilizator'];$parola=$row['parola'];
echo "<td>".$row['utilizator']." </td>";
echo "<td>".$row['parola']."</td>";
echo "<td><a href='delete.php?id=$idn'>Sterge</a></td>
<td><a href='home.php?id=$idn&action=edit&utilizator=$utilizator&parola=$parola'>Editeaza</a></td>";
echo "</tr>";
}
echo "</table>";
?>
</body>
</html>
5.Realizati fisierul index.php
<?php
header("location:home.php?action");
?>
6.Realizati fisierul insert.php
<?php
require_once('conn.php');
$utilizator= $_POST['utilizator'];
$parola= $_POST['parola'];
mysql_query("INSERT INTO tbllogin (utilizator, parola) VALUES ('$utilizator', '$parola')");
header("location:home.php?action");
?>
7.Realizati fisierul update.php
<?php
require_once('conn.php');
$idp= $_REQUEST['id'];
$utilizator= $_POST['utilizator'];
$parola= $_POST['parola'];
mysql_query("UPDATE tbllogin SET utilizator='$utilizator',parola='$parola' where id=$idp");
header("location:home.php?action");
?>
TEMA:
In home.php, inainte de </body> scrieti secventa urmatoare:
<p>Pentru tema1 apasati butonul.</p>
<button onclick="myFunction()">Tema1</button>
<script>
function myFunction() {
window.open("http://www.val.centrale-ths.ro/bloc");
}
</script>
In FTP creati un director nou bloc in care veti copia toate aceste fisiere.
Conform celor de mai sus realizati un program web care citeste, afiseaza, modifica si sterge urmatoarele informatii despre locatarii unui bloc: ap, nume, prenume, persoane in locuinta, consum apa. Asa incat tabelul va fi urmatorul:
|Ap | Persoane in locuinta | Nume | Prenume | consum apa |
-----+------------------------------+----------+-------------+-----------------+
|1 | 5 | Mitroi | Oana | 30 |
minim 3 inregistrari
Niciun comentariu:
Trimiteți un comentariu