Hi folks,
I'm having difficulties getting php4 to connect to a remote oracle
database.
I have an entry in tnsnames.ora, along the lines of
shorthostname = (etc, etc)
and I can use sqlplus user/name@shorthostname to connect just fine, as
a regular user. Even without ORACLE_SID set, since I
On Mon, Jul 02, 2001 at 10:53:55AM -0400, Anthony Carlos wrote:
Phil,
Perhaps I'm being nit-picky, but shouldn't it be OCILogon($user,
$PASSWORD, $connect_string); ?
I have tried both
$user=realuser;
$password=actualpassword;
$dbname=oraclename
ocilogon($user,$password,$dbname
On Mon, Jul 02, 2001 at 02:07:38PM -0400, Brian S. Dunworth wrote:
Hi Phil,
Make sure that the web user (usually 'nobody' on an Apache installation)
has access to the $ORA_HOME/bin directory and permissions to execute the
binaries within. Also, be sure that ORA_HOME and ORACLE_SID
a little more info...
I've just tried a few public oracle-sql tools.
Seems to have the same problem.
I can connect just fine to the database using sqlplus.
But when I try the hand-compiled tools, linked against
libclntsh.so, it doenst properly authenticate to the remote system.
Hey...
On Tue, Jul 03, 2001 at 09:43:52AM -0400, Brian S. Dunworth wrote:
Hi Phil...
Since you have the server name (vs. the IP address) in the HOST= verb,
make sure you have an entry in /etc/hosts for a server called 'staging'
yes, that's there, otherwise, I wouldnt be able to use sqlplus
Hi everybody,
If I edit the php3.ini and activate a extension, I can see the effect with
the function phpinfo(). This works with all extensions, exept mssql.dll and
mssql70.dll. What am I doing wrong?? I dont think this is a general
problem!!
And, ladies and gentleman, I need help... thx!!
--
data row may be modified by different user at the same time.
Should I use Transaction in my queries ?
Regards,
Phil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in MySQL.However,there
are two
things I doubted as follows:
1.Can database owner who has been given lock privilege lock row??
2.I am not sure that using transaction as queries in PHP script is
the correct way to keep data's unity.
Regards,
Phil
Bastien Koert wrote:
Transactions are not necessarily
,
Phil.
-
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:0411-185-652
Fax: +61:2:8923-5363
E-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands
the appropriate C
function to talk to the tables and then pass data back to the php class?
Any other way of doing what I want?
Thanks,
Phil.
-
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:0411-185-652
Fax: +61:2:8923-5363
E-mail
what's going wrong.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
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
int)$Date_array[2] 59 AND (int)$Date_array[2] 100) {
$Date_array[2] = "19". $Date_array[2];
}
/*Make a unix time stamp out of the array elements */
$TransDate = mktime(0,0,0,$Date_array[1],$Date_array[0],$Date_array[2]);
Phil
--
PHP Database Mailing List (http://www.php.net/)
(and hence your
mysql_fetch_array calls will have an entry for that field containing an
entry string) and then back again to null. I've just tried it on my machine
and it works a treat.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP
the possibility of being caught out by errant scripts running
away with your machine.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
;crap!");
$db = mysql_select_db("fractalv", $connection) or die ("db");
$sql = "INSERT INTO Images (Image,
ImageType,ImageGallery,ImageLink,ThumbnailLink) VALUES
('$filecontents','$txtImageType', '$txtImageGallery', '$txtImageLink',
'$txtThumbnailLink')";
$sql_resul
Perhaps the quote marks within quote marks? PHP,as is javascript, very
particular..
Try:
echo "Name: $row['user_id'].'br\n"; or some such.
or
echo "Name".$row[user_id]."br\n";
It's the quote marks within that are playing havoc..
Phil J.
Chris Hall wrote:
I keep
to send
consultants for hundreds of dollars an hour to tell you what you could
figure out if their
reference manuals weren't circular refernces to obtuse garbage...
Phil J.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comm
Dunno without looking at code, but try storing the value of $customer into a
local variable when the script is invoked - something is wiping it clean.
my thunks,
Phil J.
Scott Kalbach wrote:
I am having a problem with losing a variables value. What I am doing is
taking the value from
in a few lines with ODBC.. - but I have a
project
using both DB2 on a mainframe and DB2 UDB - so I am very interested in your
thoughts on all this!
Phil J.
Chris Book wrote:
Hi,
I've compiled php before with --with-ibm-db2 to use DB2's CLI driver. Now
I'm working on NT with the php binary, and I
I think your only choices are to put this value into either a database or if
you are using
php4 - to use a session varible - or use a cookie if you are trying to
persist this value
across multiple pages for multiple users...or pass as a querystring to the
next page..
or as a hidden form variable
What is retrieved if you do a Select Count(*) from myDb where
condition = parameters?
Seems your result set should contain this value...
Phil J.
DC wrote:
Hi All
I cant quite work out how to count the number of rows in my mysql db that
match a certain critieria and the show that number
isn't
nor is model.
$sql = "Select * from someDB where make =" . $make;
If $model "" {
$sql = $sql . " And model = " . $model;
}
If $color "" {
$sql = $sql . " and color=" . $color
}
Build your sql string incrementally and conditionally
t;mime_mail.inc" and a "mail.php" file that are
good examples.
Phil J.
"Pedro M. S. Oliveira" wrote:
hello all. this is what i need to do
i have a dinamic page, buitl with mysql and php,
and then i have this form saying, send this page to a friend.
how can i send the content
, as the "arrows" would somehow comprise a form.
Phil J.
CC Zona wrote:
In article 001301c0bafa$34d15be0$[EMAIL PROTECTED],
[EMAIL PROTECTED] ("David Drummond") wrote:
Can anyone tell me what is the best way to implement displaying multiple
search results using next
mber.focus()
alert("Enter fleet vehicle number")
return false
}
Have a look at http://www.wsabstract.com/ for good javascript info.
good luck,
Phil J.
"Julio Cuz, Jr." wrote:
Hi--
I have a form that cannot have a specific field blank, so I would like to
add
rver on PC, if you will) for future
development. Best I can say here to anyone is "stay away"!
My vote is with MySql, unless you'vegot to do triggers, sub-selects, or
views, or simply have to create work for a pre-existing DBA
Phil J.
"Brian.J.Mauter" wrote:
Hey,
Hmmm...given that the form fields all had the same names - i.e. you were
performing
the same sql, you could use and include or "required" file that did all the DB
work.
Or - you could have a generic includr file function that you passed a
connectstring and
sqlstring to as variables..
Hi,
Check out
http://www.zdnet.com/devhead/stories/articles/0,4413,2643888,00.html
for a good workable example of using PHP/MySql to do this - the principles
should
be the same.
Also, search www.asptoday.com for the word "blob" to find some good articles
on the topic.
Phil J.
Marc
ge 1 - set a session variable $visitedPageOne = true
On the top of that page, first thing - check for the value of $visitedPageOne, if
true, redirect to the next page, ect.
Phil J.
olinux wrote:
I am using sessions to store variables until all forms have been filled out. at this
point th
t;;
$sql_result = mysql_query($sql,$someconnection) or die ("could not insert into DB");
mysql_close($someconnection);
--
Hope this helps..
Phil J.
Zeus wrote:
I'm trying to do a filexchange script.
Does anyone know how t
else if
it appears elsewhere - and don't change it's type!
Phil J.
- Original Message -
From: "Richard Scott Crawford" [EMAIL PROTECTED]
To: "Phil Jackson" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, April 22, 2001 1:17 AM
Subject: Re: [PHP-DB] Designing a datab
that type behavior will not be tolerated - the goal here is to share
info and all benefit and become more proficient - folks come into this from
all levels of experience - The only really stupid questions are those that
go un-asked!
My Thoughts,
Phil J.
Paul S wrote:
I have a question that I
in a text field
Phil J.
Joni Jrvinen - Wandu wrote:
Hey
I'm quite new to databases so I though I'd ask you for
some tips in designing a database.
The db that I'm supposed to design holds information
about workstations: Motherboard (Motherboard id, # of pci slots,
agp slot etc etc.),
Try stripslashes(fieldname) to "unescape" those slashes when retieving from DB
Phil J.
Jennifer Arcino Demeterio wrote:
Hello all,
I am having a problem in inserting text with apostrophe to mysql database.
When a user fills out a form field that includes an apostrophe
material...
Phil J.
Doug Schasteen wrote:
I've been programming PHP w/ mysql for almost 2 years now for my company. We develop
online testing and surveying software. We are currently running operations for a few
specific companies where maybe 20-30 tests will be taken online per day
flexiblity, but
keep it simple enough that you don't have to join 30 tables together to
display one studen't class schedule...
Phil J.
Duke Normandin wrote:
I asked this a year or so ago, but never did receive a "practical" reply
that I could understand. So I'll give it another shot
Check www.p2p.wrox.com...more later on this
Phil J.
Nicolas Machado wrote:
Hy, somebody knows if exist a driver for database access to DB2/400, running
on AS/400.
Something like a module.
Thanks.
---
Este Mail NO contiene Virus.
Checked by AVG anti-virus system (http
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
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
remember!) you will find them easier to read,
maintain, and also spot obvious errors.
Hope this helps,
Phil J.
Todd Pillars wrote:
I have checked the mysql.com docs and phpbuilder.com and zend.com and I am
more confused than ever on selecting a single common record from multiple
tables. Here
gave to the previous post for more extensive
info...
Phil J.
Sharmad Naik wrote:
I have written a small script having connectivity with postgresql which
can upload an image and display the already uploaded images.
But it doesn't display the uploaded images. I guess the problem lies
(but as with all versions
of php, it does not include MySQL itself).
Cheers
--
Phil Driscoll
--
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]
Hi,
Could someone let me know if it is possible to pass a resultset of a query
to a single variable so it can be included as the message part of the mail
function?
Thanks!
Phil Dowson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
TEMPORARY
TABLE rights.
Any ideas why this is intermittent?
Thanks for your help!
Phil Dowson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
]
To: Phil Dowson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 2:29 am
Subject: Re: [PHP-DB] Create Temporary Table
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP
On Tuesday 12 August 2003 10:39 am, Phil Driscoll wrote:
The modulus is the remainder after division hence 5 into 24 goes 3 times
with a remainder of 4,
oops - 4 times with a remainder of 4 :(
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
with
a remainder of 4, hence
$mod=25%4
gives $mod=4
Cheers
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
an index on that field will speed things up lots -
especially as the table becomes big.
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
',
PRIMARY KEY (`statid`)
) TYPE=MyISAM;
select count(weekday(stat03)) AS dayname from stat where and
date_format(rms03,'%m %Y') = '09 2003' and weekday(stat03) = '0'
I hope this is a simple question, I've googled for over an hour and I'm
drawing blanks.
Thanks!
Phil Dowson
--
PHP Database
['recip']; echo $recip; ?
However, all this manages to do is to print out this:
Send e-mail to $myrow[0]
Instead of the VALUE contained in the variable!
What am I doing wrong?
TIA --- Phil Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
that the syntax would be (where $foo is another variable)
a href=email.php?foo='.$myrow[3].'?recip='.$myrow[0].'
Thanks again for restoring my sanity!
Cheers --- Phil Matt
on the various
PHP lists
and sources, but I just cannot figure out this piece of the puzzle.
TIA for your suggestions, and for your patience with my lack of knowledge here.
-- Phil Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
if I've appended those two things
correctly.
TIA for your continued assistance.
Cheers --- Phil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
De-lurking here. I am trying to modify a mailing script that I originally wrote to use a small form
to send mail to different people from a MySQL database. I would like to modify it so that instead of
using a form, the user's regular default email program opens on activating the link. I can't
I've got a mail form that automatically pulls in the addressee from a MySQL db,
and lets the sender
fill in his/her own info before sending. I figured out how to set up tests for
legal input in the
different fields, but I don't know how to incorporate the test results into my
form submission
really want though Currently working with a dataset of 89 million records,
will be expanding that to many many more times that... To the tune of possibly
a couple billion records...
Any ideas? :)
PostgreSQL?
;-)...
Cheers,
Phil...
--
Nothing to see here... move along, move along
but the downside is that it's a very steep learning curve
after coming from mysql.
It's relatively easy to install there are the drivers of course for PHP
but it'll take up a lot of your time to learn it to the extent of being
confident with it in my experience.
Good luck,
Cheers,
Phil
56 matches
Mail list logo