If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. To understand Delete query, consider an Customers table, which is having following query First you can need database connection in php Code
If you are not familiar with the term “pagination”, it refers to links that allows you to navigate from page to page. Ajax makes your application more flexible, you don’t need to reload or refresh the whole body for small changes, you can made changes in any part without loading page. Jquery function call to […]
Here I have developed an application in Codeigniter which will help you to take backup as per your wish wnenever you want to take backup. While most web hosting company do a daily backup of a customer’s database and site, relying on them to make backups and provide them at no cost is risky also.
Query grouping allows you to create groups of WHERE clauses by enclosing them in parentheses. This will allow you to create queries with complex WHERE clauses. Nested groups are supported. $this->db->group_start() Starts a new group by adding an opening parenthesis to the WHERE clause of the query. $this->db->or_group_start() Starts a new group by adding an […]
public function url() { $this->load->helper(‘url’); $currentURL = current_url(); $data[‘params’] = $_SERVER[‘QUERY_STRING’]; $fullURL = $currentURL . ‘?’ . $params; $category = $data[‘params’]; }
A prepared statement (also known as parameterized statement) is simply a SQL query template containing placeholder instead of the actual parameter values. Here is example of PDO statements. <?php $servername = “localhost”; $username = “root”; $password = “”; $dbname = “myDBPDO”; try { $conn = new PDO(“mysql:host=$servername;dbname=$dbname”, $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // […]
The SUM() function returns the total sum of a numeric column. To understand SUM function, consider an products table, which is having the following query. Code
Ajax form submission is better and fast way to submit form without page loading .It’s make a nice experience to your users. Below we have written a tutorial on how to submit a contact form with jquery ajax . You can also consider this as a PHP, ajax registration form . First of all we […]
If you want to increment or decrement opration using update() method of laravel query builder then you also do that, i am showing you how to increment and decrement value of column in table by using increment(), and decrement(). Both of these methods accept at least one argument the column to modify. A second argument […]
Laravel 5.* introduces a simple syntax for lookups and updates based on the value of specific keys in your JSON columns. This operation is only supported on databases that support JSON columns. When updating a JSON column, you should use -> this sign.