Search options

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function() {
    $("a[id^='trinti']").click(function() {
        var numrow = $(this).attr("id");
        numrow = numrow.substr(6);
        var eil = 'id=' + numrow;
            $.ajax({
                type: 'POST',
                url: 'trinti.php',
                data: eil,
                success: function() {
                       numrowas = "#row"+numrow;
                    $(numrowas).fadeOut(2000);
                }
            });
    });
});
</script>
<?php
require_once('db.php');
if (isset($_GET['list'])) {
$query = "SELECT * FROM zinutes";
mysql_query("SET NAMES 'UTF8'");
$uzklausa=mysql_query($query);
$i = 1;
while($lauk = mysql_fetch_array($uzklausa)){
$r = $lauk['id'];
echo '<div id="row$r">'.$i++.'. Vardas: '.$lauk['vardas'].' žinutė: '.$lauk['zinute'].'<a href="#" id="trinti'.$r.'">Delete broker</a></div>';
}
}
?>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''','0','96','syhe','744','2012-03-21')' at line 1 .

function addItem($arejus) {
                    $count = 0;
                    $fields = '';

                    foreach($arejus as $laukelis => $verte) {
                    if ($count++ != 0) $fields .= ', '; $fields1 .= ',';
                    $laukelis = mysql_real_escape_string($laukelis);
                    $verte = mysql_real_escape_string($verte);
                    $fields .= "$laukelis";
                    $fields1 .= "'$verte'";
                }
            
            $sql1=("insert into uzsakymai ($fields) values ($fields1)");
            $result=mysql_query($sql1) or die(mysql_error());

                    }
    if (isset ($_POST['patvirtinti'])){
        if($_POST["vardas"] && $_POST["pavarde"] && $_POST["adresas"] && $_POST["pastas"] && $_POST["tel"] )
        {
            $max=count($_SESSION['cart']);
            for($i=0;$i<$max;$i++){
            $pid=$_SESSION['cart'][$i]['productid'];
            $ppid=get_product_id($pid);
            $ppav=get_product_name($pid);
            $price=get_price($pid);
            $date=date('Y-m-d');
            $orderid=mysql_insert_id();
            $customerid=mysql_insert_id();
            ?>
            <?
            $arejus = array('id' => NULL,
                            'pirkejo_id' => $customerid,
                            'prod_id' => $ppid,
                            'produkto_pav'=> $ppav,
                            'kaina' => $price,
                            'data' => $date
                            );
                            addItem($arejus)
                    ?>
<?                    
            }

<?php
if (isset($_POST['submit'])) {
    header('Content-type: application/vnd.openxmlformats-officedocument.wordprocessingml.document');
header('Content-Disposition: attachment; filename="ataskaita.docx"');
readfile('../generavimui/ataskaita.docx'); 
     }
?>