|
|
PHP Programming
For Long Island and all of New York |
| |
We do some
of the best PHP programming on Long Island. For whole applications -
or the automation of smaller processes - we can help you with a data driven
web site. While we generally use MYSQL as the back end, we can link to most
any database you have.
If you don't know, PHP is the language of
choice for data driven websites. You may have heard of some of the sites
that use our favorite programming language for the web: Facebook.
Wikipedia. Yahoo. Flickr. Tumbler - to name a few. |
| You might be
surprised as to what you can do with this language. The classic use is to
bring data in from a backend source such as MYSQL or PostgreSQL or MongoDB
and merge it into a webpage. But we can also use PHP to send email, or write
data out to a text file. For programming in the modern world this is a
sophisticated language of wide use. For
example, we recently used PHP to read MongoDB files in the cloud from an
Mlab data source, and write this data into a MYSQL table. This was more
involved than we would have liked, due to the need to find and install the
current MongoDB driver for PHP in a Linux cloud server. This kind of systems
issue is a common source of challenge to programmers - and something we're
good at. If you poke around this site you'll see we not only program, but we
build computers, install operating systems and can deal with a whole variety
of systems issues.
|
| Some of our web work:
www.closepizza.com uses PHP code to
link to Google maps. Here we also use PHP to gather prices, store it in a MYSQL file and to display this data as geo
located "push pins" on a map. This system also uses a custom user
management system and data grids - which lowered the cost of the project. On a more complex
scale we use PHP to code a
complete application - a CD trading site - that's "CD" as in
"money" Think you need frameworks or
Javascript to make working PHP CRUD apps or dashboards? Here's a rough but
working start of a DB program made from just HTML, PHP and MYSQL:
http://50.56.87.26/php/mysqli4a.php |
|
| One of the nice things
about PHP is that it's free, and you can get it
here |
| Note (among many other
things I might say about PHP) is that to get it to work you'll have to
adjust your Apache configuration. Just another thing about it we're very
good at. |
|
| But of course you may want to use
JavaScript too |
|
We sometimes get the feeling that many folks think you can't
do anything very modern or interesting outside of a web page with PHP, but if
MongoDB helps defines "modern" (and it does, at least in part) then this bit of
our code might changes some minds - <?php
// no need to pretty it up for the web :>)
$database = new MongoDB\Driver\Manager("mongodb://art:xxxxx8@ds1xxx02.mlab.com:6XXXX02/idletest");
$date1="2018-11-02";
$date1=new DateTime($date1);
$date1=new MongoDB\BSON\UTCDatetime($date1->getTimeStamp() *
1000);//Transforming into miliseconds
$date2="2019-06-01";
$date2=new DateTime($date2);
$date2=new MongoDB\BSON\UTCDatetime($date2->getTimeStamp() * 1000);//
//Transforming second date into ms
//Prepare the array to select time from $date1 to $date2 from mongo db
echo "date 1 ". $date1 ;echo"<br>";
echo "date 2 ". $date2;
$array=array("date"=>array(
"\$gte"=>$date1,
"\$lte"=>$date2 ));
$query=new MongoDB\Driver\Query($array);// Preparing the query
$rows=$database->executeQuery("idlesave.logsbackup",$query);// Getting the data into
//object $rows
// NOW WHE HAVE TO PRINT THE DATE`s THAT WE FOUND IN THE INTERVAL FROM THE
//COLLECTIONS
foreach($rows as $k=>$v){// each object $v represents objects from one row
foreach($v as $key=>$value){// each object from one row
if($key=="date"){// "date" is the index time from collection
foreach($value as $t=>$time){// $value is an object and
//it needs an foreach "[milliseconds]->time"
$time=$time / 1000; //transform from ms into
//seconds
}
echo date("Y-m-d",(int)$time);//finally we are
//echoing the time in YEAR-MONTH-DAY
echo "<br>";
}
}
}
?>
|
|
|
