-
PHP Projects Join Forces To Go PHP 5
(News)
-
The Symfony, Typo3, phpMyAdmin, Drupal, Propel, and Doctrine projects have all announced
that their next release after February 5, 2008 will require PHP version 5.2 as part of a
coordinated effort at GoPHP5.org, and have issued an open invitation to any other PHP
projects and applications, both open source and proprietary, that want to participate in the
effort.
Most PHP-based web applications today run in both PHP version 4 and PHP version 5. PHP
4 was released in 2000, and quickly cemented itself as one of the dominant web development
languages. Version 5 was released in 2004 with dramatic improvements in functionality, but
adoption has been slow due mostly to the "chicken and egg" problem that accompanies many
new platform releases.
"Most of the PHP developers I talk to want to use PHP 5 but can't because so many web
hosts offer PHP 4 by default," said Larry Garfield, a Drupal developer and one of
GoPHP5.org's founders. "The hosts won't upgrade until projects do, but projects won't
upgrade until the hosts do. That has made a lot of projects reluctant to be the first to drop
support for PHP 4, so we've decided that we will all be first."
By pre-announcing plans to require PHP 5.2 in upcoming software versions in 2008, GoPHP5
hopes to provide web hosts with the incentive to upgrade their servers to newer, more stable,
more feature-rich versions of PHP as well as sufficient time to do so. Users that are already
using current versions of participating projects won't be left out in the cold, either. All involved
projects will continue to support current releases on PHP 4 for their normal life cycle, giving
both users and hosts time to plan and implement an upgrade.
"The phpMyAdmin project is very enthusiastic to join the GoPHP5 initiative," added
phpMyAdmin's project lead, Marc Delisle. "We see GoPHP5 as a way both to improve our
product's new versions — not always having to add workarounds to remain PHP4compatible
— and improve the experience of our users — by projecting the correct message about the
PHP system itself and its evolution."
PHP 5 offers developers a wide array of features designed to make developing fast, modern
web applications faster and easier. That includes vastly improved XML handling for Web
services, an integrated SQL database called SQLite, better handling of time zones,
dramatically improved security tools, stronger object-oriented functionality, and more.
Many PHP projects already require PHP 5. Encouraging a larger installed base of PHP 5 will broaden the market for those projects as well. PHP is a widely-used general purpose scripting language that is especially suited for Web development. PHP is one of the leading web development languages in the world, running on a third of the world's web servers. It is the platform of choice for companies from Yahoo to Facebook as well as the most widely available development platform on shared hosting,
which powers millions of web sites world wide.
For more information:
http://gophp5.org/
http://www.phpmyadmin.net/home_page/gophp5.php
http://drupal.org/gophp5
Press Contact:
larry.garfield@gophp5.org
Generated on July 10, 2007.
-
Using PostNuke and MySQL in Unicode (UTF-8)
(News)
-
MySql and UTF-8
by: Bernd Plagge
www.choicenet.ne.jp
MySql introduced support for different character sets and collating rules in version 4.1. While this has many advantages databases sometimes need to be migrated and then we have to ensure that the correct character code is set for the new database. We are mainly using UTF-8 and hence you may have to adapt this information to your situation!
What is the problem?
MySql uses as default Latin1, swedish flavour.
How do we check this?
run mysql.
mysql> show variables;
How to check the character set for a particular database?
run mysql.
mysql> show create table
The character code can be set in various places - so where is the best place for this?
We always use UTF-8
------------------------
In this case it makes sense to set the character code for the whole server to UTF-8. MySql actually sets the character code at different levels:
server
client
database connection
database
The character encoding for server, client and the connection work hand in hand to ensure that the data is interpreted correctly. It seems that MySql makes no effort to determine the correct character set but will convert data in accordance with it's configuration. This leads to problems for old databases if the database character code differes from the one configured.
The easiest way to configure MySql for UTF-8 is to put the configuration inot the main configuration file (/etc/mysql/my.cnf).
In my.cnf there are different file sections. So you can't put it just anywhere.
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
Setting UTF-8 for one Database
--------------------------------------
You can check the default character code for a database either by dumping the data and then changing the schema file or you can do this online.
You use the 'alter table' statement to change the database using mysql.
run mysql
alter database
default character set utf-8
default collotion_name utf8-general_ci;
note: you may omit the word 'default'.
It is also worth noting that e.g. mysqldump silently adds the default character code when exporting data!
This can causes problems if the character code defined and the database content are different. In such cases MySqldump will try to convert data to it's default character code!
However, you can disable that by adding the character code option when using MySqldump.
e.g. mysqldump --set-charset.
In the same way you may explicitely set the character set.
mysqlimport --default-character-set = utf8
mysqladmin --defautl-character-set = utf8 create
Setting the character code at server start
-----------------------------------------------------
You can start the server with:
character-set-server
collation-server
The current values can be determined with the command
run MySql:
mysql> show variables;
Values may be changed with commands like:
set character_set_server = utf8;
set collation_server = utf8_unicode_ci
Setting the character code within Applications
----------------------------------------------------------
You want ensure that the correct character code is set when connecting to a particular database.
Connect to the database and issue the following SQL command:
mysql>SET NAMES utf8;
SET NAMES is equivalent to the 3 commands:
character_set_client
character_set_connection
character_set_results
How to run PostNuke in UTF-8
-----------------------------------
Several things have to fall into place for this to work correctly.
1) the database encoding needs to be set to UTF-8
2) the application language needs to be encoded in UTF-8
3) PostNuke needs to be told to use UTF-8
ad 1)
see above for details!
ad 2)
The character code for a given language is set in language//global.php (PN 0.76x) or in language//core.php (PN 0.8). Search and adjust the following 3 define strings:
define('_CHARSET','UTF-8');
define('_LOCALE','en_US');
define('_LOCALEWIN','eng');
Of course it is not sufficient just to change the _CHARSET to UTF-8. The text strings themselves need to be encoded in UTF-8. This can be done in a number of ways:
a) use 'recode' or 'iconv' on every language file
b) use the pnlwb (PN Language Workbench) to extract and convert all language files
ad 3)
Following the database initialization you need to issue a "set names to 'UTF-8'" command. As this is done in includes/pnAPI.php we need to patch that file.
PN 0.76x
----------
// load security functions.
include 'includes/pnSecurity.php';
// Load our language files
include 'includes/pnLang.php';
pnLangLoad();
//bplagge 2006-01-31 - charset fix for new MySql version
$dbconn =& pnDBGetConn(true);
$info=$dbconn->ServerInfo();
if ($dbconn->ErrorNo() != 0) {
echo "Error: "; echo $dbconn->ErrorNo();
}
// print_r($info);
$c = _CHARSET;
// Mysql uses non-standard name for UTF-8!
if ($c == 'UTF-8')
$c = 'UTF8';
$query = sprintf('SET NAMES \'%s\'', $c);
$dbconn->Execute($query);
if ($dbconn->ErrorNo()!=0) {
echo "Error: "; echo $dbconn->ErrorMsg();
echo "check pnAPI.php";
}
}
// end bplagge - mysql charset adjustment
PN 0.8
-------
if ($stages & PN_CORE_LANGS) {
// Load our language files
pnLangLoad();
}
# bp 2007-06-01
# need to "set names '' " to ensure correct data handling
$query = sprintf('SET NAMES \'%s\'', 'UTF8');
$result = DBUtil::executeSQL($query, -1, -1, true, true);
Please note that the MySQL character code names are NON STANDARD!
How to check?
----------------
I always found that phpMyAdmin is an excellent tool for MySQL databases. If the data entered in PostNuke is also correctly displayed in phpMyAdmin table browse mode I'm quite confident that everything is fine.
Generated on June 6, 2007.
-
phpMyAdmin 2.6.2-final is released: many fixes & new features
(News)
-
Generated on April 20, 2005.
-
PostNuke included with YellowTip Web Server 2.0
(News)
-
Due to high demand, our developers have included a selection of the most popular Open Source packages with Web Server 2.0:
PostNuke
phpBB
b2evolution
Gallery
The YellowTip Web Server was developed to make available a highly professional and easily installable package of Apache2, PHP4, MySQL4, phpMyAdmin and Zend Optimizer for the Windows platform (Win2K, WinXP).
With a convenient all-in-one installer, all components are installed in a single directory and can be used immediately after the installation process has completed. An uninstaller allows you to remove the YellowTip WebServer from your computer.
YellowTip WebServer 2.0 is OpenSource under the GPL license.
Click here for more information about YellowTip WebServer.
Click here to download YellowTip Web Server 2.0.
Generated on May 6, 2004.
-
phpMyadmin Version 2.6.2 Release Candidate 2: many enhancements and Bugfixes
(News)
-
Features of v2.5.6 RC 2: (here the Changelog):
-General code optimization by removing old PHP3-compatibility
-Make default functions configurable
-Visual scratchboard: show column names
-Show overhead in table list, allow to check all overheaded tables at once
-Export: can suppress dates information
-MySQL error messages improved formatting
-Printview: display linked values and other relational features
-Export: allow delayed INSERTs, and support for UPDATE and REPLACE statements
-Show result of last SHOW query when using multiple queries
a Online-Demo
Generated on February 22, 2004.
-
phpMyAdmin 2.3.2 was released - update recommended
(News)
-
Because of a last-minute bug in version 2.3.1, phpmyadmin V 2.3.2 has been released!(2002-10-08)
Some improvements:
-upgraded to version 1.51 of the FPDF library
-drop-down choice for foreign keys in Select sub-page
-validation for bookmark insert errors
Some fixes:
-display true row count for InnoDB tables
-parse error in exported dumps
-browser cache problems with Apache 2
-wrong tabindex for linked fields
-cannot change field properties
read the full Changelog
regards Martin
Generated on October 12, 2002.
-
Free PN Installation and PN Hosting for $5 USD
(News)
-
- 7 gigs for regular transfer
- 200 MB of disk space
- Your PostNuke database and site installed
- Transfer for existing server, for free!
- All the standard stuff
- phpMyAdmin installed
- more!
This deal is not available to our regular customers! Only to the PN Community, so if you are interested in this offer, please login with the following username and password.
Username: postnuke
Password: promotion
And follow the ‘PostNuke Promos’ link.
Any more questions, please visit http://GrapeBiz.com
Generated on September 21, 2002.
-
Permission Administration - A discussion
(News)
-
and I want to share some of the solutions they had. Since I am not a programmer, the only thing I can contribute to PN is Ideas...
The CMS was using a Role-Model system. So there were differnet Roles (Access-Rights) that were assigned to groups or users. For PN there would be the following RM:
- Reader: Can read and post comments
- Editor: Can Post items
- Publisher: Can Post items and publish them or publish items posted by other, but e.g. not delete items once published
- Administrator: Godlike
This would reduce the amount of Roles to four. If someone wanted different models, it can be done in the Database itself (for someone that can deal with own permissions can shurely handle phpmyadmin...).
The function of users and groups was similar. You have users, you have groups, that´s about it. This could be done a little more comfortable in PN, but works fine right now.
Next step was, that every object was defined the permissions (objects = Modules?). So we had a setting like:
Object - Group/User - Role
News - Reg. users - editor
News - unreg users - reader
News - Marketingteam - Publisher
News - Admins - Administrator
News - User XY - Publisher
This should be set in the News administration and should be handled mostly via dropdown menues. These could also include subobjects like:
Downloads
DL Cat. 1
DL Cat. 2
Everything not assigned was inherited. Also the position within the setting (above / below) was not relevant. I guess when having conflicting rights, we would use the more restrictive.
This could be a big step forward with PN, what do you think? Is this a lot of work, or could we see it in let´s say 0,73???
To state this clear: PN is absolutely awsome already, so please read this as suggestion, not as complaint.
Thank You
Graffiti
http://www.graffiti-marketing.de
Generated on April 6, 2002.
-
Doing a clean install and restoring sql data.
(News)
-
"View dump (schema) of database" for my sql database?
I've tried to find a good expanation for this but have never been able to come up with something the lay person can understand.
In particular if I choose to do a completely "NEW" install of the latest version of PostNuke by wiping everything clean (after backing up of course).
Deleting everything might be by choice or it might be becasue the upgrade went terribly wrong and everything is screwed up.
What is the best way to backup my SQL database with phpMyAdmin? What options do I check off before saving the file. What the F&%^k does all this s#$t mean? PLEASE HELP!!!:
Which one/s do I tic off in the following list of four options? What does this stuff mean?
Add 'drop table'?
Complete inserts??
Extended inserts???
Use backquotes with tables and fields' names????
Save to file... I KNOW WHAT THIS MEANS!!!
And which one of these three items is the best one to choose and why?
-Structure only?
-Structure and data??
-Data only???
Many thanks!
Generated on March 18, 2002.
-
Phpmyadmin 2.2.3 is out
(News)
-
Generated on January 11, 2002.