Part 2: HTML, jQuery, PHP, and MySQL Basics for Creating a Web Application

In our previous post about how to store data in a data base and then query that data to display on an HTML page, we did not go over adding data from an HTML form and then refreshing the data that is displayed.  So today we are going to cover that since its an important part of creating a web application.

To get started, you can download our previous tutorials package and upload them onto your server.  You can then build out your database the same as we did in the first tutorial.

HTML, jQuery, PHP, and MySQL Basics for Creating a Web Application

This is a go-to stack of technologies for many web developers.  Whether your go-to is PHP, Python, Perl, or any of the other programming language, being able to store, update, and delete data in a database is essential.  You don’t need to be a database guru to create a database, create tables within, and put the data infrastructure to use in a web or desktop application.  Yes, in a corporate enterprise environment you are going to “phone a DBA” at times to optimize your web application by using database indexes in your query, but if you are a developer, or have the passion to become a developer, you should learn the basics.  For this session, I will be working on a CentOS server that has Apache, MySQL, PHP, and the PHP MySQL extension so that PHP can put MySQL to use.

Protect your Home Wireless Network from Hackers

 

When it comes to your home wireless network, you should often be aware of who is connected to it.

If a hacker gets onto your network, you risk having all your network traffic sniffed over the network by the hacker spoofing itself as the network router. This is called a MITM Man-in-the-middle attack and makes the attacker machine act as the router on the network for all the devices or a single victim machine.

iOS 7.1 Problems List Released and How to Fix Them

ios 7.1

Last week, the IOS 7.1 release was pushed to users with iPads, iPhones, and iPod touch. While it contained some useful features and functionality, it also came with a cost. Many users have started experienced less battery life since they have updated to IOS 7.1. BGR.com has recently published some methods to address the battery life issue with IOS 7.1.

Battery life is not the only issue and ZDNet has compiled a list of problems with IOS 7.1 for users to review. This list includes wifi and bluetooth connectivity issues, Apple Touch ID fingerprint scanner issues, and personal hotspot problems.

Is Apple missing something in the QA department that is causing updates to go out with problems? Or is Apple just deciding that battery life is not as important as the features they are rolling out? With the mass usage of iPhones and other Apple products, it doesn't speak very well for the software engineers and testers when such important things get overlooked in a release.

Phaser Javascript Game Tutorial Series – Flappy Bird – Getting Started

Screen Shot 2014-02-17 at 12.07.47 AMWelcome to my Phaser Javascript Game Tutorial. Phaser is a desktop and mobile html5 game framework created by Photon Storm Ltd. The framework makes it super simple to create 2D games in JavaScript with the canvas and WebGL libraries. With all the attention surrounding the popular game Flappy Bird, I decided to give Phaser framework a go by creating a Flappy Bird like game. For this example, we will call it.. FappyBird!

Anti-NSA Secure Smart Phone Called BlackPhone

blackphone

In a time where privacy is more of an idea than reality, security becomes a major focus for application developers, network engineers, system and database administrators.  Most importantly it becomes a hot and in-demand requirement for consumers of technology.  If you don’t already know, and I would be very surprised by someone not being aware with all the recent revelations, the NSA is above the law and can eavesdrop on phones, computers, tablets, and just about any device that utilizes network transmission without warrant or over-sight.

iFrame JavaScript + PNG MetaData Malware Injections Discovered

pnginfected

Researchers have discovered a method of injecting metadata malware onto users computers through an iFrame containing a obfuscated PNG image that has instructions in its metadata.  If you are not familiar with metadata, every picture has metadata.  You can find any photo on your computer, right click it, click properties, and in the properties you can view the metadata.

Peter Gramantik, a malware researcher at Securi, described his findings in a blog post Monday.

Inside the iFrame, there will be a JavaScript file included that will load in the PNG file.

Adobe Flash Player Emergency Update Issued by Adobe

adobe-flash-player-emergency-update

Adobe has issued an emergency warning to Adobe Flash Player users to update immediately.  A vulnerability has been found that allows hackers to remotely take control of systems running the outdated version.  A blog post was made by Adobe stated “Adobe is aware of reports that an exploit for this vulnerability exists in the wild, and recommends users apply the updates referenced in the security bulletin.”

The exploit is both vulnerable on Windows and Mac operating systems so make sure you update your Flash immediately!  Adobe has assigned a priority 1 severity to this vulnerability.

Dell to Layoff Thousands This Week

dell
Photo credit: Dell

The prestigious computer manufacturer Dell is expected to be laying off thousands of employees this week.  It is estimated that around 15,000 will be losing their jobs.

As often seen in corporate IT companies, Dell is performing a reorganization that will restructure its operations, cutting every department.  The market for personal computing has slumped and the mobile market is flourishing with Samsung, Google, and Apple dominating on top.

The business focus, per company founder Michael Dell, is to put efforts towards enterprise services like a cloud and/or mobile systems.

PlatyPus the MacOSX Compiler

Ever wanted to compile your Python script or software into a MacOSX .app?  I have tried Py2App and I never seemed to get it working properly.  It would not import the modules I used in my application so upon launching it would give immediate error on the first imported module.  I really wanted to compile my app for Mac as I had already successfully used Py2Exe to compile it for windows.