PHP Tutorial : Extracting rows from mysql

Posted on May 8, 2009 by admin

Helllooooooo,
In latest two posts I have shown you how to connect to a mysql database via PHP, and in another one I teach you how to select rows from a mysql database table. In this one I will show you how to extract that rows from mysql and print them out into a page. Let’s suppose we have a database which contains fields : id, full_name, age. Ok, next step is connecting to db, then making a query to select those fields and finally extract & print them on the screen :

$query_db = "select * from table_Name";
$result_db = mysql_query($query_db);

while($row=@mysql_fetch_object($result_db) {
print "$row->full_name it's $row->age years old";
}

We used a while() loop to extract all results!

Isn’t PHP rocking?

Posted in Php & MySQL | Tagged , , , , , , , , , | 2 Comments

PHP Tutorial : Building a MySQL query

Posted on May 3, 2009 by admin

In a recent tutorial I was showing you how to build a connection to MySQL database via PHP. In this one I will show you how to create a query to interogate a table of the database. Look below :

<?php
$query = mysql_query("select * from table_Name");
?>

* – sign means all, so by using this query, you will select all fields from a table_Name

Posted in Php & MySQL | Tagged , , , , , , | 2 Comments

PHP Tutorial : Connecting to MySQL database via PHP

Posted on April 30, 2009 by admin

In this tutorial I will speak first time about php programming language and MySQL database engine togheter. I will show and explain how simple is to connect to a mysql server via php using a simple functio called mysql_connect().

mysql_connect('localhost', 'mysql_database_user', 'mysql_db_password') or die("not connected to db");
Posted in Php & MySQL | Tagged , , | 1 Comment

It Stuff : RSS Feeds List + Submission service

Posted on April 25, 2009 by admin

Hello, even if this is SEO related subject I finded it usefull to post as I didn’t found a list of rss feeds sites like this where you may submit your feed URL. This is good for getting traffic and backlinks as we all of us know.

Have a look over the entire list (around 80 sites) here :

http://www.crivionweb.com/feeds.txt

Also, if you’re too comfortable to visit all these sites and submit your feed, you may leave a comment into this post and for as low as 7.99$ I am offer rss feeds submission service to all those 80 sites.

Posted in It Stuff | Tagged , , , , , , , | Leave a comment

It Stuff : Hostgator Coupon

Posted on April 22, 2009 by admin

Hello you guys searching for Hostgator Coupon codes, do you plan to sign up for a web hosting plan under Hostgator? If the answer is yes, then you should really go with a hostgator coupon code which will save some money. First, click here to go to hostgator , choose a plan (I recommend Baby Plan), then at the final enter one of this two coupons : JURY for $9.94 or SPRING for 20% – then click “Calculate” totals or something like that and taddaaa, good savings. I hope it’s usefull for you : I use Hostgator on all of my websites and never had troubles, they give adwords coupons of 25$ too, so, a lot of advantages!

Posted in It Stuff | Tagged | 1 Comment

The Benefits of having Company Web Blog

Posted on April 21, 2009 by admin

In the early days of blogging, people use it to document events and experiences that they’ve been through. Then came a time where the whole concept of blogging evolved. As of now blogs do not just talk about personal experiences. They can also be used for news reporting, product reviews, online marketing, and many others.

The Internet community is growing bigger each day and because of this, many companies would always want to have a presence in the Web. There are several reasons why a company should publish their own website. Some of them would want to sell products and services on the Internet. Others just want to have publicity through advertisements.

Many of these web design companies choose the blog format in putting up their websites. One of the major reasons for this is the popularity of the blog format. A blog site is easy to navigate and it can provide a clean look for the website.

Putting up a blog site is easy. One can easily find blogging software applications on the Web and many of them are free. A company who wants publicity over the Web can put up a blog with articles reviewing their products and products of competing brands. Service oriented companies would usually talk about their services in the blog. There are companies who put up their blogs to post updates and news about the company. This is typical and seen in banking and finance companies. Creating a blog with custom web development is an easy way of establishing Web presence for a company. Visitors can easily browse the website if it is in a form of a blog.

Posted in It Stuff | Tagged , , , | Leave a comment

PHP Tutorial : PHP $_POST array

Posted on April 12, 2009 by admin

Hello folks,

BTW Happy Easter,my traffic this weekend decreased dramatically because of the hollidays, I hope you enjoy it.

I want to clarify something that I might missed to say about php $_POST : this $_POST is an php array, if you want to see yourself, make recursive print with print_r() function. For example if you have a form, you can get all values in one time with this php $_POST array by typing

<?php
print_r($_POST);
?>
Posted in Basic PHP | Tagged , , | 1 Comment

PHP Tutorial : Substract part of string with substr

Posted on April 10, 2009 by admin

Hello,

I didn’t posted for a long time because I am simply stucked into finding a subject. I made a search into my own blog and I saw that (miraculous btw) I didn’t writed yet about substr function which helps you to print only a part of a string – substract it!

<?php
$stringIs = "mystring";
$substract = substr($stringIs, 0, 3);
print $subtract; //this will print my

?>

First you declare the string you want substracted, then first number means from where to start and the last no. means where to finish.

Taddaaa!

Posted in Basic PHP | Tagged , , , | Leave a comment

It Stuff : hosting managed web

Posted on April 8, 2009 by admin

Do you need hosting managed web? My advice is to check review sites before taking a decission. What is hosting managed web? It’s a “normal” service, but as we all know, the server where it’s hosted it’s managed, maintained by someone.

Please note this post is a test of mine so dont give big attention, thanks!

Posted in It Stuff | Tagged | Leave a comment

It Stuff : Another google pagerank update

Posted on April 2, 2009 by admin

Today a google pagerank (pr) update has taken place, I must tell you that I am totally disgusted by this update as my blog it seems to be the same, nothing changed in matter of pagerank. Also, my other domains remained the same, no one changed, so this really sux. I hope you guys enjoy it at least, and get big pr’s, I am pissed off since my hard work didn’t had results, I spent 2 hours daily in building backlinks, making optimizations, etc.

I will decide what’s next, Google dissappointed me this me!

Posted in It Stuff | Tagged , , , , , | Leave a comment