不能解决的php+mysql 兼容性问题

Question

症状是显示中文就发不全文章 发全文章就不显示中文

使用 MySQL 4.1.12-max
PHP Version 4.3.11
'./configure' '--prefix=/usr/local/php' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-config-filepath=/usr/local/php' '--enable-sockets' '--with-mysql'

这样编译完了 显示中文但是发文章发不全它会自动把有特殊字符的和下面的内容过滤掉

如果使用这样编译php 就不会过滤文章但是不显示中文。全是乱码./configure --with-mysql=/usr/local/mysql --with-apxs2=/usr/local/apache/bin/apxs

请问这是什么引起的?

Answer 1

踢上去

Answer 2

不解决 不可能沉下去

Answer 3

ti

Answer 4

yun

Answer 5

哭

Answer 6

yunsi le

Answer 7

不是很明白，你能否将你的故障环境说详细点。

Answer 8

环境是这样的fc2 stat硬盘apache和php和mysql均为最新版本

Answer 9

PHP Version 4.3.11

System  Linux OpensystemX 2.6.5-1.358 #1 Sat May 8 09:04:50 EDT 2004 i686  
Build Date  May 23 2005 01:29:12  
Configure Command  './configure' '--prefix=/usr/local/php' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-config-filepath=/usr/local/php' '--enable-sockets' '--with-mysql'  
Server API  Apache 2.0 Handler  
Virtual Directory Support  disabled  
Configuration File (php.ini) Path  /usr/local/php/lib  
PHP API  20020918  
PHP Extension  20020429  
Zend Extension  20021010  
Debug Build  no  
Thread Safety  disabled  
Registered PHP Streams  php, http, ftp  

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies  

--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting no value no value
expose_php On On
extension_dir /usr/local/php/lib/php/extensions/no-debug-non-zts-20020429 /usr/local/php/lib/php/extensions/no-debug-non-zts-20020429
file_uploads On On
gpc_order GPC GPC
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/local/php/lib/php .:/usr/local/php/lib/php
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time -1 -1
open_basedir no value no value
output_buffering 0 0
output_handler no value no value
post_max_size 8M 8M
precision 14 14
register_argc_argv On On
register_globals Off Off
report_memleaks On On
safe_mode Off Off
safe_mode_exec_dir /usr/local/php/bin /usr/local/php/bin
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i  /usr/sbin/sendmail -t -i  
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order no value no value
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On

apache2handler
Apache Version  Apache  
Apache API Version  20020903  
Server Administrator  lqa@21cn.com  
Hostnameort  www.gipsky.com:0  
User/Group  pastsoft(500)/500  
Max Requests  Per Child: 0 - Keep Alive: on - Max Per Connection: 100  
Timeouts  Connection: 200 - Keep-Alive: 15  
Virtual Server  Yes  
Server Root  /usr/local/apache  
Loaded Modules  core mod_access mod_auth mod_include mod_log_config mod_env mod_setenvif prefork http_core mod_mime mod_status mod_autoindex mod_asis mod_cgi mod_negotiation mod_dir mod_imap mod_actions mod_userdir mod_alias mod_so sapi_apache2 mod_perl  

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment
Variable Value
HTTP_ACCEPT  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*  
HTTP_ACCEPT_LANGUAGE  zh-cn  
HTTP_ACCEPT_ENCODING  gzip, deflate  
HTTP_USER_AGENT  Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)  
HTTP_HOST  www.gipsky.com  
HTTP_CONNECTION  Keep-Alive  
HTTP_COOKIE  istats=060620051353; gipsky_com_newbb0_LV=1117938965; gipsky_com_newbb1_LV=1117820215; gipsky_com_newbb1_V=flat; PHPSESSID=6925ec59549ae136c3573939e61b5a8b  
PATH  /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin  
SERVER_SIGNATURE  no value  
SERVER_SOFTWARE  Apache  
SERVER_NAME  www.gipsky.com  
SERVER_ADDR  60.191.0.172  
SERVER_PORT  80  
REMOTE_ADDR  219.234.81.66  
DOCUMENT_ROOT  /mnt/i/pcai/httpd  
SERVER_ADMIN  lqa@21cn.com  
SCRIPT_FILENAME  /mnt/i/pcai/httpd/test.php  
REMOTE_PORT  55644  
GATEWAY_INTERFACE  CGI/1.1  
SERVER_PROTOCOL  HTTP/1.1  
REQUEST_METHOD  GET  
QUERY_STRING  no value  
REQUEST_URI  /test.php  
SCRIPT_NAME  /test.php  

HTTP Headers Information
HTTP Request Headers
HTTP Request  GET /test.php HTTP/1.1  
Accept  image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*  
Accept-Language  zh-cn  
Accept-Encoding  gzip, deflate  
User-Agent  Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)  
Host  www.gipsky.com  
Connection  Keep-Alive  
Cookie  istats=060620051353; gipsky_com_newbb0_LV=1117938965; gipsky_com_newbb1_LV=1117820215; gipsky_com_newbb1_V=flat; PHPSESSID=6925ec59549ae136c3573939e61b5a8b  
HTTP Response Headers
X-Powered-By  PHP/4.3.11  
Keep-Alive  timeout=15, max=95  
Connection  Keep-Alive  
Transfer-Encoding  chunked  
Content-Type  text/html  

ctype
ctype functions  enabled  

mysql
MySQL Support enabled
Active Persistent Links  0  
Active Links  0  
Client API version  3.23.49  
MYSQL_MODULE_TYPE  builtin  
MYSQL_SOCKET  /tmp/mysql.sock  
MYSQL_INCLUDE  no value  
MYSQL_LIBS  no value  

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

overload
User-Space Object Overloading Support  enabled  

pcre
PCRE (Perl Compatible Regular Expressions) Support  enabled  
PCRE Library Version  4.5 01-December-2003  

posix
Revision  $Revision: 1.51.2.3 $  

session
Session Support  enabled  
Registered save handlers  files user  

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid Off Off

sockets
Sockets Support  enabled  

standard
Regex Library  Bundled library enabled  
Dynamic Library Support  enabled  
Path to sendmail  /usr/sbin/sendmail -t -i  

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset=
user_agent no value no value

tokenizer
Tokenizer Support  enabled  

xml
XML Support  active  
XML Namespace Support  active  
EXPAT Version  1.95.6  

Additional Modules
Module Name

Environment
Variable Value
HOSTNAME  OpensystemX  
SHELL  /bin/bash  
TERM  xterm  
HISTSIZE  1000  
SSH_CLIENT  ::ffff:61.51.71.37 53674 3000  
QTDIR  /usr/lib/qt-3.3  
SSH_TTY  /dev/pts/10  
USER  root  
LD_LIBRARY_PATH  /usr/local/apache/lib:  
LS_COLORS  no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:  
KDEDIR  /usr  
USERNAME  root  
PATH  /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin  
MAIL  /var/spool/mail/root  
PWD  /root/php-4.3.11  
INPUTRC  /etc/inputrc  
LANG  en_US.UTF-8  
SSH_ASKPASS  /usr/libexec/openssh/gnome-ssh-askpass  
HOME  /root  
SHLVL  2  
BASH_ENV  /root/.bashrc  
LOGNAME  root  
SSH_CONNECTION  ::ffff:61.51.71.37 53674 ::ffff:60.191.0.172 3000  
LESSOPEN  |/usr/bin/lesspipe.sh %s  
G_BROKEN_FILENAMES  1  
_  /usr/local/apache/bin/httpd  

PHP Variables
Variable Value
_REQUEST["istats"] 060620051353
_REQUEST["gipsky_com_newbb0_LV"] 1117938965
_REQUEST["gipsky_com_newbb1_LV"] 1117820215
_REQUEST["gipsky_com_newbb1_V"] flat
_REQUEST["HPSESSID"] 6925ec59549ae136c3573939e61b5a8b
_COOKIE["istats"] 060620051353
_COOKIE["gipsky_com_newbb0_LV"] 1117938965
_COOKIE["gipsky_com_newbb1_LV"] 1117820215
_COOKIE["gipsky_com_newbb1_V"] flat
_COOKIE["HPSESSID"] 6925ec59549ae136c3573939e61b5a8b
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] zh-cn
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
_SERVER["HTTP_HOST"] www.gipsky.com
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] istats=060620051353; gipsky_com_newbb0_LV=1117938965; gipsky_com_newbb1_LV=1117820215; gipsky_com_newbb1_V=flat; PHPSESSID=6925ec59549ae136c3573939e61b5a8b
_SERVER["ATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_SERVER["SERVER_SIGNATURE"] no value
_SERVER["SERVER_SOFTWARE"] Apache
_SERVER["SERVER_NAME"] www.gipsky.com
_SERVER["SERVER_ADDR"] 60.191.0.172
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 219.234.81.66
_SERVER["DOCUMENT_ROOT"] /mnt/i/pcai/httpd
_SERVER["SERVER_ADMIN"] lqa@21cn.com
_SERVER["SCRIPT_FILENAME"] /mnt/i/pcai/httpd/test.php
_SERVER["REMOTE_PORT"] 55644
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /test.php
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["HP_SELF"] /test.php
_SERVER["ATH_TRANSLATED"] /mnt/i/pcai/httpd/test.php
_SERVER["argv"] Array
(
)

_SERVER["argc"] 0
_ENV["HOSTNAME"] OpensystemX
_ENV["SHELL"] /bin/bash
_ENV["TERM"] xterm
_ENV["HISTSIZE"] 1000
_ENV["SSH_CLIENT"] ::ffff:61.51.71.37 53674 3000
_ENV["QTDIR"] /usr/lib/qt-3.3
_ENV["SSH_TTY"] /dev/pts/10
_ENV["USER"] root
_ENV["LD_LIBRARY_PATH"] /usr/local/apache/lib:
_ENV["LS_COLORS"] no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
_ENV["KDEDIR"] /usr
_ENV["USERNAME"] root
_ENV["ATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
_ENV["MAIL"] /var/spool/mail/root
_ENV["WD"] /root/php-4.3.11
_ENV["INPUTRC"] /etc/inputrc
_ENV["LANG"] en_US.UTF-8
_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass
_ENV["HOME"] /root
_ENV["SHLVL"] 2
_ENV["BASH_ENV"] /root/.bashrc
_ENV["LOGNAME"] root
_ENV["SSH_CONNECTION"] ::ffff:61.51.71.37 53674 ::ffff:60.191.0.172 3000
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["_"] /usr/local/apache/bin/httpd

PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact license@php.net.