PHP Archive

createElement PHP PEAR Development

Tue, 27 Sep 2011 04:53:03 GMT

Creates a new form element of the given type. Just like addElement, this method can take a variable number of parameters, depending on the type of element you're creating. object amp createElement mixed element element mixed Either an element object or a string specifying the type of element. If a string, then additional parameters can be included that vary depending on the type of element to add and that are used to create the element.

Calendar.php Apache MySQL and PHP

Mon, 26 Sep 2011 14:45:15 GMT

The following listing shows the final calendar code. Notice that the numbers at the beginning of each line are not part of the code they appear here to aid in the discussion that follows the listing. Display a calendar and allow user to move forward and backward through months via form controls. month last month displayed year last year displayed calendar TRUE if this script is calling, mini to display miniature calendar Form control POST Next Next month Form control POST Prev Previous month...

How to Initialize Your Own library Classes Codeigniter for PHP

Mon, 26 Sep 2011 12:39:08 GMT

Originally, you couldn't make your own classes part of the CI 'super-object'. This was a problem, because it meant that your library code couldn't, for instance, access the database through Active Record, or use other CI libraries, and that became pretty limiting. Version 1.2 added the get_instance function that allows you to access the 'super-object'. See Chapter 7. You could include it in your 'library' or 'script' and then use the CI resources. Unless your new file was a functional script...

getHolidaysForDatespan PHP PEAR Development

Mon, 26 Sep 2011 08:55:17 GMT

Returns an array of Date_Holidays_Holiday objects for the holidays that occur between the two specified dates. If no holidays are found, then an empty array will be returned. array getHolidaysForDatespan mixed start, mixed end , Date_Holidays_Filter filter null , string locale null start mixed The starting date of the time span. end mixed The end date of the time span. filter to use for loading holidays. locale string The locale to use when loading holiday

Creating a Shopping Cart Class PHP 5 Advanced

Mon, 26 Sep 2011 00:23:50 GMT

For the second real-world use of object-oriented programming, I want to implement as a class the shopping cart system created in Chapter 5, E-Commerce Techniques. If you look back at cart.php Script 5.7 , you'll see that the one page does several things Updates the quantities in the cart Removes items from the cart when the user enters a quantity of 0 Displays the shopping cart in an HTML form In an object-oriented structure, this can be implemented in many ways. You could start with an...

My Security Anecdote PHP 5 Advanced

Sun, 25 Sep 2011 23:36:11 GMT

In the summer of 2006, I revamped my company's Web site www.DMCInsights.com , using a modularized layout, to a small extent. Literally the first night the new version of the site went live, someone tried hacking the server by changing URLs like about.php i phpmysql2 into about.php i http somesite.com file.txt. The file.txt script on that other server contained PHP code that would reveal every file on my server. Had it run, my site's security would have been compromised. The attempt did not work...

Dreamweaver Template Builder MamboPHP

Sat, 24 Sep 2011 10:36:37 GMT

Since Macromedia Dreamweaver http www.macromedia.com software dreamweaver is among the market leaders when it comes to professional web editors, there was a Mambo template builder for quite a long time. We are talking about a normal Dreamweaver extension that you can install by means of the Macromedia Extension Manager. The Extension Manager is in the same program group as Dreamweaver itself. Figure 2.14 Macromedia Extensions Manager with the Mambo Plug-in Figure 2.14 Macromedia Extensions...

finderQuery Parameter CakePHP

Fri, 23 Sep 2011 18:44:31 GMT

To produce even more customized results, you may enter a SQL string in the finderOuery key, and it will run when the associated records are queried. You really should need to use this option only if your application requires a high level of database customization. Most of the time, you will be able to work just fine using Cake's built-in model functions. The has many relationship is extremely useful for helping to design effective databases. If you know that you intend to put a select menu in...

tableCells dataarray oddTrAttributesarray evenTrAttributesarray-useCountbool CakePHP

Fri, 23 Sep 2011 18:21:18 GMT

data Table data arranged as rows and columns in an array oddTrAttributes null HTML attributes to be passed to odd rows evenTrAttributes null HTML attributes to be passed to even rows useCount false If true, adds the class name column- plus the number of the row to the lt tr gt element The html- gt tableHeaders function renders only the header row inside a table. Be sure to enter the lt table gt element tags by hand as HTML and include these table functions inside this element. The returned HTML...

Introduction to PEAR Ajax with PHP

Fri, 23 Sep 2011 17:08:32 GMT

As you might imagine, there are plenty of open source libraries available to the PHP language. In fact, one might say that PHP's success as a language is due to the multitude of available resources and the amazing, helpful online community. Because of the large amount of open source development libraries, implementing clean, effective code into your Ajax-based applications is a mere Google search away. However, like anything, some code libraries repositories are better than others. One of the...

C.9.4 Exercise 4 Learning PHP 5

Fri, 23 Sep 2011 12:49:45 GMT

Load the form element helper functions require 'formhelpers.php' if _POST '_submit_check' If validate form returns errors, pass them to show form if form errors validate form The submitted data is valid, so process it process form The form wasn't submitted, so display show form function show form errors '' if errors print 'You need to correct the following errors lt ul gt lt li gt ' print print ' lt li gt lt ul gt ' print ' lt form method POST input submit 'submit','Show File' the hidden...

Displaying the Entire Contents of a Directory PHP PEAR Development

Fri, 23 Sep 2011 12:19:53 GMT

The example shown here demonstrates how to display the entire contents of a directory by using the maptree function to populate two arrays. One array, directories, contains a list of directory names, while the files array contains a list of files found in the directory that is being mapped. Two loops at the end of the example iterate through the two arrays and print their contents. Displaying the entire contents of a directory require_once 'File Find.php' This example will recursively search...

Binding Parameters 2 PHPMySQL

Fri, 23 Sep 2011 07:09:19 GMT

You might have noted in the earlier introduction to the execute method that the input_parameters parameter was optional. This is convenient because if you need to pass along numerous variables, providing an array in this manner can quickly become unwieldy. So what's the alternative The bindParam method. Its prototype follows boolean PDOStatement bindParam mixed parameter, mixed amp variable , int datatype , int length , mixed driver_options When using named parameters, parameter is the name of...

Designing a Better View Codeigniter for PHP

Thu, 22 Sep 2011 18:18:22 GMT

At this stage, you might ask why we are going through so much effort to serve up a simple HTML page. Why not put everything in one file For a simple site, that's a valid point but whoever heard of a simple site One of the coolest things about CI is the way it helps us to develop a consistent structure, so that as we add to and develop our site, it is internally consistent, well laid out, and simple to maintain. At the start, we need three common steps Update our config file to specify where the...

generateTreeList CakePHP

Thu, 22 Sep 2011 11:31:47 GMT

This function is a convenience method for returning a hierarchical array to be used in making HTML select boxes or breadcrumbs. generateTreeList amp model, conditions mixed , keyPath string , valuePath string , spacer string , recursive int conditions null SQL conditions as a string or as an array similar to conditions used in the find model function keyPath null A string path to the key, for example, n .Tag.name valuePath null A string path to the value similar to keyPath spacer '_' For each...

addCrumb namestring linkmixed attributesarray CakePHP

Wed, 21 Sep 2011 15:43:29 GMT

link null Can be keyed in an array for example, or entered as a string for example, ' posts add' if left blank, no link will be rendered around the text attributes HTML attributes to be passed to the lt a gt tag of the crumb Adding the home page of the site to the breadcrumbs array, for example, is simple using this function To display the breadcrumbs, however, you must use the html- gt getCrumbs function. Some parameters exist for the html- gt getCrumbs function to better manipulate how these...

Adding Moving and Removing Notebook Pages Professional PHP GTK

Wed, 21 Sep 2011 13:14:28 GMT

Each page of a notebook has two elements the tab and the content. The page tab is usually a string that describes the contents of the page. The tab is the main method by which a user will select a page. The content of the page can be anything. Usually, the content that is added directly to the page is some sort of container. A page can be added at the beginning of a notebook, at the end of a notebook, or anywhere in between using the methods prepend_page, append_page, and insert_page,...

Interacting with Controllers Codeigniter for PHP

Tue, 20 Sep 2011 02:04:19 GMT

You can call libraries, models, plug-ins, or helpers from within any controller, and models and libraries can also call each other as well as plug-ins and helpers. However, you can't call one controller from another, or call a controller from a model or library. There are only two ways that a model or a library can refer back to a controller Firstly, it can return data. If the controller assigns a value like this fred this- gt mymodel- gt myfunction and the function is set to return a value,...

dependent Parameter CakePHP

Mon, 19 Sep 2011 10:33:06 GMT

When deleting records in a has one relationship, you may want both sides of the association to be deleted. For example, when a user has one profile and the user is deleted, you may want the associated profile to be deleted also. In these cases, the dependent key allows you to do this easily. By default, it is set to false. Set dependent to true to delete records in both tables when the delete action is run through the associated model. In the blog you are building, you have no need of a has one...

One-way communication FlashPHP

Sun, 18 Sep 2011 16:51:37 GMT

One-way communication in Flash is the process of sending data to a Web server and not looking or caring if a response comes back. This is mostly used to open a URL, but could also be used to update a file with no intention of handling the result. This type of communication is often used for simply firing off an event or running some sort of cleaning system. For example, if your site needs periodic file cleaning deleting, renaming, moving , it is a good idea to attach this to the front-end...

The foreachelse Function PHPMySQL

Sun, 18 Sep 2011 07:30:36 GMT

The foreachelse function is used in conjunction with foreach, and operates much like the default tag does for strings, producing some alternative output if the array is empty. An example of a template using foreachelse follows foreach key key item item from titles key item lt br gt foreachelse lt p gt No states matching your query were found. lt p gt foreach Note that foreachelse does not use a closing bracket rather, it is embedded within foreach, much like an elseif is embedded within an if...

Setting Variables PHPMySQL

Sun, 18 Sep 2011 06:40:37 GMT

The SET statement is used to set the value of a declared stored routine variable. Its prototype looks like this SET variable_name value , variable_name value The following example illustrates the process of declaring and setting a variable titled inv It's also possible to set variables using a SELECT INTO statement. For example, the inv variable can also be set like this SELECT inventory INTO inv FROM product WHERE productid MZC38373 Of course, this variable is local in scope to the BEGIN END...

Running SQL statements with MySQLGUI Linux PHP and MySQL

Sat, 17 Sep 2011 01:06:49 GMT

Running a query or other SQL statement is really quite simple with MySQLGUI. Simply type the query into the box as shown in Figure 8-40, using a simple query on the mysql database such as SELECT FROM user. Choose Execute 1 Save , L , . Clear Options tables query queiy 1 j Fuuiul 9 tables Info Figure 8-40 Executing SQL statements with MySQLGUI is easy, as shown by this simple query. You can choose of what you'd like to do with the results from the statement. Figures 8-36 through 8-39 show three...

Understanding How PHP Works with Apache Apache MySQL and PHP

Sat, 17 Sep 2011 00:27:14 GMT

Apache uses MIME types to determine how to serve up specific files. For example, look at the PHP MIME type definition in the Apache configuration file AddType application x-httpd-php .php .phtml Whenever Apache is asked to serve up a file with a .php or .phtml extension, it identifies the file as a PHP file and utilizes the appropriate module the PHP module to help serve it. In PHP's case, the module provides communication with the PHP engine. The engine executes the PHP code and directs any...

Has and Belongs to Many CakePHP

Fri, 16 Sep 2011 22:36:30 GMT

The final association Cake can recognize for database table relationships is the has and belongs to many relationship. This relationship is powerful but also a little difficult to master. The more you experiment with has and belongs to many associations, the easier it will be to use them in your applications. In short, I've already discussed a one-to-one relationship with the hasOne association, and the hasMany association shows you how a one-to-many relationship is managed in Cake. What about...

Acknowledgments PHP Multi-Tier

Thu, 15 Sep 2011 22:13:13 GMT

A book, particularly a technical one, is a collaborative effort. Not only does an author have to consult with other people in his effort to fill the gaps in his knowledge, he must build atop the tangible prior efforts of others. This is particularly true when the author is working with open-source software, which derives from a community. I have benefited from the assistance, direct and indirect, of dozens of people in the course of writing this book. Thanks to Karyn Johnson and the rest of the...

Validating Multiple-Choice Input PHPMySQL

Thu, 15 Sep 2011 14:11:02 GMT

Checkboxes and drop-down lists are an important component of web forms, and it's often necessary to include validation for these controls in your PHP applications. Normally, the user's selections from these controls are submitted to the form processor in the form of an array, and it's necessary to use PHP's array functions to validate them. To see this in action, consider the following script, which requires the user to fill out a brief user profile and select at least three hobbies and two...

Installing a Third-Party Script CakePHP

Thu, 15 Sep 2011 05:51:38 GMT

Now that I've covered the basics of installing a vendor, let's use a third-party script in your blog application. Rather than build a wiki engine from scratch, let's choose one of the many open source text-parsing engines Textile. First, obtain a copy of Textile, which is available at http textile.thresholdstate.com. In this tutorial, I'll be using version 2.0. Once you have downloaded the file and decompressed it, you'll find the main engine file named classTextile.php. Place this file in the...

Using the UNIQUE Modifier PHPMySQL

Wed, 14 Sep 2011 16:39:08 GMT

Using MySQL's built-in validation mechanisms has an important advantage it makes it easy to perform certain types of validation that would be lengthy and time-consuming to write code for. Consider, for example, the situation of ensuring that a particular field contains only unique values. MySQL makes it possible to do this, simply by attaching a UNIQUE modifier to the field, as in the following example - gt username VARCHAR 50 NOT NULL UNIQUE Query OK, 0 rows affected 0.06 sec mysql gt INSERT...

Writing shopping_product_page.inc PHPMySQL

Tue, 13 Sep 2011 23:40:02 GMT

The shopping_product_page.inc and shopping_product_page-oo.inc files are very similar to the catalog_product_page.inc and catalog_ product_page-oo.inc files in Chapter 5. However, a few additions are required that allow the customer to order online. The file with the additions is shown in Listing 6-2. I describe only the lines that are changed in this section. For a complete description of all the lines, see the section Writing the code for the products page in Chapter 5. The file for the...

selectByID PHPMySQL

Tue, 13 Sep 2011 22:50:12 GMT

This method retrieves a single row from the table. The row is identified by its id column. selectBylD doesn't return the content of the row, it returns TRUE or FALSE to indicate whether the requested row was found. If the selectByID function can't find the row that is being looked up, it stores a message in the object explaining that no such object exists in the data that can be retrieved by calling the getMessage method. The following numbers refer to line number in Listing 8-17. 38 Because...

Turning Off Verbose Error Reporting Apache MySQL and PHP

Tue, 13 Sep 2011 14:51:31 GMT

You usually want to turn off verbose error reporting in production scripts. The main reason for this has to do with security you don't want users seeing too much of the man behind the curtain. For example, PHP usually outputs something similar to the following if it fails to connect to a database Warning Access denied for user 'username localhost' Using password YES in var www html errortest.php on line 11 Warning MySQL Connection Failed Access denied for user 'username localhost' Using...

Using Decimal and Comma Separators PHPMySQL

Tue, 13 Sep 2011 13:51:38 GMT

When it comes to formatting numeric values in PHP, there are only two functions number_format and sprintf . Of these, the former is easier to understand and use, so let's begin with that function. The number_format function is used to display large numbers with comma and decimal separators. It can be used to control both the visibility and the appearance of the decimal digits, as well as the character used as the thousands separator. To see how this works, consider the following table mysql gt...

loginHandler method FlashPHP

Tue, 13 Sep 2011 00:00:18 GMT

The loginHandler method is attached to the CLICK event of the loginBtn. This method is called whenever the loginBtn is clicked by the mouse. private function loginHandler e MouseEvent void This method is responsible for checking the username and password fields for valid data. If one of these fields is empty, the function is exited and a response message is displayed below the password field. loginMC.responseTxt.text if loginMC.username.text loginMC.password.text loginMC.responseTxt.text...

... 16 Professional PHP GTK

Mon, 12 Sep 2011 14:59:35 GMT

save reset Modify the button's style. style save- gt style- gt copy Change the normal state. Set the background color to dark blue. blue new GdkColor parse ' 0A0A6A' style- gt bg Gtk STATE_NORMAL blue Make the prelight color white. style- gt bg Gtk STATE_PRELIGHT style- gt white Set the style. save- gt set_style style The label inside the button must be changed too. style new GtkStyle Change the normal and prelight states. style- gt fg Gtk STATE_NORMAL style- gt white style- gt fg Gtk...

Sorting multidimensional arrays PHP 5 Advanced

Fri, 09 Sep 2011 07:39:12 GMT

Sorting arrays is easy using PHP, thanks to the sort , ksort , and related functions. You can sort a one-dimensional array by key, by value, in reverse order, etc. But these functions will not work on multidimensional arrays not as you'd probably like, at least . Say you have an array defined like so a array array 'keyl' gt 940, 'key2' gt 'blah' , array 'keyl' gt 23, 'key2' gt 'this' , array 'keyl' gt 894, 'key2' gt 'that' This is a simple two-dimensional array an array whose elements are also...

The MySQLResultSet Class Object-Oriented PHP

Thu, 08 Sep 2011 08:21:56 GMT

Not surprisingly, the MySQLResultSet class shown in Listing 9-1 has more data members and methods than the MySQLConnect class. However, in many ways, it's a much simpler class and requires much less explanation. To get an overview of this class, find all its data members and methods listed here data members private strSQL private databasename private connection private result public methods public function _construct strSQL, databasename, connection return current record public function getRow...

Creating an RSS Feed PHP 5 Advanced

Wed, 07 Sep 2011 19:21:36 GMT

RSS, which stands for Really Simple Syndication it used to mean Rich Site Summary or RDF Site Summary , is a way for Web sites to provide listings of the site's content. Normally this list contains at least the titles of articles, plus their descriptions and by article, think of any type of content that a site might offer . Users access these feeds using an RSS client many Web browsers support RSS, as well . If they want to read more of an article, there's a link to click, which takes them to...

The Articles Table Apache MySQL and PHP

Wed, 07 Sep 2011 16:41:44 GMT

The articles table is the heart of the system, storing all articles for retrieval via various utility programs. The articles table needs to store the following pieces of data An index to uniquely identify the article The publication date of the article The category to which the article is assigned A short title for the article The full text of the article A field to identify the article as a draft or a final copy The MySQL create statement for this table is as follows idx int 10 unsigned NOT...

Extending Sqlite Object-Oriented PHP

Wed, 07 Sep 2011 14:51:06 GMT

SQLite comes packaged with PHP 5. It has advanced capabilities and a built-in object-oriented OO interface. Examining the classes and methods of SQLite is the ostensible reason for including this chapter but that's not the only reason. SQLite is a great addition to PHP, but because MySQL is so entrenched, programmers tend to ignore SQLite. Don't let the Lite in SQLite lead you to underestimate the capabilities of this database. Because it is bundled with PHP, there is no external server to...

Confirming Important Actions Using a One-Time Token Ajax with PHP

Wed, 07 Sep 2011 10:28:10 GMT

If a user tries to do something that has some importance such as transferring funds, changing password, or buying goods , make them confirm their intentions before processing the transaction. In the preceding example, the Insecure Bank Co. shouldn't have transferred the money to Bob's account so easily. Julie should have been forced to fill out a specific form for the transaction to take place. In this form, you use a one-time token. This is essentially a password that is generated for a...

234 supPart pHpsup PHPMySQL

Tue, 06 Sep 2011 12:29:07 GMT

Listing 8-13 Checking All the Data in Form Fields Description Program checks all the form fields for blank fields and incorrect format. lt head gt lt title gt Check fields lt title gt lt head gt set up array containing all the fields labels array first_name gt First Name, middle_name gt Middle Name, last_name gt Last Name, phone gt Phone foreach _POST as field gt value check each field except middle name for blank fields if field middle_name check names for invalid formats. elseif field...

SHOW GRANTS FOR user Linux PHP and MySQL

Tue, 06 Sep 2011 08:22:16 GMT

The SHOW GRANTS FOR lt user gt statement, which I refer to simply as SHOW GRANTS, enables you to find out quickly the privileges that a given user has on a server and the statements you would have to issue if you were to give that user those same privileges. For example, one task I am confronted with frequently is giving a user access to a new database system as new servers are implemented. The user almost always needs the same access as they have on the existing system. Using the SHOW GRANTS...

To create the configuration file PHP 5 Advanced

Tue, 06 Sep 2011 04:17:13 GMT

1. Begin a new PHP script in your text editor or IDE Script 2.1 . lt php Script 2.1 - config.inc.php Script 2.1 The configuration file is the key back-end script. It defines site-wide constants and dictates how errors are handled. 1 lt php Script 2.1 - config.inc.php 5 Created by Larry E. Ullman of DMC Insights, Inc. 6 Contact LarryUllman DMCInsights.com, http www.dmcinsights.com 7 Last modified November 8, 2006 9 Configuration file does the following things 10 - Has site settings in one...

Using the Amazon Web Service FlashPHP

Sat, 03 Sep 2011 13:00:02 GMT

To get started with creating a developers account, visit the Amazon Web Service AWS page at www.amazon.com gp aws landing.html. j j' J'j Be sure to activate the account via e-mail before you begin to use it. The AWS is set up to be accessed from different mediums. The format used for this example is Representational State Transfer REST , which is basically a formatted URL with all of the necessary information provided in GET format. Here is a sample request sent to Amazon, as shown in Figure...

The MySQLException Class Object-Oriented PHP

Thu, 01 Sep 2011 06:05:05 GMT

You can improve the functionality of a class when using inheritance by adding new methods or changing inherited ones. Changing inherited methods of a class is called overriding. In this particular case, the number of changes you can make to existing methods by overriding them is severely limited because, as you saw in Listing 10-1, there are only two non-final methods of the Exception class the constructor and the_toString method. Let's change both of these class MySQLException extends...

sum PHP Database Applications

Wed, 31 Aug 2011 05:35:49 GMT

The sum function returns the sum of a given column and is almost always used with a group by clause. For instance, if you are running an application for a nonprofit, you might want to know the total contributions from each state. The table you're working with might look like the one in Figure 3-9. http 192.168.1.1 b o o k ch3_fu n cti o ns. p h p q u e ry se I e ct fro m co ntri b uti o ns http 192.168.1.1 Figure 3-9 Table where using sum would be helpful To get the total from each state you'd...

Is It the Holy Grail Object-Oriented PHP

Tue, 30 Aug 2011 14:52:14 GMT

One very legitimate concern might be voiced over the inclusion of the SQLite-specific method sqliteCreateFunction, and this is certainly not the only database-specific capability provided by PDO.3 Doesn't providing database-specific functionality do exactly what we refrained from doing at the start namely, extending the PDO class The short answer is, unquestionably, yes. But the whole notion of a perfect database abstraction layer is a Holy Grail glimpsed here and there but never grasped....

Your first database Dynamic Web Sites

Tue, 16 Aug 2011 20:17:09 GMT

Now that we have PHP running properly and have created our first script, let's create our first database and see what we can do with it. Drop to console and type in the following command This creates a database named learndb for us to use. Here we have assumed that you are root user. If you are logged in as another user, just use the command mysqladmin -uusername -pyourpassword create learndb, replacing username and yourpassword with your username and password respectively. If you are hosting...

allow_call_time_pass_reference On Off PHPMySQL

Tue, 05 Apr 2011 19:16:29 GMT

Scope PHP_INI_SYSTEM Default value On Function arguments can be passed in two ways by value and by reference. Exactly how each argument is passed to a function at function call time can be specified in the function definition, which is the recommended means for doing so. However, you can force all arguments to be passed by reference at function call time by enabling allow_call_time_pass_reference. The discussion of PHP functions in Chapter 4 addresses how functional arguments can be passed both...

The Test Suite Codeigniter for PHP

Tue, 05 Apr 2011 15:40:30 GMT

Remember those 'test blocks' in the delete function Their purpose is simply to detect if the function is being run 'for real' or for a test, and, if the latter, to make sure that it returns a value we can easily test. This is all because, at the end of the CRUD model, we have a 'self-test' suite. This is called by the test function in any controller it doesn't matter which one and performs generalized CRUD tests using a dummy table. First in the CRUD class there is a master 'test' function,...

string 2 XML and Web Services

Mon, 04 Apr 2011 21:01:21 GMT

A string element is used for the string data type. In PHI many things are strings. No date or binary types exist, because these are handled using strings. As you will see with the next two types, you do not always have a direct one-to-one mapping of a native PHP data type to an XML-RPC type. In terms of usage within PHP you can use the string element when the data is to be interpreted textually rather than what is held within the string, such as a date time value. This is the syntax PHP Data...

Caching a template fragment SymfonyFramework

Sun, 03 Apr 2011 17:07:38 GMT

Many times the slot and page types will be too large for the templates of an application. For instance, the list of users can show a link of the last accessed user, and this information is dynamic. Would that mean that nothing can be cached Thankfully not. Symfony allows you to cache fragments of a template with the cache helper. The listSuccess.php template could be written as follows lt php echo link_to 'last accessed user', 'user show id '. last_accessed_user_id gt lt uncached HTML gt lt php...

Creating a MySQL Database PHPMySQL

Sun, 03 Apr 2011 12:59:14 GMT

You're going to create a database called store. The CREATE DATABASE command works like this If this works, you'll get a result like this one Database names cannot contain any spaces. On Unix servers, such as Linux and Mac OS X, database names are also case-sensitive. To start using this database, type USE store You will get the result Database changed. Assuming you've done everything correctly, you'll be set up with new data, and it will be selected for use. Creating tables to hold data is an...

Building the CMS Application Procedural Approach PHPMySQL

Wed, 30 Mar 2011 19:04:12 GMT

The CompanyHome.php file contains the logic for organizing the data for the main display of the CMS. It figures out whether the user is looking at the main page, a department-level page, a content list page, or a detail page. It fills in elements of the page array. The page array is used in the company.inc program to construct the HTML display. This CMS intranet Web site requires that the people browsing it are registered users who have logged in to the system. Some intranet sites require only...

DOCMan MamboPHP

Mon, 28 Mar 2011 16:45:45 GMT

There are two approaches to the topic of document administration on the one hand, there are large commercial solutions such as Documentum http www.documentum.com and OpenText http www.opentext - de , which are geared to profoundly influence the processes of an enterprise on the other hand, there is the simple administration of downloads, which is standard fare with a CMS such as Mambo. A middle approach between these two is being offered by the DOCMan Mambo extension. It administers files and...

Multipurpose Pages DatabaseWebsite

Mon, 28 Mar 2011 04:11:23 GMT

Let's say you wanted to construct your site so that it showed the visitor's name at the top of every page. With our custom welcome message example above, we're halfway there already. Here are the problems we'll need to overcome to extend the example We need the name on every page of the site, not just one. We have no control over which page of our site users will view first. The first problem isn't too hard to overcome. Once we have the user's name in a variable on one page, we can pass it with...

The bindModel Function CakePHP

Sun, 27 Mar 2011 00:24:40 GMT

Just as the unbindModel function helps you kill associations on the fly, the bindModel allows you to assign associations as well. Again, this function operates for just one query and then ceases to affect other succeeding model functions. This function follows the same syntax as the unbindModel function and contains two arrays one for the association to be bound to the current model and another for the models to be assigned to the association.

Writing the Programs 3 PHPMySQL

Sat, 26 Mar 2011 20:42:23 GMT

After you know what the pages are going to look like and what they are going to do, you can write the programs. In general, you create a program for each page, although sometimes it makes sense to separate programs into more than one file or to combine programs on a page. See Chapter 10 for details on how to organize applications. As I discuss in Chapter 10, keep the information needed to connect to the database in a separate file and include it in the programs that need to access the database....

toNumeral PHP PEAR Development

Thu, 24 Mar 2011 23:41:46 GMT

Converts a decimal number into a string that represents a Roman numeral for example, 6 is converted to VI. string toNumeral integer num, boolean uppercase true , boolean html true A decimal number, such as 10, 100, or 1211. If true, the Roman numeral string that's returned will be If true, the string that is returned will use HyperText Markup Language HTML formatting to place the bars above and

Symfony CakePHP

Thu, 24 Mar 2011 13:50:23 GMT

Symfony entered the PHP frameworks arena early on and has remained popular. Its community is also large with developers groups, forums, a chat room, a wiki, and more. All of the main links to these various online groups and sites are available on Symfony's community web page Symfony actually is much different from CakePHP in its approach. In this book, I showed how to create a Cake project by renaming a folder and placing it on your server or localhost. In Symfony, you learn important commands...

myPlayer.stop FlashPHP

Thu, 24 Mar 2011 03:43:40 GMT

For simplicity, the video player component has the ability to be skinned, which means you don't have to design a custom interface. This custom skin loads in a default set of playback controls. In fact, Adobe offers a large list of skins, each in different colors or with various selections of buttons and functionality For example, here is the most common example used. This skin is a full set of controls that is placed underneath the video player component. Seeing as this skin has basic playback...

Form Validation 2 Ajax with PHP

Wed, 23 Mar 2011 22:53:01 GMT

Form validation well, validation period is what I believe separates the slackers from the true development professionals. Your application will only run as well as the code that implements it, and such success is partly defined by being aware of what errors could potentially occur as well as how to deal with them should problems arise. In the development world, handling errors and unplanned actions is called validation. There are two ways to validate input client-side and server-side....

returnSelect PHP PEAR Development

Wed, 23 Mar 2011 09:55:18 GMT

Returns a string containing a select input type, either as a drop-down menu or as a list of selectable options. string returnSelect string name, array entries , mixed default null , integer size 1 , string blank '' , boolean multiple false , string attr '' An associative array of the entries, where the key is used as the option value, and the value of the array is used as the displayed text. The number of rows in the select element to display. A value of 1 shows a drop-down list any other value...

Normalization Linux PHP and MySQL

Tue, 22 Mar 2011 20:52:54 GMT

Long the woe of many a college student learning database concepts, normalization is the practice of getting a database design into a format with no duplications or redundancy of data within the database so the database operates as efficiently as possible. This has obvious benefits of efficiency. However, it can also prevent catastrophic inconsistencies. There are five forms that a data model passes through on its way to being normalized. For our purposes, I'll deal with only the first three...

sqlite_escape_string PHP and PostgreSQL 8

Tue, 22 Mar 2011 11:21:09 GMT

string sqlite_escape_string string item Some characters or character sequences have special meaning to a database, and therefore they must be treated with special care when trying to insert them into a table. For example, SQLite expects that single quotes signal the delimitation of a string. However, because this character is often used within data that you might want to include in a table column, a means is required for tricking the database server into ignoring single quotes on these...

PHP Variables Apache MySQL and PHP

Mon, 21 Mar 2011 09:51:00 GMT

PHP denotes variables with a dollar sign. Variable names can be any length and contain numbers, letters, or underscores. Variable names must start with a letter or an underscore they cannot start with a number. Examples of valid variables include the following You can use variables to store text, integers, or floating-point values. Because PHP variables are untyped, you can store any type of data in any variable and even store multiple types of data in the variable. For example, any of the...

Display ImageMagick

Fri, 18 Mar 2011 12:08:12 GMT

The display utility is the basic ImageMagick program for showing images or image sequences like all the .png files in a directory on a X server. So it works only on X servers and if you run it on Windows the following error message box will be displayed Fig 5-1 The Error Message when Windows is not Running an X Window Server such as Xwin32 Fig 5-1 The Error Message when Windows is not Running an X Window Server such as Xwin32 For ImageMagick users running Windows there is a corresponding...

Php-gtk PHP 5 Advanced

Thu, 17 Mar 2011 10:53:42 GMT

GTK , which stands for GIMP Tool Kit GIMP being the GNU Image Manipulation Program , is an open-source toolkit that works on multiple platforms. This resource makes it easy for programmers to generate graphical elements windows, buttons, and so on for their applications. The GTK home page, www.gtk.org, describes the system's origins and usage but from a C programming perspective GTK, like PHP, is written in C . The PHP-GTK Web site, http gtk.php.net Figure 10.10 , discusses how GTK can be used...

Link helpers SymfonyFramework

Wed, 16 Mar 2011 04:00:39 GMT

The url_for helper returns an URL, the link_to helper returns a hyperlink. You may never use the Templating in practice Link helpers 80 282 first one, but you will use link_to a lot. lt php echo gt will generate in HTML lt php echo link_to 'interesting article', 'article read title Finance_in_France' gt will generate in HTML Notice that the default routing rules transform all the , and amp characters into . Also note that the link_to helper gives a bonus title attribute for the lt a gt tag,...

Your Own Template MamboPHP

Sat, 12 Mar 2011 10:48:22 GMT

There are two ways to get started with your own layout You can either copy an existing layout and modify it or you can create a completely new one. The latter is naturally substantially more complicated, but it is the only way to achieve independent results. In this section we will first see the components of a template, and then generate a very simple template step by step. In doing this, we do not attach great importance to HTML and CSS programming, only to the basic principles. You can find...

Summary 13 Professional PHP GTK

Thu, 10 Mar 2011 17:43:19 GMT

To receive drop data, a widget must be set as a destination. This is a simple matter of calling drag_dest_set. Of course, the widget must also be set up to handle the incoming data, and that can be done by creating a signal handler for the drag-data-received signal. A source of drop data is created using drag_source_set. The data that a source gives to the destination needs to be set in the signal handler for the drag-data-get signal. DnD is a powerful means to make an application more...

Drag Destination Targets Professional PHP GTK

Thu, 10 Mar 2011 17:30:45 GMT

The second argument to drag_dest_set targets is an array of targets that the widget should accept. The targets are not specific items, but rather types of items. Each element of the array is called a target entry. Each target entry is itself an array consisting of a string and two integers. The string indicates the MIME type of the data that is acceptable to drop in the destination widget. Listing 13-1 sets this to text uri-list. This means that only lists of URIs strings that give the location...

Caution Using the xmlrpc_set_type function to create datetime and base64 data types will convert t XML and Web Services

Wed, 09 Mar 2011 19:58:10 GMT

When decoding an XML structure, unless absolutely positive that it does not contain a dateTime.iso8601 or base64 type, you should check the type of variable. Any data of these types would be returned as objects. The values for these data types must be read through the object properties as follows xmlrpc_type The data type set using xmlrpc_set_type . scalar The value for the data returned as a PHP string. timestamp This property is valid only for date time data and is the value of the scalar in...

Creating Breadcrumbs from Database Table Data PHP and PostgreSQL 8

Wed, 09 Mar 2011 08:48:47 GMT

In the previous section, you learned how to use arrays in conjunction with URLs to create navigational trails. But what about generating breadcrumbs based on data stored within a database For example, consider the following URL How would you go about translating this URL into the following breadcrumb trail Home gt Books gt Beginning PHP 5 and PostgreSQL 8 At first glance, it would seem that you could use the first breadcrumb implementation. After all, it seems as if a simple translation is...

Installing MySQL on Windows 2000 Linux PHP and MySQL

Wed, 09 Mar 2011 07:52:17 GMT

Installation of MySQL on Windows 2000 is incredibly simple. MySQL AB has gone to great lengths to ensure a hassle-free installation process. The first step is to download the installation files or use the ones you can find on the CD-ROM with this book. The MySQL binary version for Windows is on the CD-ROM that accompanies this Once the files are downloaded or copied, you'll need a program such as WinZip to uncompress the installation files see Figure 4-13 . Double-click setup.exe to start MySQL...

Yes But...What is CodeIgniter What are Frameworks Codeigniter for PHP

Tue, 08 Mar 2011 17:08:26 GMT

Shortly after programming was invented, someone noticed that it involved many repetitive operations. And shortly after that, someone else maybe it was Ada Lovelace, spanner in hand, adjusting Babbage's differential engine, or maybe it was Alan Turing at Bletchley Park decided to modularize code, so you only had to write certain chunks once, and could then re-use them. PHP programmers are used to writing separate chunks of code in functions, and then storing those functions in include files. At...

Creating Individual Views CakePHP

Sun, 06 Mar 2011 12:43:52 GMT

What do you do if you want to manipulate the views directly For example, say you wanted to get rid of the title at the top that reads Posts and replace it with Blog Posts. This is where individual views come in. Yes, the scaffolding is a nice feature that makes testing code quick and painless, especially if all you want to do is play around with the database to make sure it's working right. But it can't possibly read your mind, and it can create only some generic views. Adding or subtracting...

Working with Forms Apache MySQL and PHP

Thu, 03 Mar 2011 21:59:20 GMT

Understanding how PHP handles form data I TML forms provide an excellent framework for receiving data from users. They provide tJ a data entry GUI, rudimentary error checking, and can be used to pass the received I data on to a script where the data can be parsed, stored, and so on. 30 Min. This session reviews HTML forms and how PHP can be used as a form handler to receive To Go and use the data from the forms. Before delving into how PHP works with forms, you should understand how HTML forms...

Parsing Data XML and Web Services

Thu, 03 Mar 2011 16:59:50 GMT

Unlike the other XML-based extensions, the xml extension parses only string data. Files containing XML must be read and sent to the parser as strings. This doesn't mean, however, that all the data must be sent at once. Remember, SAX works on streaming data. The function used to parse the data is xml_parse , with its prototype being as follows int xml_parse resource parser, string data , bool is_final The first parameter, parser, is the resource you have been working with throughout the chapter....

Configuration 3 MamboPHP

Wed, 02 Mar 2011 13:06:34 GMT

You can find the Simpleboard configuration under Components Simpleboard Forum. An interface with its own control panel can be opened there. To go back at any time, use the Back button or the Mambo menus, which are still shown. Figure 6.3 The start point is the Simpleboard administration interface Figure 6.3 The start point is the Simpleboard administration interface For a change, you should first have a look at the bottom row. If you are starting without an exact conception of your future...

To use cURL PHP 5 Advanced

Wed, 02 Mar 2011 06:31:45 GMT

1. Create a new PHP script in your text editor or IDE, beginning with the HTML Script 9.4 . lt DOCTYPE html PUBLIC - W3C DTD lt html xmlns http www.w3.org 1999 xhtml xml lang en lang en gt lt meta http-equiv content-type content text html charset iso-8859-1 gt lt title gt Using cURL lt title gt lt head gt lt body gt url 'http localhost login.php' curl curl_init url You don't have to assign the URL to use to a variable prior to the curl_init line, of course. But do make sure you change this URL...

Wizard Step 1 How to Receive Images ImageMagick

Wed, 23 Feb 2011 19:31:26 GMT

The first step involves deciding on an image source. There are three possible resources for input images So the first step will need the following code in order to create a selectable resource page lt title gt My Ecards lt title gt lt meta http-equiv Content-Type content text html charset windows-12 56 gt lt META content MSHTML 6.00.2900.2802 name GENERATOR gt lt head gt lt body bgcolor ffffff leftmargin 0 topmargin 0 marginwidth 0 marginheight 0 gt font face Times New Roman, Times, serif size...

An Example of a CI Helper the URL Helper Codeigniter for PHP

Wed, 23 Feb 2011 18:37:42 GMT

As an example of the way you can split your code up into neat, focussed, chunks, CI's URL helper contains a set of functions that help you to manipulate URLs. You load it like this And then, you can use it to find and return the site and or base URLs that you set in your config file You can also use it to create hyperlinks. We saw in the last section how you can access the hello function in the start controller, and pass it the parameter fred, with a URL like If you want your own code to create...

MySQL 4.1.x and Later phpMyAdmin

Tue, 22 Feb 2011 18:33:06 GMT

Since MySQL 4.1.x, the MySQL server does the character recoding work for us. Also, MySQL enables us to indicate the character set and collation for each database, each table, and even each field. A default character set for a database applies to each of its tables, unless it is overridden at the table level. The same principle applies to every field. Since phpMyAdmin 2.6.0, support for MySQL 4.1.x character set and collation features is no longer experimental, as it was in previous versions....

Recipe 4.8 Appending One Array to Another TipsTricks

Mon, 21 Feb 2011 20:21:54 GMT

You want to combine two arrays into one. garden array_merge fruits, vegetables The array_merge function works with both predefined arrays and arrays defined in place using array p_languages array 'Perl', 'PHP' p_languages array_merge p_languages, array ,Python' print_r p_languages Array Accordingly, merged arrays can be either preexisting arrays, as with p_languages, or anonymous arrays, as with array 'Python' . You can't use array_push , because PHP won't automatically flatten out the array...

myisamchk PHPMySQL

Sun, 20 Feb 2011 01:33:58 GMT

Although it is widely acknowledged that MySQL is quite stable, certain conditions out of its control can result in corrupt tables. Such corruption can wreak all sorts of havoc, including preventing further insertions or updates, and even resulting in the temporary and in extreme cases, permanent loss of data. If you experience any table errors or oddities, you can use the myisamchk utility to check MyISAM table indices for corruption, and repair them if necessary. It's invoked using the...

Installing Magpie PHPMySQL

Sat, 19 Feb 2011 09:29:50 GMT

Like most PHP classes, Magpie is as simple to install as placing the relevant files within a directory that can later be referenced from a PHP script. The instructions for doing so follow 1. Download Magpie from http magpierss.sourceforge.net . 2. Extract the package contents to a location convenient for inclusion from a PHP script. For instance, consider placing third-party classes within an aptly named directory located within the PHP_INSTALL_DIR includes directory. Note that you can forgo...

Modularizing a Web Site PHP 5 Advanced

Fri, 18 Feb 2011 10:20:17 GMT

In my experience, the arc of a programmer's development starts with writing one-page applications that do just a single thing. These turn into two-page tools, and eventually into multipage sites, using templates, sessions, and or cookies to tie them all together. For many programmers, though, the arc is actually a bell curve. After more and more experience, the seasoned PHP developer starts doing the same amount of work in fewer pages, like having the same script both display and handle a form....

Introduction ImageMagick

Thu, 17 Feb 2011 15:39:55 GMT

In 1999 the ImageMagick Studio LLC developed a graphical application named ImageMagick for working on images. ImageMagick is a powerful collection of tools and libraries to read, write, and manipulate images in close to a hundred formats. The question, is what is the point of using ImageMagick when there are so many professional image processing programs like Adobe Photoshop or Macromedia Freehand Maybe one good reason is ImageMagick's powerful utilities and interfaces. From a user's point of...

Identify ImageMagick

Thu, 17 Feb 2011 09:05:41 GMT

Identify is one of the special utilities in ImageMagick because, unlike other utilities, it works on image characteristics and specifications. There is a lot of helpful information that identify can retrieve from an image and display at the command line. Beside image characteristics it can find out if an image is corrupted and report it. Moreover there is an option named -list which can be found in other utilities as well that helps us to find out more information about the ImageMagick software...

mktime PHP and PostgreSQL 8

Fri, 11 Feb 2011 12:05:36 GMT

int mktime int hour , int minute , int second , int month , int day , int year , int is_dst The mktime function is useful for producing a timestamp, in seconds, between the Unix epoch and a given date and time. The purpose of each optional parameter should be obvious, save for perhaps is_dst, which should be set to 1 if daylight savings time is in effect, 0 if not, or -1 default if you're not sure. The default value prompts PHP to try to determine whether daylight savings is in effect. For...

To create the database 2 PHP 5 Advanced

Tue, 08 Feb 2011 21:35:18 GMT

1. Connect to your server via a command-line interface and connect to MySQL. If you'd rather, or are forced to, use phpMyAdmin or whatever other tool instead, that's fine. 2. Create the database. CREATE DATABASE ecommerce 3. Choose the database Figure 5.1 . USE ecommerce 4. Create the customers table Figure 5.2 . CREATE TABLE customers customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR 40 NOT NULL, pass CHAR 40 NOT NULL, first_name VARCHAR 20 NOT NULL, last_name VARCHAR 30 NOT...

Convert and Mogrify ImageMagick

Thu, 03 Feb 2011 08:53:42 GMT

We learned from Chapter 1 that any image processing activity in ImageMagick can be done using its utilities. The convert utility is one that contains many parameters for implementing more than seventy percent of ImageMagick features. We can see that mogrify is similar to convert in some situations. These utilities will be studied in depth in this chapter and we will get familiar with their image processing and other capabilities. We will concentrate on parameters and their practical usage....

Calendar.php 2 Apache MySQL and PHP

Tue, 01 Feb 2011 21:44:08 GMT

The calendar script was not set up to handle appointments it was a simple display-only model. However, the changes needed to make it work with this new project are very simple. Construct a valid name value pair for inclusion in the hyperlink and surround your numeric date display with the appropriate anchor tags to make it a hyperlink. The following code snippet shows the additional code in bold. This code replaces lines 203-211 in the final calendar.php code listing in the previous session....

Machines Talking to Machines AgainXML-RPC Codeigniter for PHP

Tue, 01 Feb 2011 17:12:16 GMT

The Web 2.0 revolution is largely built on machine-to-machine interfaces, which allow mashups and APIs and all those good things. This is the basis of 'web services'. You can offer an interface to your site that allows other people to use it to do something for them. To give a simple example, if you set up a 'web service' that converts temperatures in centigrade to Fahrenheit, the client sends in a request with one parameter the temperature to be converted and the server returns the converted...

Testing the application PHP 5 Advanced

Sat, 29 Jan 2011 16:49:49 GMT

That's it You've now created an entire Ajax application from scratch. You have created four files These should all be in the same folder in your Web directory. Now, to test the applica-tion but first If yours does not work as it should as it does in the following figures , you'll need to use some good old-fashioned debugging work to solve the problem. I discuss how to debug Ajax applications at the end of this chapter. Figure 13.16 The result without reloading the Web page if a username is...

11.4 Exercises Learning PHP 5

Wed, 26 Jan 2011 04:38:16 GMT

1. Using the XML document in the menu variable defined in Example 11-5, print an HTML lt ul gt list in which each list element is the lt title gt of one lt item gt in the XML document, and that lt title gt is hyperlinked to the URL listed in the lt link gt element of the item. For example, if one of the items were 3. lt title gt Steamed Rock Cod lt title gt 5. lt description gt Enjoy a cod, bursting with flavor. lt description gt lt item gt Then the corresponding list element that your code...

The Code Object-Oriented PHP

Wed, 26 Jan 2011 01:21:10 GMT

Go ahead and download the code for your page navigator, and look it over. Notice that there are considerably more data members than in other classes discussed so far. Names have been chosen in an attempt to make the purpose of the variable explicit, and related variables have been grouped. We'll discuss these variables in the order in which they appear in the class file. The variable pagename is the name of the page that will contain the page navigator control. It could be replaced by _SERVER...

Common command-line options for mysqld 2 Linux PHP and MySQL

Tue, 25 Jan 2011 04:48:09 GMT

The default server executable file for MySQL in Windows 2000 is called mysqld-nt. Some of the options you can set or call when you run mysqld-nt actually change the behavior of the server. In addition, many options can be set inside the my.ini file located in the WI NNT directory or sometimes in just the root directory . Note strongly recommend that you don't make a batch file or script to start MySQL instead, use the my . i ni file for changing the command-line behavior of MySQL. The my.ini...

Condition PHP For Flash

Thu, 20 Jan 2011 23:16:21 GMT

M for lt 5 count 1 Jcount lt 1 3 1 Yes, you've guessed it This does exactly the same as the two preceding examples. If you look closely at the examples you'll see that all we've done is move all the statements referring to the loop control variable within the for loop. The easiest way to think of an array is as a list of variables all referenced by the same name. In order to access the individual variables or elements in an array we use what is known as array index notation. In PHP, the...