Posts Tagged mysql

Fast PHP – effective optimisation and bottleneck detection

PHP is not the fastest language on earth. That honour probably goes to machine code. But like many high-level languages, PHP provides some handy abstractions, like named variables, hashmaps (associative arrays), a C-like syntax, object oriented capabilities, loose typing and so on – we trade processing speed for development ease.

So it’s quite a common problem that people find their large PHP web applications running quite slowly.

Here are some frequently encountered bottlenecks found in web applications generally, and PHP specifically:

Read the rest of this entry »

, , , , , , ,

13 Comments

Super Useful Web Dev Tools

OMG, it’s been a whole month since my last update.

I have draft posts about all kinds of Good Stuffâ„¢, but none are quite publishable yet. So today I’m just going to point you at a few great resources I use all the time while doing my web development magic:

Read the rest of this entry »

, , , , , , ,

5 Comments

Howard Yeend: UK Web Developer CV

Northampton UK / howard.yeend@gmail.com

Availability

Not currently seeking work. Sorry! (updated Mar 2013)

Read the rest of this entry »

, , , , , ,

No Comments

Setting up a WAMP Server by hand

This article will step through what you need to do get WAMP (Windows, Apache, mySQL, PHP) running on windows 2000, 98 or XP. (It might work with Vista, ME or 95, but I don’t promise anything)

By the end, you’ll have a versatile tool that will allow you to:

-host your own website (permanent internet connection preferable)
-learn a basic programming language (PHP)
-learn about relational databases (mySQL)
-learn about server config on the industry standard webserver (apache)

all without having to install a new operating system.

Read the rest of this entry »

, , , , , , , , ,

14 Comments

DB 2 SQL code

A PHP file that connects to a specified host and mySQL database, and generates the SQL queries needed to reconstruct the database. Very useful if you want to back up a database over the web, or simply to transfer a mySQL database to your local machine. Read the rest of this entry »

, , , ,

9 Comments

Free PHP Scripts / Web Projects

Various PHP projects of mine, with free GPL source code.

Mostly, these are small PHP/mySQL applications that provide an equally small piece of functionality. Source code is available under the GPL in most cases. Read the rest of this entry »

, , , , , ,

No Comments