Database | allphp.com

Archive for the ‘Database’ Category

SANIsoft Blog: The longer Lithium Blog tutorial using MySQL ‘” Part 1

15 Apr 2010 at 17:31

PHPDeveloper.org

On the SANIsoft blog there’s a recent post looking at using the Lithium framework with MySQL (the first part of a series).

Lithium is a lightweight, fast, flexible framework for PHP 5.3+. It is still in dev release state but is under active development. This post, as the title suggests, is to introduce you to this new framework using the typical blog tutorial.

They help you clone the latest version of the framework from github, update the default files to change the main page, set up some routing and connect to the database. They include the SQL to create a sample “posts” table and pull some data out of it. There’s also some code to help you add, edit and delete posts from the table with Lithium’s built-in database layer.

Create Simple Data Paging using PHP and MySQL

13 Apr 2010 at 01:59

Sony AK

Database, MySQL

4 Comments

Now we will cover about how to create simple data paging using PHP and MySQL. Sometimes you have to display large set of data on the web page. Using data paging, you can display your data page-by-page and you can define how many data should be displayed on each page. Let’s start our mission.
I assume [...]

Introduction to MySQL 5.5

13 Apr 2010 at 00:59

Latest Developer Updates from MySQL AB

MySQL, Uncategorized

1 Comment

It’s been a busy year for MySQL. Perhaps you’ve heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and give feedback to the MySQL engineering team.

Storing Images in MySQL Revisited

13 Mar 2010 at 00:00

PhpRiot Latest Articles

MySQL

Comments Off

By Quentin Zervaas. This article shows you how you can store images in MySQL using the Blob column type. I will show you to create a file upload form, then store the uploaded file in the database. The concepts covered in this article can apply to all files in general, not just images. This is an updated version of a similar article that already appears on PhpRiot.

The New MySQL Server Release Model

26 Jun 2009 at 01:00

Latest Developer Updates from MySQL AB

Database, MySQL

No Comment

When I joined MySQL back in June of 2005, one of the first “MySQL Truths” I learned and repeated often when discussing MySQL with others was “release early, release often.” If you’ve been using MySQL for any length of time, you know what that statement means – it meant that MySQL was: (1) dedicated to getting new features and enhancements into the hands of its community so the software’s quality could be validated; (2) eager to take early feedback on those features so the input could rapidly be incorporated back into the product allowing everyone to benefit; (3) committed to very frequent releases of the software so helpful new features and/or external contributions that were ready for action could quickly be put into play and not sit idle on the shelf. And if you’ve been around Open Source for a while now, you know this is the spirit in which most providers of Open Source software operate.

How to Install PHP on Windows

13 Apr 2009 at 09:03

Craig Buckler

Apache, MySQL

Comments Off

In his final installation tutorial, Craig provides a step-by-step guide to installing PHP5 as an Apache module in your Windows development environment.

How to Install PHP 5.3 on Windows

How to Install Apache Web Server on Windows

Running Apache on Windows

Eight Weeks of Prototype: Week 8, A Complete Prototype Example

30 May 2008 at 00:00

PhpRiot Latest Articles

AJAX/JavaScript, MySQL, Prototype

Comments Off

By Quentin Zervaas. So far in this series, “Eight Weeks of Prototype,” I have shown you some of the extensive features the Prototype JavaScript framework provides. In this, the final article of the series, I will bring many of these features together into a simple example.