re, and give it the
permissions you need it to have?
If that doesn't work, why don't you look up the connection error in google, or
paste it here? The number of the error code usually leads to where the error
comes from.
Cheers,
Matthias
--
PHP Database Mailing List (http://www
For some strange reason I get an :
Warning: failed to rollback outstanding transactions!: ORA-24324 : Service handle not
initialised in ... on line 0
I'm running 4.0.3pl1 as server module with OCI8-support for apache 1.3.14 and had no
problems with the same script under php3.
After some error(
So you like to let the SQL check for those constraints and you want only the
PHP to deal with that ugly error:
- disable the error output by placing @ before your php-function
- catch the error either by checking $php_errormsg (works only if
error-tracking is enabled) or by the result code or
This is not exactly a DB-Problem but:
> What I'm trying to do is after a user submits a form,
> PHP validates the
> form and if an error open a JavaScript popup window.
> I'm having trouble-getting PHP to either run the JavaScript
> or send the
> information to the browser so it can execute
Are you useing persistent connections (I had no real luck with them)?
How do you connect to your DB over Multi Threaded Server (MTS) or Dedicated
Server ?
I think Oracles NET8 Config has a Parameter to limit this.
Check out the MasterIndex at
http://technet.oracle.com/doc/server.815/a68826/toc.
> On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote:
> > Are you useing persistent connections (I had no real luck
> with them)?
> >
> > How do you connect to your DB over Multi Threaded Server
> (MTS) or Dedicated
> > Server ?
>
> I am just using p
Yes, same question. The only thing i know about, is that, if you are running
php not ass an module, your connection will die right ever script executing
therefore making OCIPLogon = OCILogon.
If run as module the connection will last till your server thread is
regenerated. Therefore it can have a
>How many of you have Oracle working with PHP4? What version of the Oracle
>drivers? Are you accessing a local db or a remote one? Did you have to
>tweak any settings to make it work? Windows or Unix?
PHP 3.0.16 / PHP 4.0.3
ORACLE 8.1.6
Remote + Local
No Problems with the "TNS No Service".
what is your complete line ?
maybe your counting environmental var that is not present in cronjob
execution
mk
-Ursprungliche Nachricht-
Von: Rahul Hari Bhide [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 6. Februar 2001 12:50
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] array_count_values
http://www.php.net/manual/en/function.ocilogon.php
tells you
int OCILogon (string username, string password [, string db])
so i assume that TEST is your User, web the password and pwd the
TNS-Identifier ?
I have a 8.1.6 DB (i guess thats what you have too), i#m using OCI8 libaries
and connecti
inary from src? I never did this, seems to be
difficult, hu?
mk
>Are you using PHP under windows with Oracle? PHP and Oracle work
>correctly under Unix.. but the Windows people are having loads of trouble,
>and I've yet to meet anyone who had it working.
>Mark Farver
Mat
you can use the meta column rownum
e.g. where rownum<20
note: you need to do subselects and (where rownum > 1) will never return a
line !!!
you could use something like
select * from
select rownum "rownumber", mydata from mytable order by
mycol
) where rownumber
OK:
imagine you want to find all rows where COLOR = 'foo' :
$st1 = ociparse ($conn, "SELECT count(*) FROM myTable WHERE COLOR =
'foo'");
ociexecute($st1,OCI_DEFAULT);
ocifetch ($st1);
$number_of_rows = ociresult ($st1, 1); //e.g. 372
$st2 = ociparse ($conn, "SELECT ID, NAME FROM myTable
>and to get rows, say, from 20 to 40?
>Is it ok to write:
>"select * from (select * from table where foocondition order by foo) where
>rownum >= 20 AND rownum <= 40"
its not that easy, as oracle start counting with the first retrieved row, so
rownum > x will wait for ever, as oracle will never st
use the display sourcecode function of your browser, it is more reliable
than the output.
try to get the char column with
ocifetch($stmt); $charcol = ociresult($stmt, "nameofcharcol");
maybe your using [] the wrong way so you are getting the chars of the string
instead of the strings in the row
you can use persistent connections or you can have the db-Environment do
that for you, e.g. COnnectionManager or ConenctionPooling of oracles NET8
mk
-Ursprüngliche Nachricht-
Von: Christopher Cheng [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 14. Februar 2001 11:27
An: [EMAIL PROTECTE
ot;308"
" A B C""626"
" " "702"
" A A N""1108"
" " "1109"
" 7 5 1""1112"
"" ""
"" ""
I will have a look at the
> I have only started to program in php over the past month or so.
> but I'm some problems with this bit of code below.
>
> Problem area
> require('$includefile.inc');
use " instead of ' because within ' the $variable will not get resolved
--
PHP Database Mailing List (http://www.php.net/)
To
MAYBE THERES ANOTHER WAY; but before selecting or fertching all you wont
know
Are you saying that, in php, every query has to be perfomed twice, if you
want
to know the number of rows in selection (before the fetch loop)?
Matthias Kopolt wrote:
> OK:
>
> imagine you want to find
confusion:
Using PHP 4.0.3pl1 with oci8 libraries and Oracle 8.1.6 there seems to be
problem when retrieving OUT-Variables from stored procedure, bind to a
variable.
for example i got an error retrun value (parsed to SQL as :1 and bind to
$error with a buffer of 4) it could !! happen that $error
>please create the shortest possible testcase that
>demonstrates your problem and send it to the list.
you need a PL/SQL stored procedure
like
CREATE PROCEDURE "SCHEMANAME"."P_TEST" (p_error out number) IS
BEGIN
p_error := 0;
END p_test;
than run a php script connecting to db and
> Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900)
violated ORA-06512: at
>"CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 in db.php on
line 344
this has nothing to do with PHP, this is your personal DB-Problem ;-)
A "constraint" is a DB-Rule that ke
try something like:
select a.memberID from table a, table b where a.choice=2 and b.choice=3 and
a.memberID = b.memberID;
or
select memberID, count(*) from table where choice=2 or choice=3 group by
memberID having count(*) = 2;
(i don't know what is more effizient, might depend on your indexes
>I am using windows2000 and when I run php it enables anyone on my network
>to allow php coding to make directorys in my computer..
>How can I disable this feature so they can only make directorys/files in
their own directory?
You could try to run php in secure mode (not sure if this helps you wi
>think you can give your problem another approach, splitting it in two
>queries and joining the result sets through php script.
>Sometimes you can't put SQL to do all the work.
That's true, but in most cases it is more efficient to leave the joins,
orders etc. in the DB, because its more optimze
look at your produced HTML-Code.
it may produce something like
I#M not sure if this is what you wanted to produce
echo("");
this would be more suitable
-Ursprungliche Nachricht-
Von: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 22. Februar 2001 22:36
An: [EMAIL PR
configure apache with modrewrite and configure it
to rewrite a request URL like
http://domain/DUMMY/1234109809--cookiedata---123412341234/file
to localfile url
/home/apache/triggeredpath/file
or use one php-file for your total website (maybe modular with includes),
then you can build URLS lik
YOu have to form proper SQL-Statements
try to parse and execute:
select foo_function ('paramstr', 999) from dual;
dual is a dummy table;
then fetch the resultrow and ociresult($stmt, 1) will return your
functionreturnvalue
mk
-Ursprungliche Nachricht-
Von: Richard S. Crawfo
le Function Calls
Here is the error that I get when I try this approach:
ORA-14551: cannot perform a DML operation inside a query
At 10:26 PM 3/7/01 +0100, Matthias Kopolt wrote:
>YOu have to form proper SQL-Statements
>
>try to parse and execute:
>
> select foo_fu
HI
I have a strange behaviour of my remote Apache-PHP-Oracle-Client.
Apache 1.3.14 mod SSL
PHP 4.0.3pl1 (everything compiled from sources)
Oracle 8.1.6 on remote Intel/Redhat 6.2 (100MBit, same subnet)
The Oracle Server runs a Multi-Threaded-Server (successfully) and accepts
d
>Another Question: Can users via PHP update field data in a MySQL database?
>I would really appreciate any comments.
PHP and MySQL (at standard ISPs) is a good (the best) choice for your
business.
It's cheap, fast and reliable, although i would not take my mission critical
parts
to an ISP.
check
hi!
is this correct: you want to check if there are two letters in the
password wich do not surround a digit? if so this is what you need:
// dies
$password = 'alfgoesswimming';
// dies too
$password = 'a2lf4g2o4e7s9s3w9i0m5m7i0n3g';
// survives
$password = 'a2l5f4g2o4e7s9s3w9i0m5m7i0n3g';
$foun
ives
$password = 'a2$5l5f4g2o4e7s9s3w9i0m5m7i0n3g';
$found = array();
$pattern = '#[^0-9]{2}#i';
if(preg_match_all($pattern, $password, $found)>0) {
die('You must have a number between 2 letters in your password ... 0-9');
} else {
die('password accepted');
hat there is at least 1 number in the password ?
// Larry
-Original Message-
From: Matthias Steinböck [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 1:41 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] regular expression help
hi!
is this correct: you want to check if there are
he moment). Maybe I can access the db via php like a
text file?
There are many question I have, sorry if this description isn't precise
enough. I'm glad about any hints, comments, suggestions, links or whatsoever
that would help me.
Thanks in advance to read and answer this long posti
mysql_close inside a function/class was executed PHP seems to
assume that the db link with the used ressource id is closed.
Since it isn't closed (we do read from apparently closed connections
above), the final mysql_close reports "not a valid MySQL-Link resource".
So somehow PHP loses information about the number of connection that
are working on the same mysql link/ressource id when mysql_close is
called within a function/class.
There are two Bugs in the Bug database which might be related to this,
but they are marked "closed":
http://bugs.php.net/bug.php?id=11201
http://bugs.php.net/bug.php?id=8634
Can someone reproduce this behaviour?
TIA, Matthias, Eike, Carsten
--
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'd like to have PHP drawing a chart based on temperature data in a mySQL
database.
Before I start inventing the wheel: does anybody know about finished code
which produces a *.png-Chart from a table of values in a database?
Gruss,
Matthias
--
Steiner Matthias
Student of Telem
JPGraph is exactly what I was looking for.
Thanks!
Gruesse aus Oesterreich,
Matthias
"Matthias Steiner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'd like to have PHP drawing a chart based on temperature data in
Hi!
The same way you compare variables:
$a = 'a';
if($a == 'a')
echo '$a is a';
define('_a_', 'a');
if(_a_ == 'a')
echo '_a_ is a';
Remember to use ' instead of " so that $a is echoed not the value of $a.
.ma
Shachar Tal <[EMAIL PROTECTED]> [EMAIL PROTECTED] 13:46 Uhr:
> Thanks.
and I changed companies and
forgot to take the code. But, seriously, this is not hard to use, once you
know how to use system calls in php.
Cheers,
Matthias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that top right
searchbox.
Matthias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ng them again. A
good filename approach is something still to do. Does it really matter, if
the filename is something identifiable? Is it not even nicer if it was
'image_title_'.$id.'.jpg'? more readable than a checksum?
Cheers,
Matthias
--
PHP Database Mailing List (http://www.p
error
everyone but me knows.
I'd alternatively use domxml_open_file (if that's the cure), but I get an
I/O error when I try opening a file, relative or absolute paths, same
directory or anywhere else. The content is fine after file_get_contents.
Help is highly appreciated,
Matthias
--
PH
so far no reply, but a little update:
I uploaded it to a linux server, similar setup(PHP4, apache1.3.something),
same problem.
Any ideas for a work-around? What do you use to edit XML on the
(php-)server? I don't have enough time to redo it for MSXML
Cheers,
Matthias
--
PHP Database Ma
t maybe you can change the
same thing by changing the character encoding in your browser manually and
not putting in any content-type. Once you've found what you need, put it in
as meta tag.
Cheers,
Matthias
-Original Message-
From: Rodrigo Haces [mailto:[EMAIL PROTECTED]
Sent: 10 O
That's a very common one. You're on windows, right?
Try putting in "consider upgrading MySQL client" into google. The first one
I found was this one:
http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Windows/Q_21252231
.html
Although the guy first claims it's not the OLD_PASSWORD problem,
2 possibilities:
either you put the defined value instead of the definition down in the
option value (but i'm sure you thought of this one)
or you use "echo constant($_POST['myType']);". Or GET, depending on how you
send your form.
Hey, this time I learned something, too! I found it in the php hel
print_r($_POST). As other people said, you probably
either forgot to session_start() somewhere, or the post screws up the
transparent session id thingy, or registerglobals is on.
Matthias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
> $q = sprintf("SELECT id FROM content");
This has nothing to do with your problem, but why don't you just do the
following?
$q = 'SELECT id FROM content';
But here's your problem. Change
> $realones = $row['id'];
into
$realones[] = $row[
s message, but the links I found didn't really
help me. :-(
Does anyone know, what's the meaning of this message? And how to solve
the problem?
Thank you .. in advance .. ,-)
Greetz
Matthias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, do any firewalls on PC B or PC A or other
network constraints let the communication through?
This is all fairly basic, but I hope it helps.
Cheers,
Matthias
--
Matthias Willerich
http://www.contentwithstyle.co.uk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
no
clue. My first guess is the API Version of the mysql client I am using with the
precompiled php binaries (Ubuntu 10.10 Server, PHP 5.3.2-1ubuntu4.7 with
Suhosin-Patch (cli) (built: Jan 12 2011 18:36:55))
Does anyone else have the same problems?
Thanks for any help,
Matthias
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
52 matches
Mail list logo