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: -
<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());
-
-
-
?>
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.
6  2674 
well you would do the same thing you have done using "ajax" but sending a different query string and parsing it with your php to delete rows in the database?
Don't understand what you're trying to say cause its a bit new to me.
All i need is to make 2 more functions(for delete table row in database, and edit), cause i've got add new function already (don't know why i pasted it cause it's actually not needed).
Delete function should refer to this row - echo " <td><a href=\"#\" onclick=\"deleteauthor()(". $red['sifra'] . ");return false;\">Delete</a></td>";
I can't give you the exact code i don't have enough information but you need to make another ajax request to your server in the function
From previous post -
xmlhttp.open("GET","add.php?ime=" + ime + "&prezime=" + prezime + "&adresa=" + adresa,true);
-
xmlhttp.send();
-
in add.php or even make a dele.php if you feel the need to and make it remove the records based on the criteria passed.
Since i'm actually new to this, don't wonder if i'm asking 'well-known or stupid questions', but does that mean that i should make a new function and copy these two lines that u quoted and add delete.php instead of add.php in new function?
I've already got delete.php that contains criteria which should allow deleting records from database, just don't know how to form that function and write the code in index.php :[
Well hello mate... I think you should be able to do this with your knowledge, as you are very intelligent and all that. It is of utmost importance that you do that. Thanks!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Damien Cobbs |
last post by:
Is there a way to remove duplicate rows from a table that does not
have a primary key leaving one copy of the row without comparing each
column to each other as suggested by the code example below:...
|
by: Rick DeBay |
last post by:
I'm trying to create a layout table, where the spacing between rows varies.
I've tried using setting margin-top and border-top for the rows I wan't spaced
down from the one above, and I've also...
|
by: Harry Gould |
last post by:
To all,
I'm a newbie here, so please bear with me.
I develop web pages for a company intranet where Internet Explorer 6
is the standard. Now I must develop a public internet website that is...
|
by: Bijoy Naick |
last post by:
I have something strange going on.. My .aspx page contains a file upload
control, a "Import Data" button, a "newTransactions" <asp:table>,
a"SaveTrans" button and an confMsg label.
First the...
|
by: somaskarthic |
last post by:
Hi
In my application , i need to create table rows at runtime. Using javascript with table id arguments i could replicate the rows at runtime. Each of these rows has checkboxes (7.no) , dropdown...
|
by: leiño |
last post by:
Hi,
i am adding table rows dynamically with javascript. This works fine.
The table is inside a div with scrolls, initially with 6 rows:
.....
<div style='overflow:auto; width:100%;...
|
by: bb nicole |
last post by:
Below is my interface for resume which need to post into database...
I have did it all in one page and it already can send into database which the table name resume...
But my letturer now want me...
|
by: kalyanilovesme |
last post by:
Hi I have a html table..
and i am adding the table rows dynamically...
actually table rows are 64..
but according to the program some are visible and other are invisible..
i want to calculate...
|
by: premMS143 |
last post by:
Hi 1 & all,
Using VB,
How to remove blank rows in a Excel worksheet?
For example,
I'm having a Excel sheet containing 900 rows data, in which there are blank rows inserted in between. Manually...
|
by: gskoli |
last post by:
Dear all
Below i have given example of my HTML table structure Where two different <Td> are containing separate table both having same no. of rows but second table having some rows where...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
