pdo bindparam string

ByAnurag batra October 4, 2022September 6, 2022

prepare('SELECT name, colour, calories
    FROM fruit
    WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>

Here is what the above code is Doing:
1. The prepare() method of the PDO object is used to prepare the SQL statement.
2. The bindParam() method binds the named parameter markers to the specified PHP variables.
3. The execute() method of the PDOStatement object executes the prepared statement.

PHP Examples

numberformater php format to k and m

ByAnurag batra October 6, 2022September 6, 2022

function shortNumber($num) { $units = [”, ‘K’, ‘M’, ‘B’, ‘T’]; for ($i = 0; $num >= 1000; $i++) { $num /= 1000; } return round($num, 1) . $units[$i]; } Here is what the above code is Doing: 1. We’re using a for loop to iterate through the $units array. 2. We’re dividing the $num by…

creating default object from empty value laravel

PHP Examples

creating default object from empty value laravel

ByAnurag batra October 19, 2022September 6, 2022

you haven’t initialized the variable $user so in the controller and before using it you’ve to add $user = new User; assuming that you already have use App\User; or $user = new \App\User; if you don’t. Update if you’re trying to update an existing user record you’ve to initialize the $user variable by selecting based…

E: Couldn’t find any package by regex ‘php7.2-json’

PHP Examples

E: Couldn’t find any package by regex ‘php7.2-json’

ByAnurag batra October 6, 2022September 6, 2022

sudo apt-add-repository ppa:ondrej/php sudo apt-get update sudo apt-get install php7.0 Here is what the above code is Doing: 1. Add the PPA repository for PHP 7.0 2. Update the local package index 3. Install PHP 7.0

PHP Examples

explode example in php

ByAnurag batra July 30, 2022June 30, 2022

$colors = “red,blue,green,orange”; $colorsArray = explode(“,”, $colors); Here is what the above code is Doing: 1. We have a string of colors separated by commas. 2. We use the explode() function to split the string into an array. 3. The explode() function splits the string where it finds the delimeter, which is a comma in…

PHP Examples

custom my account page woocommerce

ByAnurag batra October 7, 2022September 6, 2022

// Method 1: // To create a whole new page using code, copy the following file: plugins/woocommerce/templates/myaccount/dashboard.php // Paste the dashboard.php file in your child theme directory themes//woocommerce/templates/myaccount/dashboard.php // Folder structure and file names must match to wordpress override the original content. // Now you can mess with your own dashboard file or using hooks…

PHP Examples

store multiple session in laravel

ByAnurag batra October 9, 2022September 6, 2022

//store multipal data Session::put(‘user’, [‘first_name’ => $request->get(‘first_name’), ‘user_role’ => Auth::user()->user_role, ‘city’ => Auth::user()->city]); //in blade template {{Session::get(‘user’)[‘city’]}} @foreach (Session::get(‘user’) as $user) {{$user}} @endforeach //condtion check @if(Session::has(‘user’)) @foreach (Session::get(‘user’) as $user) {{ $user }} @endforeach @endif // condition check using ternary operator {{ (Session::has(‘user’)) ? 45 : 55}} //delete session Session::forget(‘customer’); //@sujay Here is what the…

Similar Posts