[PHP-DB] POSTGRESQL PHP
I've installed MySQL and PostgreSQL on my XP. I'd like to make an PHP script working with pgsql base. I created database (typed createdb name) but when trying execute script with pg_connect(host=localhost dbname=name); it fails. Any suggestions? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] POSTGRESQL PHP
Miles Thompson wrote: 1. run a script containing phpinfo() function and confirm you have support for pgsql 2. add code to display the error message generated by either php or pgsql when you try to connnect 3. (Maybe this should have been first) I don't know about Windows systems, but on *nix, PostgreSQL has to be started with the -i switch to be accessible from the Internet. Check docs. Hope this helps - Miles Thompson Yes, it does :) First, I had to remove one little semicolon in php.ini (extensions) and configure extensions.patch. After restart of Apache PHP began to display some errors that finally guided me to succesfull pg_connect. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: change data before its sent to db?
You will laugh. When you quote month, you don't sort date by month field. You sort by month - text constant being always equal. In fact you son't sort it at all! The sort code --- if ($orderby == 'month_num'): $sql = select * from releases order by 'month'; elseif ($orderby == 'month_num2'): $sql = select * from releases order by 'month' desc; Try this: $sql = select * from releases order by month; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP database
Hello I'm to have database, but server's administrator refuses to install MySQL nor PHP MySQL support :( He told me he won't install it and I should use textfiles if I want to have database. I don't want to write engine to textfiles, so... Can You point where can I find PHP code which realize basic database functions without installing any not standard functions nor modules on unix/linux server? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php