Tag : MySql

ItSolutionStuff.com have tutorials for MySql tag, here you can study articles of MySql tag, MySql tag posts collection, most popular and useful tutorials of MySql tag, here you can find list of all relevant posts and example about MySql tag, we have lists of tutorials and examples about MySql tag. very simple and quick example collection of Latest MySql tag.




How to get filename from file path in MySQL?

How to get filename from file path in MySQL?

Sometimes we require to get filenames from path of table column in MySQL. If you are working on PHP then you can simply use basename() pre-define function of code PHP, But in MySQL you can't use basename() in select query. This mysql function you can use in code PHP, PHP framework like laravel, code.....

By Hardik Savani | Views: 42094 | November 30, 2016 | Category : PHP MySql

PHP - import excel file into mysql database tutorial

PHP - import excel file into mysql database tutorial

In this post, i going to explain how to import excel file into mysql database using PHP. In this post i will give you full example of csv file, ods file, xls file, xlsx file import into database using phpexcel package. We always require to add data from admin panel like products, items, users, emai.....

By Hardik Savani | Views: 135727 | November 27, 2016 | Category : PHP Bootstrap MySql


PHP Script - Login with Facebook using facebook-php-sdk and MySQL example with demo

PHP Script - Login with Facebook using facebook-php-sdk and MySQL example with demo

In this post, I am going to share with you How to integrate login with facebook in PHP website using Facebook Graph API. In Website normally registration form for sign up, But users are not interested to filling the big registration forms. So you can implement login or register with facebook login,.....

By Hardik Savani | Views: 112836 | November 11, 2016 | Category : PHP Bootstrap MySql

How to connect mysql database in node js with example?

How to connect mysql database in node js with example?

Node.js is very popular in Todays for make chat system, real-time notification, real-time developing etc. So, Today, I am going to give you very simple example of How to use MySQL Query in Node JS. If you use node.js then you can see how it is work and there are several driver for different task li.....

By Hardik Savani | Views: 52675 | September 29, 2016 | Category : MySql Ubuntu Server SQL Node JS

How to get last 2 days records from table using Mysql Query?

How to get last 2 days records from table using Mysql Query?

We may sometimes require to get few days ago records from table like last 2 days, last 3 days, last 10 days or last 15 days etc. Most of developer choose other logic but we can easily get using mysql query(using CURDATE and INTERVAL). In this example mysql query i have one table "elements" and colu.....

By Hardik Savani | Views: 59816 | July 22, 2016 | Category : PHP MySql

How to get current year rows using MySql Query PHP?

How to get current year rows using MySql Query PHP?

If you require to get all the records of current year using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this year. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In follo.....

By Hardik Savani | Views: 33280 | June 14, 2016 | Category : MySql

How to calculate age from date of birth column in mysql?

How to calculate age from date of birth column in mysql?

Sometimes, we require to get age from birthdate using mysql select query, we can do it in programming like php,.net and etc framework but if we can do it using mysql query. In bellow example mysql query you can learn how to get age from date field. We can get age value from using mysql DATEDIFF(). S.....

By Hardik Savani | Views: 46236 | June 1, 2016 | Category : MySql

How to rename column name foreign key constraint in MySql Query?

How to rename column name foreign key constraint in MySql Query?

This is more one post on mysql query, I don't remember exactly time but i had need to change name of foreign key constraint column field. We can rename field name easily if we didn't set foreign key constraint. But if you set foreign key constraint then you can't rename easily. I had rename directly.....

By Hardik Savani | Views: 54301 | May 4, 2016 | Category : MySql

How to execute mysql query in laravel?

How to execute mysql query in laravel?

Sometimes, we require to run directly mysql query on Laravel for example if you need to copy one table to other table using mysql query. I also need in one project and that's why i am fetching problem. But you can use sql query on laravel using db statement in bellow example you can learn how to run.....

By Hardik Savani | Views: 42715 | May 2, 2016 | Category : Laravel

Connection for controluser as defined in your configuration failed - Ubuntu phpmyadmin Resolve?

Connection for controluser as defined in your configuration failed - Ubuntu phpmyadmin Resolve?

When i was working on my PHP project since last 1 year on my current system and phpmyadmin was working very well. but one day i was working on my prjects and electricity off suddenly and when electricity on, i start my system again and open localhost/phpmyadmin, then i found following error: <pre>Co.....

By Hardik Savani | Views: 29110 | April 8, 2016 | Category : Ubuntu