On/El 16/03/09 13:03, Mark Halling-Brown wrote/escribió:
Grant, thank you very much. You are a life saver. This worked perfectly.
Thanks again
Mark
No problem,
g
--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.org/grant
It was so much easier to blame it on Them
some where near the top of apachectl, I cannot tell you
exactly since fink will not install and MacPorts does not build SQLite3.
Restart apache and you should see the correct values in getenv() or
phpinfo().
regards
grant
On/El 16/03/09 12:13, Mark Halling-Brown wrote/escribió:
Hi Grant,
T
;setenv" or "export" in
csh/bash/etc. Apache maintains its own symbol table for environment
variables. Unless the OCI8 extension calls apache_getenv those
declarations will have no effect.
regards
grant
--
Grant Croker - Ingres PHP and Ruby maintainer
http://blogs.planetingres.or
ave any further questions
regards
grant
Ingres PECL maintainer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
sel_row[12]\",\"$sel_row[13]\",\"$
sel_row[14]\",\"$sel_row[15]\",\"$sel_row[16]\",\"$sel_row[17]\",\"$sel_
row[18]\",\"$sel_row[19]\",";
print
"\"$sel_row[20]\",\"$sel_row[21]\",\"$sel_row[22]\",\"$sel_row[23]\",\"$
sel_row[24]\",\"$sel_row[25]\",\"$sel_row[26]\",\"$sel_row[27]\"\n";
}
Thanks,
Grant Griffith
Web Application Developer
Enhanced Telecommunications
http://www.etczone.com
812-932-1000
-Original Message-
> From: "Alex Gemmell" [EMAIL PROTECTED]
> Date: 13/12/2005 14:07
> Hello,
Hi
> I'm experiencing some odd character encoding issues. My PHP webpage is
> displaying test from a MySQL database. What happens is that I export
> data from an SQL Server database to a M
{$data} ";
print "\n";
}
Thanks ahead of time for your thoughts and recipes :)
Grant
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi
I did actually encounter that problem. However, wouldn't redirecting
properly still allow the user to resubmit the information using the back
button? I solved this problem a different way by setting and clearing
session variables on entry and exit to a series of pages.
Grant
On Fri,
I'm very new to PHP so somebody correct me please if this is a bad
idea...
I had the same problem and I ended up just including the second page at
the end of the first one:
Grant
On Fri, 2003-05-30 at 09:43, Rick Dahl wrote:
> The scripts I need to run before I redirect automatica
PROTECTED]]
Sent: Thursday, January 23, 2003 8:21 PM
To: Grant, Dean (OIT); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ms sql limit equivalence
> I am just joining this list so if this has been covered in the past I
> apologize. I am working with MS SQL and would like the functionalit
Hi,
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality that
MySQL's limit function provides. I understand that MS SQL has no such
command or equivalent. Has someone found a way to use standard (or MS SQL
spe
x27; '--enable-discard-path'
'--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--without-oci8' '--with-imap=shared' '--with-imap-ssl'
'--with-kerberos=/usr/kerberos' '--with-ldap=shared'
'--with-mysql=shared,/usr' '--with-pgsql=shared'
'--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath'
'--enable-shmop' '--enable-versioning' '--enable-calendar'
'--enable-dbx' '--enable-dio' '--enable-mbstring'
'--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs'
Any help would be greatly appreciated.
-Grant
Grant P. Kohler
Technology Consultant
The Information Age, Inc.
[EMAIL PROTECTED]
770.838.0373
The different machine has nothing to do with the config, and everything
to do with the connect. It is in the connect string that you specify
which machine for PHP to connect to Postgres.
Joe Nelson wrote:
>I'm trying to configure php so that it will have support for both MySQL
>and Postgres.
I mostly agree, although I prefer PostgreSQL for the transactions,
better row locking, and server side cursors. It also does better with
lotsa users (if the data isn't just used for the web, this is
important). I have used many languages for this stuff, and the one with
the best balance of f
Access has to be running on a Winders machine. At least the drivers.
Another option might be to migrate the data, and use ODBC and linked
tables to let Access still work temporarily, but really have the data
already transitioned.
Otherwise it is a weird linked ODBC bouncing off a Windows mac
Look in you apache.conf file and find out what user the web server runs
as, then give that user the right to write to that directory, probably
through a group used for nothing else is most secure.
Brian Mauter wrote:
>To get around this, I made a small shell script which runs as root. The php
The web server user needs to have access to that directory. On NT,
there are 2 of these users. On *nix, there is one. Giving these users
access to write to that directory is not a huge risk.
koelwebdesign wrote:
>hi there,
>I've searched the lists and forums for a couple of days now but nop
> The 600$ alternative
> http://www.zend.com/store/products/zend-developer-suite.php
>
> / LJ
>
$0 option:
Put your user ID and password in a config file, then give only the
webserver user access to it. Read the config file to make it work. This
also allows easy switching between test and produc
ning" mode
indefinitely. The web page loads as normal BAH!
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
"Grant Boggs" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "Steve Brett" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > no need to recompile.
> >
"Steve Brett" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> no need to recompile.
>
> the debug server is a .so and only needs added lines php.ini
>
> we used the windoze ide clients whihc install easily if you have JRE. if
not
> you need to downoad/install.
>
mpile both of these products to get the Zend
debugger installed?
Recompiling now... heh
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
This does not sound like a MySQL problem, but more likely a poor indexes
problem. PostgreSQL does scale bigger than MySQL (more users) but you are
probably nowhere near that limit. When you have more than 25 concurrent
users (remember that the web server is probably only one or 2 unless it is
re
"Grant Boggs" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone use the Zend IDE for development?
>
> My code is getting complicated enough that I need a step-execute
capable
> debugger. Where I can set br
And see what that pops up. If you did it by rpm, mysql is probably in a
/etc/mysql directory.
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
other recommendations?
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
However, the concept of the filename on the drive having nothing to do
with the real original useful filename was the real point. You can then
save whatever type of file you want, point to it, and tell the user on the
other end what to save it as.
The most useful schema would be to have the name of the document be system
generated, like i123456789.img and make the database as follows:
Image
Image_Name varchar(50) primary key
Original_Name varchar(50)
Description text
User
User_ID int8 primary key
Login char(8) uniques index
password varch
I figured as much. Thanks guys!
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
I'm inserting
int, update it's value, write it back, then use that key to insert into the
main table?
--
==
Grant Boggs
http://www.cornersonesoftware.ws
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comman
On Wed, 22 Aug 2001, Tim O'Brien wrote:
> What is the best method to move data from access tables to postgreSQL?
>
> Are there are php functions that are available?
>
Unfortunately, only Access reads Access very well, but you can use ODBC
and linked tables in Access to copy it to PostgreSQL.
--
Hi,
I have this code after a user submits a form with name, description and
image file upload fields:
images/people/preview is simply a unix link to /tmp/phptempimg-ian.grant
The problem is, when this script is run, the image show is that from the
previous operation. If you refresh the page, the
ch_row($result);
$id = $row[0];
return $id;
}
Ian.
Ian Grant <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> mysql_insert_id([resource link_identifier]) returns the value of the
> auto_increment field for the previous INSERT quer
mysql_insert_id([resource link_identifier]) returns the value of the
auto_increment field for the previous INSERT query. It will return 0 if
there is not an auto_increment field. If the link_identifier is not
specified, the last opened connection is used.
So, use $id = mysql_insert_id(); directly
This uses PostgreSQL, but the concepts are the same for MySQL.
On Fri, 17 Aug 2001, Alex wrote:
> Could you give me an example?
>
> Grant wrote:
>
> > That Resource ID #2 is the connection or result set. You need to use the
> > connection to do a query, which returns a
That Resource ID #2 is the connection or result set. You need to use the
connection to do a query, which returns a result set, then use the result
set to do fetches. Those will return an array of the stuff you really
wanted.
__
Okay thanks, I'll have a look at that.
I am right in thinking that ActiveX controls can work in Netscape, as long
as Internet Explorer (>4.0) is installed?
Ian.
John Pickett <[EMAIL PROTECTED]> wrote in message
001501c1269f$c977ed20$4c6146a6@notebook">news:001501c1269f$c977ed20$4c6146a6@notebo
tag would be
better, considering the users are not going to be HTML-proficient.
However, I cannot seem to find anything like this that doesn't cost loads.
Does anyone know of anything similar?
Thanks,
Ian Grant.
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
Perrin wrote:
> ==> $connection = pg_connect("$constr user='$USER' password='$PW'");
>
> Actually It should be closed the connection after access finished, like that
>pg_close();
>
> ==> pg_close($connection);
>
> But if the user force to close the web page that means have not close the
>con
Yes, thank you, this works!
Ian.
Paul Burney <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> on 8/10/01 7:50 AM, Ian Grant at [EMAIL PROTECTED] wrote:
>
> > I've got a simply search form, on my site using PHP and MySQL.
>
Hi,
I've got a simply search form, on my site using PHP and MySQL.
It writes a SELECT query using WHERE ( LIKE '%thingy%') where thingy
is the word entered in the form. It works fine if the submit button is
pressed, but if you press return after typing the word, instead, it fails
and writes noth
Another possible solution (although more drastic) is to switch DBMS's. I
use PostgreSQL with no troubles. However, 6.5 and earlier are not so
great performance wise. 7.0.3 is OK, and 7.1.2 is exceptional. It also
now (finally) supports outer joins and write ahead locking.
If you are at the be
2 ideas:
1) Define the loosest item that returns results (likely regex) then search
with slightly tighter criteria within the results.
Good for situations where even partial matches are a small percentage of
the total data
2) Check every record, and give it a score based on proximity to the
sear
Eric Marenyi wrote:
>
> I am trying to develop a dynamic website, but I dont have the capability to
> use SQL, or Access databases, can I use PHP to interface with a different
> type of database?, maybe a text delimited, or something, please help, thanks
>
> --
> Eric Marenyi
> CEO Virtual Briti
On Fri, 3 Aug 2001, Robert Fitzpatrick wrote:
> Hello:
>
> I configured PHP originally --with-mysql and now I want to also use
> PostgreSQL with PHP. Can I just re-run the './configure --with-mysql
> --with-pgsql --enable-track-vars' again. Then do another 'make' and 'make
> install'?
>
> Thanks
last row with
> empty cells.
>
> "Ian Grant" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi,
> >
> > Can anyone help me with this - I have a database of people, that I want
to
> > print into an HTML t
Hi,
Can anyone help me with this - I have a database of people, that I want to
print into an HTML table - how can I make the table wrap into an equal
number of rows.
i.e. if there are 4 entries, a 2x2 table, 6 a 2x3, 8 a 2x4, 9 a 3x3, etc.
At the moment, I have something like:
$rows=mysql_num_r
Sorry I am not replying to the thread. I deleted the message, not
thinking.
If you install PostgreSQL from source, and take the defaults, it puts
its files in /usr/local/pgsql/... Each of theses subdirectories
matches one in /usr/local/... What I do is create symlinks win
/usr/local so I don
Hello all
Is there any way of using a string in an SQL query instead of using the
table name. Something along the lines of
$result=mysql_query("SELECT * FROM $tablename",$db);
this doesnt work it come up with a parse error
thankyou
Grant
--
PHP Database Mailing List (http://w
he search engine visitors.
I could do that, but it seems to defeat the purpose of the dynamic pages
somewhat... pity.
Any other ideas? How do others deal with this issue?
Regards
Grant
---
Grant Ballard-Tremeer,
HEDON Household Energy Network http://www.ecoharmony.net/hedon/
e
50 matches
Mail list logo
