Pintogen's Posts

Nairaland Forum › Pintogen's Profile › Pintogen's Posts

1 2 3 4 5 6 7 8 ... 27 28 29 30 31 32 (of 32 pages)

Webmasters › Re: Can You Develop Applications With Custom Controls With Scripting? by pintogen(op): 3:00pm On Jan 13, 2009

I will let you know these that bulding custom web controls can be actualize with C# , this controls are basically web controls that can be added to a web contents, it depends on your creativity and how far you learn fast and understand how you can build your own rich custom web control.

Webmasters › Re: Can You Develop Applications With Custom Controls With Scripting? by pintogen(op): 2:46pm On Jan 13, 2009

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 2:18pm On Jan 13, 2009

Your First PHP Script

It would be unfair of me to help you get everything installed and not even give you a taste of what a PHP-driven Web page looks like until next week, so here's a little something to whet your appetite.

Open up your favorite text or HTML editor and create a new file called today.php. Type the following into the file:

<HTML><HEAD><TITLE>Today's Date</TITLE></HEAD><BODY><P>Today's Date (according to this Web server) is<?php
echo( date("l, F dS Y." wink

);
?></BODY></HTML>
Save it and place it on your Web site as you would any regular HTML file, then see what it looks like when you view it in your browser. If you haven't yet had time to set up PHP on your Web server, click here to see the results on our server.

Pretty neat, huh? If you use the view source feature in your browser, all you'll see is a regular HTML file with the date in it. The PHP code (everything between <?php and ?> in the code above) has been interpreted by the Web server and converted to normal text before sending it to your browser. The beauty of PHP (and other server-side scripting languages) is that the Web browser doesn't have to know anything about it!

Don't worry too much about the exact code I used in this example. Before too long you'll know it like the back of your hand.

Wrap-up

All things going to plan, you should now have everything you need to get MySQL and PHP installed on your Web Server. If the little example above didn't work right (for example, if the raw PHP code appeared instead of the date), then something went wrong with the setup. Drop by the SitePoint.com Forums and we'll be glad to help you figure out the problem!

In the next section, we'll learn the basics of relational databases and get started working with MySQL. If you've never even touched a database before, I promise you it'll be a real eye opener!

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 2:16pm On Jan 13, 2009

If Your Web Host Provides PHP and MySQL

If the host providing you with Web space has already installed and set up MySQL and PHP for you and you're just hoping to learn how to use them, there really isn't a lot you need to do. Now would be a good time to get in touch with your host and request any information you may need to access these services.

Specifically, you'll need a username and password to access the MySQL server they have set up for you. They'll probably have set up an empty database for you to use as well (this prevents you from messing with the databases of other users that share the same MySQL server), and you'll want to know its name.

There are two ways you can access the MySQL server. The first is to use telnet to log into the host and use the MySQL client programs (mysql, mysqladmin, mysqldump, etc.) installed there to interact with the MySQL server directly. The second is to install those client programs on your own computer and have them connect to the MySQL server. Your Web host may support one or both of these methods, so you'll need to ask which.

If they support logging in by telnet to do your work, you'll need a username and password for the telnet login in addition to those you'll use to access the MySQL server (they can be different). Be sure to ask for both sets of information.

If they support remote access to the MySQL server, you'll want to download a program for connecting to and interacting with the server. This article series will assume you've downloaded the set of MySQL client programs from http://www.mysql.com/. Packages are available for Windows or Unix, and are free. Install instructions are fairly simple and are included with the packages. If you prefer something more graphical, you can download something like MySQLWinAdmin for Windows (also available from http://www.mysql.com/). I'd really recommend getting comfortable with the basic client programs first, though, since the commands you use with them will be similar to those you include in your PHP scripts to access MySQL databases.

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 2:14pm On Jan 13, 2009

Installing PHP under Linux

As mentioned above, PHP is not really a program in and of itself. Rather, it is a plug-in module for your Web server (probably Apache). There are actually three ways you can install the PHP plug-in for Apache:

As a CGI program that Apache runs every time it needs to process a PHP-enhanced Web page.

As an Apache module compiled right into the Apache program.

As an Apache module loaded by Apache each time it starts up.

The first option is the easiest to install and set up, but requires Apache to launch PHP as a program on your computer every time a PHP page is requested. This can really slow down the response time of your Web server, especially if more than one request needs to be processed at a time.

The second and third options are pretty much identical in terms of performance, but since you likely already have Apache installed, you'd probably prefer to avoid downloading, recompiling, and reinstalling it from scratch. For this reason, we'll be using the third option.

Start by downloading the PHP Source package from http://www.php.net/ (or one of its mirrors listed at http://www.php.net/mirrors.php). At the time of this writing, PHP 4.0 was available as "Release Candidate 2"-or "almost ready but not quite". Personally I use PHP 4.0-RC2 and don't have any trouble with it. Since the final version will be out "real soon now" (likely before this series of articles is even finished), I'd recommend you install the latest version of 4.0 so you don't have to change anything when the final version is released. In case you do decide to stick with 3.0, however, I'll be sure to point out any spots in the installation procedure that would differ between the two.

The file you downloaded should be called php-version.tar.gz. We'll start by extracting the files it contains:

% tar xfz php-version.tar.gz
% cd php-version

To install PHP as a loadable Apache module, you'll need the Apache apxs program. This comes with most versions of Apache, but if you're using the copy that was installed by RedHat Linux, you'll need to install the Apache development RPM package to get it. You'll find this package on your RedHat CD or you can download it from http://www.redhat.com/. By default, RedHat will install the program as /usr/sbin/apxs. If you see that file, you know it's installed.

For the rest of this install procedure, you'll need to be logged in as the root user, because it involves making changes to the Apache configuration files.

The next step is to configure the PHP installation program by letting it know what options you want to have enabled and where it should find the programs it needs to know about (like Apache and MySQL). Unless you know what you're doing, you should just type the command like this (all on one line):

% ./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php --with-apxs=/usr/sbin/apxs --enable-track-vars --enable-magic-quotes --enable-debugger
If you are installing PHP 3.0 (and not 4.0 or later), you'll also need to tell it where to find MySQL on your system with the following additional parameter:

--with-mysql=/usr/local/mysql/
After watching several screens of tests scroll by, you'll be returned to the command prompt. The following two commands will compile and then install PHP:

% make% make install
PHP is now installed in /usr/local/php (unless you specified a different directory with the --prefix option of ./configure above), and expects to find its configuration file, named php.ini, in the same directory (unless you specified a different directory with the --with-config-file-path option of ./configure above). PHP comes with a sample php.ini file called php.ini-optimized (php.ini-dist for PHP 3.0). Copy this file from your installation work directory to where it belongs:

% cp php.ini-optimized /usr/local/php/php.ini
Or for PHP 3.0:

% cp php.ini-dist /usr/local/php/php.ini
We'll worry about fine-tuning php.ini shortly. For now, we need to make sure Apache knows where to find PHP so that it can load it when starting up. Open your Apache httpd.conf configuration file (/etc/httpd/conf/httpd.conf on RedHat Linux) in your favorite text editor. Look for a line like the following:

LoadModule php4_module lib/apache/libphp4.so
If you installed PHP 3.0, the line will read php3 instead of php4. You're looking for a new, uncommented line (no # at the start of the line), not the old line that we commented out earlier. Chances are it will not appear along with the other LoadModule lines in the file. Once you find it, you need to change the path so that it matches all the other LoadModule lines in the file. Under RedHat Linux, this means changing the line so that it looks like this:

LoadModule php4_module modules/libphp4.so
Next, look for the line starting with DirectoryIndex. This line tells Apache what filenames to use when looking for the default page for a given directory. You'll see the usual index.html and so forth, but you need to add index.php and index.php3 to that list:

DirectoryIndex index.html index.cgi , index.php index.php3
Finally, go right to the bottom of the file and add the following line to tell Apache what file extensions should be seen as PHP files:

AddType application/x-httpd-php .phtml .php .php3
That should do it! Save your changes and restart your Apache server. All things going to plan, Apache should start up without any error messages. If you run into any trouble, the helpful folks in the SitePoint.com Forums (myself included) will be happy to help.

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 2:11pm On Jan 13, 2009

PART 1 CONTINUE-Installing MySQL under Linux

MySQL is freely available for Linux from http://www.mysql.com/ (or one of its mirrors listed at http://www.mysql.com/downloads/mirrors.html). Download the latest stable release (listed as "recommended" on the download page). You should grab the "tarball source download" version, with filename mysql-version.tar.gz.

With the program downloaded, you should make sure you're logged in as root before proceeding with the installation, unless you only want to install MySQL in your own home directory. Begin by unpacking the downloaded file and moving into the directory that is created:

% tar xfz mysql-version.tar.gz% cd mysql-version
Next you need to configure the MySQL install. Unless you really know what you're doing, all you should have to do is tell it where to install. I recommend /usr/local/mysql:

% ./configure --prefix=/usr/local/mysql
After sitting through the screens and screens of configuration tests, you'll eventually get back to a command prompt. You're ready to compile MySQL:

% make
After even more screens of compilation, you'll again be returned to the command prompt. You're now ready to install your newly compiled program:

% make install
MySQL is now installed, but before it can do anything useful its database files need to be installed too. Still in the directory you installed from, type the following command:

% scripts/mysql_install_db
With that done, you can delete the directory you've been working in, which just contains all the source files and temporary installation files. If you ever need to reinstall, you can just re-extract the mysql-version.tar.gz file.

With MySQL installed and ready to store information, all that's left is to get the server running on your computer. While you can run the server as the root user, or even as yourself (if, for example, you installed the server in your own home directory), the best idea is to set up a special user on the system that can do nothing but run the MySQL server. This will remove any possibility of someone using the MySQL server as a way to break into the rest of your system. To create a special MySQL user, you'll need to log in as root and type the following commands:

% /usr/sbin/groupadd mysqlgrp% /usr/sbin/useradd -g mysqlgrp mysqlusr
By default, MySQL stores all database information in the var subdirectory of the directory to which it was installed. We want to make it so that nobody can access that directory except our new MySQL user. The following commands will do this (I'm assuming you installed MySQL to the /usr/local/mysql directory):

% cd /usr/local/mysql% chown -R mysqlusr.mysqlgrp var% chmod -R go-rwx var
Everything's set for you to try launching the MySQL server for the first time. From the MySQL directory, type the following command:

% bin/safe_mysqld --user=mysqlusr &
The MySQL server has now been launched by the MySQL user and will stay running (just like your Web or FTP server) until your computer is shut down. To test that the server is running properly, type the following command:

% bin/mysqladmin -u root status
A little blurb with some statistics about the MySQL server should be displayed. If you get an error message, something has gone wrong. If retracing your steps to make sure you did everything described above doesn't solve the problem, a post to the SitePoint.com Forums will probably help you pin it down in no time.

If you want to set up your MySQL server to run automatically whenever the system is running (just like your Web server probably does), you'll have to set it up to do so. In the share/mysql subdirectory of the MySQL directory, you'll find a script called mysql.server that can be added to your system startup routines to do this.

Assuming you've set up a special MySQL user to run the MySQL server, you'll need to edit the mysql.server script before you use it. Open it in your favorite text editor and change the mysql_daemon_user setting to refer to the user you created above:

mysql_daemon_user=mysqlusr
Setting up the script to be run by your system at startup is a highly operating system-dependant task. If you're not using RedHat Linux and you're not sure of how to do this, you'd be best to ask someone who knows. In RedHat Linux, the following commands (starting in the MySQL directory) will do the trick:

% cp share/mysql/mysql.server /etc/rc.d/init.d/% cd /etc/rc.d/init.d% chmod 500 mysql.server% cd /etc/rc.d/rc3.d% ln -s , /init.d/mysql.server S99mysql% cd /etc/rc.d/rc5.d% ln -s , /init.d/mysql.server S99mysql
That's it! To test that this works, you can reboot your system and request the status of the server as before to make sure it runs properly at startup.

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 1:29pm On Jan 13, 2009

PART 1 CONTINUE-Installing under Linux

This section covers the exact procedure for installing PHP and MySQL under RedHat Linux 5 or later. If you're using a different flavor of Linux, or another Unix-based operating system, the steps involved will be very similar, if not identical.

As a user of RedHat Linux, you may be tempted to download and install the RPM distributions of PHP and MySQL. RPM's are nice, pre-packaged versions of software that are really easy to install. Unfortunately, they also limit the options you have in choosing how the software is configured. For this reason, I consider the RPM versions of PHP and MySQL to be more trouble than they are worth.

Since a few of the default RedHat Linux install configurations will automatically install PHP for you, your first step should be to remove any old versions of PHP and MySQL from your system. You'll need to be logged in as the root user to issue the commands to do this. Note that in the following commands, "%" represents the shell prompt, and is not something that needs to be typed.

% rpm -e mysql% rpm -e php
If either or both of these commands tell you that the program in question is not installed, don't worry about it. If the second command runs successfully (i.e. no message is displayed), then you did indeed have an older version of PHP installed, and you'll need to do one more thing to get rid of it entirely. Open your Apache configuration file (usually /etc/httpd/conf/httpd.conf) in your favorite text editor and look for the two lines shown here. They usually appear in separate sections of the file, so don't worry if they're not together.

LoadModule php3_module modules/libphp3.soAddModule mod_php3.c
These lines are responsible for telling Apache to load PHP as a plug-in module. Since you just uninstalled that module, you'll need to get rid of these lines to make sure Apache keeps working properly. You can comment out these lines by adding a hash (#) at the beginning of both lines.

To make sure Apache is still in working order, you should now restart it without the PHP plug-in:

% /etc/rc.d/init.d/httpd stop% /etc/rc.d/init.d/httpd start
With everything neat and tidy, you're ready to download and install MySQL and PHP.

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 1:25pm On Jan 13, 2009

PART 1 CONTINUE-Installation under Windows

As I mentioned above, MySQL for Windows costs about US$200 to buy. For those of us who just want to try it out and see what it can do, T.c.X. (the company that develops MySQL) provides an older version that can be downloaded for free. It can be found by going to http://www.mysql.com/ (or one of its mirrors listed at http://www.mysql.com/mirrors.html) and selecting "Register and download shareware version of MySQL-Win32" in the "Downloads" section under "Downloads for Windows MySQL related software". After downloading the file, unzip it and run the setup.exe program contained therein.

Once installed, MySQL is ready to roll (barring a couple of configuration tasks that we'll look at shortly). Just like your Web server, MySQL is a server that should be run in the background so that it may respond to requests for information at any time. The server program may be found in the "bin" subfolder of the folder where you installed MySQL. If you are using the shareware version of MySQL, the server is called mysqld-shareware.exe. Before proceeding, rename this file to mysqld.exe. From the MS-DOS Prompt, start the server:

C:\mysql\bin> mysqld
To ensure that the server is started whenever Windows starts, you might want to create a shortcut to the program and put it in your Startup folder. If you decide to buy MySQL, it will come with a version that can be installed as a Windows NT/2000 service with the following command:

C:\mysql\bin> mysqld-nt --install
If you have trouble running the shareware version under Windows NT/2000, you can try running the server as a standalone program:

C:\mysql\bin> mysqld --standalone
The next step is to install PHP. At the time of this writing, PHP 4.0 was available as "Release Candidate 2"--or "almost ready but not quite". Personally I use PHP 4.0-RC2 and don't have any trouble with it. Since the final version is slated for release "real soon now" (likely before this series of articles is even finished), I'd recommend you install the latest version of 4.0 so you don't have to change anything when the final version is released.

PHP may be downloaded for free from http://www.php.net/ (or one of its mirrors listed at http://www.php.net/mirrors.php). You want the "binaries for Win32" package. Don't worry about grabbing any of the add-ons; we don't need them. A good installation guide for PHP 3.0 for Windows is available at the following URL: http://www.umesd.k12.or.us/php/win32install.html. It'll probably be updated with instructions for PHP 4.0 when it is finally released, but since installation of 4.0 is pretty much identical to installation of 3.0, you shouldn't have any trouble following the instructions with either version.

Don't worry about any of the optional steps (like choosing extension modules)-we'll work through those things together in a little bit. If you have any trouble following the instructions, feel free to post your question to the SitePoint.com Forums. I will be glad to help if the other helpful people there don't beat me to it!

With MySQL and PHP installed, you're ready to proceed to Post-Installation Setup Tasks.

Webmasters › Re: Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 1:21pm On Jan 13, 2009

Part 1: Installation

Welcome to the Show

Hi there, and welcome to the first in ten-part series on building a database-driven Web site! For the next few months, it will be my job to guide you as you take your first steps beyond the HTML-and-JavaScript world of client-side site design. Together we'll learn everything that's needed to build the kind of large, content-driven sites that are so successful today, but which can be a real headache to maintain if they aren't done right.

Before we get started, we need to gather together the tools we'll need for the job. In this first article, we'll download and set up the two software packages we'll be using: PHP and MySQL.

PHP is a server-side scripting language. You can think of it as a "plug-in" for your Web server that will allow it to do more than just send plain Web pages when browsers request them. With PHP installed, your Web server will be able to read a new kind of file (called a "PHP script" wink

that can do things like retrieve up-to-the-minute information from a database and insert it into a Web page before sending it to the browser that requested it. PHP is completely free to download and use.

To retrieve information from a database, you first need to have a database. That's where MySQL comes in. MySQL is a relational database management system, or RDBMS. Exactly what role it plays and how it works we'll get into later, but basically it's a software package that is very good at organizing and managing large amounts of information. MySQL also makes that information really easy to get at using server-side scripting languages like PHP. MySQL is free for non-commercial use on most Unix-based platforms, like Linux. MySQL for Windows 9x/NT/2000 costs about US$200 to buy, but you can download an older version for free if you just want to try it out. For our purposes, the older version will serve just fine, but if you find MySQL for Windows useful and you decide to use it on one of your own sites, you should pay for it.

If you're lucky, your current Web host may already have installed MySQL and PHP on your Web server for you. If that's the case, much of this article will not apply to you, and you can skip straight to If Your Web Host Provides PHP and MySQL to make sure everything is ship shape.

Everything we'll discuss in this article series may be done on a Windows- or Unix-based server. Depending on which type of server you'll be using, the installation procedure will be different. The next section deals with installation on a Windows-based Web server. The section after that deals with installation under Linux (and other Unix-based platforms). Unless you're especially curious, you should only need to read the section that applies to you.

Webmasters › Learn how to Build A Database-driven Web Site Using Php And Mysql here by pintogen(op): 1:08pm On Jan 13, 2009

On the Web today, content is king. After you've mastered HTML and learned a few neat tricks in JavaScript and Dynamic HTML, you can probably build a pretty impressive-looking Web site design. But then comes the time to fill that fancy page layout with some real information. Any site that successfully attracts repeat visitors has to have fresh and constantly updated content. In the world of traditional site building, that means HTML files--and lots of 'em.

The problem is that, more often than not, the people providing the content for a site are not the same people handling its design. Oftentimes, the content provider doesn't even know HTML. How, then, is the content to get from the provider onto the Web site? Not every company can afford to staff a full-time Webmaster, and most Webmasters have better things to do than copying Word files into HTML templates anyway.

Maintenance of a content-driven site can be a real pain, too. Many sites (perhaps yours?) feel locked into a dry, outdated design because rewriting those hundreds of HTML files to reflect a new design would take forever. Server-side includes (SSI's) can help alleviate the burden a little, but you still end up with hundreds of files that need to be maintained should you wish to make a fundamental change to your site.

The solution to these headaches is database-driven site design. By achieving complete separation between your site's design and the content you are looking to present, you can work with each without disturbing the other. Instead of writing an HTML file for every page of your site, you only need to write a page for each kind of information you want to be able to present. Instead of endlessly pasting new content into your tired page layouts, create a simple content management system that allows the writers to post new content themselves without a lick of HTML!

In this 10-part weekly series of articles, I'll provide a hands-on look at what's involved in building a database-driven Web site. We'll be using two new tools for this: the PHP scripting language and the MySQL relational database. If your Web host provides PHP/MySQL support, you're in great shape. If not, we'll be looking at the set-up procedures under Unix and Windows, so don't sweat it.

These articles are aimed at intermediate or advanced Web designers looking to make the leap into server-side programming. You'll be expected to be comfortable with HTML, as I'll be making use of it without explanation. A teensy bit of JavaScript may serve us well at some point, but I'll be sure to keep it simple for the uninitiated.

By the end of this series, you can expect to have a grasp of what's involved in setting up and building a database-driven Web site. If you follow along with the examples, you'll also learn the basics of PHP (a server-side scripting language that allows you to do a lot more than access a database easily) and Structured Query Language (SQL -- the standard language for interacting with relational databases). Most importantly, you'll come away with everything you need to get started on your very own database-driven site in no time!

Topics we will cover
Part 1: Installation
Part 2: Getting Started with MySQL
Part 3: Getting Started with PHP
Part 4: Using PHP to access a MySQL database
Challenge Solution
Part 5: Relational Database Design
Part 6: A Content Management System
Part 7: Content Formatting and Submission
Part 8: MySQL Administration
Part 9: Advanced SQL
Part 10: Advanced PHP

Programming › Connecting To A Mysql Database Using Php by pintogen(op): 11:45am On Jan 13, 2009

Connecting to a mySQL database using PHP

Connecting to a mySQL database through PHP first requires knowing what a few parameters are. I suggest making these parameters variables that you can easily change, so that if these parameters change you don't have to go in and alter hundreds (or worse thousands) of mySQL connections inside your scripts. Keep these variables in a setup file and require it or at the very top of scripts you write so you can change them.

// change below is your assigned mySQL username
$user = " ";

// change to the pw below is your assigned mySQL password
$pw = " ";

// change to the database you have permission to connect to
$db = " ";

If you don't know what these values are then consult your host to help you. They should be able to tell you what these parameters are.

SHOW available tables in mySQL database

Similar to opening a file to write to it, you have to open a connection to mySQL before you can do anything. The syntax of this function is as follows:

mysql_connect("localhost OR hostname:port", "httpd OR username", "" or "password" wink

;

<?
$mysql_access = mysql_connect("localhost", "username", "password" wink

;
mysql_close($mysql_access);
?>

The function mysql_close is unnecessary unless you are setting a persistent connection. To set a persistent mySQL connection use:

mysql_pconnect("localhost", "username", "password" wink

;

You would want to use persistent connections where you would have a lot of simulataneous connections from the same user through the script.

The following script below will open your mySQL database connection and show the tables available to you in your mySQL database. You must always open a connection to the mySQL database before doing anything else (you only need to open it at the beginning of a script, and then you can run multiple queries if you want). This is good for testing your ability to successfully access the mySQL database.

$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);

$result = mysql_query("SHOW tables", $mysql_access);
while($row = mysql_fetch_row($result))
{
print("$row[0]<br>" wink

;
}

Using telnet to CREATE tables in a mySQL database

Before you can begin to add data into your mySQL database you need to create a table. You can do this through a script or through telnet. Here's how to do it using telnet.

1. login into telnet.
2. at prompt enter the mysql monitor by typing mysql -p
3. at the password prompt enter your mySQL password.
4. You will be prompted by the mySQL monitor. Type use DATABASENAME where DATABASENAME is the name of your mySQL assigned database.
5. Cut and paste the test table below exactly as below:

CREATE TABLE email
(
ID INT NOT NULL AUTO_INCREMENT,
email VARCHAR(35) NOT NULL,
PRIMARY KEY (ID)
);

You should receive the message like 0 rows affected. Now try entering: SHOW tables;
and you should see the table email now is present. We will use this table for our demonstration below.

How to INSERT new rows (new data) into a table in the mySQL database

The following PHP script (save it as add_email.php3) below demonstrates how to open your mySQL database connection and insert a new email address into the created table email in a mySQL database using PHP scripting. It provides a built-in form to enter email addresses into.

<?
if($email) {
// if $email valid format add email to database
if(ereg("^.+@.+\\, +$", $email))
{
$mysql_access = mysql_connect("localhost", $user, $pw);
mysql_select_db($db, $mysql_access);
$query = "INSERT INTO email ";
$query .= "VALUES(0, '$email')";
mysql_query($query, $mysql_access);
print("successfully added your email to the mySQL database!" wink

;

} else { print("sorry your email address does not appear valid" wink

; }

} else {

print("<form method=\"POST\" action=\"add_email.php3\">" wink

;
print("Please enter your email address: " wink

;
print("<input type=\"text\" name=\"email\" size=\"30\">" wink

;
print("<input type=\"submit\" value=\"submit\"></form>" wink

;
}
?>

How to QUERY rows (existing data) in a table in the mySQL database

Queries can be executed by using the PHP mysql_query function. First you need to build the query. Let's say we entered in abc@123.com into the script above and my email is in the database. Here is how we'd run a query to find if it was entered into the database successfully:

$query = "SELECT email FROM email WHERE email='abc@123.com' ";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
// it is true (the email exists)
print("<strong>$email</strong> exists in the database." wink

;
} else {
// false, so it doesn't exist
}

Now what if we wanted to find all emails from the tdscripts.com domain? Use the code below:

$query = "SELECT email FROM email LIKE '%tdscripts.com' ";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
// it is true, so let's print the results to the browser
while($row = mysql_fetch_row($result))
{
print("$row[0]<br>" wink

;
}
} else {
// false, no results
}

What if we want to find all email addresses that begin with the letter "a"?

$query = "SELECT email FROM email LIKE 'a%' ";
$result = mysql_query($query, $mysql_access);
if(mysql_num_rows($result)) {
// it is true, so let's print the results to the browser
while($row = mysql_fetch_row($result))
{
print("$row[0]<br>" wink

;
}
} else {
// false, no results
}

How to UPDATE rows (change existing data) in a table in the mySQL database

Let's say we mispelled my email address when entering it into the script above. Instead of tdscripts we spelled it tdscipts.com (missing the "r" wink

. Here is how we would build a query to change it.

$query = "UPDATE email set email='abc@123.com' ";
$query = " WHERE email='abc@123.com' ";
mysql_query($query, $mysql_access);

Pretty slick huh? Important note: If you omit the WHERE clause above then it would change every email address in the table to be the same, so be careful not to omit the WHERE clause which effectively singles out a specific row of data.

How to DELETE rows (remove existing data) in a table in the mySQL database

What if we want to remove a duplicate email address from the database? This is a little more tricky since as mentioned above, if you omit the WHERE clause mySQL will remove ALL instances. Fortunately when we CREATEd the email table we used a unique primary key known as ID. So you can remove the duplicate row by using the WHERE clause with the unique ID number. Let's say the duplicate email address is ID 2, here is how we'd construct the query to delete the duplicate email address from the table based on the unique id.

$query = "DELETE FROM email WHERE ID='2' ";
mysql_query($query, $mysql_access);

It is better of course to query the database first before adding data which might be the same as existing data, but this shows how to remove duplicates if should they exist. One last note about DELETE. It is a very powerful SQL function and can erase the entire contents of a table quite easily, so always make sure you use a WHERE clause with it.

How to ALTER (add columns to the existing table) a table in the mySQL database

Let's say we want to add a column to our email table which will datestamp when a new email is added or last updated. Let's use telnet again to do this. Use the following query:

ALTER TABLE email ADD last_update DATETIME;

Now check the rows by using the following query:

SHOW COLUMNS from email;

You will now need to modify your scripts when inserting data, as the new column "last_updated" is present and when using INSERT to add a new row the inserted data must match the fieldtypes. I have modified the script to add an email address now which will also datestamp it when it is added below. It only involves altering the query:

$query = "INSERT INTO email ";
$query .= "VALUES(0, '$email', SYSDATE() )";

Now SYSDATE() will be replaced with a date/time stamp using the server date/time when the email was last added. If you want to update the time just follow the instructions above to UPDATE and make it

set last_update=SYSDATE();

Commenting Your mySQL Tables

I am kind of a nut about keeping good notes in my code, so I like to use those comment tags -- at least in my working versions -- of scripts I write. I may remove some of these comments from public versions, but in my working versions I always keep good notes. When settiing up mySQL tables I like to put that information in between comments tags in PHP as follows:

<?

/* mySQL Table create
USE: tracks ratings at php-scripts.com

create table structure here,

a "test" SQL insert to the database

*/

I always include a test SQL insert statement to show how the data will be inserted into the rows if I was typing it directly into telnet. I am going to use PHP to insert, query, and delete data from the tables, but I want to make sure that I am making a valid insert from telnet, before moving onto creating the PHP code to interact with mySQL. You don't have to do the above step, but when you have problems later on, you can refer to this as a reference point for what each field name is and how to insert information into the table properly. It serves as a pretty decent guide.

Creating mySQL tables

Now let's create a table for the rating box used by php-scripts site. Currently the only thing we track is the vote number. However I would like to add a couple more fields to this. The first is the filename which is the 6 digit date, the second is the vote the user is registering, the third is the unique IP address, and lastly the date/time that they are voting. So basically we are taking all the files and breaking them down into one TABLE with the information. It will look like this

filename | vote | IP address | date/time of vote

This is quite an improvement in tracking information over just tracking the vote and recording in the appropriate file. It may not be apparent how useful this is right now, but it will in future diary entries when you see how we can query this data and present it in interesting ways. Here is how I would go about creating the above table using telnet:

CREATE TABLE rating
(
RATE_ID INT NOT NULL AUTO_INCREMENT,
filename CHAR(6),
vote CHAR(1),
ip_ad VARCHAR(16),
log_date DATETIME,
PRIMARY KEY (RATE_ID)
);

Certification And Training Adverts › Can You Develop Applications With Custom Controls With Scripting? by pintogen(op): 9:32am On Jan 07, 2009

Introduction

This 4-week course provides a comprehensive education in managing and developing web-based applications and services. It prepares participants with knowledge and skills in the area of designing and developing web-based applications and web services. This course will benefit IT application developers of Internet web-based business applications.

Ever wanted to develop an on-line shopping application, build a content management system, create database-enabled websites? Perhaps your business is ready to make its mark on the World Wide Web. Then maybe you've come to the right place, for here you can learn about an exciting new range of short courses proposed for future development within the Faculty of Maths Computing and Technology.

Course Objective
To develop competency in managing and developing a web-based project methodically.

Who Should Attend

Non IT professionals who is looking for foundation/Advance knowldge in Web Application Development
IT professionals who are seeking skills upgrading in the area of web applications/services development.

The topics covered include:

(1) The design, development and management of web applications
(2) Client-side application development
(3) Server-side application development
(4) Databases within web applications
(5) Open source software for web applications
(6) Server administration, performance, and tuning

These are academic courses, not training courses. So whilst you'll encounter development tools such as JavaScript, ASP, PHP, and ColdFusion, the emphasis will always be on the broader issues of planning, designing, and managing. You'll learn something of the strengths and weaknesses of these various tools, you'll even be expected to use them within project work, but in the end the primary aim is to empower you to make decisions that matter.

You can email us at treasurecomputeredu@yahoo.com treasureeduenquiries@yahoo.com
08085370604

Webmasters › Can You Develop Applications With Custom Controls With Scripting? by pintogen(op): 9:24am On Jan 07, 2009

Certification And Training Adverts › Re: Database Management / Web Designing / Web Application Development by pintogen(op): 9:02am On Jan 07, 2009

You are free to ask any question that as to do with Web Application Development with PHP/MYSQL, ASP.NET, JSP, JANASCRIPTS. if you feel the answers i supply you is not enough then you are free to mail me on treasurecomputeredu@yahoo.com for further informations and free materials.

Adverts › Database Management / Web Designing / Web Application Development by pintogen(op): 12:41pm On Jan 05, 2009

Course Benefits

Whether you consider your career a lifelong journey toward personal fulfillment or a way of making ends meet, TreComms Courses helps you reach your career goals by defining the skills necessary to master today's technology-driven world.

Becoming TreComms Student reaps great rewards. Many candidates have experienced greater success in their lives or careers after enrolling Web Technologies courses.

Consider some of the benefits you can earn with TreComms Programme:

Validate and specialize in defined job-role skills.

Add industry-recognized credentials to your resume.

Increase your salary and job responsibilities.

Distinguish yourself from co-workers and earn advancement within your organization.

Keep your skills up-to-date in the evolving technology world.

Professional job-role courses benefit both individuals and employers. For individuals, Web Technologies Course is a gateway to career opportunities and advancement. For organizations,Web Technologies Course is a way to reduce hiring and training costs, and create a properly skilled workforce. Without these benefits, all parties waste time and money with development mistakes, misdirected skills and hiring obstacles.

Benefits for Participants

Job-role Web Technologies Course enhances an individual's career by demonstrating to employers one's readiness to perform the tasks required for real jobs today. Obtaining an industry-recognized Web Technologies Course validates an individual's competence in a set of job-role skills

TreComm Web Technologies Course can:

Validate to employers an individual's IT job skills in various disciplines and at various levels of advancement.

Provide a baseline measurement of these job skills.

Allow portability of these job skills within the industry.

Provide criteria for advancement within an organization.

Benefits for Employers

TreComm Web Technologies Course provides job-role definition and skills standards for companies to meet recruitment needs. TreComm Web Technologies Course also provides industry-recognized objectives and standards for comprehensive educational resources.

Courses within TreComm job-role program can:

Help employers ensure that employees are proficient in the job skills necessary for meeting the company's needs.

Guide companies to utilize industry-sanctioned best practices.

Reduce training costs.

Provide employers with standardized criteria for screening, hiring and/or advancing employees within an organization.

Create a framework to meet workforce needs using public/private partnerships between academic institutions and employers.

Allow companies to distinguish themselves in the marketplace and to customers and suppliers.

Who Should Earn TreComm Web Technologies Programme?

TreComm job-role Courses is important for all types of IT professionals, from career changers and business professionals to experienced and certified IT professionals.

College bound high school students

TreComm prepares high school students with the essential Web-related skills to acquire professional level internships while also earning college credit towards a postsecondary degree, such as an Associate or Bachelor’s Degree.

Job seeking high school students

TreComm teaches only the essential Web-related skills that can position a recent high school graduate to earn a non-exportable, high demand and high wage job. TreComm Courses demonstrates to employers that you are well qualified for a wide variety of Web-related job roles.

Career changers

TreComm Courses is an excellent way to enter the IT industry because vendor-neutral skill Courses address the roles and responsibilities of a specific position. TreComm focuses on industry standards, and leading hardware and software technologies. Career changers are not limited by knowledge of only one IT platform.

Business professionals

TreComm Course demonstrates knowledge of industry standards, best practices, and leading hardware and software technology. Taking the time to learn new IT concepts shows a commitment to keep pace with today's technology-driven economy, to better understand a customer's business, and to become more self-sufficient by better understanding the technology on which almost every professional relies.

Who Should Attend

Non IT professionals who is looking for foundation/Advance knowldge in Web Application Development
IT professionals who are seeking skills upgrading in the area of web applications/services development.

The topics covered include:

(1) The design, development and management of web applications
(2) Client-side application development
(3) Server-side application development
(4) Databases within web applications
(5) Open source software for web applications
(6) Server administration, performance, and tuning

You can email us at treasurecomputeredu@yahoo.com treasureeduenquiries@yahoo.com
08085370604

Adverts › Database Management / Web Designing / Web Application Development by pintogen(op): 12:40pm On Jan 05, 2009

Certification And Training Adverts › Database Management / Web Designing / Web Application Development by pintogen(op): 12:39pm On Jan 05, 2009

Certification And Training Adverts › Re: Web Designing/ Applications Development/database Management by pintogen(op): 3:12pm On Dec 30, 2008

That is a very good start, PHP is object oriented Programming OOP and moreso, its fall under Open source technology, i will advice you start developing something good on it, you can learn JSP later in the advance level

Web Market › Web Designing/ Applications Development/database Management by pintogen(op): 12:10pm On Dec 29, 2008

Webmasters › Web Designing/ Applications Development/database Management by pintogen(op): 12:01pm On Dec 29, 2008

Certification And Training Adverts › Web Designing/ Applications Development/database Management by pintogen(op): 12:01pm On Dec 29, 2008

Adverts › Web Designing/ Applications Development/database Management by pintogen(op): 5:21pm On Dec 28, 2008

Webmasters › Web Designing/ Applications Development/database Management by pintogen(op): 5:03pm On Dec 28, 2008

Certification And Training Adverts › Web Designing/ Applications Development/database Management by pintogen(op): 4:58pm On Dec 28, 2008

Science/Technology › Web Designing/ Applications Development/database Management by pintogen(op): 1:06pm On Dec 18, 2008

Education › Web Designing/ Applications Development/database Management by pintogen(op): 12:54pm On Dec 18, 2008

Adverts › Web Designing/ Applications Development/database Management by pintogen(op): 12:52pm On Dec 18, 2008

Certification And Training Adverts › Web Designing/ Applications Development/database Management by pintogen(op): 12:43pm On Dec 18, 2008

1 2 3 4 5 6 7 8 ... 27 28 29 30 31 32 (of 32 pages)