Excel to mysql using php

Posted in Php, Sql No comments March 8, 2016

Class sql connection

$con = new mysqli("localhost","root","MYSECRET","kit");

// Check connection
if ($con->connect_error) {
    die("Connection failed: " . $con->connect_error);
} 

$execute = $con->query("select * from contact");

print_r($execute->fetch_assoc());

1

2

3

4

5

6

7

8

9

10

$con = new mysqli("localhost","root","MYSECRET","kit");

// Check connection

if ($con->connect_error) {

die("Connection failed: " . $con->connect_error);

}

$execute = $con->query("select * from contact");

print_r($execute->fetch_assoc());

Posted in Php, Sql No comments January 15, 2016

Replace sql query

update VersionedFields set Value = replace(value,'<iframe','<a>iframe')

1	update VersionedFields set Value = replace(value,'<iframe','<a>iframe')

Posted in Php, Sql No comments December 28, 2015

Recent Posts

Category Sql

Excel to mysql using php

Class sql connection

Replace sql query