Learn & Earn by PHP& MYSQL

how to start php : step by step.

2011-06-20T04:59:00.000-07:00

============================================
Before we can do the big fancy stuff we must first learn the basics from which we build on.
Start by creating a blank file using any program that can save in plain text format.
==>open note pad
==>Save as .php file for example testpage.php
==>enter the following code :

==> here " echo"Bismillah" indicates print the word "Bismillah"
==>"?>" indicates end point of php tags.
Comments in PHP

In PHP, we use // to make a single-line comment or /* and */ to make a large comment block.

for example:

//This is a comment

/*
This is
a comment
block
*/
?>
One reason you may want to put a comment in your code is to make a note to yourself about what the code is doing for reference when you edit it later. You may also want to put comments in your code if you plan on sharing it with others and want them to understand what it does, or to include your name and terms of use within the script.

how to install

2011-06-20T03:44:00.000-07:00

If your server supports PHP you don't need to do anything.

Just create some .php files in your web directory, and the server will parse them for you. Because it is free, most web hosts offer PHP support.

However, if your server does not support PHP, you must install PHP.
Here is a link to a good tutorial from PHP.net on how to install PHP5: http://www.php.net/manual/en/install.php

Download PHP

Download PHP for free here: http://www.php.net/downloads.php

Download MySQL Database

Download MySQL for free here: http://www.mysql.com/downloads/

Download Apache Server

Download Apache for free here: http://httpd.apache.org/download.cgi

Or you can Install wamp which contains whole php,apache,mysql So now we can say Installing PHP is easy. You can install PHP on your computer easily with WAMP5. WAMP5 is an open source application which comes with with PHP5, Apache web server, MySQL database and phpMyAdmin (mysql database administration program). You can install these items on your windows machine using WAMP5. You can read more about WAMP5 at www.wampserver.com.

Installing WAMP5

Download the latest version of WAMP5.
Run the installation wizard and follow the easy instructions to install WAMP5.
Once you're done installing WAMP5, please go to your folder where you installed wamp5. If you didn’t specify which folder to install wamp during the installation wizard, then it should be installed in your C:/ drive, i.e. C:/wamp.
In your wamp directory you should see the following folders.

apache2 – This is where the apache web server is installed. Apache will run our php code and scripts on the web browser. You will not need to do anything in this folder. So you can relax and ignore it for now:)
mysql – This is where MySql databse is installed. MySQL is an open source database. PHP and MySQL work really well together. You can use PHP and MySql to store data. Don’t worry, we will learn how to do all that in our tutorials.
php – You guessed it. This is where php modules are stored.
www – This is the root folder of our web server. This is where you are going to put all your php files and scripts.
wampserver.exe – This file will run the WAMP program. We need to start WAMP everytime we want to work with PHP. So, go ahead and double click on this file.

Once you run the wamp server file, you will see a small icon on your windows tray.

Right click on this icon and then click on “Start All Services”. This will start the apache web server along with everything we need to run PHP pages on our machine.

Now open up your web browser and type in http://localhost. You should see the WAMP welcome page.

When you type in http://localhost in your browser, it executes the index.php file in your www folder. All our php files will go in the www folder. Follow the next tutorials to see how that is done.

You have done

Basic Knowledge about php,mysql

2011-06-19T12:09:00.000-07:00

What is PHP?
PHP stands for PHP: Hypertext Preprocessor
PHP is a server-side scripting language, like ASP
PHP scripts are executed on the server
PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)
PHP is an open source software
PHP is free to download and use
What is MySQL?

MySQL is a database server
MySQL is ideal for both small and large applications
MySQL supports standard SQL
MySQL compiles on a number of platforms
MySQL is free to download and use

PHP + MySQL

PHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform)

Why PHP?

PHP runs on different platforms (Windows, Linux, Unix, etc.)
PHP is compatible with almost all servers used today (Apache, IIS, etc.)
PHP is FREE to download from the official PHP resource: www.php.net
PHP is easy to learn and runs efficiently on the server side

Where to Start?

To get access to a web server with PHP support, you can:

Install Apache (or IIS) on your own server, install PHP, and MySQL
Or find a web hosting plan with PHP and MySQL support

SITE MAP

2010-09-28T02:06:00.000-07:00

@@String::::....Matching Patterns (Regular Expressions)

2010-06-26T01:15:00.000-07:00

PHP includes a couple of different sets of regex functions that you can use. The one we will use exclusively here is the PCRE extension. The PCRE functions (all prefaced by preg_) is the preferred library to use. It tends to be faster than the other option, and it uses the same regex syntax as Perl, another popular programming language that many programmers are already familiar with.

To best demonstrate the usefulness of regular expressions, let's examine a relatively simple problem: searching for a United States ZIP Code. Such numbers are either a five-digit number, or are known as a ZIP+4 and look like "12345-6789." Attempting this search with the standard PHP string functions would require a multiline algorithm. However, with regular expressions, a single function, preg_match(), is all that is required, here's given example :

// A function to detect zipcodes in a string.
function detect_zipcode($string) {
// Use regex to look for zipcodes, return true or false
return preg_match('/\b\d{5}(-\d{4})?\b/', $string);
}

// Try a few examples:
echo '

';



// A true example:

if (detect_zipcode('Frederick, MD  21701-3883')) {

    echo "Test 1: true\n";

}

// Another true example:

if (detect_zipcode('The zipcode 26623 is the area in which I grew up.')) {

    echo "Test 2: true\n";

}

// A False example:

if (detect_zipcode('The Phone Number is 301-555-1212')) {

    echo "Test 3: true\n";

}

// Another false example:

if (detect_zipcode('42696-313109')) {

    echo "Test 4: true\n";

}



echo '

';
?>

OUTPUT:

As a quick reference, here are some of the most common syntax characters for use in PCRE regular expressions:

Pattern matches:

\d = Digit

\D = Not a digit

\s = Whitespace

\S = Not whitespace

. = Any character (except \n)

^ = Start of string

$ = End of string

\b = Word boundary

Pattern match extenders:

? = Previous item is match 0 or 1 times.

* = Previous item is matched 0 or more times.

+ = Previous item is matched 1 or more times.

{n} = Previous item is matched exactly n times.

{n,} = Previous item is matched at least n times.

{n,m} = Previous item is matched at least n and at most m times.

? (after any of above) = Match as few as possible times.

Option patterns:

(pattern) = Groups the pattern to act as one item and captures it

(x|y) = Matches either pattern x, or pattern y

[abc] = Matches either the character a, b, or c

[^abc] = Matches any character except a, b, or c

[a-f] = Matches characters a through f

If you want to learn more try to read http://php.net/pcre.

Cleaning Up Whitespace...::--

If you want to just remove space from the beginning or end of a string, you can use the built-in function trim() to do that for you. However, often you want to completely clean up the data. You will want to remove leading/trailing spaces, collapse multiple spaces into a single one, and even replace all other types of whitespace with a regular space.

To accomplish this, you can use the regular expression functions of PHP as like as below:

$str = " This line  contains\tliberal \r\n use of   whitespace.\n\n";



// First remove the leading/trailing whitespace

$str = trim($str);



// Now remove any doubled-up whitespace

$str = preg_replace('/\s(?=\s)/', '', $str);



// Finally, replace any non-space whitespace, with a space

$str = preg_replace('/[\n\r\t]/', ' ', $str);



// Echo out: 'This line contains liberal use of whitespace.'

echo "{$str}";

?>

OUTPUT:

This line contains liberal use of whitespace.

Section 1.1. Matching Patterns (Regular Expressions)

2009-11-25T12:28:00.001-08:00

PHP Internals

2009-11-14T04:00:00.000-08:00

1 Strings
2 Numbers
3 Time and Date
4 Variables
5 Arrays
6 Functions
7 Classes and Objects
8 Files and Directories

1 Strings:
Quick learn:
Find the length of a string:

$length = strlen($string);
This function returns the number of characters in a string.

Full documentation: http://php.net/strlen

Split a string using a string as a separator:

$array_of_strings = explode($separator, $string);
This function returns the array of substrings created by splitting a string at every point the separator string appears.

Full documentation: http://php.net/explode

Create a string from an array of strings, with a separator:

$string = implode($separator, $array_of_strings);
The returned string will be a concatenation of all the strings in the array, with the separator string between them.

Full documentation: http://php.net/implode

Remove extra space from the beginning and end of a string:

$trimmed_string = trim($string);
The returned string will have any whitespace characters removed from the beginning and end of the string. The functions rtrim() and ltrim() remove whitespace from only the right or left end of the string, respectively.

Full documentation: http://php.net/trim, http://php.net/rtrim, and http://php.net/ltrim

Replace all occurrences of one string with another string:

$result_string = str_replace($old, $new, $full);
All occurrences of the old string within the full string are replaced with the new string. A case-insensitive version is also available as the function str_ireplace().

Full documentation: http://php.net/str_replace and http://php.net/str_ireplace

Pad a string to a specified length:

$padded = str_pad($string, $length);
The returned string is at least $length characters long. Spaces are added to the right of the string to achieve this. With optional arguments, any string can be used as padding along with whether the padding will occur at the beginning or end of string.

Full documentation: http://php.net/str_pad

Create a larger string via repetition:

$repeat = str_repeat($string, $nrepeats);
The input string is replicated the specified number of times to create the result.

Full documentation: http://php.net/str_repeat:

Split a string into an array of characters

$array = str_split($string);
This function returns an array comprising the characters that make up the string.

Full documentation: http://php.net/str_split

Return a portion of a string:

$substring = substr($string, $n, $length);
The portion of the string starting at the nth character for $length number of characters is returned. If $n is negative, the substring will start that many characters from the end of the string. If $length is negative, that many characters will be omitted from the end of the string.

Full documentation: http://php.net/substr

Make a string all uppercase or lowercase letters:

$lower = strtolower($string);

$upper = strtoupper($string);
These functions simply return, respectively, the lowercase or uppercase versions of the string.

Full documentation: http://php.net/strtolower and http://php.net/strtoupper

Parse a string based on a format:

$array = sscanf($string, $format);
The returned array contains each extracted value from the string according to the specified format.

Full documentation: http://php.net/sscanf

Output values using well-defined formats:

printf($format, $var1, $var2,...);
Using a simple syntax, the format argument defines how the subsequent arguments are printed. This function is part of a family of formatting functions.

Full documentation: http://php.net/printf, http://php.net/sprintf, http://php.net/fprintf

Compare two strings:

$result = strcmp($string1, $string2);
This function returns a number less than, equal to, or greater than 0 depending on how the strings compare alphabetically. 0 is returned if the strings are equivalent. A case-insensitive version is also available as strcasecmp().

Full documentation: http://php.net/strcmp and http://php.net/strcasecmp

Compare two strings as a human would do so:

$result = strnatcmp($string1, $string2);

$result = strnatcasecmp($string1, $string2);
The comparison is based on how people order stringsthat is, strings with numbers in them are ordered based on value, not just characters. The comparison is case-sensitive for the former call while being case-insensitve for the latter.

Full documentation: http://php.net/strnatcmp

Determine where the first occurrence of a string is within another string:

$pos = strpos($bigstring, $search);
This function returns the position of the search string in $bigstring. If not found, false is returned. A case-insensitive version is also available as stripos().

Full documentation: http://php.net/strpos and http://php.net/stripos

Determine where the last occurrence of a string is within another string:

$lastpos = strrpos($bigstring, $search);
This function returns the position of the last occurrence of the search string in $bigstring. If not found, false is returned. A case-insensitive version is also available as strripos().

Full documentation: http://php.net/strrpos and http://php.net/strripos

Search for any of a set of characters within a string:

$found = strpbrk($string, $characters);
The string is scanned for any of the characters in the $characters string. If a match is found, it returns a string starting from the character it just matched to the end of the string.

Full documentation: http://php.net/strpbrk

Learn PHP MySQL

2009-07-12T02:47:00.000-07:00

What Is PHP?
PHP is an open-source, server-side, HTML-embedded Web-scripting language that is compatible
with all the major Web servers (most notably Apache). PHP enables you to embed code
fragments in normal HTML pages—code that is interpreted as your pages are served up to users.
PHP stands for PHP: Hypertext Preprocessor.
PHP was developed before ASP. Over the past few years.
PHP is an official module of Apache HTTP Server, the market-leading free Web server that
runs about 67 percent of the World Wide Web (according to the widely quoted Netcraft Web
server survey). This means that the PHP scripting engine can be built into the Web server
itself, leading to faster processing, more efficient memory allocation, and greatly simplified
maintenance. Like Apache Server, PHP is fully cross-platform, meaning it runs native on several
flavors of Unix, as well as on Windows and now on Mac OS X. All projects under the aegis
of the Apache Software Foundation—including PHP—are open source software.

Why PHP?
The short answer is that it’s free, it’s open source,it’s easy to learn, and it plays well with others.

What is MySQL?
MySQL (pronounced My Ess Q El) is an open source, SQL Relational Database Management
System (RDBMS) that is free for many uses.

Why MySQL?
The short answer is that it’s free, it’s open source,it’s easy to learn, and it plays well with others.

Ads :baileysworldwide
Chameleonexpediting.com