display rows brought back by query php

ByAnurag batra July 29, 2022October 23, 2022

$result = mysqli_query($sql); // execute query

// process each row returned from query
while($row = mysqli_fetch_array($result)) {
    echo $row['fieldname'];  // print the field (column name in table)
  	echo print_r($row);		 // print out the whole road
}

Here is what the above code is Doing:
1. Connect to the database
2. Create a query to select all the fields from the table
3. Execute the query
4. Loop through the results and print out each field

PHP Examples

laravel get file name

ByAnurag batra October 20, 2022September 6, 2022

$path = $request->image->getClientOriginalName(); Here is what the above code is Doing: 1. We’re getting the file from the request. 2. We’re getting the original name of the file. 3. We’re storing the file in the public/uploads directory. 4. We’re getting the path of the file and storing it in the $path variable.

PHP Examples

remove item from collection

ByAnurag batra August 2, 2022June 30, 2022

$collection = collect([‘name’ => ‘taylor’, ‘framework’ => ‘laravel’]); // The forget method removes an item from the collection by its key: $collection->forget(‘name’); // The pull method removes and returns an item from the collection by its key: $collection->pull(‘name’); // The reject method filters the collection using the given closure. // The closure should return true…

how tdo you convert a stringto lowercase in php

PHP Examples

how tdo you convert a stringto lowercase in php

ByAnurag batra July 29, 2022June 30, 2022

/* strtolower() function converts string to lowercase. */ // Output:hello world 123 Here is what the above code is Doing: 1. The strtolower() function converts the string “Hello WORLD 123” to lowercase. 2. The echo statement prints the lowercase string to the screen.

PHP Examples

php compare two arrays of objects

ByAnurag batra October 10, 2022September 6, 2022

// Computes the difference of arrays by using a callback function for data comparison. This is unlike array_diff() which uses an internal function for comparing the data. function compare_objects($obj_a, $obj_b) { return $obj_a->id – $obj_b->id; } $diff = array_udiff($first_array, $second_array, ‘compare_objects’); Here is what the above code is Doing: 1. The function compare_objects() is used…

PHP Examples

php array in cookie

ByAnurag batra July 15, 2022June 30, 2022

// Storing code setcookie(‘your_cookie_name’, json_encode($info), time()+3600); // Reading code $data = json_decode($_COOKIE[‘your_cookie_name’], true); Here is what the above code is Doing: 1. We’re creating an array with some data. 2. We’re encoding the array into a JSON string. 3. We’re storing the JSON string in a cookie. 4. We’re reading the JSON string from the…

php warning: php startup: unable to load dynamic library

PHP Examples

php warning: php startup: unable to load dynamic library

ByAnurag batra July 11, 2022June 30, 2022

If you are a windows user, make sure to uncomment this line in your php.ini file: extension_dir = “ext” Here is what the above code is Doing: 1. We are creating a new instance of the class “MySQLdb.connect” 2. We are passing the following arguments to the constructor: a. host = “localhost” b. user =…

Similar Posts