PHP: 2014

Friday 3 October 2014

Drupal PHP Query Connection

$DB_NAME = DB_START_NAME . $clinic_id;
dpr($DB_NAME);
$database_info = array(
'host' => HOST_NAME,
'database' => $DB_NAME,
'username' => HOSTUSER,
'password' => HOSTPASS,
'driver' => 'mysql',
);

Database::addConnectionInfo('flat_db', 'default', $database_info);
$key = 'flat_db';
$custom_db = Database::getConnection($DB_NAME, $key);
$sql_query = "SELECT * FROM sc_patient_appointments LIMIT 1";
$result = $custom_db->query($sql_query);
foreach ($result as $row) {
//$reaged = (array) $row; // Standard object to array
dpr($row);
}

Sunday 31 August 2014

Php String Split to Array

$str = 'one,two,three,four';
$arr=explode(",",$str);
dpr($arr);

--------Result

Array
(
    [0] => one
    [1] => two
    [2] => three
    [3] => four
)

Monday 11 August 2014

drupal mysql insert statement

$id = db_insert('pms_link_master')
->fields(array(
'NODE_ID' => '1',
'PMS_ID' => '2',
'CLINIC_ID' => '415',
'MASTER_TYPE' => 'location'
))
->execute();

http://alvinalexander.com/drupal/drupal-7-db_insert-query-sql-insert-db_query

drupal custom mysql statement

$sql_query = db_query("select * from pms_link_master");
echo "total rows ".$sql_query->rowCount();

$sql_array = array();
foreach ($sql_query as $row) {
$reaged = (array) $row; // Standard object to array
$sql_array[] = $reaged;
}
dpr($sql_array);

Friday 4 July 2014

PHP Read Folder Files

$files = glob($dir . '*.csv');

foreach ($files as $x => $x_filepath) {
// get file path
$filePath = $x_filepath;
// get file name
$file_NAME = basename($filePath, ".csv");
}

PHP Read CSV file and store in array

PHP Drupal View to Array

Thursday 3 July 2014

array search

function findWhere($array, $matching) {
    foreach ($array as $item) {
        $is_match = true;
        foreach ($matching as $key => $value) {

            if (is_object($item)) {
                if (! isset($item->$key)) {
                    $is_match = false;
                    break;
                }
            } else {
                if (! isset($item[$key])) {
                    $is_match = false;
                    break;
                }
            }

            if (is_object($item)) {
                if ($item->$key != $value) {
                    $is_match = false;
                    break;
                }
            } else {
                if ($item[$key] != $value) {
                    $is_match = false;
                    break;
                } 
            }
        }

        if ($is_match) {
            return $item;   
        }
    }

    return false;
}

Example:

$cars = array(
    array('id' => 1, 'name' => 'Toyota'),
    array('id' => 2, 'name' => 'Ford')
);

$car = findWhere($cars, array('id' => 1));

$car = findWhere($cars, array(
    'id' => 1,
    'name' => 'Toyota'
));

PHP DateTime Validation

if (DateTime_Validation($text, $format = 'YmdHi') == 1) {
return 1; // False
}
return 0; // True

function DateTime_Validation($date, $format = 'YmdHi') {
$d = DateTime::createFromFormat($format, $date);
$return_type = $d && $d->format($format) == $date;
if ($return_type == 1) {
return 0;
} else {
return 1;
}
}

PHP Multidimensional Array Search by Column

$result_array = (search($array_list, 'column_name', 'Value'));

function search($array, $key, $value) {
$results = array();

if (is_array($array)) {
if (isset($array[$key]) && $array[$key] == $value) {
$results[] = $array;
}

foreach ($array as $subarray) {
$results = array_merge($results, search($subarray, $key, $value));
}
}

return $results;
}

PHP Array To HTML Table Conversion

print array2table($array);

function array2table($array, $recursive = false, $null = ' ')
{
// Sanity check
if (empty($array) || !is_array($array)) {
return false;
}

if (!isset($array[0]) || !is_array($array[0])) {
$array = array($array);
}

// Start the table

$table = '<table class="table table-bordered table-striped dataTable">';

// The header
$table .= "\t<tr>";
// Take the keys from the first row as the headings
foreach (array_keys($array[0]) as $heading) {
$table .= '<th>' . $heading . '</th>';
}
$table .= "</tr>\n";

// The body
foreach ($array as $row) {
$table .= "\t<tr>" ;
foreach ($row as $cell) {
$table .= '<td>';

// Cast objects
if (is_object($cell)) { $cell = (array) $cell; }

if ($recursive === true && is_array($cell) && !empty($cell)) {
// Recursive mode
$table .= "\n" . array2table($cell, true, true) . "\n";
} else {
$table .= (strlen($cell) > 0) ?
htmlspecialchars((string) $cell) :
$null;
}

$table .= '</td>';
}

$table .= "</tr>\n";
}

$table .= '</table>';
return $table;
}

Monday 23 June 2014

PHP String Functions

There are three main ways to define strings in PHP. We have:

Characters enclosed in double quotes.
Characters enclosed in single quotes.
Characters or lines of characters enclosed by heredoc symbols

Double Quotes
Double quotes are useful when you have a PHP variable you want to embed within the string, since when the PHP runs, it will use interpolation to grab the actual value of that variable.

1

$str = "Hi buddy, I'm a PHP String";

Single Quotes
Some people find it easier to leave their variables out of strings and let them be more hard coded sort to speak. Use single quotes for that.

1

$str = 'Hi again, still a PHP String!';

Heredoc Syntax

1

2

3

4

5

6

$str = <<<EOD

Wordpress is really cool

HTML5 is the key to the open web

Who likes to use Twitter Bootstrap

We can have several lines here!

EOD;

Note: You don’t have to use EOD as your delimiter, you can use anything you like as long as they are the same!

Most Popular PHP String Functions

1. substr()

The substr() function helps you to access a substring between given start and end points of a string. It can be useful when you need to get at parts of fixed format strings.

The substr() function prototype is as follows:

1

string substr(string string, int start[, int length] );

The return value is a substring copied from within string.

1

$blog = 'Your Blog is Excellent!';

When you call the function with a positive number for start (only), you will get the string from the start position to the end of the string.

1

2

3

$blog = 'Your Blog is Excellent!';

substr($blog, 1);

//  returns 'our Blog is Excellent!'

String position starts from 0, just like arrays.

When you call substr() with a negative start (only), you will get the string from the end of the string minus start characters to the end of the string.

1

2

3

$blog = 'Your Blog is Excellent!';

substr($blog, -9);

//  returns 'xcellent!'

The length parameter can be used to specify either a number of characters to return if it is positive, or the end character of the return sequence if it is negative.

1

2

3

4

5

6

$blog = 'Your Blog is Excellent!';

substr($blog, 0, 4);

// returns 'Your'

substr($blog, 5, -13);

//returns 'Blog'

5 signifies the starting character point (B) and -13 determines the ending point (count 13 places backwards starting from the end of the string).

Learn more about substr() at http://us3.php.net/substr

2. strlen()

Next up we have the popular strlen() function for checking the length of a string. If you pass it a string,strlen() will return its length.

1

2

echo strlen("Super Cali Fragilistics Expy Ali Docious");

// 40

Often times this function is used for validating input data or making sure a string variable has a value.

1

2

3

4

5

6

7

8

9

10

<?php

$super = 'duper';

if (strlen ( $super ) > 0) {

    echo 'Thanks for giving super some duper';

} else {

    echo 'That might not have worked';

}

?>

// Thanks for giving super some duper

Learn more about strlen() at http://us3.php.net/strlen

3. str_replace()

Find and replace functionality is super useful with strings. You can use find and replace for almost anything your imagination can think of.

The most commonly used string function for replacement is str_replace(). It has the following prototype:

1

mixed str_replace(mixed needle, mixed new_needle, mixed haystack[, int &count]));

str_replace() replaces all the instances of needle in haystack with new_needle and returns the new version of the haystack.The optional fourth parameter contains the number of replacements made.

A really awesome feature of str_replace() is the ability to pass an array to both the search terms and replace terms, as well as an array of strings to apply the rules to!

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

<?php

$strings = array (

        'You like to have a fun time',

        'You are a really nice person',

        'Would you like to have a cup of coffee?' 

);

$search = array (

        'fun',

        'time',

        'person',

        'coffee' 

);

$replace = array (

        'excellent',

        'adventure',

        'individual',

        'joe' 

);

$replaced = str_replace ( $search, $replace, $strings );

print_r ( $replaced );

/////////////////////////////////

Array

(

    [0] => You like to have a excellent adventure

    [1] => You are a really nice individual

    [2] => Would you like to have a cup of joe?

)

?>

Learn more about str_replace() at http://php.net/manual/en/function.str-replace.php

4. trim()

The first step in tidying up data is to trim any excess whitespace from the string. This is a good idea to prepare for a database insert or string comparison.

The trim() function strips whitespace from the start and end of a string and returns the resulting string. The characters it strips by default are newlines and carriage returns (\n and \r), horizontal and vertical tabs (\t and \x0B), end-of-string characters (\0), and spaces. You can also pass it a second parameter containing a list of characters to strip instead of this default list. Depending on your particular purpose, you might like to use theltrim() or rtrim() functions instead which perform the same operation, but you choose which side of the string to affect.

Here we remove some literal junk from the beginning and end of our string:

1

2

3

4

5

6

7

8

9

<?php

$trimit = 'junk awesome stuff junk';

$trimmed = trim ( $trimit, 'junk' );

print_r ( $trimmed );

// awesome stuff 

?>

Learn more about trim() at http://us2.php.net/manual/en/function.trim.php

5. strpos()

The function strpos() operates in a similar fashion to strstr(), except, instead of returning a substring, it returns the numerical position of a needle within a haystack.

The strpos() function has the following prototype:

1

int strpos(string haystack, string needle, int [offset] );

The integer returned is the position of the first occurrence of the needle within the haystack. The first character is in position 0 just like arrays.

We can see by running the following code that our exclamation point is at position 13.

1

2

3

$awesome = "Super Awesome!";

echo strpos($awesome, "!");

// 13

This function accepts a single character as the needle, but it can accept a string of any length. The optional offset parameter determines the point within the haystack to start searching.

1

2

3

$awesome = "Super Awesome!";

echo strpos($awesome, ‘m’, 3);

// 11

This code echoes the value 11 to the browser because PHP has started looking for the character ‘m’ at position 3.

In any of these cases, if the needle is not in the string, strpos() will return false. To avoid strange behavior you can use the === operator to test return values:

1

2

3

4

5

6

7

8

9

10

11

12

<?php

$awesome = "Super Awesome!";

$result = strpos ( $awesome, G );

if ($result === false) {

    echo 'Not found';

} else {

    echo 'Found at position ' . $result;

}

// Not found

?>

Learn more about strpos() at http://us2.php.net/strpos

6. strtolower()

Very often in PHP we need to compare strings or correct capitalization when people SHOUT or do odd things. In order to compare strings, you want to make sure they are the same case. We can use strtolower() for this purpose. We’ll use a function created with strtolower() to calm down an angry person.

1

2

3

4

5

6

7

8

9

10

11

<?php

function calm_down($string) {

    return strtolower ( $string );

}

$person = 'Angry people SHOUT!';

echo calm_down ( $person );

// angry people shout!

?>

Learn more about strtolower() at http://us3.php.net/strtolower

7. strtoupper()

strtoupper() is also quite popular for many of the reasons listed above, in reverse, meaning take lowercase or a mixed case string and set it to all upper case. We’ll change things up and create a wake up function to get our workers going in the morning.

1

2

3

4

5

6

7

8

9

10

11

<?php

function wake_up($string) {

    return strtoupper ( $string );

}

$person = 'these people need to get working!';

echo wake_up ( $person );

// THESE PEOPLE NEED TO GET WORKING!

?>

Learn more about strtoupper() at http://us3.php.net/strtoupper

8. is_string()

is_string() is used to check if a value is a string. Let’s take a look at this within an if() statement to take an action on strings in one way and non-strings in another. is_string() returns true or false.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

<?php

if (is_string ( 7 )) {

    echo "Yes";

} else {

    echo "No";

}

// No

if (is_string ( "Lucky Number 7" )) {

    echo "Yes";

} else {

    echo "No";

}

// Yes

?>

Learn more about is_string() at http://us2.php.net/is_string

9. strstr()

Last but not least we have the strstr() function. The function strstr() can be used to find a string or character match within a longer string. This function can be used to find a string inside a string, including finding a string containing only a single character.

The function prototype for strstr() is as follows:

1

string strstr(string haystack, string needle);

You pass strstr() a haystack to be searched and a needle to be found. If an exact match of the needle is found, the strstr() function returns the haystack from the needle onward. If it does not find the needle, it will return false. If the needle occurs more than once, the returned string will begin from the first occurrence of the needle.

As an example, let’s say we have a submission form for people to submit their website, but we would like it in a certain format. We can use strstr() to check for a string within a string to help us here:

1

2

3

4

5

6

7

8

9

10

<?php

$url = 'vegibit.com';

if (strstr ( $url, 'http://www.' ) === false) {

    $url = 'http://www.' . $url;

}

echo $url;

// http://www.vegibit.com

?>