como puedo implementar mi funcion que tengo de jquery de un dato externo a mi php que esta en otro dado externo con onclick mi funcion es del ajax delete(id) y delete($code) del php
<?php
require_once('../Models/product.php');
$product = new product();
session_start();
if (isset($_SESSION['login']) && $_SESSION['login']=='YES')
{?>
<!DOCTYPE html>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<link rel="stylesheet" href="../Resources/css/bootstrap.min.css"> <link rel="stylesheet" href="../Resources/css/main.css">
<!--Barra de Navegacion-->
<nav class="navbar navbar-default frm-nav">
<div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only">Cambiar Navegacion
</span> <a href="#" class="navbar-brand">Sales
</a> <ul class="nav navbar-nav navbar-right"> <a href="javascript:void(0)" onclick="" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user"></span> <?php echo $_SESSION['name'];?><span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a href="javascript:void(0)" onclick="settings();"><span class="glyphicon glyphicon-cog"></span> Settings
</a></li> <li><a href="javascript:void(0)" onclick="edit();"><span class="glyphicon glyphicon-edit"></span> Edit
</a></li> <li><a href="javascript:void(0)" onclick="change(); "><span class="glyphicon glyphicon-repeat"></span> Change your password
</a></li> <li class="divider"></li> <li><a href="javascript:void(0)" onclick="cerrar();"><span class="glyphicon glyphicon-off"> Sign out
</span></a></li> <ul class="nav navbar-nav navbar-right"> <a href="javascript:void(0)" onclick="" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-flag"></span> Reports
<span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a href=""><span class="glyphicon glyphicon-list"></span> Items
</a></li> <li><a href="#"><span class="glyphicon glyphicon-list"></span> Parents list
</a></li> <ul class="nav navbar-nav navbar-right"> <li><a href="javascript:void(0)" onclick=""><span class="glyphicon glyphicon-home"></span> home
</a></li> <li><a href="javascript:void(0)" id="low_stock" onclick=""><span class="glyphicon glyphicon-alert"></span> slow stock
<span id="notif" class="badge">0
</span></a></li> </nav>
<ul class="nav nav-pills nav-stacked"> <li class="active"><a href="javascript:void(0)" onclick="home();"><span class="glyphicon glyphicon-home"></span> home
</a></li> <li><a href="javascript:void(0)" onclick="product();"><span class=" glyphicon glyphicon-bed"></span> products
</a></li> <li><a href="javascript:void(0)" onclick="sales();"><span class="glyphicon glyphicon-credit-card"></span> Sales
</a></li> <li><a href="javascript:void(0)" id="msg" onclick="users();"><span class="glyphicon glyphicon-user"></span> Users
<span id="notif" class="badge" onclick="push_up();">0
</span></a></li> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModallabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="myModalLabel">Registro
</h4> <form class="form-horizontal" id="formCliente"> <label for="fecha" class="control-label col-xs-5">date:
</label> <input type="text" class="form-control" value="<?php echo date('y-m-d'); ?>" disabled="disabled"/>
<label for="code" class="control-label col-xs-5">code:
</label> <div class="col-xs-2 frm-code"> <input type="text" id="code" name="code" class="form-control" onkeyup="validacion('code');" aria-describedby="inputSuccess2Status"> <label for="product" class="control-label col-xs-5">Product:
</label> <div class="col-xs-4 frm-product"> <select class="form-control" id="product" name="product" onchange="validacion('product');"> <label for="price" class="control-label col-xs-5">Price:
</label> <div class="col-xs-3 frm-price"> <input type="text" class="form-control" id="price" name="price" onkeyup="validacion('price');"> <label for="stock" class="control-label col-xs-5">Stock:
</label> <select class="form-control" id="stock" name="stock" onchange="validacion('stock')";> <div class="alert alert-success text-center" style="display:none;" id="success"> <div class="alert alert-danger text-center" style="display:none;" id="error"> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">close
</button> <button type="button" class="btn btn-success" onclick="add_product();" id="add"><span class="glyphicon glyphicon-plus"></span> Add
</button> <div class="tab-content nav col-md-8 frm-grid"> <div class="form-group col-xs-3 frm-search"> <div class="form-group has-feedback"> <input type="text" class="form-control" id="inputValidation" placeholder="Search"/> <span class="glyphicon glyphicon-search form-control-feedback"></span> <button class="btn btn-success frm-add" data-toggle="modal" data-target="#myModal"><span class="glyphicon glyphicon-plus"></span> Add products
</button> <table class="table table-hover table-resposive" id="return_product"> <?php
$product->show_product();
?>
function cerrar()
{
$.ajax({
url:'../Controllers/actions.php',
type:'POST',
data:"boton=cerrar"
}).done(function(resp){
location.href = '../Views/'
});
}
function add_product(){
var code = $('#code').val();
var product = $('#product').val();
var price = $('#price').val();
var stock = $('#stock').val();
var valCheck = verificar();
if(valCheck == true){
$.ajax({
url: '../Controllers/actions.php',
type: 'POST',
data: 'code='+code+'&product='+product+'&price='+price+'&stock='+stock+'&boton=add_product'
}).done(function(ans){
if(ans == 'success'){
$('#code').val("");
$('#product').val('reset_product');
$('#price').val("");
$('#stock').val('rest_stock');
$('#success').show().delay(2000).fadeOut();
}else{
alert(ans);
}
})
}
else {
}
}
function delete(id){
$.ajax({
url:'../Controllers/product.php',
type:'POST',
data:'code='+id+'&boton=delete'
}).done(function(ans){
alert(ans);
});
}
$(document).ready(function(){
$('#add').click(function(){
$.ajax({
url: '../Controllers/actions.php',
type: 'POST',
data: 'boton=show_product'
}).done(function(data){
$('#records').html(data);
})
});
});
<?php
}
else
{
header("location: ./");
}
?>
<?php
class product{
private $conexion;
public function __construct(){
require_once('conexion.php');
$this->conexion = new conexion();
$this->conexion->conectar();
}
function add($price,$stock,$code,$product){
$sql1 ="INSERT INTO product (price,stock,code,product) VALUES('$price','$stock','$code','$product')";
if($this->conexion->conexion->query($sql1)){
return true;
}
else{
return false;
}
$this->conexion->cerrar();
}
function delete($code){
$sql = "DELETE FROM product WHERE id_product='$code'";
if($this->conexion->conexion->query($sql)){
return true;
}
else{
return false;
}
$this->conexion->cerrar();
}
function show_product(){
$sql = "SELECT * FROM product";
$record = $this->conexion->conexion->query($sql);
$item =0;
if(!$this->conexion->conexion->query($sql)){
printf("Errormessage: %s\n", $this->conexion->conexion->error); }
if($record->num_rows>0){
while($show = $record->fetch_array(MYSQLI_ASSOC)){
$item += 1;
<td>'.$item.'</td>
<td>'.$show["code"].'</td>
<td>'.$show["product"].'</td>
<td>'.$show["price"].'</td>
<td>'.$show["stock"].'</td>
<td><button class="btn btn-danger" onclick="delete();"><span class="glyphicon glyphicon-trash"></span></button></td>
</tr>';
}
//this is for counting number of page
}
else{
echo '<tr><td colspan="7">no hay registros</td></tr>'; }
}
}
?>
Mostrar Mensajes
