Posted by W3Avenue Team on Mar 10, 2010 in
Javascript,
MySql,
PHP,
Silver Light |
View Original Article PHP News System (phpns) is an open source CMS that enables you to embed dynamic content into an existing website. It allows you to design your website however you like, and squeezes content into your design, wherever you like, with one line of code. PHP News System requires PHP, MySQL and ability to change file permissions on the server.
Setting up phpns is fairly simple with the help of built-in web based installer. The administration area provides you ability to create and manage articles, create categories, manage templates, create users, ban users, etc. Embedding your dynamic content into website is simply a matter of including a PHP file.
Features
- Web design freedom
- Users management
- Search engine friendly URLs
- Freeze/cache management
- WYSIWYG editor
- Theme management
- Database backup/restore
Developed by Alec Henriksen; PHP News System (phpns) is available for download under GNU General Public License. You can find further information, documentation, demo & download on PHP News System Website.
Similar Posts:
You can also stay updated by following us on Twitter, becoming a fan on Facebook or by subscribing to our FriendFeed.
Tags: Alec Henriksen, Application Packaging, CMS, GNU GPL, Software, Virtualization
Posted by W3Avenue Team on Mar 7, 2010 in
Javascript,
MySql,
PHP,
Silver Light |
View Original Article jCore is an open source Content Management System (CMS) build using PHP and MySQL. It can power multiple websites, enabling you to keep CMS software up to date and fix bugs for all websites from a single location.
jCore has two main systems, jCore Server – which holds all the libraries and modules, and jCore Client – which is the stripped version of the core system that install with each website. You don’t really need to install jCore server, just copy the files in a public place so that all you websites can access it.
jCore allows designers to easily create custom look & feel of their website by simply adding new blocks (DIVs) from the admin area and apply any style (CSS) or script (jQuery). The developer on the other hand can easily create new Modules to extend the site’s functionality.
Features
- Custom Look & Feel with CSS/JavaScript
- Multilanguage Support
- Multiple Menus
- Manage your site’s content with a WYSIWYG editor and attach files/pictures to them
- Create submit forms with custom fields and store or send values trough email
- Extend your site with new functionality like Photo Gallery or a File sharing module and so on
- Include posts, modules, blocks, forms and other are of your site in your posts/blocks contents
- Keep your readers up to date with RSS feeds
- Easily place ad codes / banners on your site and earn money
- Manage your site members or send out mass emails to let them know about news
- SEO Friendly Links
- Custom 404 Error Page
Developed by Istvan Petres; jCore is available for download under GNU General Public License. You can find further information, demo & download on jCore Website.
Similar Posts:
You can also stay updated by following us on Twitter, becoming a fan on Facebook or by subscribing to our FriendFeed.
Tags: Application Packaging, CMS, GNU GPL, Istvan Petres, LAMP, Software, Virtualization
Posted by Saud Khan on Dec 2, 2009 in
Javascript,
MySql |
View Original Article Whether you are developing desktop software or web based application, there is a pretty good chance you will consider MySQL for data storage. Due to its popularity and open source business model, numerous tools and utilities are available that will help you easily design and manage your MySQL databases.
W3Avenue has compiled a list of really useful free tools and utilities for MySQL that will enable you design and manage your databases of various scope and complexity.
Cross Platform
- MySQL GUI Tools
The MySQL GUI Tools is a set of cross platform tools that include: MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
- MySQL Workbench
MySQL Workbench is a cross platform GUI product for the MySQL Server that can be used to write and execute SQL queries and scripts, edit data, visually design database models and manage the MySQL Server.
- MySQL Control Center
MySQL Control Center is a GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI, stored login credentials, point and click dump file imports and more.
- Lita
Lita is a free SQLite database administration tool for Windows, MacOSX and Linux.
- SQuirreL SQL
SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
Mac OS X
- Sequel Pro
Sequel Pro is fast, easy to use Mac OS X database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote servers.
- YourSQL
YourSQL is intended to be easy to use for the beginner as well as the advanced user. It provides access to advanced features of MySQL, such as indices, InnoDB tables, multi-statement SQL scripts and multi-threaded handling of SQL dumps for backups or similar administration tasks.
Windows
- HeidiSQL
HeidiSQL is an easy to use MySQL management client for Windows. It allows you to synchronize tables between two databases; manage user-privileges; import / export; browse and edit table-data using a comfortable grid; create and edit stored procedures; and lot more. You can also run HeidiSQL on Linux with Wine.
- Toad for MySQL
Toad for MySQL is database development and administration tool that enables: query development, database design, database administration, data management, reporting, project management and automation.
- MyDB Studio
MyDB Studio is a collection of powerful tools for MySQL Server administration. It also supports SSH tunneling to secure your connections enabling you to connect even if your host doesn’t allow you remote access connection.
Web Based
- phpMyAdmin
phpMyAdmin is one of the most popular web based MySQL administration tool written in PHP. It supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
- MySQL Sidu
Sidu (Select, Insert, Delete, Update) is a web based MySQL client with easy to use GUI. In addition to standard MySQL administration you can use Sidu to sorts data in two columns; secures your data with multiple firewalls; manage accesses easily; filter and sort tables to export.
- VFront
VFront is a dynamic front-end for MySQL or PostgreSQL databases written in PHP and Javascript. With VFront you can create forms for manage your data in AJAX style, different rules and privileges for groups, report in XML,HTML,PDF,statistics and much more.
- SQL Buddy
SQL Buddy is an open source web based MySQL administration tool developed using PHP. Just unzip the files to your server and its ready to use. Logins are handled directly by MySQL, and you can create as many or as few users as you want.
- MySQL Ajax Table Editor
This is a free open source application (PHP4 & PHP5 compatible) that allows you to quickly create database admin pages and manage MySQL tables. Its MySQL editor has the ability to join on multiple tables and maintain search functionality and is written with AJAX.
- Adminer
Adminer is a full-featured MySQL management tool written in PHP. It consist of only a single file ready to deploy to the target server. Supports both PHP 4.3+ and PHP 5 with sessions enabled.
- MySql Lite Administrator
MySql Lite Administrator is a PHP based web application that will help you insert and update data in your MySQL Database.
- AeroSQL
AeroSQL is an open source web based tool for managing MySql. The key feature of AeroSQL is intuitive management of the database content.
- MySQLDumper
MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and – if needed – restore it. It is especially suited for shared web hosting, where you don’t have shell access.
- phpMyBackupPro
phpMyBackup Pro is a very easy to use, PHP based MySQL backup application. It allows you to create schedule, manage, restore, download or email database backups.
- WWW SQL Designer
WWW SQL Designer is a web based visual SQL modeling tool that allows you to draw E-R designs, edit tables and rows, manage keys, create relations (FK constraints), save & load designs and import DB schemas.
Cheet Sheets
Please feel free to suggest any addition, correction or updates in your comments. You may also be interested in reading following posts published on W3Avenue:
Similar Posts:
You can also stay updated by following us on Twitter, becoming a fan on Facebook or by subscribing to our FriendFeed.
Tags: free, Lists, Tools
Posted by W3Avenue Team on Oct 29, 2009 in
Database,
Javascript,
MySql,
PHP |
View Original Article UserCake is a simple user management system developed in PHP that provides you a foundation to build user applications without all the hassle. It is object oriented, cleanly written, well commented, formatted and documented for easy customization.
UserCake requires PHP5, MySQL or MySQLi to work. UserCake does not have a admin backend, it is merely a foundation to start building your application. It uses phpBB’s DBAL or Database Abstraction layer to support multiple DBMS.
Features
- Login
- Register
- Lost password
- Update password
- Update user details
- Email templates
- SHA1 security + Salt / Hash
- Account activation
- User groups
Developed by Adam Davis; UserCake is available under Creative Commons – Attribution 3.0 Unported License. You can find further information & download on UserCake Website.
Similar Posts:
You can also stay updated by following us on Twitter, becoming a fan on Facebook or by subscribing to our FriendFeed.
Tags: Adam Davis, CC License, Software
Posted by W3Avenue Team on Jul 16, 2009 in
Javascript,
MySql,
PHP |
View Original Article Open Atrium is an open source intranet package powered by Drupal that is easy to install and use, and since it is open source you can customize it to meet your exact needs. Open Atrium’s built in communication and collaboration features include a blog, a wiki, a calendar, a to do list, a shoutbox, and a dashboard to manage it all.
Open Atrium is completely customizable. If you want a feature that’s not on that list, you can add it yourself. Open Atriums allows new features to be added easily as a plugin to the basic package, enabling entire community to share and extend it.
Atrium has been tested with the following software successfully. Your mileage may vary on other configurations:
- PHP 5.2+
- PHP GD extension
- 64MB memory limit
- MySQL 5
- Apache with mod_rewrite
Developed by Development Seed; Most of Open Atrium’s source code falls under GPL v. 2 b, since it’s built on Drupal framework. All the code that’s not under GPL has a BSD license. You can find further information, demo & download on Open Atrium Website.
Tags: BSD, Development Seed, Drupal, GPL2, Intranet, Software
Posted by W3Avenue Team on Jun 24, 2009 in
Javascript,
MySql,
PHP |
View Original Article
Pligg is an open source Content Management System (CMS) that allows you to create a site where registered members can submit, publish and rank articles based on the quality of content. Since Pligg is based on open source PHP and MySQL technologies you can install it on most web hosts on a relatively small budget.
Tags: AGPL License, CMS, Miscellaneous, Open Source, Software
