Database Archives - Page 2 of 2

How to update a column value with the current column value plus an increment in codeigniter?How to update a column value with the current column …

CodeIgniter / Database / mysql / PHP

Update the value of a field in database by 1 using codeigniter

October 31, 2017 Chandan SharmaComment

Update the value of a field in database by 1 using codeigniter $this->db->set(‘usage’, ‘usage+1’, FALSE); $this->db->where(‘tag’, ‘java’); $this->db->update(‘tags’);

On delete Cascade in php

June 29, 2017 Chandan SharmaComment

## ON Delete Cascade: Cascade will work when you delete something on table Courses. Any record on table BookCourses that has reference to table Courses …

On delete Cascade in php

May 18, 2017 Chandan SharmaComment

## On Delete one main table data ,delete related others table data. ALTER TABLE Courses ADD FOREIGN KEY (CatCode) REFERENCES Categories(Code) ON DELETE CASCADE;

Sql-. On delete Cascade in sql

May 17, 2017 Chandan SharmaComment

#ON DELETE CASCADE IN SQL Cascade will work when you delete something on table Courses. Any record on table BookCourses that has reference to table …

Database / mysql / mysqli / PHP

Mysqli is not working in php version 7

March 12, 2017 Chandan SharmaComment

## By using this function we can reduce errors and can work using mysql instead of mysqli. <?php if (PHP_VERSION_ID > 59999) { function mysql_connect($a,$b,$c,$d=null) …

Database / mysql / mysqli / PDO

How to connect using Mysqli, Mysql & PDO in php

March 12, 2017 Chandan SharmaComment

## All connection are shown below.Like mysql, mysqli, PDO <?php // mysqli $mysqli = new mysqli(“example.com”, “user”, “password”, “database”); $result = $mysqli->query(“SELECT ‘Hello, dear MySQL …

Database / mysqli

How to connect using mysqli_connect in php

March 12, 2017 Chandan SharmaComment

<?php //echo “I am Working Now”; $dbhost = “localhost”; dbuser = “root”; $dbpass = “”; $dbname = “chandan_test” $link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $ss …

Database / PHP

How to Connect Database in php

March 12, 2017 Chandan SharmaComment

# It used in core php $dbhost = HOSTNAME; $dbuser = DATABASE USERNAME; $dbpass = DATABASE_PASSWORD; $dbname = DATABASE_NAME; $link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);