<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-244126016257787965</id><updated>2024-12-18T19:31:41.821-08:00</updated><title type='text'>PHP MYSQL Web Hosting SEO</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://lphpmysql.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/244126016257787965/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://lphpmysql.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>suman sanjel</name><uri>http://www.blogger.com/profile/09236776333439934587</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-244126016257787965.post-5194171202132417905</id><published>2011-01-26T03:10:00.000-08:00</published><updated>2011-02-02T22:58:42.651-08:00</updated><title type='text'></title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;div style=&quot;color: white;&quot;&gt;&lt;b&gt;&lt;span style=&quot;font-family: Arial,Helvetica,sans-serif; font-size: small;&quot;&gt;               &lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;div align=&quot;right&quot; style=&quot;color: white; float: right;&quot;&gt;&lt;/div&gt;&lt;b&gt;&lt;span style=&quot;font-family: Arial,Helvetica,sans-serif; font-size: small;&quot;&gt;&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;Introduction&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
For many people, the main reson for learning a scripting language like  PHP is because of the interaction with databases it can offer. In this  tutorial I will show you how to use PHP and the MySQL database to store  information on the web and include it into your website. Before you read  this tutorial you should have at least a basic knowledge of how to use  PHP. If you do not yet know PHP, I suggest that you read our PHP  tutorial before continuing.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;Why Would I Want A Database?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
It is actually surprising how useful a database can be when used with a  website. There are a huge variety of things you can do when you interact  the two, from displaying simple lists to running a complete website  from a database. Some examples of PHP and MySQL being used together are:&lt;br /&gt;
&lt;/span&gt;&lt;span style=&quot;font-family: Arial,Helvetica,sans-serif; font-size: small;&quot;&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;What Do I Need?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
You only really need three things to run PHP scripts which access MySQL  databases. Firstly, you will, of course, need a webserver. This can  either be on a computer of your own or on a web host. Any web server  software should work with PHP and MySQL but the best to use is Apache,  which is free.&lt;br /&gt;
&lt;br /&gt;
PHP also needs to be installed on the server. If it is not already  installed you can install it (or ask your web host to install it). It  can be downloaded from PHP.net and is also free. If you are not sure if  you have PHP installed I will show you a way to check it later.&lt;br /&gt;
&lt;br /&gt;
Finally, you will also require MySQL. This is the actual database  software. You can also use most other types of database (SQL, Oracle  etc.) but as this is a PHP/MySQL tutorial I will deal just now with the  MySQL database (although the commands used here will also work with SQL  databases). As with the other software you need, MySQL is free and can  be downloaded from the MySQL homepage. If you are not sure if you have  MySQL installed, I will show you how to check later.&lt;br /&gt;
&lt;br /&gt;
If you cannot install (or your web host won&#39;t allow) PHP and MySQL you  can still use another web host. Freedom2Surf are a free (banner  supported) web host and support PHP and have MySQL installed. HostRocket  are an excellent web host and can offer you 300MB of space with PHP,  MySQL and loads of other extras for under $10 a month.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;Testing For PHP and MySQL&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
There is a simple test for both PHP and MySQL. Open a text editor and type in the following:&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: yellow;&quot;&gt;phpinfo();&lt;/span&gt;&lt;br style=&quot;background-color: yellow;&quot; /&gt;&lt;span style=&quot;background-color: yellow;&quot;&gt; ?&amp;gt;&lt;/span&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
and save it as phpinfo.php&lt;br /&gt;
&lt;br /&gt;
Now upload this to your webspace and go to i&lt;br /&gt;
t in your browser. If you have PHP installed you will see a huge page  with all the details of your PHP installation on it. Next, scroll down  through all this information. If you find a section about MySQL then you  will know that MySQL is installed.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;Managing Databases&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Although all the database administrative options can be done through PHP  scripts, I strongly suggest installing a copy of PHPMyAdmin on your  server. It is an excellent free set of scripts that will provide you  with an administrative interface for your MySQL database(s). You can  add, remove, edit, backup and view your databases using this and it is  especially useful when troubleshooting your databases.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;background-color: yellow; color: #000099; font-family: Arial;&quot;&gt;This Tutorial&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
Throughout this tutorial I will be showing you some of the basics of  using PHP and MySQL together. To do this I will be using an example all  the way through. As you use this tutorial, you will learn how to create a  web based contact management program. It will allow you to store names  with their addresses, e-mail and phone numbers. You will be able to  update records and search the database. There will even be an option  which allows you to send an e-mail out to all the people in the database  (please note: this system should not be used for spam or unsolicited  e-mail).&lt;br /&gt;
&lt;br /&gt;
After creating this system you should have enough knowledge to go on and  create nearly any type of database enabled site you want to.&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;ul&gt;&lt;b&gt;&lt;span style=&quot;font-family: Arial,Helvetica,sans-serif; font-size: small;&quot;&gt;
&lt;li&gt;Banner  Rotation. On this site, where each banner is, a PHP script is called.  This opens a database and picks a random banner from it to show the  visitor. It also counts the number of times the banner has been viewed  and could, with a few changes, track clicks too. To add, change or edit  the banners all I have to do is change the database and the script will  pick the correct banners for all the pages on the site.&lt;/li&gt;
&lt;li&gt;Forums.  Hundreds of forums (message boards) on the internet are run using PHP  and MySQL. These are much more efficent than other systems that create a  page for each message and offer a wide variety of options. All the  pages in the forum can be updated by changing one script.&lt;/li&gt;
&lt;li&gt;Databases.  One quite obvious example is sites which get all there information from  a database. For example Script Avenue is run by a few scripts, which  gain all their information from a large database. All the different  script categories can be accessed in one script by just changing the URL  to access a different part of the database.&lt;/li&gt;
&lt;li&gt;Websites. If you  have a large website and you want to change the design it can take a  very long time to update and upload all the pages. With PHP and MySQL  your whole website could be just one or two PHP scripts. These would  access a MySQL database to get the information for the pages. To update  the website&#39;s design you would just have to change one page.&lt;/li&gt;
&lt;/span&gt; &lt;b xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;a href=&quot;http://www.blogger.com/goog_1314520999&quot;&gt; &lt;/a&gt;&lt;/b&gt;&lt;a href=&quot;http://www.freewebmasterhelp.com/tutorials/phpmysql/2&quot;&gt;&amp;gt;&amp;gt;&lt;i&gt; Read More&lt;/i&gt; &amp;gt;&amp;gt;&lt;/a&gt;&lt;/b&gt;&lt;/ul&gt;&lt;/div&gt;</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/244126016257787965/posts/default/5194171202132417905'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/244126016257787965/posts/default/5194171202132417905'/><link rel='alternate' type='text/html' href='http://lphpmysql.blogspot.com/2011/01/phpmysql-tutorial-part-1-introduction.html' title=''/><author><name>suman sanjel</name><uri>http://www.blogger.com/profile/09236776333439934587</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author></entry></feed>