Calling Stored Procedure Inside Foreach in PHP CodeIgniter

AmitDiwan
Updated on 06-Apr-2020 08:33:34

1K+ Views

The code inside the 'Model' and the 'Controller' needs to be changed to include code that is shown below −Inside the 'Controller'$header = $this->model_name->call_head(); foreach($header as $item) {    $name = $item['name'];    $array['name'] = $name;    $array['data'] = $item['data'];    $child_val = $this->model_name->call_child($name);    foreach($child_val as $value) {       $array['child'] = array(          'child_name' => $value['child_name'],          'child_data' => $value['child_data']       );    } }Inside the 'model'public function call_head() {    $query = "CALL PROCEDURE_HEAD()";    $result = $this->db->query($query)->result_array();    $query->next_result();    $query->free_result();    return $result; } public function ... Read More

Convert JSONL to Array with PHP

AmitDiwan
Updated on 06-Apr-2020 08:31:12

442 Views

The json_decode function can be used as shown below −json_decode($json_string_that_needs_to_be_converted, true);The below lines of code can be used to convert JSONL to array format −$json_string = '["m@gmail.com", "p@gmail.com", "q@gmail.com"]'; $array_of_data=json_decode($json_string);An alternate is to use the below code, wherein the way json_string has been defined changes −Example$json_string = "[\"m@gmail.com\", \"p@gmail.com\", \"q@gmail.com\"]"; $array_of_data=json_decode($json_string);OutputThis will produce the following output −Array("m@gmail.com", "p@gmail.com", "q@gmail.com")Read More

PHP Function to Convert HEX to HSL

AmitDiwan
Updated on 06-Apr-2020 08:29:57

593 Views

The below code can be used to convert hex value into HSL value −function hex_To_Hsl($hex) {    $hex_val = array($hex_val[0].$hex_val[1], $hex_val[2].$hex_val[3], $hex_val[4].$hex_val[5]);    $rgb_val = array_map(function($part) {       return hexdec($part) / 255;    }, $hex_val);    $max_val = max($rgb_val);    $min_val = min($rgb_val);    $l = ($max_val + $min_val) / 2;    if ($max_val == $min_val) {       $h = $s = 0;    } else {       $diff = $max_val - $min_val;       $s = $l > 0.5 ? $diff / (2 - $max_val - $min_val) : $diff / ($max_val + ... Read More

Check Existence of Value in Array Efficiently in PHP

AmitDiwan
Updated on 06-Apr-2020 08:28:04

118 Views

A quick way of doing this has been shown below −if (array_flip($set)[$value] !== null) {    echo "something"; //take some action }To customize the number of keys, the function can be customized in the below manner −function array_keys_exists(array $keys, array $arr) {    return !array_diff_key(array_flip($keys), $arr); }

Send Multiple Data with AJAX in PHP

AmitDiwan
Updated on 06-Apr-2020 08:26:11

6K+ Views

Data can be sent through JSON or via normal POST. Following is an example showing data sent through JSON −var value_1 = 1; var value_2 = 2; var value_3 = 3; $.ajax({    type: "POST",    contentType: "application/json; charset=utf-8",    url: "your_url_goes_here",    data: { data_1: value_1, data_2: value_2, data_3: value_3 },    success: function (result) {       // perform operations here    } });With normal post, the below code can be used −$.ajax({    type: "POST",    url: $('form').attr("action"),    data: $('#form0').serialize(),    success: function (result) {       // perform operations here    } });An ... Read More

Get Unix Timestamp from String in PHP Without Setting Default Timezone

AmitDiwan
Updated on 06-Apr-2020 08:23:28

594 Views

String has a time zone, and there is usually no need to set a default time zone. But when it needs to be printed, the default time zone can be set explicitly. Below is the code to do the same −Default timezoneExample Live Demoecho date_default_timezone_get();OutputThis will produce the following output −UTCWhen timezone is specifiedExample Live Demoecho date("Y-m-d H:i:s",strtotime("1/1/2020 00:00:00 America/Los_Angeles"));OutputThis will produce the following output −2020-01-01 08:00:00 Another way of specifying timezoneExample Live Demoecho date("Y-m-d H:i:s",strtotime("1/1/2020 00:00:00"));OutputThis will produce the following output −2020-01-01 00:00:00

Effectively Hide href from a Link in PHP

AmitDiwan
Updated on 06-Apr-2020 08:20:48

814 Views

This is not possible. A href can’t be hidden from a link. But the files can be rewritten and the request URL can be changed to look like this − name.php/5001Other than this, a post request can be used in the below way − Go This will expose a single button in the browser.

Get All Keys from an Array Starting with a Certain String in PHP

AmitDiwan
Updated on 06-Apr-2020 08:18:02

1K+ Views

Method 1$arr_main_array = array('test_val' => 123, 'other-value' => 456, 'test_result' => 789); foreach($arr_main_array as $key => $value){    $exp_key = explode('-', $key);    if($exp_key[0] == 'test'){       $arr_result[] = $value;    } } if(isset($arr_result)){    print_r($arr_result); }Method 2A functional approach An array_filter_key type of function is taken, and applied to the array elements $array = array_filter_key($array, function($key) {    return strpos($key, 'foo-') === 0; });Method 3A procedural approach −$val_1 = array(); foreach ($array as $key => $value) {    if (strpos($key, 'foo-') === 0) {       $val_1[$key] = $value;    } }Method 4A procedural approach using ... Read More

Resize Image in PHP

AmitDiwan
Updated on 06-Apr-2020 07:55:41

5K+ Views

Images can be resized using ImageMagick or GD functions. If GD’s functions are used, the size of the image file is also reduced when raw digital camera images are sampled. We will see how GD can be used to resize an image in the below code.function image_resize($file_name, $width, $height, $crop=FALSE) {    list($wid, $ht) = getimagesize($file_name);    $r = $wid / $ht;    if ($crop) {       if ($wid > $ht) {          $wid = ceil($wid-($width*abs($r-$width/$height)));       } else {          $ht = ceil($ht-($ht*abs($r-$w/$h)));       }     ... Read More

Sort Multidimensional Array by Multiple Keys in PHP

AmitDiwan
Updated on 06-Apr-2020 07:53:22

3K+ Views

The array_multisort function can be used to sort a multidimensional array based on multiple keys −Example$my_list = array(    array('ID' => 1, 'title' => 'data one', 'event_type' => 'one'),    array('ID' => 2, 'title' => 'data two', 'event_type' => 'zero'),    array('ID' => 3, 'title' => 'data three', 'event_type' => 'one'),    array('ID' => 4, 'title' => 'data four', 'event_type' => 'zero') ); # The list of sorted columns and their data can be obtained. This will be passed to the array_multisort function. $sort = array(); foreach($my_list as $k=>$v) {    $sort['title'][$k] = $v['title'];    $sort['event_type'][$k] = $v['event_type']; } # ... Read More

Advertisements