I need to be able to delete table rows from database via link which is shown down below, but i don't know how to form javascript function which will enable that.
So, this is how my index.php looks like:
So could anyone help me, and form a javascript function which will enable deleting rows by clicking 'Delete' link?
Know it's a few lines of code, but I just can't do it.
So, this is how my index.php looks like:
Code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" media="screen" />
<title>Ajax</title>
<script>
function dodajNovogAutora()
{
alert("Dodali ste novog autora!");
var ime = document.getElementById("inputName").value;
var prezime = document.getElementById("inputPrezime").value;
var adresa = document.getElementById("inputAdresa").value;
alert("add.php?ime=" + ime + "&prezime=" + prezime + "&adresa=" + adresa);
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
var rowCount = document.getElementById("tablica").getElementsByTagName("TR").length;
var table=document.getElementById("tablica");
var row=table.insertRow(rowCount);
var cell1=row.insertCell(0);
var cell2=row.insertCell(1);
var cell3=row.insertCell(2);
var cell4=row.insertCell(3);
var cell5=row.insertCell(4);
var cell6=row.insertCell(5);
var sifra= xmlhttp.responseText;
cell1.innerHTML=sifra;
cell2.innerHTML=ime;
cell3.innerHTML=prezime;
cell4.innerHTML=adresa;
cell5.innerHTML="<a href=\"#\" onclick=\"updateauthor()(" +sifra + ");return false;\">Edit</a>";
cell6.innerHTML="<a href=\"#\" onclick=\"deleteauthor()(" +sifra + ");return false;\">Briši</a>";
}
}
xmlhttp.open("GET","add.php?ime=" + ime + "&prezime=" + prezime + "&adresa=" + adresa,true);
xmlhttp.send();
}
//potrebno je napraviti funkcije update i obrisi koje rade kao i dodajNovogAutora
</script>
</head>
<body>
<h3>Popis autora</h3>
<table border="1" id="tablica">
<thead>
<tr>
<td>Sifra</td>
<td>Ime</td>
<td>Prezime</td>
<td>Adresa</td>
<td></td>
<td></td>
</tr>
</thead>
<tbody>
<?php
include 'connect-db.php';
//dohvacanje rezultata pretrazivanja
$rezultati = mysql_query("select * from Autor");
//Iteracija kroz rezultate
while($red = mysql_fetch_array($rezultati))
{
//ispis rezultata pretrazivanja
echo "<tr>";
echo " <td>" . $red['sifra'] . "</td>";
echo " <td>" . $red['ime'] . "</td>";
echo " <td>" . $red['prezime'] . "</td>";
echo " <td>" . $red['adresa'] . "</td>";
echo " <td><a href=\"#\" onclick=\"updateauthor()(". $red['sifra'] . ");return false;\">Edit</a></td>";
echo " <td><a href=\"#\" onclick=\"deleteauthor()(". $red['sifra'] . ");return false;\">Delete</a></td>";
echo "</tr>";
}
mysql_close($veza);
?>
</tbody>
</table>
<h3>Dodaj novog autora</h3>
<form action="add.php" method="GET" id="forma">
Ime: <input type="text" name="inputName" id="inputName" value="" /> <br />
Prezime: <input type="text" name="inputPrezime" id="inputPrezime" value="" /><br />
Adresa: <input type="text" name="inputAdresa" id="inputAdresa" value="" />
<br />
<input type="button" onclick="dodajNovogAutora(); return false;" value="Dodaj" />
</form>
</body>
</html>
And this is how my delete.php looks like:
<?php
//Uspostava veze prema bazi
$veza = mysql_connect("localhost","root","");
//odabir baze na kojoj zelimo raditi
mysql_select_db("seminar", $veza);
mysql_query("DELETE FROM Autor WHERE sifra = $_GET[sifra]") or die(mysql_error());
?>
Know it's a few lines of code, but I just can't do it.
Comment