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 …
Read MoreDatabase
Update the value of a field in database by 1 using codeigniter
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’);
Read MoreOn delete Cascade in php
## ON Delete Cascade: Cascade will work when you delete something on table Courses. Any record on table BookCourses that has reference to table Courses …
Read MoreOn delete Cascade in php
## On Delete one main table data ,delete related others table data. ALTER TABLE Courses ADD FOREIGN KEY (CatCode) REFERENCES Categories(Code) ON DELETE CASCADE;
Read MoreSql-. On delete Cascade in sql
#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 …
Read MoreHow to connect using mysqli_connect in php
<?php //echo “I am Working Now”; $dbhost = “localhost”; dbuser = “root”; $dbpass = “”; $dbname = “chandan_test” $link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); $ss …
Read MoreHow to Connect Database in php
# It used in core php $dbhost = HOSTNAME; $dbuser = DATABASE USERNAME; $dbpass = DATABASE_PASSWORD; $dbname = DATABASE_NAME; $link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
Read More