PHP Web Hosting, Tomcat, JSP, J2EE, Servlets, Struts - PHP4, PHP5 Programming Blog

WHERE article_id= . $_GET[ article ]; $result = mysql_query($sql, $conn) or die( Could not retrieve article data; . mysql_error()); $row = mysql_fetch_array($result); $title = $row[ title ]; $body = $row[ body ]; $article = $_GET[ article ]; $authorid = $row[ author_id ]; } Load the prerequisite header.php: require_once header.php ; What follows is more standard HTML stuff. You know what htmlspecialchars() does, don t you? Of course you do. If not, go back a page or two and review. ?>

Figure 13-7 How It Works You re almost there. Next, you tackle compose.php, the page where you create new articles. First, initialize the variables you are going to be using: If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.

$title = $row[ title ]; $body = $row[ body ]; $article = $_GET[ article ]; $authorid = $row[ author_id ]; } require_once header.php ; ?>

Compose Article

Title:
>

Body:
<?php echo htmlspecialchars($body); ?>

n ; if ($_SESSION[ access_lvl ] < 2) { echo n ; } if ($article) { echo n ; } else { echo n ; } ?>

2. Click the Compose link to load compose.php (see Figure 13-7). 3. Enter a title and some text for the article. When you are done, click Submit New Article. You will be taken back to the index page, but there will still be no article. The article you just wrote is pending review. 459 Building a Content Management System
We recommend high quality webhost to host and run your jsp application: christian web host services.

First you display the page title: ?>

User Administration

Then you loop through the code three times, running the function each time with a different level value:

. $a_users[$i] .

n .

n ; } ?> And then you re done.
Article Publishing You have all these transaction pages and user account maintenance so far, but nothing that would put your application squarely into the CMS category. Well that s all about to change! In this section you ll be creating the pages that allow you to create, review, read, and comment on articles. On to the articles! Try It Out Creating an Article In your first step toward having content, you re going to create the page that allows you to actually write out the articles and save them to the database. 1. Create a new file and name it compose.php: We highly recommend you visit web and email hosting services if you need stable and cheap web hosting platform for your web applications.

Hey, a function. Shouldn t this go in an include file, such as outputfunctions.php? Perhaps, and you could certainly do that if you wanted to. However, this function is very specific to this file, so it really doesn t need to go in an include file. It s up to you, really. function echoUserList($lvl) { To use the array you created earlier within this function, you must declare it global. Now the function can access the data in the array. global $a_users; This function will be called more than once. Each time, a different value will be contained in the $lvl variable. The following SQL pulls the appropriate data according to the $lvl value: $sql = SELECT user_id, name, email FROM cms_users . WHERE access_lvl = $lvl ORDER BY name ; $result = mysql_query($sql) or die(mysql_error()); If no users are found in the database for this access level, you display a message explaining that those users were not found. You do this by using the array you created earlier: if (mysql_num_rows($result) == 0) { echo No . $a_users[$lvl] . created. ; Auser cannot modify his or her own record. Instead, his or her name is shown in plain text, with no link. } else { while ($row = mysql_fetch_array($result)) { if ($row[ user_id ] == $_SESSION[ user_id ]) { echo htmlspecialchars($row[ name ]) .
n ; Otherwise, the user s name is displayed on the screen, as a link that loads useraccount.php. } else { echo . htmlspecialchars($row[ name ]) .
n ; } Here s the end of the function. Note that nothing has been output to the screen yet. } } } 457 Building a Content Management System
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.

Figure 13-6 How It Works Guess what? You guessed it. Our good friends conn.php and header.php are back. Okay, let s move on. Users , Moderators , Admins ); 456 Chapter 13
In case you need quality webspace to host and run your web applications, try our personal web hosting services.

echoUserList($i); echo n

Then cycle through each one, displaying them as radio buttons on the page. while ($row = mysql_fetch_array($result)) { echo . $row[ access_name ] .
n ; } The next page requires the user ID. Because this is not entered in a form field, create a hidden field to carry the data over to the transaction page. ?>

>

A short but sweet PHP tag ends the first part of the if statement and adds an else clause. This is a very flexible way of using if…else commands with standard HTML. Because you can enter and exit PHP at any time, your pages are very flexible and easy to read. The rest of this code is loaded if you are not an admin type. If you are not an admin, you must be here to create a new account. Therefore, it asks you for your password:

Password:

Password (again):

Then comes the end of the if statement and the end of the form:

453 Building a Content Management System
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.