Tag : Field


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>Connection for controluser as defined in your configuration failed.</pre> I did try lot to solve. i also reboot my ubuntu 14.04 system again but i found still that issue. i was very disappointed from this issue. But when i open my PHP Laravel framework project i found bellow issue: <pre>can't connect.....

By Hardik Savani | April 8, 2016 | | 760 Viewer | Category : Ubuntu
READ MORE

Sql function remove numeric characters from column example

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove numeric characters from table field value. this function through you can also remove numeric characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeNumber function:</strong> <pre class="prettyprint lang-mysql"> DROP FUNCTION IF EXISTS removeNumber; DELIMITER | CREATE FUNCTION removeNumber( str CH.....

By Hardik Savani | March 12, 2016 | | 651 Viewer | Category : PHP MySql SQL MSSQL
READ MORE

How to remove special characters by mysql custom function.

Mysql custom fucntion is a very prety and intresting concept. In this posts i want to create one custom mysql function for remove special characters from table field value. this function through you can also remove special characters from string in mysql. in following sql query fire in your mysql or mssql database and check how it works. So, lets create function and how to use in select statement in sql query. <strong class="step">Create removeSpacialChar function:</strong> <pre class="prettyprint lang-mysql"> CREATE FUNCTION `removeSpacialChar`(`in_str` varchar(4096)) RETURNS varchar(4096) C.....

By Hardik Savani | March 10, 2016 | | 1441 Viewer | Category : PHP MySql SQL MSSQL
READ MORE

    Laravel 5.4 - send email using Markdown Mailables

    Laravel 5.4 - send email using Markdown Mailables

    Open Post

    Laravel 5 - "syntax error or access violation 1055 in group by" Solved

    Laravel 5 - "syntax error or access violation 1055 in group by" Solved

    Open Post

    How to use groupby having with DB::raw in Laravel Query Builder?

    How to use groupby having with DB::raw in Laravel Query Builder?

    Open Post

    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

    Open Post

    AngularJS - scroll to a specific element using anchorscroll

    AngularJS - scroll to a specific element using anchorscroll

    Open Post

    Laravel 5 Twitter OAuth using Socialite Package

    Laravel 5 Twitter OAuth using Socialite Package

    Open Post