Category Archives: PHP

Php Recursive Directory Copy

May 9, 2016 Galaxy Internet Leave a comment

$source  = "./resources/bootstrap-3.3.6-dist/"; // source folder or file
$destination = "./$created_app_directory/bootstrap-3.3.6-dist"; // destination folder or file

function recurse_copy($source, $destination)
    {
    $dir = opendir($source);
    mkdir($destination);
    while (false !== ($file = readdir($dir)))
        {
        if (($file != '.') && ($file != '..'))
            {
            if (is_dir($source . '/' . $file))
                {
                recurse_copy($source . '/' . $file, $destination . '/' . $file);
                }
            else
                {
                copy($source . '/' . $file, $destination . '/' . $file);
                }
            }
        }
    closedir($dir);
    }
recurse_copy($source, $destination);

$source = "./resources/bootstrap-3.3.6-dist/"; // source folder or file

$destination = "./$created_app_directory/bootstrap-3.3.6-dist"; // destination folder or file

function recurse_copy($source, $destination)

{

$dir = opendir($source);

mkdir($destination);

while (false !== ($file = readdir($dir)))

{

if (($file != '.') && ($file != '..'))

{

if (is_dir($source . '/' . $file))

{

recurse_copy($source . '/' . $file, $destination . '/' . $file);

}

else

{

copy($source . '/' . $file, $destination . '/' . $file);

}

closedir($dir);

}

recurse_copy($source, $destination);

PHP, Reg Ex, Regex, Regular Expressions

Php Short Tags Regex

May 7, 2016 Galaxy Internet Leave a comment

Regular Expression to find Php Short Tags

Webuilder
<\?\s

Replace Studio
<\?\r

PHP, Uncategorized

View Hidden Characters In Php

May 3, 2016 Galaxy Internet Leave a comment

To easily view hidden characters in a string just echo the string with json_encode. You will be able to see all the \n and \r\n hidden characters.

$str = "...";
echo json_encode($str);

1 2	$str = "..."; echo json_encode($str);

Arrays, CSV, Forms, PHP

Php Form To CSV

October 12, 2015 Galaxy Internet Leave a comment

$_POST['fname'] = 'Sam';
$_POST['lname'] = 'Smith';
$_POST['sex']   = 'M';

$list = array(
    array(
        $_POST['fname'],
        $_POST['lname'],
        $_POST['sex']
    )
);

$fp = fopen('test.csv', 'a');

foreach ($list as $fields)
    {
    fputcsv($fp, $fields);
    }
fclose($fp);

$_POST['fname'] = 'Sam';

$_POST['lname'] = 'Smith';

$_POST['sex'] = 'M';

$list = array(

array(

$_POST['fname'],

$_POST['lname'],

$_POST['sex']

)

);

$fp = fopen('test.csv', 'a');

foreach ($list as $fields)

{

fputcsv($fp, $fields);

}

fclose($fp);

Arrays, Mysql, PDO, PHP

How To Get Mysql Column Names

September 22, 2014 Galaxy Internet Leave a comment

<?php
try
    {
    $stmt = $pdo->prepare("DESCRIBE `YourTableName`");
    $stmt->execute();
    $colum_names_array = $stmt->fetchAll(PDO::FETCH_COLUMN);
    }
catch (PDOException $e)
    {
    echo "<pre>";
    echo $e;
    echo "</pre>";
    }

echo "<pre>";
print_r($colum_names_array);
echo "</pre>";
?>

<?php

try

{

$stmt = $pdo->prepare("DESCRIBE `YourTableName`");

$stmt->execute();

$colum_names_array = $stmt->fetchAll(PDO::FETCH_COLUMN);

}

catch (PDOException $e)

{

echo "<pre>";

echo $e;

echo "</pre>";

}

echo "<pre>";

print_r($colum_names_array);

echo "</pre>";

How To Get Mysql Field Names Short Version

$q = $pdo->prepare("DESCRIBE YourtableName");
$q->execute();
print_r($column_names = $q->fetchAll(PDO::FETCH_COLUMN));

$q = $pdo->prepare("DESCRIBE YourtableName");

$q->execute();

print_r($column_names = $q->fetchAll(PDO::FETCH_COLUMN));

Arrays, PHP

PHP Pagination – Array Chunk Pagination

March 16, 2014 Galaxy Internet Leave a comment

PHP Array Chunk Pagination – array_chunk

<?php
//----------------------------------------------------------------------------
// Generate Sample Data
//----------------------------------------------------------------------------

foreach (range(1, 40) as $value)
    {
    $data[] = array(
        'Product' => 'Product ' . $value,
        'Price' => rand(10, 100),
        'Quantity' => rand(1, 25)
    );
    }

//----------------------------------------------------------------------------
// Number Of Chunks
//----------------------------------------------------------------------------

$number_of_chunks = 4;

//----------------------------------------------------------------------------
// Break Array Into Chunks
//----------------------------------------------------------------------------

$data = array_chunk($data, $number_of_chunks);

//----------------------------------------------------------------------------
// Get Page Count
//----------------------------------------------------------------------------

$pagecount = count($data);

//----------------------------------------------------------------------------
// Make sure page is set and is numeric
//----------------------------------------------------------------------------

if (isset($_GET['p']) && (is_numeric($_GET['p'])))
    {
    if ($_GET['p'] > $pagecount)
        {
        die('<span style="color:#FF0000">Error: Page Does Not Exist</span>');
        }
    $i = $_GET['p'] - 1;
    }
else
    {
    $i = 0;
    }

//----------------------------------------------------------------------------
// Display array_chunk Data
//----------------------------------------------------------------------------

echo '<pre>';
print_r($data[$i]);
echo '</pre>';

//----------------------------------------------------------------------------
// Display array_chunk Pagination
//----------------------------------------------------------------------------

for ($i = 1; $i <= $pagecount; $i++)
    {
    echo "<a href='{$_SERVER['SCRIPT_NAME']}?p=$i'>$i</a> | ";
    }
?>

<?php

//----------------------------------------------------------------------------

// Generate Sample Data

//----------------------------------------------------------------------------

foreach (range(1, 40) as $value)

{

$data[] = array(

'Product' => 'Product ' . $value,

'Price' => rand(10, 100),

'Quantity' => rand(1, 25)

);

}

//----------------------------------------------------------------------------

// Number Of Chunks

//----------------------------------------------------------------------------

$number_of_chunks = 4;

//----------------------------------------------------------------------------

// Break Array Into Chunks

//----------------------------------------------------------------------------

$data = array_chunk($data, $number_of_chunks);

//----------------------------------------------------------------------------

// Get Page Count

//----------------------------------------------------------------------------

$pagecount = count($data);

//----------------------------------------------------------------------------

// Make sure page is set and is numeric

//----------------------------------------------------------------------------

if (isset($_GET['p']) && (is_numeric($_GET['p'])))

{

if ($_GET['p'] > $pagecount)

{

die('<span style="color:#FF0000">Error: Page Does Not Exist</span>');

}

$i = $_GET['p'] - 1;

}

else

{

$i = 0;

}

//----------------------------------------------------------------------------

// Display array_chunk Data

//----------------------------------------------------------------------------

echo '<pre>';

print_r($data[$i]);

echo '</pre>';

//----------------------------------------------------------------------------

// Display array_chunk Pagination

//----------------------------------------------------------------------------

for ($i = 1; $i <= $pagecount; $i++)

{

echo "<a href='{$_SERVER['SCRIPT_NAME']}?p=$i'>$i</a> | ";

}

Arrays, PHP

PHP List Files in Directory Excluding Index

March 3, 2014 Galaxy Internet Leave a comment

PHP List all files in a directory excluding the index file from the list.

Functions used are array_values, preg_grep, glob, foreach and basename.

$files = array_values(preg_grep('/^((?!index.php).)*$/', glob("*.php")));
foreach ($files as $filename)
    {
    echo "<li><a href=\"{$filename}\">".basename($filename, ".php")."</a></li>";
    }

$files = array_values(preg_grep('/^((?!index.php).)*$/', glob("*.php")));

foreach ($files as $filename)

{

echo "<li><a href=\"{$filename}\">".basename($filename, ".php")."</a></li>";

}

Another option using str_replace and !empty

<?php
foreach (glob("*.php") as $filename)
    {
    $filename = str_replace("index.php", '', $filename);
    if (!empty($filename))
        {
        echo "<li><a href=\"$filename\">" . basename($filename, ".php") . "</a></li>";
        }
    }
?>

<?php

foreach (glob("*.php") as $filename)

{

$filename = str_replace("index.php", '', $filename);

if (!empty($filename))

{

echo "<li><a href=\"$filename\">" . basename($filename, ".php") . "</a></li>";

}

Arrays, Forms, HTML, PHP

PHP US State Dropdown Array

March 2, 2014 Galaxy Internet Leave a comment

PHP State Dropdown Array Demo

Complete PHP State Dropdown Array Form

<!DOCTYPE html>

<html>

<head>
  <title>States Dropdown Array</title>
<style type="text/css">
<!--
.states {
display:none;
}
-->
</style>
</head>

<body>

<?php
$states = array(
    'AL' => "Alabama",
    'AK' => "Alaska",
    'AZ' => "Arizona",
    'AR' => "Arkansas",
    'CA' => "California",
    'CO' => "Colorado",
    'CT' => "Connecticut",
    'DE' => "Delaware",
    'DC' => "District Of Columbia",
    'FL' => "Florida",
    'GA' => "Georgia",
    'HI' => "Hawaii",
    'ID' => "Idaho",
    'IL' => "Illinois",
    'IN' => "Indiana",
    'IA' => "Iowa",
    'KS' => "Kansas",
    'KY' => "Kentucky",
    'LA' => "Louisiana",
    'ME' => "Maine",
    'MD' => "Maryland",
    'MA' => "Massachusetts",
    'MI' => "Michigan",
    'MN' => "Minnesota",
    'MS' => "Mississippi",
    'MO' => "Missouri",
    'MT' => "Montana",
    'NE' => "Nebraska",
    'NV' => "Nevada",
    'NH' => "New Hampshire",
    'NJ' => "New Jersey",
    'NM' => "New Mexico",
    'NY' => "New York",
    'NC' => "North Carolina",
    'ND' => "North Dakota",
    'OH' => "Ohio",
    'OK' => "Oklahoma",
    'OR' => "Oregon",
    'PA' => "Pennsylvania",
    'RI' => "Rhode Island",
    'SC' => "South Carolina",
    'SD' => "South Dakota",
    'TN' => "Tennessee",
    'TX' => "Texas",
    'UT' => "Utah",
    'VT' => "Vermont",
    'VA' => "Virginia",
    'WA' => "Washington",
    'WV' => "West Virginia",
    'WI' => "Wisconsin",
    'WY' => "Wyoming"
);
?>
<form>
    <select name="state">
        <option selected="selected" class="states">Select State</option>
        <?php foreach ($states as $abbr => $state) {?>
            <option value="<?php echo $abbr;?>"><?php echo $state;?></option>
        <?php }?>
    </select>
</form>

</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>States Dropdown Array</title>

<!--

.states {

display:none;

}

-->

</style>

</head>

<body>

<?php

$states = array(

'AL' => "Alabama",

'AK' => "Alaska",

'AZ' => "Arizona",

'AR' => "Arkansas",

'CA' => "California",

'CO' => "Colorado",

'CT' => "Connecticut",

'DE' => "Delaware",

'DC' => "District Of Columbia",

'FL' => "Florida",

'GA' => "Georgia",

'HI' => "Hawaii",

'ID' => "Idaho",

'IL' => "Illinois",

'IN' => "Indiana",

'IA' => "Iowa",

'KS' => "Kansas",

'KY' => "Kentucky",

'LA' => "Louisiana",

'ME' => "Maine",

'MD' => "Maryland",

'MA' => "Massachusetts",

'MI' => "Michigan",

'MN' => "Minnesota",

'MS' => "Mississippi",

'MO' => "Missouri",

'MT' => "Montana",

'NE' => "Nebraska",

'NV' => "Nevada",

'NH' => "New Hampshire",

'NJ' => "New Jersey",

'NM' => "New Mexico",

'NY' => "New York",

'NC' => "North Carolina",

'ND' => "North Dakota",

'OH' => "Ohio",

'OK' => "Oklahoma",

'OR' => "Oregon",

'PA' => "Pennsylvania",

'RI' => "Rhode Island",

'SC' => "South Carolina",

'SD' => "South Dakota",

'TN' => "Tennessee",

'TX' => "Texas",

'UT' => "Utah",

'VT' => "Vermont",

'VA' => "Virginia",

'WA' => "Washington",

'WV' => "West Virginia",

'WI' => "Wisconsin",

'WY' => "Wyoming"

);

<form>

<option selected="selected" class="states">Select State</option>

<?php foreach ($states as $abbr => $state) {?>

<?php }?>

</select>

</form>

</body>

</html>

PHP, PHP Sessions

PHP Automatic Logout – Auto Logout

February 22, 2014 Galaxy Internet Leave a comment

This PHP function automatically logs out a user after a specified amount of inactivity.

Usage: Add this PHP code to the top of your pages

<?php
session_start();
auto_logout();
?>

<?php

session_start();

auto_logout();

<?php
$inactive = 30; // Set timeout minutes
$logout_redirect_url = "index.php"; // Set logout URL

function auto_logout()
    {
    global $inactive, $logout_redirect_url;   
    $inactive = $inactive * 60; // Converts minutes to seconds
    if (isset($_SESSION['start_time']))
        {
        $elapsed_time = time() - $_SESSION['start_time'];
        if ($elapsed_time >= $inactive)
            {
            session_destroy();
            header("Location: $logout_redirect_url");
            }
        }
    $_SESSION['start_time'] = time();
    }
?>

<?php

$inactive = 30; // Set timeout minutes

$logout_redirect_url = "index.php"; // Set logout URL

function auto_logout()

{

global $inactive, $logout_redirect_url;

$inactive = $inactive * 60; // Converts minutes to seconds

if (isset($_SESSION['start_time']))

{

$elapsed_time = time() - $_SESSION['start_time'];

if ($elapsed_time >= $inactive)

{

session_destroy();

header("Location: $logout_redirect_url");

}

$_SESSION['start_time'] = time();

}

Arrays, Forms, PHP

Php Insert Form Array

February 22, 2014 Galaxy Internet Leave a comment

<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
    {
    $pdo = new PDO("mysql:host=localhost;dbname=demo", "root", "");
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $pdo->prepare("INSERT INTO mytable (field1, field2) VALUES (?,?)");

    for ($i = 0; $i < count($_POST['field1']); $i++)
        {
        $stmt->execute(array(
            $_POST['field1'][$i],
            $_POST['field2'][$i]
        ));
        }
    }
?>
<form method="post">
   <b>field1 1</b><br>
   <label>field1 <input type="text" name="field1[]"></label>
   <br>
   <label>field2 <input type="text" name="field2[]"></label>
   <br>
   <b>field1 2</b><br>
   <label>field1 <input type="text" name="field1[]"></label>
   <br>
   <label>field2 <input type="text" name="field2[]"></label>
   <input name="" type="submit" value="Submit">
</form>

<?php

if ($_SERVER['REQUEST_METHOD'] == 'POST')

{

$pdo = new PDO("mysql:host=localhost;dbname=demo", "root", "");

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $pdo->prepare("INSERT INTO mytable (field1, field2) VALUES (?,?)");

for ($i = 0; $i < count($_POST['field1']); $i++)

{

$stmt->execute(array(

$_POST['field1'][$i],

$_POST['field2'][$i]

));

}

<b>field1 1</b><br>

<label>field1 <input type="text" name="field1[]"></label>

<br>

<label>field2 <input type="text" name="field2[]"></label>

<br>

<b>field1 2</b><br>

<label>field1 <input type="text" name="field1[]"></label>

<br>

<label>field2 <input type="text" name="field2[]"></label>

</form>

CREATE TABLE `mytable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `field1` varchar(255) DEFAULT NULL,
  `field2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `mytable` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`field1` varchar(255) DEFAULT NULL,

`field2` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Freelance Php And Mysql Programming – Galaxy Internet

Category Archives: PHP

Php Recursive Directory Copy

Php Short Tags Regex

View Hidden Characters In Php

Php Form To CSV

How To Get Mysql Column Names

PHP List Files in Directory Excluding Index

PHP US State Dropdown Array

PHP Automatic Logout – Auto Logout

Php Insert Form Array

Expert Freelance Programming Services