CRUD BackboneJS PHP MySQL

# Thực hiện chức năng crud add (ok) {% embed url="" %} {% file src="/files/-Mgv88hBO8943xmGHJ2w" %} ``` CRUD BackboneJS PHP MySQL

``` {% embed url="" %} ``` prepare($sql); $query->execute(array(":id"=>null,":nm"=>$_POST['name'],":em"=>$_POST['email'],":hp"=>$_POST['phone'],":ad"=>$_POST['address'],":at"=>$_POST['active'])); } else if($page=='edit'){ $sql = "UPDATE crud SET name= :nm, email= :em, phone= :hp, address= :ad, active= :at WHERE id = :id"; $query = $db->prepare($sql); $query->execute(array(":id"=>$_POST['id'],":nm"=>$_POST['name'],":em"=>$_POST['email'],":hp"=>$_POST['phone'],":ad"=>$_POST['address'], ":at"=>$_POST['active'])); } else if($page=='trash'){ $sql = "DELETE FROM crud WHERE id = :id"; $query = $db->prepare($sql); $query->execute(array(":id"=>$_POST['id'])); } else if($page=='item'){ $statement = $db->query("SELECT * FROM crud WHERE id = ".$_GET['id']); $statement->setFetchMode(PDO::FETCH_ASSOC); echo json_encode($statement->fetch()); } else{ $statement = $db->query('SELECT * FROM crud'); $statement->setFetchMode(PDO::FETCH_ASSOC); echo json_encode($statement->fetchAll()); } ?> ``` views/notification.js ``` "use strict"; APP.AlertView = Backbone.View.extend({ tagName: "div", className: "alert fade", template: ["×", "<%= title %>", "<%= message %>"].join("\n"), initialize: function (options) { _.bindAll(this, "render", "remove"); this.template = _.template(this.template); if (options) { this.alert = options.alert || "info"; this.title = options.title || ""; this.message = options.message || ""; this.fixed = options.fixed || false; } }, render: function () { var that = this, output = this.template({title: this.title, message: this.message}); this.$el.addClass("alert-" + this.alert).html(output).alert(); if (this.fixed) { this.$el.addClass("fixed"); } window.setTimeout(function () { that.$el.addClass("in"); }, 20); return this; }, remove: function () { var that = this; this.$el.removeClass("in"); window.setTimeout(function () { that.$el.remove(); }, 1000); } }); APP.AlertView.show = function (title, message, alertType) { var alert = new APP.AlertView({ alert: alertType, title: title, message: message, fixed: true }); $(document.body).append(alert.render().el); window.setTimeout(function () { alert.remove(); }, 9000); return alert; }; ``` views/add.js ``` "use strict"; APP.crudNewView = Backbone.View.extend({ // functions to fire on events // here we are blocking the submission of the form, and handling it ourself events: { "click button.save": "save", "keyup input": "validate", "keyup textarea": "validate" }, template: _.template($('#formTemplate').html()), initialize: function (options) { this.model.bind('invalid', APP.helpers.showErrors, APP.helpers); }, save: function (event) { event.stopPropagation(); event.preventDefault(); var at = this.$el.find('input[name=active]').prop('checked'); if (at) { at = 1; } else { at = 0; } // update our model with values from the form this.model.set({ id: this.$el.find('input[name=id]').val(), name: this.$el.find('input[name=name]').val(), email: this.$el.find('input[name=email]').val(), phone: this.$el.find('input[name=phone]').val(), address: this.$el.find('textarea[name=address]').val(), active: at }); if (this.model.isValid()) { // save it this.collection.add(this.model); if (this.model.save) { new APP.AlertView.show("CRUD", "Created Success", "success"); } else { new APP.AlertView.show("Error", "can not be created", "danger"); } var id = this.$el.find('input[name=id]').val(); var nm = this.$el.find('input[name=name]').val(); var em = this.$el.find('input[name=email]').val(); var hp = this.$el.find('input[name=phone]').val(); var ad = this.$el.find('textarea[name=address]').val(); $.post("crud.php?p=add", { id: id, name: nm, email: em, phone: hp, address: ad, active: at } , function(data){ Backbone.history.navigate("crud/index", {trigger: true}); }); } }, // populate the html to the dom render: function () { this.$el.html( this.template(this.model.toJSON()) ); return this; } }); ``` Source C:\xampp\htdocs\gulp {% file src="/files/-MemfxDOa7PowwwT\_JeC" %} --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://javascriptuse.gitbook.io/advanced/thuc-hien-chuc-nang-crud-add-ok.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.

MY CRUD