Altering column size in SQL Server ALTER TABLE table_name ALTER COLUMN column_name datatype; LIKE:: ALTER TABLE `product` MODIFY COLUMN `updatedon` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP …
Read Moremysql
mysql – Split value from one field to two
How to split a single column values to multiple column values? For Example: #Current table Field is like:: Name ———— abcd efgh ijk lmn opq …
Read MoreCodeigniter – How to Join City Country State by concatenate two fields in Sql
Codeigniter – How to Join City Country State by concatenate two fields in Sql $this->db->select(” CONCAT(c.name,’-‘,co.code) as id,CONCAT(c.name,’ ,’,s.name,’ ,’,co.name) as text”,FALSE); $this->db->from(“city c”); $this->db->join(‘state …
Read MoreHow to prevent duplicate usernames when people register? PHP/MySQL
$connect = mysql_connect(‘whatever’,’whatever’,’whatever’); $database = mysql_select_db(‘your dbname’); $username = $_POST[‘username’]; if(isset($username)){ $mysql_get_users = mysql_query(“SELECT * FROM table_name where username=’$username'”); $get_rows = mysql_affected_rows($connect); if($get_rows >=1){ echo …
Read MoreAccess database config variables from a helper in Codeigniter
By using Like this way you can access Codeigniter Files From Helper. $CI =& get_instance(); $CI->load->database();
Read MorePhp – How to Connect Database from Constant file in Codeigniter version 3.0
Here, Using this way you can connect with database from constant file. then you can access the tables. include(APPPATH.’config/database’.EXT); $conn = mysql_connect($db[‘default’][‘hostname’], $db[‘default’][‘username’], $db[‘default’][‘password’]); …
Read MoreUpdate 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 More