Scottie”T” asked:


If i just have my stand alone computer, how can i practice using MySQL and viewing the web pages?

nikki asked:


3 tables from oracle are to be copied to and merged in mysql. Can it be done manually? Also, is it possible to make a program to transfer the needed data from one database to the other?

Carbonbased Lifeform asked:


When a visitor fills out a form, I want to know when the form data was submitted. So how do I make MySQL automatically add a timestamp on the data so that when I pull the data back up, I will have the submitted data in one column and the time the data was submitted in another column?

Rodel Garcia asked:


So you have finally arrived at a stage where you to need to choose a web host to run your PHP & MySQL supported website. This means your website is dynamic, that is, it changes according to the feedback from your visitors or the data your MySQL database contains.

You may need PHP features in your web hosting for the following reasons:

[o] YOU NEED TO PROCESS THE WEB FORM USING php

Although there are numerous CGI scripts available (and many hosts provide these scripts for free), if you can, it is preferable to get your own script written to meet your specific requirements. The cgi scripts available at your web host are very generic in nature. If you have your own PHP script to handle your form, you can generate your own response when a visitor submits your form.

There are great many JavaScripts that can help you validate your forms, but these days many surfers prefer to disable scripts for the fearing on getting infected with worms and viruses. php script on the other hand a server-side script and nobody can stop them from running as long as the browser is loading the web page.

You can also send a customized “thank you” message to whoever submits the form. After sending the “thank you” message and emailing the form details to you, your customized php script can also save the submitted information in a php database.

[o] MANAGE PRODUCT CATALOGS WITH php & MySql DATABASE

You may like to generate your pages dynamically using data in your MySQL database. For example, if you want to maintain a catalog of 150 different wine bags, it would be arduous to maintain the details manually. Instead you can put information like price, shape, color, picture path, etc. in a database and then write a php page that, let us say, shows 10 wine bags at a time. The visitor thinks she’s visited 15 pages, but there is only one dynamic page that is sequentially showing the products.

Additionally, if you want your visitors to be able to conduct searches (just red wine bags) you can upload a php script to your web host that shows only the wine bags that satisfy the search criteria.

[o] PUBLISH A BLOG

You may need a PHP/MySQL web host if you are planning to publish a regular blog.

Most blogging software these days, such as MovableType and WordPress use php and MySql to generate dynamic content. In fact, WordPress has been purely written using PHP and MySql so that people well-versed with the php programming language can make their own changes.

[o] MANAGE AN E-COMMERCE WEBSITE

Choosing a php / MySql web host is a great way to go if you want to run an e-commerce website. E-commerce websites indisputably need dynamic capabilities such as updatable shopping carts and inventory management systems that can be developed using php and MySql.

As they say, when it comes to imagination and innovation, the sky is the limited. A PHP/MySQL web host empowers you to create as many web-enabled capabilities as you can think of.

ADVANTAGES OF CHOOSING A php / MySql WEB HOST

Advantages of opting for php & MySql web hosting are:

1. php websites, since they are run on Linux and Unix, are considered more secure compared to Windows supported languages such as ASP and .NET.

2. Lots of free php source code is available on the Internet. There are hundreds of forums that readily provide you assistance while you learn and develop websites in php.

3. Both php and MySql are free from License fees.

4. php & MySql web hosting is much cheaper than Windows supported hosting

5. Applications written in php are sturdier and easily scalable to various web hosting environments. Notably, php scripts can be run on Windows hosting but ASP and .NET apps do not work on Linux and Unix

quiksilver_army asked:


I am programming using a mySQL database running on my local machine, yet, it is a school project that needs to run on the school secure servers…. we have access to the MySQL commands in these machines, but no access to external machines, so I need a way to migrate all the data in my database to this other machine…. I am using a JSP/Java project using a Tomcat Apache server, in case that helps…I am currently writing a huge transaction to create the database, the tables and write all the data, but there ahs to be an easier way…. i have a lot of tables and a lot of data… please help!

rlab18 asked:


I am a new webmaster with a webpage that was pretty much built for me. I am wondering how I can place different links on my webpage and getting them to appear where I want them on the page usuing cpanel. I have made some minor changes but don’t have a lot of experience adding and making changes on my site. Any help would be appreciated. Thanks!

web4web4 asked:

www.WebDesignNH.org presents How To View Your cPanel Stats. A Web Design NH production - CALL TOLL-FREE 888-311-RANK (7265) - Top Ranked Website GUARANTEED Or Your Money Back! Dominate Your Local Market With A Business Website That Is Ranked At The Top Of The Search Engines!

Bill Miller asked:


When I purchased my first blog web hosting account, no one told me that I’d need certain features. I manually uploaded the WordPress program to my hosting account, followed the directions to install the MySql database and all the other nifty techie stuff I needed to make a blog work. Problem was, I’m not techie! It wasn’t easy and it took me about two days to get it up and running.

Fast forward. Many of today’s blog web hosting providers offer one click installation of WordPress and other blogs. Heck, if you pick the right blog web hosting provider, it should take you less than 30 minutes to have a fully functional WordPress blog up and running!

Here are 5 Features you need to make sure that your blog web hosting provider includes before purchasing a hosting account.

1. CPanel - The blog web hosting provider you choose should have CPanel so you can easily maintain your blog. There are other companies like DreamHost, GoDaddy and 1and1 that have their own custom dashboards that work as easily as CPanel does.

2. Fantastico - This is an auto installation program that will install a number of programs and scripts for you with minimal effort. Often times with only a click of a button. It makes it really easy to set up a blog or personal website. Programs such as WordPress, bulletin boards, photo galleries and much more. Most web host provide Fantastico with CPanel, but not all.

3. Multiple Domain Hosting - If you’re just looking to host a personal blog, then this will not matter to you. But if you’re looking for easy web hosting so you can run multiple blogs or websites, then make sure the blog web hosting provider offers the ability to host multiple domains on one account. Some will only let you host 1 domain while other will allow you to host more than one.

5. Domain Registration - Although it’s pretty easy to buy a domain in one place and then host you website in another, not everyone wants to fool with this. For this reason, you may want to make sure the blog web hosting provider you choose offers domain registration. What’s even better is if the blog web hosting provider will give you a free domain for buying their web hosting services.

5. Customer Service - Before I sign up with any blog web hosting provider, I email the company and ask a few simple questions. I already know the answers to the questions before I send them. What I’m looking for is how quick they get back to me and how informative their answers are. This gives me an idea how well they take care of their customers.

Don’t worry too much about storage space or bandwidth. If you’re running a small to medium sized blog, chances are you’ll never have to worry about this.

The one exception would be if you’ll be uploading a lot of files to your blog web hosting account. In that case, I’d host those files at a third party site and just like to them from your blog. For example, if you want all your Family pictures up on the web for family members and friends to see, I’d use a service like Flickr. There are many WordPress plugins that will show your Flickr photo’s on your blog.

There are many blog web hosting providers out there currently that offer all the features I listed above. Don’t be fooled by price alone! Expect to pay in the $5 to $10 a month range for affordable and reliable blog web hosting.

J.O. Moen asked:


What is website hosting with MySQL and why would you want to use it? Simply put, it offers application developers everything they need to be successful in building database-driven information systems. Website hosting with MySQL offers consistent fast performance, high reliability and is very easy to use. It is the most popular open source database in the world and has become the database of choice for applications of Linux, Apache, or PHP.

If you are new to database technology, website hosting with MySQL offers a wide range of certified software and support to make you very successful. It has the ultimate in scalability and capacity to handle deeply entrenched applications of only 1 MB running massive data warehouses holding gigabytes of information.

WEB STRENGTHS AND DATA PROTECTION

This data base software is the standard for high traffic websites because of its high-performance query engine and fast data insert capability. These strengths also apply to data warehousing environments where it scales up into the terabyte range. Because of the open source nature of MySQL, this allows complete customization for those wanting to add exclusive requirements to the database server.

Guarding the data assets of corporations is the number one job of database professionals; website hosting with MySQL offers exceptional security features that ensure absolute data protection. When it comes to database authentication, it also provides powerful mechanisms for ensuring only authorized users have entry to the database server. This ability to block users down to the client machine level becomes possible. A privileged framework is present so that users only see the data they should, and powerful data encryption functions ensure that sensitive data protected from non-permitted viewing.

Finally, backup and recovery utilities provided through website hosting with MySQL and third party software vendors allow for complete logical and physical backup as well as full and point-in-time recovery.

ASP WEBSITE HOSTING - FLEXIBLE, FAST AND POWERFUL

Active Server Pages or ASP in website hosting uses the ASP programming language developed by Microsoft. Even though classic ASP is no longer supported, Microsoft pushes the ASP.NET version for web hosting. ASP.NET is HTML pages with embedded ASP scripts processed on the server before sending the page to the user. This allows for a very fast and powerful web experience.

Web pages displayed on the internet are either static or dynamic. Static pages display information that never changes while dynamic pages can change content automatically. Dynamic, server-side scripting loads changes on the server before sending to the browser. PHP and ASP.NET program languages are examples that use server-side scripting.

ASP.NET - To Use Or Not To Use?

Website hosting with ASP.NET is easy to learn. It is also very flexible and powerful. Designed with less code and more predefined commands it is faster to learn than Classic website hosting ASP. Being a popular programming language, it is easy to find answers to any questions you may have when using ASP.NET hosting. There are many free tutorials on the internet that will help you with building various types of web pages. It also works well with other programming languages such as JavaScript and VBScript.

Even though ASP and ASP.NET are free since they come with Microsoft IIS; Microsoft Windows and a Microsoft IIS server are expensive. Most of the functions and add-ons will cost a lot of money, too.

InternetMarketingU asked:

training lessons from InternetMarketingUniversity.com courses