mysqli Archives - Logic Bytes

Altering column size in SQL Server

February 12, 2018 Chandan SharmaComment

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 …

Php – How to Connect Database from Constant file in Codeigniter version 3.0

November 17, 2017 Chandan SharmaComment

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’]); …

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 …