RRT
-
Posts
25 -
Joined
-
Last visited
Never
Posts posted by RRT
-
-
That did it! THANKS!!! I had to use "pg_escape_string" instead of "mysql_real_escape_string" since I am using postgres, but other than that its similar. Besides string data, do they make escape methods for other types of data, such as integers, floats, etc? Maybe those types aren't suseptable to exploit? That would make sense to me, as commands aren't numbers but strings of words.
-
Thanks for the info about the SQL injection, I will take that into account.
So you are suggesting that I change my code to something like this, right?:
=======================
$query = sprintf("INSERT INTO inventory VALUES ('%s','%s','%s','%s', '%s','%s','%s','%s','%s','%s')";,
mysql_real_escape_string($CID),
mysql_real_escape_string($ImageFile),
mysql_real_escape_string($ItemTitle),
mysql_real_escape_string($ItemNo),
mysql_real_escape_string($Barcode),
mysql_real_escape_string($Description),
mysql_real_escape_string($Dept),
mysql_real_escape_string($Price),
mysql_real_escape_string($Quantity),
mysql_real_escape_string($Shipping));
mysql_query($query);
=======================
-
I can't do an INSERT via a web query. Can you look at my syntax and see if I have a typo below?:
-------------------------------------
<?php
$CID = $_POST['CID'];
$ImageFile = $_POST['ImageFile'];
$ItemTitle = $_POST['ItemTitle'];
$ItemNo = $_POST['ItemNo'];
$Barcode = $_POST['Barcode'];
$Description = $_POST['Description'];
$Dept = $_POST['Dept'];
$Price = $_POST['Price'];
$Quantity = $_POST['Quantity'];
$Shipping = $_POST['Shipping'];
.
.
.
$query = 'INSERT INTO inventory (cid, image_pic, item_title, item_no, barcode, description, dept, price, quantity, ship_rate) VALUES ('$CID','$ImageFile','$ItemTitle','$ItemNo', '$Barcode','$Description','$Dept','$Price','$Quantity','$Shipping')';
-------------------------------------
This is what I get back when I try to submit the query (Line 20 is the query line posted above.):
Parse error: syntax error, unexpected T_VARIABLE in /perform_insert.php on line 20
-
I tried the solution to Q.7 but it didn't fix it.
I tried "python", "import yum" but it fails saying
>>> import yum
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "yum/__init__.py", line 23, in ?
import rpm
ImportError: No module named rpm
>>>
-
OK, I am taking your advice and trying to get yum fixed, but keep getting this Python error:
-----------------------------------------
yum check-update php5
There was a problem importing one of the Python modules
required to run yum. The error leading to this problem was:
cannot import name flagToString
Please install a package which provides this module, or
verify that the module is installed correctly.
It's possible that the above module doesn't match the
current version of Python, which is:
2.4.1 (#1, May 16 2005, 15:19:29)
[GCC 4.0.0 20050512 (Red Hat 4.0.0-5)]
If you cannot solve this problem yourself, please go to
the yum faq at:
http://wiki.linux.duke.edu/YumFaq
-----------------------------------------
Any ideas as to what I need to do to get this issue fixed? I am running yum version 3.2.23 and Python version 3.1.1. Thanks.
-
OK, I'm really starting to get irked about his whole PHP configuration issue; I've been working on this problem for over a month. Modifying the httpd.conf and adding
LoadModule php5_module "/full/path/to/php/php5apache2_2.so"
AddType application/x-httpd-php .php
has not informed the server to parse PHP files as PHP. Here's another thing, why are their so many php.ini and httpd.conf files? Shouldn't there just be one of each? Here's the locations I am finding on my server:
/usr/local/apache2/conf/httpd.conf
/usr/local/apache2/conf/original/httpd.conf
/usr/local/apache2/docs/conf/httpd.conf
/etc/httpd/conf/httpd.conf
/etc/httpd/conf.d/php.conf
/usr/local/lib/php.ini
/usr/local/php/php-5.2.9/php.ini
/etc/php.ini
/etc/php.d/php.ini
I just want to get this thing working correctly so I can get the server to parse PHP files as PHP. I need to get past this so that I can move forward onto other things...
Thanks!
-
OK. What does this error mean? There is no text containing "sqlite3ExprDelete" anywhere within the httpd.conf file:
# apachectl start
httpd: Syntax error on line 57 of /usr/local/apache2/conf/httpd.conf: Cannot load /usr/local/php/php-5.2.9/libs/libphp5.so into server: /usr/local/php/php-5.2.9/libs/libphp5.so: undefined symbol: sqlite3ExprDelete
-
These are the .so files that I could find on my server. Which module(s) should I load to get PHP working with Apache?:
============
/usr/lib/httpd/modules/libphp5.so
/usr/lib/httpd/modules/mod_imap.so
/usr/lib/httpd/modules/mod_vhost_alias.so
/usr/lib/httpd/modules/mod_unique_id.so
/usr/lib/httpd/modules/mod_info.so
/usr/lib/httpd/modules/mod_alias.so
/usr/lib/httpd/modules/mod_mem_cache.so
/usr/lib/httpd/modules/mod_access.so
/usr/lib/httpd/modules/mod_asis.so
/usr/lib/httpd/modules/mod_headers.so
/usr/lib/httpd/modules/mod_auth_digest.so
/usr/lib/httpd/modules/mod_dav.so
/usr/lib/httpd/modules/mod_logio.so
/usr/lib/httpd/modules/mod_include.so
/usr/lib/httpd/modules/mod_autoindex.so
/usr/lib/httpd/modules/mod_env.so
/usr/lib/httpd/modules/mod_proxy_ftp.so
/usr/lib/httpd/modules/mod_negotiation.so
/usr/lib/httpd/modules/mod_ldap.so
/usr/lib/httpd/modules/mod_status.so
/usr/lib/httpd/modules/mod_ext_filter.so
/usr/lib/httpd/modules/mod_usertrack.so
/usr/lib/httpd/modules/mod_python.so
/usr/lib/httpd/modules/mod_proxy_http.so
/usr/lib/httpd/modules/mod_userdir.so
/usr/lib/httpd/modules/mod_actions.so
/usr/lib/httpd/modules/mod_disk_cache.so
/usr/lib/httpd/modules/mod_speling.so
/usr/lib/httpd/modules/mod_mime_magic.so
/usr/lib/httpd/modules/mod_auth_ldap.so
/usr/lib/httpd/modules/mod_perl.so
/usr/lib/httpd/modules/mod_cgid.so
/usr/lib/httpd/modules/mod_dir.so
/usr/lib/httpd/modules/mod_rewrite.so
/usr/lib/httpd/modules/mod_auth.so
/usr/lib/httpd/modules/mod_file_cache.so
/usr/lib/httpd/modules/mod_dav_fs.so
/usr/lib/httpd/modules/mod_log_forensic.so
/usr/local/apache2/modules/libphp5.so
/usr/local/apache2/lib/apr-util-1/apr_dbd_pgsql-1.so
/usr/local/apache2/lib/apr-util-1/apr_dbd_sqlite3.so
/usr/local/apache2/lib/apr-util-1/apr_dbd_pgsql.so
/usr/local/php/OLD/php-5.2.8/modules/pgsql.so
/usr/local/php/OLD/php-5.2.8/.libs/libphp5.so
/usr/local/php/OLD/php-5.2.8/ext/pgsql/.libs/pgsql.so
/usr/local/php/php-5.2.9/.libs/libphp5.so
/usr/local/php/php-5.2.9/libs/libphp5.so
============
I didn't see any .so file named "php5apache2_2.so", unless you were just making up that filename as an example. Thanks.
-
I'm on Fedora 2.6.11-1.1369_FC4 on that particular server. I'm running PHP 5.2.9 which I downloaded directly from the php web site, then untarred, ran make, and make install commands as described in the php INSTALL file that was included with the distribution..
==================
Example 2-4. Installation Instructions (Apache 2 Shared Module Version)
1. gzip -d httpd-2_0_NN.tar.gz
2. tar xvf httpd-2_0_NN.tar
3. gunzip php-NN.tar.gz
4. tar -xvf php-NN.tar
5. cd httpd-2_0_NN
6. ./configure --enable-so
7. make
8. make install
==================
You will probably try to talk me into using yum, which I have already tried to do, but it will not work on my system; it always fails on 'setting up repositories'. Fixing this will have to be another project on its own and in th future.
-
How to I set it to do that? I am running Apache version 2.2.11.
-
PHP pages won't open at all on my server. HTML pages open fine, but when going to the PHP pages that are on my server, the browser tries to download the page like a file instead of presenting it by the browser. What can I do to make the PHP processor to be handled properly? Do I need to recompile it again, and if so, what switches should I use?
-
This issue is still not solved. If I can't get Yum to work correctly, then that means that I will have to config and compile manually. Any suggestions on what I should try next?
-
When I try that I guess this:
Setting up Install Process
Setting up repositories
Cannot find a valid baseurl for repo: updates-released
That is as far as I get. Do I need to run some other command to setup yum first?
-
Did this fix your issue? Would I do the same thing for Postgres, such as this:
yum install php-postgres
Any ideas?
-
YUM always fails when I try to run it. I get these messages back:
===
[root@server1 ~]# yum check-update
Setting up repositories
Cannot find a valid baseurl for repo: updates-released
===
What does this error mean?
Plus, I don't know YUM that well, so I figured installing it manually was the most direct path, instead of getting diverted trying to fix another issue that I could try to tackle later... especially since I am trying to get the PHP fixed first.
-
System specs:
OS: Linux, Fedora v.2.6.11-1.1369_FC4
HTTPD: Apache v.2.2.11
PHP v.5.2.9
DBMS: PostgreSQL v. 8.3.7
I have PHP v. 5.2.9 installed on my web server running Apache v.2.2.11, but
it is not processing PHP commands on web pages hosted on that same machine.
For example, I have a page that I created named phpinfo.php, which solely
runs the phpinfo() command. It works on my other web server, but not this
one. Here is the code for that entire phpinfo.php:
<?php phpinfo() ?>
When I try to access the phpinfo.php web page from a browser on another
desktop computer, it treats it like its trying to download a file, asking me
whether I want to Save or Open the file, not execute the code within the
browser as it should be doing. However, if I try to browse to the
phpinfo.php file hosted on my other web server, it processes the phpinfo()
command as it is supposed to and displays the results of the function.
When I installed PHP on the problematic server, I ran these commands as
root:
./configure --with-pgsql=/usr/local/pgsql/bin --with-apxs2=/usr/local/apache2/bin/apxs
make
make install
There were no errors, everything installed fine.
Whenever you install a newer version of PHP, are you supposed to re-run the
Apache installation for it to successfully be able to "talk" to PHP? I'm
fairly new to this... Thanks.
RRT
-
When you say "And it comes from the package php5-pgsql, or another package with a similar name" , do you mean that it resides within one of those RPMs? And if so, what is the easiest way to 'unzip' them so that I can retreive the ini file?
Mark
-
OK, I have read a lot, re-installed a lot, and one thing that I have noticed is that in the directory /etc/php.d/ there are different ini files for different programs, such as mysql, json, dbase, ldap, etc. SHOULD there be an pgsql.ini file (or something similar) in there. And if so, where can i get one from?
Mark
-
The file that I modified was /etc/php.ini. I added those 2 lines to it.
pgsql.so is not found on the system, however there is a file named libplpgsql.so It is located at /usr/local/postgresql-8.2.6/src/pl/plpgsql/src/libplpgsql.so. Is that not the right file? If it's not the right file, how do I get the correct one?
Mark
-
It STILL isn't showing up! Here's when shows when phpinfo() is run:
================
PHP Version 5.2.4
System Linux server1 2.6.23.1-42.fc8 #1 SMP Tue Oct 30 13:55:12 EDT 2007 i686
Build Date Oct 16 2007 09:15:34
Configure Command './configure' '--build=i386-redhat-linux-gnu' '--host=i386-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--without-mime-magic' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter' '--disable-json'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc
Loaded Configuration File /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/dbase.ini, /etc/php.d/json.ini, /etc/php.d/ldap.ini, /etc/php.d/mysqli.ini, /etc/php.d/mysql.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/zip.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps, zip
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies
--------------------------------------------------------------------------------
PHP Credits
--------------------------------------------------------------------------------
Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
allow_url_include Off Off
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_globals_jit On On
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 Off Off
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 6143 6143
expose_php On On
extension_dir /usr/lib/php/modules /usr/lib/php/modules
file_uploads On On
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/share/pear:/usr/share/php .:/usr/share/pear:/usr/share/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 32M 32M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
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 EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off
apache2handler
Apache Version Apache/2.2.6 (Fedora)
Apache API Version 20051115
Server Administrator root@localhost
Hostname:Port server1.my_domain.com:80
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 120 - Keep-Alive: 15
Virtual Server No
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_auth_basic mod_auth_digest mod_authn_file mod_authn_alias mod_authn_anon mod_authn_dbm mod_authn_default mod_authz_host mod_authz_user mod_authz_owner mod_authz_groupfile mod_authz_dbm mod_authz_default util_ldap mod_authnz_ldap mod_include mod_log_config mod_logio mod_env mod_ext_filter mod_mime_magic mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy mod_proxy_balancer mod_proxy_ftp mod_proxy_http mod_proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_php5 mod_perl mod_proxy_ajp mod_python mod_ssl
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, */*
HTTP_REFERER http://server1.my_domain.com/portal/acme/
HTTP_ACCEPT_LANGUAGE en-us
HTTP_UA_CPU x86
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
HTTP_HOST server1.my_domain.com
HTTP_CONNECTION Keep-Alive
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
SERVER_SIGNATURE <address>Apache/2.2.6 (Fedora) Server at server1.my_domain.com Port 80</address>
SERVER_SOFTWARE Apache/2.2.6 (Fedora)
SERVER_NAME server1.my_domain.com
SERVER_ADDR 192.168.192.2
SERVER_PORT 80
REMOTE_ADDR 192.168.192.100
DOCUMENT_ROOT /var/www/html
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/portal/acme/phpinfo.php
REMOTE_PORT 1254
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /portal/acme/phpinfo.php
SCRIPT_NAME /portal/acme/phpinfo.php
HTTP Headers Information
HTTP Request Headers
HTTP Request GET /portal/acme/phpinfo.php HTTP/1.1
Accept image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
Referer http://server1.my_domain.com/portal/acme/
Accept-Language en-us
UA-CPU x86
Accept-Encoding gzip, deflate
User-Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
Host server1.my_domain.com
Connection Keep-Alive
HTTP Response Headers
X-Powered-By PHP/5.2.4
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8
bz2
BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.4, 20-Dec-2006
calendar
Calendar support enabled
ctype
ctype functions enabled
curl
cURL support enabled
cURL Information libcurl/7.16.4 NSS/3.11.7.1 zlib/1.2.3 libidn/0.6.14
date
date/time support enabled
"Olson" Timezone Database Version 2007.6
Timezone Database internal
Default timezone America/Chicago
Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value
exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.20 2007/06/10 20:12:45 iliaa Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
filter
Input Validation and Filtering enabled
Revision $Revision: 1.52.2.39 $
Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value
ftp
FTP support enabled
gettext
GetText Support enabled
gmp
gmp support enabled
GMP version 4.2.2
hash
hash support enabled
Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.7
Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1
json
json support enabled
json version 1.2.1
ldap
LDAP Support enabled
RCS Version $Id: ldap.c,v 1.161.2.3.2.11 2007/07/17 09:09:42 jani Exp $
Total Links 0/unlimited
API Version 3001
Vendor Name OpenLDAP
Vendor Version 20338
SASL Support Enabled
libxml
libXML support active
libXML Version 2.6.30
libXML streams enabled
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
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
mysqli
MysqlI Support enabled
Client API library version 5.0.45
Client API header version 5.0.45
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.8b 04 May 2006
pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 7.3 2007-08-28
Directive Local Value Master Value
pcre.backtrack_limit 100000 100000
pcre.recursion_limit 100000 100000
PDO
PDO support enabled
PDO drivers mysql, sqlite
pdo_mysql
PDO Driver for MySQL, client library version 5.0.45
pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $
SQLite Library 3.4.2
posix
Revision $Revision: 1.70.2.3.2.16 $
pspell
PSpell Support enabled
Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $
session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx
Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
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_httponly Off Off
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 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php/session /var/lib/php/session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0
shmop
shmop support enabled
SimpleXML
Simplexml support enabled
Revision $Revision: 1.151.2.22.2.35 $
Schema support enabled
sockets
Sockets Support enabled
SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException
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,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value
sysvmsg
sysvmsg support enabled
Revision $Revision: 1.20.2.3.2.6 $
tokenizer
Tokenizer Support enabled
wddx
WDDX Support enabled
WDDX Session Serializer enabled
xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.30
zip
Zip enabled
Extension Version $Id: php_zip.c,v 1.1.2.38 2007/08/06 22:02:32 bjori Exp $
Zip version 2.0.0
Libzip version 0.7.1
zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value
Additional Modules
Module Name
dbase
sysvsem
sysvshm
Environment
Variable Value
SSH_AGENT_PID 2080
HOSTNAME server1
DESKTOP_STARTUP_ID no value
TERM xterm
SHELL /bin/bash
XDG_SESSION_COOKIE 121d6142667cee2f96609c00477f8500-1215315866.321968-1477842974
HISTSIZE 1000
GTK_RC_FILES /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
WINDOWID 56623195
GTK_MODULES gnomebreakpad
USER root
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;01:or=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:
CCACHE_DIR /var/cache/ccache
SSH_AUTH_SOCK /tmp/ssh-BAZJdS2078/agent.2078
GNOME_KEYRING_SOCKET /tmp/keyring-d6vPS5/socket
SESSION_MANAGER local/unix:@/tmp/.ICE-unix/2078,unix/unix:/tmp/.ICE-unix/2078
PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
MAIL /var/spool/mail/root
PWD /etc/rc5.d
INPUTRC /etc/inputrc
CCACHE_UMASK 002
LANG en_US.UTF-8
SSH_ASKPASS /usr/libexec/openssh/gnome-ssh-askpass
HOME /root
SHLVL 4
GNOME_DESKTOP_SESSION_ID Default
LOGNAME root
CVS_RSH ssh
DBUS_SESSION_BUS_ADDRESS unix:abstract=/tmp/dbus-iAnr3Z5wAa,guid=7b12055f459ca93c27e3030048703f9a
LESSOPEN |/usr/bin/lesspipe.sh %s
WINDOWPATH 7
DISPLAY :0.0
G_BROKEN_FILENAMES 1
XAUTHORITY /root/.Xauthority
COLORTERM gnome-terminal
_ /usr/sbin/httpd
PHP Variables
Variable Value
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
_SERVER["HTTP_REFERER"] http://server1.my_domain.com/portal/acme/
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_UA_CPU"] x86
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1)
_SERVER["HTTP_HOST"] server1.my_domain.com
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.6 (Fedora) Server at server1.my_domain.com Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.2.6 (Fedora)
_SERVER["SERVER_NAME"] server1.my_domain.com
_SERVER["SERVER_ADDR"] 192.168.192.2
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.192.100
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/portal/acme/phpinfo.php
_SERVER["REMOTE_PORT"] 1254
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] no value
_SERVER["REQUEST_URI"] /portal/acme/phpinfo.php
_SERVER["SCRIPT_NAME"] /portal/acme/phpinfo.php
_SERVER["PHP_SELF"] /portal/acme/phpinfo.php
_SERVER["REQUEST_TIME"] 1215316030
_ENV["SSH_AGENT_PID"] 2080
_ENV["HOSTNAME"] server1
_ENV["DESKTOP_STARTUP_ID"] no value
_ENV["TERM"] xterm
_ENV["SHELL"] /bin/bash
_ENV["XDG_SESSION_COOKIE"] 121d6142667cee2f96609c00477f8500-1215315866.321968-1477842974
_ENV["HISTSIZE"] 1000
_ENV["GTK_RC_FILES"] /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
_ENV["WINDOWID"] 56623195
_ENV["GTK_MODULES"] gnomebreakpad
_ENV["USER"] root
_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;01:or=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["CCACHE_DIR"] /var/cache/ccache
_ENV["SSH_AUTH_SOCK"] /tmp/ssh-BAZJdS2078/agent.2078
_ENV["GNOME_KEYRING_SOCKET"] /tmp/keyring-d6vPS5/socket
_ENV["SESSION_MANAGER"] local/unix:@/tmp/.ICE-unix/2078,unix/unix:/tmp/.ICE-unix/2078
_ENV["PATH"] /usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
_ENV["MAIL"] /var/spool/mail/root
_ENV["PWD"] /etc/rc5.d
_ENV["INPUTRC"] /etc/inputrc
_ENV["CCACHE_UMASK"] 002
_ENV["LANG"] en_US.UTF-8
_ENV["SSH_ASKPASS"] /usr/libexec/openssh/gnome-ssh-askpass
_ENV["HOME"] /root
_ENV["SHLVL"] 4
_ENV["GNOME_DESKTOP_SESSION_ID"] Default
_ENV["LOGNAME"] root
_ENV["CVS_RSH"] ssh
_ENV["DBUS_SESSION_BUS_ADDRESS"] unix:abstract=/tmp/dbus-iAnr3Z5wAa,guid=7b12055f459ca93c27e3030048703f9a
_ENV["LESSOPEN"] |/usr/bin/lesspipe.sh %s
_ENV["WINDOWPATH"] 7
_ENV["DISPLAY"] :0.0
_ENV["G_BROKEN_FILENAMES"] 1
_ENV["XAUTHORITY"] /root/.Xauthority
_ENV["COLORTERM"] gnome-terminal
_ENV["_"] /usr/sbin/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.
-
OK, I just added that... Restart the server now? Or just apachectl stop and then start?
-
phpinfo() runs, but there is no separate module listed for PostgreSQL like there is for mysql, ldap, and others...
-
I tried both edits, neither one would work. Very strange!
<html> <head> <title>Connecting...</title> </head> <body> <?php ini_set('display_errors', 1); ?> <?php $dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); ?> </body> </html>
<html> <head> <title>Connecting...</title> </head> <body> <?php ini_set('display_errors', 1); $dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); ?> </body> </html>
Did I misunderstand what you wanted me to try?
Mark
-
OK, here's what I'm running:
Fedora 2.6.23.1-42.fc8
PostgreSQL v. 8.2.6
Apache v. 2.2.6
PHP v. 5.2.4
Here's the problem I'm having:
I can create simple PHP pages like this, and it displays properly:
<html> <head> <title>Hello PHP World!</title> </head> <body> <?php echo '<p>Hello World</p>; ?> </body> </html>
But, when I try something more complicated, such as seen below, the client's web browser just gets an HTTP 500 Internal Server Error.
<html> <head> <title>Connecting...</title> </head> <body> <?php $dbconn = pg_connect("host=webserver1.domain.com port=5432 dbname=database1 user=postgres password=mypassword") or die('Could not connect: ' . pg_last_error()); ?> </body> </html>
Any ideas? I've tried a million variations of this code all weekend, such as putting the IP address in place of them hostname, only passing the host= and the dbname= fields, etc. Any suggestions or advice would be appreciated!
Mark
Trying to learn how to select multiple checkboxes to delete entries from a DB
in PHP Coding Help
Posted
I am looking for help trying to select multiple checkboxes to delete entries from a DB via a php web page. I know the SQL syntax on *how* to delete a row of data within a SQL database, just not how to create a php array where I can do multiple delete commands at once. For example, if I have a PostgreSQL database with the following rows:
database1=# SELECT * FROM table1;
cid | home_location | asking_price
----+---------------------+-----------------
1 123 Main Street 200000
2 345 First Ave 210000
3 456 Frontage Rd 199900
4 678 5th Street 205000
5 1001 Elm Street 225000
I would like to display the results of this SELECT ALL query onto a php web page with checkboxes next to each row, giving me the ability to check multiple rows and then delete them from the database.
The php code to display the selections looks something like this:
<?php
// Connecting to the database server
$dbconnect = pg_connect("host=aaa.bbb.ccc.ddd dbname=database1 user=user1 password=password1") or die("Could not connect: " . pg_last_error());
//Performing the SQL query
$removequery = sprintf("DELETE FROM table1 WHERE CID="?");
How would you suggest that i put all the desired queries together to be able to delete various ones at the same time? I assume that I need to create some sort of array and then be able to delete them all at once, just not sure of how to go about coding that to work.