Case-sensitive where statement in laravel

You'll need to use DB::raw(), perhaps something like

Invite::where(DB::raw('BINARY `token`'), $token)->first();

or alternatively:

Invite::whereRaw("BINARY `token`= ?",[$token])->first();

1

2

3

4

5

6

7

You'll need to use DB::raw(), perhaps something like

Invite::where(DB::raw('BINARY `token`'), $token)->first();

or alternatively:

Invite::whereRaw("BINARY `token`= ?",[$token])->first();

Posted in Laravel, Postgresql, Sql No comments September 7, 2021

Increase phpmyadmin import file size

Go to wamp64\alias\ edit phpmyadmin.conf file then update size

Alias /phpmyadmin "c:/wamp64/apps/phpmyadmin4.7.9/"

<Directory "c:/wamp64/apps/phpmyadmin4.7.9/">
	Options +Indexes +FollowSymLinks +MultiViews
  AllowOverride all
  <ifDefine APACHE24>
		Require local
	</ifDefine>
	<ifDefine !APACHE24>
		Order Deny,Allow
    Deny from all
    Allow from localhost ::1 127.0.0.1
	</ifDefine>

# To import big file you can increase values
  php_admin_value upload_max_filesize 800M
  php_admin_value post_max_size 800M
  php_admin_value max_execution_time 2800
  php_admin_value max_input_time 2800
</Directory>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

Alias /phpmyadmin "c:/wamp64/apps/phpmyadmin4.7.9/"

<Directory "c:/wamp64/a...

Posted in Php, Sql No comments December 17, 2019

Create Mysql Function

Directly run in sql

CREATE FUNCTION grade (grade_point INT)
            RETURNS VARCHAR(15)
            RETURN 
                CASE
                    WHEN grade_point >= 90 THEN "EXCELLENT"
                    WHEN grade_point >= 80 THEN "GOOD"
                END

1

2

3

4

5

6

7

CREATE FUNCTION grade (grade_point INT)

RETURNS VARCHAR(15)

RETURN

CASE

WHEN grade_point >= 90 THEN "EXCELLENT"

WHEN grade_point >= 80 THEN "GOOD"

END

Then use like

select grade (79)

1	select grade (79)

using in laravel

DB...

Posted in Laravel, Sql No comments October 3, 2019

Create Dynamic URLs from Database, like wordpress

if you have a script called index.php that took a parameter called slug…

<?php
if (isset($_GET['slug'])) {
    $sql = "SELECT * FROM `your_table` WHERE slug = ? LIMIT 1";
    $smt = $pdo->prepare($sql);
    $smt->execute(array($_GET['slug']));
    $row = $smt->fetchObject();
    // do something with the matching record here...
}
else {
    // display home page
}

1

2

3

4

5

6

7

8

9

10

11

<?php

if (isset($_GET['slug'])) {

$sql = "SELECT * FROM `your_table` WHERE slug = ? LIMIT 1";

$smt = $pdo->prepare($sql);

$smt->execute(array($_GET['slug']));

$row = $smt->fetchObject();

// do something with the matching record here...

}

else {

// display home page

}

You could then re-write requests using ...

Posted in Php, Sql No comments January 28, 2019

Ajax scroll pagination with php and mysql

Download

Posted in Ajax, Jquery, Php, Sql No comments September 21, 2017

Ajax Pagination

Download

Posted in Ajax, Php, Sql No comments September 21, 2017

Create Backup in Localhost

function EXPORT_TABLES($host,$user,$pass,$name,       $tables=false, $backup_name=false){ 
    set_time_limit(3000); $mysqli = new mysqli($host,$user,$pass,$name); $mysqli->select_db($name); $mysqli->query("SET NAMES 'utf8'");
    $queryTables = $mysqli->query('SHOW TABLES'); while($row = $queryTables->fetch_row()) { $target_tables[] = $row[0]; }   if($tables !== false) { $target_tables = array_intersect( $target_tables, $tables); } 
    $content = "SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET time_zone = \"+00:00\";\r\n\r\n\r\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\r\n/*!40101 SET NAMES ut...

Posted in Php, Sql No comments August 16, 2017

Get mysql data using lat long with some radius

SELECT
    *,
    ( 6371 * acos( cos( radians({$lat}) ) * cos( radians( `lat` ) ) * cos( radians( `lng` ) - radians({$lng}) ) + sin( radians({$lat}) ) * sin( radians( `lat` ) ) ) ) AS distance
FROM `positions`
HAVING distance <= {$radius}
ORDER BY distance ASC

1

2

3

4

5

6

SELECT

*,

( 6371 * acos( cos( radians({$lat}) ) * cos( radians( `lat` ) ) * cos( radians( `lng` ) - radians({$lng}) ) + sin( radians({$lat}) ) * sin( radians( `lat` ) ) ) ) AS distance

FROM `positions`

HAVING distance <= {$radius}

ORDER BY distance ASC

Posted in Php, Sql No comments April 21, 2017