How do I Connect a website in MySql?
Published: July 5, 2009

Question:
How do I Connect a website in MySql?

Answer:
If you want to connect your website to a MySQL database. There are a number of steps.

  1. You must make sure your hosting company offers that service and that you have that feature on your current hosting account.
  2. You must create the database with a user name and password. You can manipulate your database(s) using a program called phpMyAdmin. This is usually provided by your host company.
  3. Youmust use a scripting language to connect with. Usually of you are using MySQL then the language will be PHP.
  4. You then create the php page and upload it up to your sever.
  5. The following sample will allow you to connect your php page to the database. It does NOT do anything else other than connect. There are too many other variables on the type of table created and what you may want to do to show a general example.

Example:
<?php

//Usually this is localhost. But could be an address of the database server
$HostType = "locahost";

//Name of your database
$DatabaseName = "SomeName";

//Your database username
$DbaseUsername = "SomeUsername";

//Your database password
$DbasePassword = "SomePassword";

$db=mysql_connect($HostType,$DbaseUsername,$DbasePassword);
mysql_select_db($DatabaseName,$db) or die ("cant change");


//code to manipulate the data base

?>

About the Author
Rich Agnew is an author for The Computer Geek Custom Web Page Design. The Computer Geek is a web design company that prides itself in professional service at a fraction of the cost. The Computer Geek specializes in Custom Web Design, PHP & MySql and Ecommerce.

Customer Reviews:

Published: March 21, 2019
Due to the positive experience we had with Mr. Rich Agnew project manager, I am writing this unsolicited strong recommendation on behalf of Mr. Rich Agnew who is a project manager at The Computer Geek Company. It is a genuine pleasure to write this u...[Read More]
Grant A. Killian, Ph.D.
grant@killianphd.com

 

Published: January 25, 2019
"Rich responded to my chat inquiry and answered my phone call immediately and had the move completed by the time i got back from lunch. Hands down the best experience I've had with a service provider and I won't bother looking anywhere else when my c...[Read More]
Darrin Wenstrand
darrin@tpai.com

 

Published: September 23, 2018
The Computer Geek team got my website up and running again within just a few hours. I was dead in the water and on a time constraint. Not knowing where to turn, I luckily found this great team and they solved my problem! Thank you guys!...[Read More]
Robert Alvarado
rwalvo@gmail.com

 

Published: September 21, 2018
I had an issue with my website's php code (whatever that is) ??. I also needed to update my php without crashing it. I had no idea who to turn to and feared an expensive price. Somehow, I found the computer-geek. It was fixed and updated in no time w...[Read More]
Pat Studstill
pat.studstill@gmail.com

 

Published: September 1, 2018
Great service, received a response within minutes. Problem solved next day! Prices are reasonable. Very happy! Thank you Rich....[Read More]
Shady Azer
shadya@concordeworldwide.com

 

Published: August 7, 2018
The computer geeks are gifted editors who strives to add excellence into all the work they do. They have worked with me on a pitch project for my comic book and I re-hired them to work with me on a feature film, CRY. The film genre was found footage ...[Read More]
Octavius Ra
r@orapictures.com

 

Published: July 28, 2018
Rich, you're the best! You kept this about the project, not the $$$. Your price was extremely fair. My site was down-for-the-count; and you got it back up within one hour of my initial call. I hope I don't come off racist, but it was great to hear so...[Read More]
George Busateri
gbusateri@att.net

 

Published: July 21, 2018
We have an e-commerce website that was hijacked for ransomware and we had nowhere to go, I got a recommendation from an acquaintance to check out computer-geek and we are so glad we did. I contacted Rich on a Saturday and got a response within minute...[Read More]
Richard James
richard@theherbalcoast.com

 

Published: July 1, 2018
"Thank you for your awesome & fast service at an awesome price. I will definitely be using your services again in the future if needed. A++"...[Read More]
Eric Villeneuve
eric@podblog.ca

 

Published: January 24, 2018
Over the past 1 1/2 years I have been extremely pleased with your business operations. When I need something done on my website, the management team delivers promptly ALL THE TIME! Rich and Justin never miss a beat and the keep my "beat" pounding wh...[Read More]
William Velmer
naga1@ix.netcom.com

 

[Read More Testimonials Here]

Latest Website Related Articles

Social Media and SEO (Search Engine Optimization)

Published: May 17, 2019
In 2019, we live in a digital age where social media platforms can become game-changers in improving Google rankings, promoting your business and increasing website traffic. Creating social media platforms, such as Facebook, Twitter, and Inst...[Read More]

 

What Are Doorway Pages

Published: May 10, 2019
New business owners can attract customers and generate business by creating an online presence and ranking high on Google. One of the quickest and most effective ways of increasing your rankings is to create doorway pages that will lead potenti...[Read More]

 


Here are some links to related topics:
 php contractor,   secure websites,   web page troubleshooting,   fatcow hacked,   small orange hacked,   just host hacked,  


Site Secured By The Website Guardian
How do I Connect a website in MySql? | Computer Geek 5 out of 5 based on 103 user ratings.
How do I Connect a website in MySql? | Computer Geek
How do I Connect a website in MySql? - Question:How do I Connect a website in MySql? Answer:If you want to connect your website to a MySQL database. There . . .
How do I Connect a website in MySql? | Computer Geek
Date Published: 10/09/2016
How do I Connect a website in MySql? - Question:How do I Connect a website in MySql? Answer:If you want to connect your website to a MySQL database. There . . .
5 / 5 stars