hockey_goalie31 asked:


I have a mysql database that receives the data from a php form that submits a unique user id, and 3 sports. I will likely be adding new fields (age etc) but the main thing I want to accomplish is if my users go through the form again (logged into to the same user id) and submit different information, how could I overwrite the old entry so I only have 1 record for the user?

hopefully this is possible one way or another !

Kamal asked:


Here are the best open source scripts that are top rated by users.They are categorized into different category as CMS(Content management system) or called as portals,Blogs,ecommerce,groupware,forums,elearning,image galleries,wiki and many more.

We have produced the 3 top ranked listing in each category.You can see more in http://www.solidscripts.com or http://www.opensourcecms.com/.

Content Management System (CMS)

Drupal

Drupal is software that allows an individual or a community of users to easily publish, manage and organize a great variety of content on a website. Tens of thousands of people and organizations have used Drupal to set up scores of different kinds of web sites. Drupal is open source software licensed under the GPL, and is maintained and developed by a community of thousands of users and developers.

Url – http://www.drupal.org/

Joomla

Joomla! is one of the most powerful Open Source Content Management Systems on the planet. It is used all over the world for everything from simple websites to complex corporate applications. Joomla! is easy to install, simple to manage, and reliable.

url - http://www.joomla.org/

Typo3

TYPO3 has to be one of the best CMS programs I have ever worked with. While reading reviews on it I came across the people who didn’t like it. Yes, TYPO3 might take some reading, its not your standard program, also NO TYPO3 IS NOT FOR BEGINNERS. You should know about programming before attempting this software, there is a release for beginners, but it’s not the best. I really reccommend this for advanced users!

Url - http://www.typo3.org/

Blogs

WordPress

WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability. What a mouthful. WordPress is both free and priceless at the same time.

More simply, WordPress is what you use when you want to work with your blogging software, not fight it.

Url - http://www.wordpress.org/

Textpattern

A free, flexible, elegant, easy-to-use content management system for all kinds of websites, even weblogs.

Built into Textpattern is Textile, a simple syntax for nudging plain text into structurally sound and stylistically rich web content. Ordinarily fussy text amendments such as headers, hyperlinks, image tags and tables are created with one or two simple markers. Compared to navigating the tag soup of markup, writing and revising with Textile is much more intuitive, being closer to working with ordinary text. Once you’re ready to publish, copy marked up with Textile is automatically converted to valid XHTML, and because Textpattern stores both versions of each article, revising and updating is a snap. When composing or readying articles for publication in Textpattern, you can switch between three views of the article:plain text, XHTML (the code with which a web browser renders the article), and a rendered preview.

Sites published with Textpattern can employ unlimited registered contributors, each of whom may be assigned privileges by the publisher of the site. Five levels of privileges (publisher, managing editor, copy editor, writer and designer) are provided, and each reflects different access to article creation, approval, editing and deletion, and to image uploads, page design and CSS, and of course adding more contributors.

Installing and managing plugins that extend Textpattern’s abilities is straightforward. Once installed, plugins can be turned on and off from within the Textpattern interface, where detailed help and access to parameters used by plugins is also available.

Url - http://www.textpattern.com/

b2evolution

b2evolution is probably the most comprehensive blog engine you can find! It includes almost any feature you could expect from a blog tool, and more. Plus, it’s free, it’s open-source (GPL), it runs virtually anywhere (PHP/mySQL) and it’s available in many languages!

Url - http://www.b2evolution.net/

E-Commerce

osCommerce

osCommerce is the leading Open Source online shop e-commerce solution that is available for free under the GNU General Public License. It features a rich set of out-of-the-box online shopping cart functionality that allows store owners to setup, run, and maintain their online stores with minimum effort and with no costs, license fees, or limitations involved.

The goal of the osCommerce project is to continually evolve by attracting a community that supports the ongoing development of the project at its core level and extensively through contributions to provide additional functionality to the already existing rich feature set.

Everything you need to get started in selling physical and digital goods over the internet, from the Catalog frontend that is presented to your customers, to the Administration Tool backend that completely handles your products, customers, orders, and online store data.

Url - http://www.oscommerce.com/

Zen Cart

Zen Cart truly is the art of e-commerce; a free, user-friendly, open source shopping cart system. The software is being developed by group of like-minded shop owners, programmers, designers, and consultants that think e-commerce could be and should be done differently. Some solutions seem to be complicated programming exercises instead of responding to users’ needs, Zen Cart puts the merchant’s and shopper’s requirements first. Similarly, other programs are nearly impossible to install and use without an IT degree, Zen Cart can be installed and set-up by anyone with the most basic computer skills. Others are so expensive … not Zen Cart it’s FREE!

Zen Cart will deliver the ultimate online shopping experience to your customers. Navigating through your merchandise offerings is a breeze with Zen Cart, the program provides several “Spotlight” lists in addition to the traditional category to product links. Once a product is added to the shopping cart, secure checkout is a simple 3-step process. After providing the billing information, your customer chooses the shipping method. (multiple shipping methods including real-time internet shipping quotes are built-in) Next, a payment type is chosen from one of the popular payment modules. (PayPal and AuthorizeNet are just 2 of the included modules) Last, the customer reviews the order, shipping and payment choices, and confirms the order. You are immediately notified of the order and your customer automatically receives an e-mail confirmation.

Zen Cart gives web designers a robust and customizable electronic storefront that’s easy to keep up-to-date with new features. It provides usable, intuitive and unobtrusive purchase flows right out of the box based on proven industry best-practices - there are no major revisions required to get things right for your clients!

One of the secrets behind its power lies in our robust template system that “abstracts” the look-and-feel from the code and logic behind Zen Cart. This enables you to give clients a truly custom solution that integrates quickly and perfectly with their existing marketing websites.

Url - http://www.zen-cart.com/

phpShop

phpShop is a shopping cart application. The goal of the phpShop development team is to provide a stable web application platform that allows for additional development.

phpShop has been used by hundreds of web sites for selling online.

Url - http://www.phpshop.org/

Forums

PhpBB

phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. Based on the powerful PHP server language and your choice of MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers, phpBB is the ideal free community solution for all web sites.

Url - http://www.phpbb.com/

PunBB

PunBB is a fast and lightweight PHP-powered discussion board. It is released under the GNU General Public License. Its primary goals are to be faster, smaller and less graphically intensive as compared to other discussion boards. PunBB has fewer features than many other discussion boards, but is generally faster and outputs smaller, semantically correct XHTML-compliant pages.

Url - http://www.punbb.org/

SMF

Elegant. Effective. Powerful. Free. SMF is all of the above. SMF is a next-generation community software package and is jam-packed with features, while at the same time having a minimal impact on resources. And, yes, it is free.

Url - http://www.simplemachines.org/

Image Galleries

Coppermine

Coppermine Photo Gallery is a picture gallery script. Users can upload pictures with a web browser or Windows XP Web Publishing Wizard (thumbnails are created on the fly), add comments, send e-cards, rate pictures and have their own gallery. The admin can manage albums/pictures/comments and batch add pictures that have been uploaded by FTP. The script has a theme system and is available in the following languages : Bosnian, Chinese (traditional and simplified), Czech, Danish, Dutch, English, Finnish, French, German, Greek, Italian, Japanese, Norwegian, Polish, Portuguese (standard and Brazilian), Russian and Spanish. The script use PHP, a MySQL database and the GD library (version 1.x or 2.x) or ImageMagick to make the thumbnails. An install script makes the installation very fast and easy.

Url - http://coppermine.sourceforge.net/

Gallery

Gallery is a web based software product that lets you manage your photos on your own website. You must have your own website with PHP support in order to install and use it. With Gallery you can easily create and maintain albums of photos via an intuitive interface. Photo management includes automatic thumbnail creation, image resizing, rotation, ordering, captioning, searching and more. Albums can have read, write and caption permissions per individual authenticated user for an additional level of privacy. Give accounts to your friends and family and let them upload and manage their own photos on your website!

Url - http://gallery.menalto.com/

Plogger

Plogger is the next generation in open-source photo gallery systems. A web application not bloated with superfluous features or complicated configuration settings. Plogger is a simple yet powerful tool — everything you need to share your images with the world. Plogger is your photos integrated into your website, a fully featured photo sharing package with an attractive and easy to use administrative interface that makes managing your galleries a breeze. Integrating our gallery software into your website is as easy as inserting three lines of PHP code.

Url - http://plogger.org/

Ricardo D Argence asked:


The most important task of any system administrator is backing up the systems they are responsible for. Not putting the system up, not keeping it running, backing it up and being able to restore is primary.

A system with no backup cannot be relied upon for any real purpose, because if anything goes wrong your data is gone.

Something always goes wrong eventually, and without good backups all of your work, and possible your entire business is just plain gone.

A good backup strategy is composed of backup, storage, verification, and restoration. The backup component covers selection of method and which data to backup (all of it by choice).

Storage covers both what media you back up onto as well as where you keep them (if your building burns down, tapes kept in the server room will be useless).

Verification is a crucial component of a backup strategy, you have to know you have usable data.

Lastly, you need to be able to get the data back to where it can be used.

There are two main strategies for backups: Disaster Recovery and Archival.

DR backups are designed to restore a system to a working state. To do this you backup the entire system so that you can restore it onto another machine to get a working system.

An archival strategy is concerned with retrieving historical data (’give me the customer database as it appeared at the end of last year’) and not with restoring a working system.

Both strategies can, and probably should, be combined. An archival-only strategy requires the system administrators to reinstall and reconfigure the operating system prior to restoring the data; this takes longer and is more error prone.

Any backup strategy must be tested.

A DR backup is tested by restoring a system backup onto a fresh system to make sure you can recover from an emergency.

Archival strategies are tested by retrieving files and verifying that you can find the files you need and that they are readable once restored. An untested backup strategy is usually a complete waste of time and money.

For web hosting clients, you will usually do your backups with the cPanel administrative interface.

cPanel will let you backup your entire hosted site, your databases, or your home directory (which will contain your website but not the data behind it).

To perform a backup you simply access the Backup control panel and select a type of backup. The system performs the backup and downloads the file to your local system.

These backups can be restored through the same interface.

To test, you would create a new hosted site and restore your backups to it.

The downloaded backup files are important (possibly confidential) data and should be integrated into your local backup strategy.

At the least, burn them to disks if you can’t arrange to include them in your main backups.

TS2 asked:


Looking for a hosting service for under $20.00 a year, a large bandwidth, and at least 1GB of space.
Needs to have cPanel, be compatible with PHP, CGI, HTACCESS, and have a MySQL Database.

Markus Fernandez asked:


Web site hosting, MySQL and PHP development are like two sides of the same coin. They work in tandem to create dynamic and comprehensive web sites. Having MySQL and PHP programs for our website shall always give a competitive edge to our business. Since, the massive range of flexibility offered by these programming languages assists in achieving our prerequisite business goals.

Therefore, creating targeted website for promoting business online is a must for all corporate entities. Some of the pertinent questions that come to our mind while structuring the site are:

• The kind of information that should be uploaded in the website?

• Whether the website is in need of regular updates and the frequency?

• If the site requires shopping cart solutions as a tool for e-commerce?

• If there is a need for a database?

• The approx. budget?

If we are looking for long term advantages from php mysql development programming language, integrating PHP and MySQL in the project shall give the website different kind of impetus. With php mysql web development, the open source code developed by the system analyst enables achievement the of project goals with little effort. The usage of these programming languages also ensures the future up gradation and storage of content in database for software application venture.

Pre Defined Functions- Php and mysql web development in general is capable of many simple functions such as date functions, file manipulation, mathematics, and logic. But on the other hand php mysql web development doesn’t expand its credentials over database driven web applications. Basically, with the help from MySQL library the integration of database in to our project is made hassle- free through these applications.

Characteristics Of MySQL and PHP Programs- If you’ve decided to automate your web site, and are not aware of the know- how, then php mysql development is the solution to your problem. In PHP, the actual coding is easily available and that too for free for the public. Since, by nature PHP is open source, therefore there is a large community of programmers who can always assist each other with code. Thus the system analysts can now use codes or functions that have been already applied, rather than reinventing them. This can dramatically cut down production time.

Why php and mysql web development? - In short, php and mysql web development is flexible, cheaper and community generation oriented. Whether we are an entrepreneur starting a website business or just a website programmer looking for quality website hosting services, it is advisable to gather considerable knowledge about php mysql web development to ensure smooth online launch of products and services.