<?php
// you understand this....
require_once('inc.pquery.class.php');
// initiate the class
$pq = new pquery;
/**
* tabla - SQL
**/
/*
--
-- Tábla szerkezet: `adatok`
--
CREATE TABLE `adatok` (
`mediatorid` int(4) NOT NULL,
`nev` varchar(30) default NULL,
KEY `mediatorid` (`mediatorid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Tábla adatok: `adatok`
--
INSERT INTO `adatok` VALUES (1, 'asdasdas');
INSERT INTO `adatok` VALUES (2, 'asdasdasd 2');
INSERT INTO `adatok` VALUES (3, 'asdasda');
*/
// DB connect
$conn = mysql_connect("localhost","root","rhqq2x");
mysql_select_db("tabla");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
<title>PQuery example</title>
<?php
$pq->write_jquery();
?>
<script language="javascript" src="jquery.color.js"></script>
<?php
$pq->pjq('
function remove_row(id) {
$("#response").show();
$("#adat_"+id).animate({ backgroundColor : "#FFFFAE" }, "slow").fadeOut("slow");
setTimeout(function() { $("#response").fadeOut(); }, 2000);
}
');
?>
</head>
<body>
<table width="300" cellpadding="0" cellspacing="0" id="tabla">
<tr>
<td>Name</td>
<td>Remove</td>
</tr>
<?php
$adat = mysql_query("SELECT * FROM adatok");
while($a = mysql_fetch_assoc($adat)){
?>
<tr id="adat_<?php echo $a['mediatorid']; ?>">
<td><?php echo $a['nev']; ?></td>
<td><input type="button" onclick="<?php $pq->pget('process.php?delete=true&id='.$a['mediatorid'],'Are you sure?','response','remove_row('.$a['mediatorid'].')'); ?>" value="Let's remove it!"/></td>
</tr>
<?php
}
?>
</table>
<div id="response"></div>
<br/><br/>
<input type="button" onclick="<?php $pq->pload('teszt.php?q=blabla','webpage'); ?>" value="Make request"/>
<div id="webpage" style="width:900px; height:450px;"></div>
</body>
</html>
|
Download
