Web-Based Multiple MySQL Manager – AeroSQL

AeroSQL is an open source web application, for managing MySQL databases.

It can control databases from different servers in a single, desktop-like interface where records can be easily browsed or edited within a grid.

AeroSQL

The application displays every query executed & can run a batch of sql queries to save you time.

It is possible to select the columns to be displayed while editing a table which will help reaching the data in an organized way.

AeroSQL is built with PHP & uses ExtJS to provide the desktop-like functionality.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags: ,

Related posts

Getting Started with CodeIgniter and How to Create All Those Great Apps

Choosing a good PHP frameworks can help you develop complex Rich Internet Applications quickly, with a best practices oriented approach, and saving a lot of time reusing code snippets that are already available. There are a lot of interesting PHP frameworks you can choose for your next web project. Today we will focus on one of my favorite PHP Frameworks: CodeIgniter.
CodeIgniter is a powerful, high-performance, open-source PHP framework that helps you author PHP applications rapidly. CodeIgniter is known for having a light footprint, there by reducing your server’s work.

CodeIgniter has an exciting online manual, a couple of helpful video tutorials and an active user forum.

In today’s post will attempt to show you the basics of setting up the CodeIgniter framework, including step by step tutorials showing you how to build awesome applications that uses the MVC approach the easy way.

Get started with CodeIgniter

1. Why CodeIgniter?

The simplicity of setting things up and getting an actual webpage that processes something online is quite easy. CodeIgniter uses the MVC or Model View Controller architectural pattern. MVC is a software approach that separates application logic from presentation. In practice, it permits your web pages to contain minimal scripting since the presentation is separate from the PHP scripting.

CodeIgniter has probably the best definition of each the model, view, and controller.

  • - The Model represents your data structures. Typically your model classes will contain functions that help you retrieve, insert, and update information in your your database.
  • - The View is the information that is being presented to a user.
  • - The Controller serves as an intermediary between the Model, the View, and any other resources needed to process the HTTP request and generate a web page. The controller is the top level file for each page that allows you to include database requests in the form of ‘Models’ and templates as ‘Views’.

By using this practice your code is tidy and re-usable.

Get started with CodeIgniter

Source: Get started with CodeIgniter

2. Installing and Configuring CodeIgniter

First you need to download CodeIgniter from http://www.codeigniter.com/.

  • 1. Unzip the package.
  • 2. Rename the “CodeIgniter” folder to your application name “app”. Upload the CodeIgniter folders and files to your PHP and MySQL enabled server. Normally the index.php file will be at your root.
  • 3. Open the application/config/config.php file with a text editor and set your base URL.
    $config['base_url'] = "http://localhost/app/";
    
  • 4. If you intend to use a database, open the application/config/database.php file with a text editor and set your database settings.
    $db['default']['hostname'] = "localhost";
    $db['default']['username'] = "root";
    $db['default']['password'] = "root";
    $db['default']['database'] = "helloworld";
    $db['default']['dbdriver'] = "mysql";
    

    This code connects to a MySQL database called “helloworld” on a localhost with the username “root”, and the password, “root”.

Please visit this tutorial to show you the basics of setting up the framework, including how to build a basic hello world application that uses the MVC approach.

Source: Everything You Need to Get Started With CodeIgniter

3. Building Your First CodeIgniter Application

Creating web applications with CodeIgniter (CI) is quick and easy because CI handles a lot of the typical application requirements right out of the box (like session management, database abstraction and file uploading). And while CodeIgniter does handle the repetitive stuff it’s still up to you to create a scalable and easy to update application.
You will need to check the following Step By Step Tutorial to learn how to create your first CI application:

4. How to Create Awesome Applications Built with CodeIgniter

4.1 Build an RSS 2.0 Feed with CodeIgniter

In this tutorial, we will learn how to build a RSS 2.0 Feed with the PHP framework CodeIgniter.

Build an RSS 2.0 Feed with CodeIgniter

4.2 Generating PDF files using CodeIgniter

In this tutorial, we will learn how to generate PDF files with CodeIgniter and the R&OS library..

4.3 Building a Shopping Cart using CodeIgniter’s Shopping Cart Class

This tutorial will cover the new “Shopping Cart” Class. The Cart Class permits items to be added to a session that stays active while a user is browsing your site. These items can be retrieved and displayed in a standard “shopping cart” format, allowing the user to update the quantity or remove items from the cart.

Building a Shopping Cart using CodeIgniter's Shopping Cart Class

4.4 CodeIgniter Clan Site- Part1 & Part2

In this series of tutorials we’ll be learning how to create a multi-gaming clan website with support for many different games, forums and a full admin system.

CodeIgniter Clan Site

4.5 Validating Web Forms with the Code Igniter

How to use the validation class included with this framework to develop a PHP program that can be used to check data submitted through some web forms.

4.6 A sample Facebook application with CodeIgniter

A sample Facebook application with CodeIgniter.

4.7 CodeIgniter and Ajax Using JQuery Tutorial

This tutorial is about creating simple CodeIgniter + database + ajax system. User will be shown a form to post a message. Then after he/she press the submit button, the system will save the message using ajax and then show the message.

CodeIgniter and Ajax Using JQuery Tutorial

4.8 Real Live Search with Pagination

In this tutorial, we will learn how to create a search page with CodeIgniter and jQuery. We’re not gonna create only a default search page using CodeIgniter framework, but also a real time search with jQuery’s support.

Real Live Search with Pagination

4.9 How to Update your Twitter Status with CodeIgniter

This article demonstrates how to update our twitter status via the ‘Twitter API’ using CodeIgniter.

How to Update your Twitter Status with CodeIgniter

4.10 Codeigniter Event Calendar

This post demonstrates how to create Codeigniter Event Calendar. When you click the date where there are events, it will take you to a page showing all the event for that day. So you can use it with javascript disabled.

Codeigniter Event Calendar update

4.11 Live search with CodeIgniter and Mootools

This article demonstrates how to create a live search application (an AJAX based application that returns search results as you type) with CodeIgniter and Mootools JSON. The application is build using JavaScript in non obtrusive ways, so it will function in just about any browser, even if they don’t support JavaScript at all.

Real Live Search

4.12 Creating a File Hosting Site with CodeIgniter

This tutorial will show you how to build a powerful web application for hosting images, using the flexibility of Codeigniter. This tutorial should teach you about the MVC coding philosophy, integral to producing serviceable applications.

Creating a File Hosting Site with CodeIgniter

5. Further Resources

Author: Noura Yehia

Noura Yehia is a Web Designer, Blogger and Creative Thinker. Founder of Noupe.com a popular blog about web design, tutorials, resources and inspiration. If you’d like to connect with her, you can follow her on Twitter or at her blog Devsnippets.

Open Source Trouble Ticket System: OTRS

OTRS is an open source trouble ticket system for easily managing support requests in a multi-agent interface.

The application can auto-convert e-mails into tickets (e-mail piping) which "eliminates the need of using the web interface" for customers.

OTRS Support Ticket System

OTRS is used by large organizations like Opera, MySQL AB, BitDefender, Suse & has very nice features like:

  • transfer of tickets between agents
  • auto-calculation of hours worked on a ticket
  • powerful reporting
  • canned responses
  • multilanguage support
  • themable web interface
  • role-based user management
  • & much more..

OTRS is built with Perl & can work with different databases (e. g. MySQL, PostgeSQL, Oracle, DB2 and MSSQL).

It has one-click installers for multiple operating systems (including Windows).

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags: , , , ,

Related posts

Impressive jQuery Image Viewer: YoxView

YoxView is a highly-customizable jQuery image viewer plugin (Lightbox) for displaying single-to-multiple images.

It helps browsing a list of images in a modal box with previous-next buttons or as a slideshow.

The viewer supports displaying multiple instances in a page where each of them can be configured independently.

jQuery VoxView

YoxView is multilingual & already comes with multiple language files.

Besides standard navigation, images can be navigated with keyboard too.

The plugin has many options like opacity levels, background colors, title display/fade durations & more.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags: ,

Related posts

Beautiful And Free Textures: TexturePalace

TexturePalace is a website which shares 200+ premium-but-free textures that we can use to decorate our designs.

All textures are converted from camera RAW data where the picture size is 3400px*2400px (or more).

The textures are well categorized like ground, nature, grunge, metal, etc. & they are free to be used in both personal or commercial projects.

TexturePalace

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags:

Related posts

A Set Of 60 High-Quality Icons: NIXUS

NIXUS is a free icon set that has 60 high-quality icons which includes actions, charts, devices & more.

The set is suitable to be used in both web applications & designing stuff like banners or buttons considering the detail it provides.

It comes in .PNG format with 3 sizes: 32*32px, 48*48px & 64*64px.

NIXUS is totally free to be used in both free & commercial projects.

NIXUS Icon Set

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags:

Related posts

Uptime Robot Gets Keyword Checking & RSS Alerts

Uptime Robot LogoUptime Robot, a free website uptime monitor service, that was built by me & Daniel Rimille of SSLmatic few weeks ago has some fresh features.

But before that, thanks very much to everyone who supports the service by using it, sending us suggestions, tweeting, etc.

Uptime Robot has added 2 new features today:

  • keyword checking
  • uptime alerts via RSS

which will enable you to monitor your websites in a more flexible way.

Uptime Robot

Keyword Checking

Now you can set Uptime Robot to check if your website contains (or doesn't contain) a keyword you define.

It is possible to find many creative uses of this feature like:

  • finding out if there is a database connection problem (set the keyword that your website displays when a db problem occurs)
  • detect if a module of your website word or not by setting a keyword from that module (like the calendar in a webpage)
  • & much more..

RSS Alerts

Well, RSS alerts is nothing creative. The service instantly updates your special feed when there is an alert.

But, it is now possible build desktop notifiers & more using these feed URLs.

P.S. Announcing every new feature from WRD is definitely not the plan. However, it can be a good idea to share milestones considering most WRD readers are already users of Uptime Robot.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags:

Related posts

Tiny CSS Framework For Rapid Layouts: EZ-CSS

EZ-CSS is a lightweight (only 1kb) CSS framework for easily creating table-less layouts.

The framework enables you to create multiple columns of any width, with or without gutters of any width.

EZ-CSS Framework

EZ-CSS is very flexible:

  • each module or layout contains a width-less container which prevents rounding issues or rounding errors.
  • it creates self-clearing containers which means every box will contain floats.

As EZ-CSS has a very small footprint, it can be fully inserted into any stylesheet or a style element which would make it compatible with every other CSS framework too.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags:

Related posts

A Practical In-Context CMS: Apostrophe

Apostrophe is an open source CMS that enables you to manage websites while browsing them.

It has an ergonomic interface & has a minimal learning curve where anyone which is not familiar with CMS systems can easily use too.

Apostrophe CMS

The application can have multiple users with permission-based levels.

Images, videos & any other media can be managed quickly, new pages can be created or new "slots" can be inserted between other slots (like adding an image gallery under a paragraph).

Apostrophe can display the history (past revisions) of every content edited.

It is built with PHP (actually, it is a plugin for the Symfony framework) & requires MySQL for storing data.

Special Downloads:
Ajaxed Add-To-Basket Scenarios With jQuery And PHP
Free Admin Template For Web Applications
jQuery Dynamic Drag’n Drop
ScheduledTweets

Advertisements:
SSLmatic – Cheap SSL Certificates (from $19.99/year)
Follow WebResourcesDepot At Twitter And Get More Resources!

Tags: , ,

Related posts

WordPress On The Go

I like to moderate comments when I’m waiting for something: a checkout clerk to help me, the dentist to call me back to the office, a soy chai to be made. I don’t lug my laptop everywhere I go,* so I love it that we have mobile apps that make this possible. I don’t know of any other blogging platform that has mobile apps for iPhone, Android and Blackberry. Do you?

The iPhone app is up to version 2.2 (note that iPhone app version numbers do not correlate to WordPress core versions, due to separate dev cycles), while the Android and Blackberry apps are brand new. You can write posts (save drafts or publish right away), moderate comments, blog photos from your phone (and video on Blackberry!**), and more. Check out the glory that is mobile WordPress in the image below:

Screenshot of WordPress mobile apps

“But what about my Nokia,” you ask? Raanan Bar-Cohen, who oversees the mobile projects, recently announced:

“We are very excited to share with all of you that in the coming weeks we’ll be opening up a beta test for the official Open Source WordPress for Nokia app. For developers who are interested in getting involved, we just opened up a dev blog with details, links to the source code and trac tickets, and an early alpha build. We’ll be leveraging the Qt framework which means will be able to support both the S60 and Maemo platforms.”

W00t!

Getting Involved

All of these mobile WordPress apps are free and open source. They are developed in the same manner as WordPress core, which means anyone can contribute! If you’ve got some mad mobile development skills and want to get involved, a) you’re awesome, and b) here are a bunch of useful links.

Development Blogs: Android | BlackBerry | iPhone

Development Tracs: Android | Blackberry | iPhone

Feedback Forums: Android | BlackBerry | iPhone

Language Support: WordPress users come from all over the world. The mobile apps here are available in multiple languages but need volunteers to enable even more people to use them. If you’re interested in helping localize these mobile apps, you can get involved by visiting translate.wordpress.org.

Getting the Apps

So go for it — download the app for your platform of choice and soon you, too, can be live posting about how slow the cashier is while you wait for him to ring you up!

* Okay, yes, I do bring my laptop everywhere, but I leave it in the bag on these occasions.

** Video support should  be coming soon to the iPhone and Android apps.