[PHP-DB] mysql_insert_id()
Is there a known way to "reset" this field? If I make a call and it succeeds, then it should be set. If it fails, shouldn't it at least be reset to 0 or -1 instead of simply the last successful insert? Is this the expected behavior? -Szii -- 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]
Re: [PHP-DB] Displaying Graphics dynamically
Mike: Depending on the number of images you wish to insert into the database, you might wish to opt for the path to the image to be stored not the image itself. img src="pathtoimage.gif" border="0" Then use some sort of loop (I use a for loop) to go through the table data (of paths-to-images) and display them dependent on whatever criteria it is you are using. HTH :) Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- 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]
[PHP-DB] Using selected fields
Hi there,
Firstly a big thanks to those who pointed me in the direction of 'PHP-fast and
easy web development'. it was/is a great book, and I have learnt loads on the
past week.
Anyhoo...
I have a php page and included the line:
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\"
";
Now I have a third column called 'userlevel'.
I have a cookie that activates on successfully matching the member and pw fields
from a form on the previous page. make sense?
How can I tell the page to use the userlevel colunm too?
Here is the relevent section to my code... can anyone point me in teh rigth
direction please???
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\"
";
$result = mysql_query($sql)
or die ("Can't execute query.");
$num = mysql_numrows($result);
if (($num != 0) ($userlevel == 1)) {
$cookie_name = "auth";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain ="";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/", $cookie_domain, 0);
$display_block ="
pBSecret area:/B
UL
LIa href=\"secreta.php\"secret page a/A
LIa href=\"secretb.php\"secret page b/A
LIa href=\"secretc.php\"secret page c/A
LIa href=\"secretd.php\"secret page d/A
LIa href=\"secreteb.php\"secret page e/A
/UL
";
} else {
header("Location: http://www.mypage.com");
exit;
}
=
Thanks guys...
Tris...
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**
--
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]
RE: [PHP-DB] Displaying Graphics dynamically
I would recommend this too. Also to make it easier, instead of giving the updating person FTP access to upload tha images, I used an Upload page using PHP to a certain images directory on the web server and all PHP links then are pointed to this directory so all img links look something like this IMG SRC="pics/? $image_name_variable ?" I am very much a beginner and was delighted to get this working I used a variation off the following site http://www.thickbook.com/extra/php_fileupload.phtml I wish you well All the Best Lisa -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 10:33 AM To: Mike Hammonds Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Displaying Graphics dynamically Mike: Depending on the number of images you wish to insert into the database, you might wish to opt for the path to the image to be stored not the image itself. img src="pathtoimage.gif" border="0" Then use some sort of loop (I use a for loop) to go through the table data (of paths-to-images) and display them dependent on whatever criteria it is you are using. HTH :) Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- 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]
Re: [PHP-DB] Using selected fields
Sure:
while($row = mysql_fetch_array($result)) {
$usrLevel = $row['userlevel'];
$member = $row['member'];
$pswd = $row['pw'];
}
//end -while loop
Now $usrLevel, $member and $pw are available as variables taken from
this array to use as you please in you php scripts!
Russ
Hi there,
Firstly a big thanks to those who pointed me in the direction of
'PHP-fast and easy web development'. it was/is a great book, and I have
learnt loads on the past week.
Anyhoo...
I have a php page and included the line:
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\" ";
Now I have a third column called 'userlevel'.
I have a cookie that activates on successfully matching the member and
pw fields from a form on the previous page. make sense?
How can I tell the page to use the userlevel colunm too?
Here is the relevent section to my code... can anyone point me in teh
rigth direction please???
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\" ";
$result = mysql_query($sql)
or die ("Can't execute query.");
$num = mysql_numrows($result);
if (($num != 0) ($userlevel == 1)) {
$cookie_name = "auth";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain ="";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/",
$cookie_domain, 0);
$display_block ="
pBSecret area:/B
UL
LIa href=\"secreta.php\"secret page a/A
LIa href=\"secretb.php\"secret page b/A
LIa href=\"secretc.php\"secret page c/A
LIa href=\"secretd.php\"secret page d/A
LIa href=\"secreteb.php\"secret page e/A
/UL
";
} else {
header("Location: http://www.mypage.com");
exit;
}
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
http://gertrude.sipu.anglia.ac.uk/webteam
[EMAIL PROTECTED]
+44 (0)1223 363271 ext 2331
www.theruss.com
#---#
--
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]
[PHP-DB] Ordering Articles
Hi, I'm trying to build an article management system. Basically it will have normal artcile type things, a picture or two etc. The articles will be ordered by date by default, but I want to include the option of being able to order the articles if need be. i.e. say I add more artciles but i still want one of the older artIcles to be at the top of the list, how would I do that? I hope this is clear, Cheers, Jord -- 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]
FW: [PHP-DB] Using selected fields
-Original Message-
From: Steve Brett
Sent: 12 March 2001 11:40
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Using selected fields
I have a similar security setup in the app i'm working on at the moment, but
attack from a slightly different angle.
i have two tables, one that stores user details and a second that stores
security details.
i match on username and password and then load the corresponding security
details.
i then set a session var that says they are logged in and then have an
include file in every page to kick them out if this is not set. ech set of
security settings laso has a user level that is also set as a session var
and then read by pages that need to.
as for getting your details you would need to extract the relevant recordset
via a call to the db you use:
for mysql something like
$secdets = mysql_fetch_array($result);
and then access each attribute by:
$level = $secdets[$userlevel];
HTH
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 12 March 2001 10:50
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Using selected fields
Hi there,
Firstly a big thanks to those who pointed me in the direction of 'PHP-fast
and
easy web development'. it was/is a great book, and I have learnt loads on
the
past week.
Anyhoo...
I have a php page and included the line:
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\"
";
Now I have a third column called 'userlevel'.
I have a cookie that activates on successfully matching the member and pw
fields
from a form on the previous page. make sense?
How can I tell the page to use the userlevel colunm too?
Here is the relevent section to my code... can anyone point me in teh rigth
direction please???
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\"
";
$result = mysql_query($sql)
or die ("Can't execute query.");
$num = mysql_numrows($result);
if (($num != 0) ($userlevel == 1)) {
$cookie_name = "auth";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain ="";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/", $cookie_domain,
0);
$display_block ="
pBSecret area:/B
UL
LIa href=\"secreta.php\"secret page a/A
LIa href=\"secretb.php\"secret page b/A
LIa href=\"secretc.php\"secret page c/A
LIa href=\"secretd.php\"secret page d/A
LIa href=\"secreteb.php\"secret page e/A
/UL
";
} else {
header("Location: http://www.mypage.com");
exit;
}
=
Thanks guys...
Tris...
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**
--
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]
--
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]
Re: [PHP-DB] Sybase character set warning
Hi i found this: Undocumented parameter "charset" ... The complete prototype of sybase_connect is : int sybase_connect([string host [, string user [, string password [, string charset). If , after a "sybase_connect", you receive a message like : " Sybase message: Cannot find the requested character set in Syscharsets: name = 'ÎU'. (severity 11) ", call sybase_connect like this : sybase_connect($host,$user,$password,'iso_1'); (if your charset is not 'iso_1', the next error message will tell you the good one !) and it will work fine ... "Dennis Luo" [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... To all the experts, I have a small problem with PHP4 connecting to Sybase. Everytime when I connect to a sybase database, the following warning comes up: bWarning/b: Sybase message: Cannot find the requested character set in Syscharsets: name = 'Ü®X'. (severity 11) Looks like there is a char set problem. Can you please help. Cheers, Dennis -- 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] -- 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]
Re: [PHP-DB] Sybase character set warning
http://www.php.net/manual/de/function.sybase-connect.php -- 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]
[PHP-DB] metabase docs / opinions on DB interfaces
Does anyone know if there is any documentation for metabase? I can't seem to find any, and the source at phpclasses didn't come with any. Also, can anyone confirm whether metabase translates SQL between DBMSs? For instance, if I used a query that would work on MySQL but not on Oracle, would metabase translate the query? Also, does anyone have an opinion on what database interface is the best, and under which circumstances? I'm developing an app that would be used on different platforms with different DBMSs -- would metabase be best for this? Thanks. Dean. -- 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]
[PHP-DB] newbie: MySQL importing data from a variable
Hi, I've been trying to get this script to read a directory and then pass the
information into a Mysql table. I can open the directory and print it's contents, or
I can get other information from variables passed to the mysql table, but I can't seem
to do both. If you have any idea what I've done wrong or have an idea where I can
read more about this problem your thoughts will be greatly appreciated.
Sincerely,
Gavin Tong
?php
$handle=opendir('.');
while (false!==($file = readdir($handle))) {
if ($file != "." $file != "..") {
echo "$file\n";
}
}
closedir($handle);
$db = mysql_connect("local host", "person", "pasword");
mysql_select_db("photos",$db);
$result = mysql_query("insert into template (name) values ('$file')",$db);
?
[PHP-DB] limit in informix
I have the same problen of Fredrik Is there any equivalent to MySQL's LIMIT x,y in Informix Dynamic Server 2000? thanks Luigi -- 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]
Re: [PHP-DB] LIMIT in MS SQL
I think so, but check the SS lang manual. It should be under the syntax for SELECT, maybe it's called "TOP". Haven't worked with SS for a while. MIles At 02:24 PM 3/12/01 +, Fredrik Wahlberg wrote: Is there any equivalent to MySQL's "LIMIT x,y" in Microsoft SQL-Server? /Fredrik -- 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] -- 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]
[PHP-DB] Re: [PHP] PHP Book
That was the PostgreSQL book. I think it's still there as HTML, but hey, support the cause and buy his book. Miles At 11:15 AM 3/12/01 -0300, you wrote: Hi all, I am new at PHP and I realize that the pdf format of the PHP Book by Bruce Momjian at http://www.php.net has been removed from there and now there is only the html format (I guess I arrived very late to get the pdf format). Has anybody downloaded the pdf file of this book when the link was active ??? I really would like to get it. Thanks in advance, Marcelo Pereira Unicamp - Brasil -- 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]
Re: [PHP-DB] LIMIT in MS SQL
Yep there is- its called TOP Example: SELECT TOP 2 * FROM Table Fredrik Wahlberg wrote: Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server? /Fredrik -- 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] -- 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]
[PHP-DB] Re: [PHP] PHP Book
Hi, Yes, I will buy the book, but it is available only in english by now... I am waiting the portuguese version. I dont like very much to read files at the computer (my eyes get tired soon). When the portuguese version isn't ready I would like to see the english version. I dont spead english very well, but I could see any example. Thanks Marcelo Pereira Unicamp - Brazil - Original Message - From: Miles Thompson [EMAIL PROTECTED] To: Marcelo Pereira [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 12, 2001 11:36 AM Subject: Re: [PHP] PHP Book That was the PostgreSQL book. I think it's still there as HTML, but hey, support the cause and buy his book. Miles At 11:15 AM 3/12/01 -0300, you wrote: Hi all, I am new at PHP and I realize that the pdf format of the PHP Book by Bruce Momjian at http://www.php.net has been removed from there and now there is only the html format (I guess I arrived very late to get the pdf format). Has anybody downloaded the pdf file of this book when the link was active ??? I really would like to get it. Thanks in advance, Marcelo Pereira Unicamp - Brasil -- 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]
[PHP-DB] must I while loop
OK, if I am extracting a row from a mysql DB where I know that there is only ONE row:
$result = "SELECT company, fname, lname FROM table_name WHERE id = \"$id\"
";
I am should be able to use the variables right away... at least I would think so, I
don't think I should have to run through a whileloop and create an array. But to make
it work I had to.
while ($row = mysql_fetch_array($result)) {
$company = $row['company'];
$fname = $row['fname'];
$lname = $row['lname'];
$contact_info .= "$company $fname $lname";
So my question, shouldn't I be able to use the variables $company $fname $lname before
the WHILE loop since I know that there is only one record?
olinux
Re: [PHP-DB] LIMIT in MS SQL
But with TOP I can't start on any row I want? I would like to be able to select rows 40 through 60 or something similar. /F Ursprungligt meddelande Trey Sheldon [EMAIL PROTECTED] skrev 2001-03-12, kl. 15:35:38 angende mnet Re: [PHP-DB] LIMIT in MS SQL: Yep there is- its called TOP Example: SELECT TOP 2 * FROM Table Fredrik Wahlberg wrote: Is there any equivalent to MySQL's ?LIMIT x,y? in Microsoft SQL-Server? /Fredrik -- 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] -- 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] -- 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]
RE: [PHP-DB] must I while loop
Hi
OK, if I am extracting a row from a mysql DB where I know
that there is only ONE row:
$result = "SELECT company, fname, lname FROM table_name WHERE
id = \"$id\"
";
snip
So my question, shouldn't I be able to use the variables
$company $fname $lname before the WHILE loop since I know
that there is only one record?
You have to make use of the mysql_result() function, the code would look
something like this:
$result = mysql_query("SELECT company, fname, lname FROM table_name WHERE id
= '$id'");
$company = mysql_result($result,"0","company");
$fname = mysql_result($result,"0","fname");
$lname = mysql_result($result,"0","lname");
Emil
--
Emil Rasmussen
http://www.noget.net
--
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]
RE: [PHP-DB] must I while loop
yea, you can use the same code that you are just take out the while loop I
do it all the time.
Thank you
Brian Paulson
Sr. Web Developer
[EMAIL PROTECTED]
http://www.chieftain.com
1-800-269-6397
-Original Message-
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 10:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] must I "while" loop
OK, if I am extracting a row from a mysql DB where I know that there is only
ONE row:
$result = "SELECT company, fname, lname FROM table_name WHERE id = \"$id\"
";
I am should be able to use the variables right away... at least I would
think so, I don't think I should have to run through a whileloop and create
an array. But to make it work I had to.
while ($row = mysql_fetch_array($result)) {
$company = $row['company'];
$fname = $row['fname'];
$lname = $row['lname'];
$contact_info .= "$company $fname $lname";
So my question, shouldn't I be able to use the variables $company $fname
$lname before the WHILE loop since I know that there is only one record?
olinux
--
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]
[PHP-DB] PHP Book
Hi all, I am new at PHP and I realize that the pdf format of the PHP Book by Bruce Momjian at http://www.php.net has been removed from there and now there is only the html format (I guess I arrived very late to get the pdf format). Has anybody downloaded the pdf file of this book when the link was active ??? I really would like to get it. Thanks in advance, Marcelo Pereira Unicamp - Brasil
[PHP-DB] NT4 PHP4.0.4pl1 IIS Ingres
Hello Folks, i try to connect to an ingres - db but it does not work. in the distribution-ZIP-File there is an extension-dll ( php_ingres.dll ) This dll are in the same directory as the php.exe, but i receive always the message: unable to load ./php_ingres.dll. Strange: in the php.ini there is no line with extension=php_ingres.dll so i write such a line into php.ini. What did happend ?? Any Hints Thanks -- 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]
Re: [PHP-DB] PHP/Oracle/mod_ssl/Apache
Hi Steve, if you use OciPLogon to connect to ORA, bad luck. Replace with OCiLogon and your problesm are gone. Of course, *always* remember to ocilogoff() your open connections. In my experience OCIPLogon is broken. It never closes open connections to ora, instead it waits for them to timeout, even if ocilogoff has been called, not a very smart thing... other than that, I have not encountered any problems with SSL or non-SSL connections. Yes, the number of open connections is affected by the ora control file. I think the default is 50, which should be enough for most applications. To change it, you have to restart ora (at least). Good Luck, -Stathis. Steve Farmer wrote: hi Brian, I'm curious to know whether or not you are using persistent connections from Oracle. And do your problems disappear if you restart the Oracle db? We are having some problems with to many sessions being created with persistent connections and we think there are a couple of parameters .. 1) no of connections allowed in apache. (this could explain why SSL id different to NON-SSL connections) 2) no of sessions an oracle user is allowed to create. 3) How many connections we provide in the oracle listener connection pool. Regards Steve Farmer At 1:41 PM -0600 9/3/01, Brian.J.Mauter wrote: Hello, I am running an Apache 1.3.19 server with mod_ssl, PHP 4.0.4pl1, and Oracle 8.1.6. Oracle is only installed so that we could compile PHP --with-oci8. When I originally got everything going, it worked well. After about two weeks, PHP works fine, Apache works fine, but when I try to logon to the Oracle database (via TCP), I get an ORA-03106 error on the OCISessionBegin statement. I can write another php page logging into the database and everything seems to work fine. If I go to another server setup exactly the same as the first, the same script will work just fine. After about two weeks, the script runs great via https, but not plain http. It's really fast with https. You're welcome to see what I'm talking about with: FIRST: http://cbhp.ua.edu/~bmauter/oracle.php?query=select+*+from+meal SECOND: http://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal THIRD: https://airwest.cba.ua.edu/~bmauter/oracle.php?query=select+*+from+meal If anyone has had similar problems, please let me know. I have no idea what is going on. Thanks in advance, Brian Mauter -- 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] -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] -- 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]
RE: [PHP-DB] MS Access and MySQL
BDY.RTF -- 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]
[PHP-DB] Apache Question
I apologise in advance but it may be a quick one. I have set up Apache, PHP and MySQL on my Home PC on Windows 98 believe it or not, on an old machine. Don't ask why!!! Anyhow to my surprise, as I am a beginner, it all installed quite smoothly and I am delighted with my efforts and of course the products. However - I can not seem to get the HTML #INCLUDE 's working in the httpd.conf configuration file. I assume all of you have set this up at some time and may be able to help me. I have read all the instructions and I was to get the PHP module installed and talking to it but not the simple html. I want the web server to parse ALL .html files not just .shtml Can someone please help and send me a httpd.conf file or point me in the right direction. On my ISP I had to change the .htaccess file but apparently Apache has done away with this and put all config stuff in one file httpd.conf Thanks in advance Lisa Lisa Rubanowicz Case ITC, Navan, Ireland Tel: #353 (0)46 77663 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: [PHP-DB] Apache Question
Lisa: 1. Apache's httpd.conf file (THE configuration file) should be in: apache/conf/httpd.conf (ot httpd.conf.default) 2. Find the following line: # # DirectoryIndex: Name of the file or files to use as a pre-written #HTML # directory index. Separate multiple entries with spaces. # DirectoryIndex index.shtml 3. Simply add your desired file ending to this: So I have: # # DirectoryIndex: Name of the file or files to use as a pre-written HTML # directory index. Separate multiple entries with spaces. # DirectoryIndex index.html DirectoryIndex index.php DirectoryIndex index.php3 DirectoryIndex index.phtml HTH :) Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam http://gertrude.sipu.anglia.ac.uk/webteam [EMAIL PROTECTED] +44 (0)1223 363271 ext 2331 www.theruss.com #---# -- 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]
Re: [PHP-DB] must I while loop
Try this: list($field1, $field2, $field3) = mysql_fetch_array($result); -- 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]
Re: [PHP-DB] limit in informix
Hello, Luigi Barone wrote: I have the same problen of Fredrik Is there any equivalent to MySQL's ?LIMIT x,y? in Informix Dynamic Server 2000? As you may have noticed, I have just replied a similar message but about MS-SQL. The same Metabase base solution can work for Informix because Metabase also supports Informix. Manuel Lemos -- 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]
[PHP-DB] df
test -- 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]
Re: [PHP-DB] csv file with mysql
At 04:05 PM 3/12/2001 -0600, you wrote: I'm loading a csv text file into a table in a mysql database, however it seems to just stop after a while if the file is to big. I'm new with php so any help would be appreciated. PHP scripts will normally have a limited life span set in the server's config file (php.ini). I think the default is 30 seconds but it could be anything. What is most likely happening is that you are hitting the maximum execution time and thus your script gets killed off because of it. The only work around is to use a smaller CSV file or up the maximum execution time. Keep in mind that a longer execution time means that errant scripts will be able to tie up resources for longer as well so do not set it to something crazy. =) Or if you have the appropriate file level access, just use "LOAD DATA INFILE" from within MySQL to do the import instead which will use less resources and not be subject to the same timeout issue. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ - -- 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]
[PHP-DB] javascript variables
Hi yes these variables are available in php referer = $HTTP_REFERER; window.location = $HTTP_HOST . $REQUEST_URI; Joris
Re: [PHP-DB] csv file with mysql
Looks like your script is hitting max execution time, as has already been pointed out. Rather than increasing the max execution time in php.ini, you can just call set_time_limit(time in seconds, or 0 for no limit) which will increase the execution time for just this script, thereby minimising 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] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Php version of mysqladmin
Hi all, I saw a posting Last week about somebody talking about an interface to administer mysql written in php. Can somebody point me to the link? Thanks, == Hector M Banda Voice: (949) 784-3143 Progress Programmer/Analyst Fax: (425) 790-6379 Draper's Damon's -- 9 Pasteur -- Irvine Ca, 92618 == -- 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]
Re: [PHP-DB] Php version of mysqladmin
http://www.phpwizard.net/ At 03:51 PM 3/12/2001 -0800, Hector Banda wrote: Hi all, I saw a posting Last week about somebody talking about an interface to administer mysql written in php. Can somebody point me to the link? Thanks, == Hector M Banda Voice: (949) 784-3143 Progress Programmer/Analyst Fax: (425) 790-6379 Draper's Damon's -- 9 Pasteur -- Irvine Ca, 92618 == -- 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] -- 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]
Re: [PHP-DB] Php version of mysqladmin
www.htmlwizard.com the program is phpMyAdmin, very cool program... Hector Banda wrote: Hi all, I saw a posting Last week about somebody talking about an interface to administer mysql written in php. Can somebody point me to the link? Thanks, == Hector M Banda Voice: (949) 784-3143 Progress Programmer/Analyst Fax: (425) 790-6379 Draper's Damon's -- 9 Pasteur -- Irvine Ca, 92618 == -- 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] -- Romeo Manzur Web Application Developer Isilicom Av. 27 de Febrero 904 Altos Despacho 1, Centro Villahermosa, Tabasco, Mexico Tel: 52+(9)3-51-5647 -- 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]
[PHP-DB] Bug or what?
First File - index.php
?php
header("Pragma: no-cache");
header("Cache-Control: no-cache, must-revalidate");
if(empty($check)) {
$page = "index.php?check=1";
header("Location: $page");
setcookie("testcookie", "1");
}
else {
if(empty($testcookie)) {
echo ("font face=arial size=4 color=redProblem detected!/fontbrbr" .
"bYour browser does not support cookies!/bbrbr" .
"font size=2Enable cookies and try again./font");
die;
}
else {
$page = "login.php";
header("Location: $page");
}
}
?
Second File - login.php
?php
header("Pragma: no-cache");
header("Cache-Control: no-cache, must-revalidate");
?
html
head
titleForecast Tool - ATL Key Account/title
/head
body
form method="post" action="temp.php" name="form_login"
table
trtdfont size="2" face="Arial, Helvetica, sans-serif"Login:/font/td
tdinput type="text" name="login" size="8" maxlength="8"br/td/tr
trtdfont size="2" face="Arial, Helvetica, sans-serif"Password:/font/td
tdinput type="password" name="senha" size="8" maxlength="8"/td/tr
trtdinput type="reset" name="botao" value="Clear"/td
tdinput type="submit" name="submit" value="Login"/td/tr
/table
/form
/body
/html
Everything works fine when I use these two files with Apache running on Solaris, RH,
Windows 98, Windows ME and Windows NT 4.0. The main objective is to test if the
browser supports cookies of course. But... If I use Microsoft IIS with these two files
it never works! The cookie is NEVER sent to the browser (this was verified using
Netscape's option to warn about new cookies coming in) and obviously I always receive
the error message stating that my browser doesn't support cookies! Impossible! The
same application running on two different servers produces different results? Is it a
bug?
Thanks in advance!!!
Best regards,
Fbio Ottolini
Re: [PHP-DB] Using text files instead of a DB
At 09:29 PM 3/12/2001 -0400, you wrote: THE ROTTERS!! They don't have to do ANYTHING to support MySQL except: 1. Set up an empty database 2. Assign it a username/password and, just possibly 3. Provide the most elemental of scripts so you can do a bulk load, thereby creating your tables. For that maybe a $50 one-time charge. $50 per month, never! Working for an ISP as I do, I take great exception to this post. The $50 per month seems rather extravagant (highly depends what you get though) but an extra monthly fee in itself is most definitely not ridiculous or unwarranted. Just because you can download the MySQL server for free does not mean that maintaining the server is free. MySQL is essentially a "smart" file system which allows you to offload disk usage into the MySQL database (depending on where the tables reside). If their pricing structure is disk space related, you can slide content into MySQL without compensating the ISP for it. For most providers, a separate server will need to be setup just for MySQL support. On top of that, MySQL requires a stiff amount of RAM for dealing with larger tables and is yet another service which needs to be monitored on an ongoing basis. Servers cost money and have a limited lifespan. Space, in a climatically controlled environment costs money. Backing up client data costs time and money. As daemon's go it is not horrifically difficult to take care of but still, it does take resources and time and expecting this service for free is unreasonable. At most, you can claim that this company is unrealistic in their pricing structure but there is no shame in charging for a service that costs real money to maintain and support. IMHO of course. Cheers - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ - -- 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]
Re: [PHP-DB] IBM DB2 connectction problems
Hi,
It should read:
$i = odbc_connect( "sample", "db2inst1", "ibmdb2" );
Please provide more detailed information on the SQL error and SQL state.
Otherwise it is not really easy to tell, what the problem is.
ManieQ wrote:
$i = odbc_connect ("PROTOCOL=TCPIP; SERVERNAME=jajo.tpi.pl;
SERVICE=50002; DATABASE=SAMPLE", "db2inst1", "ibmdb2" );
I receive:
Warning: SQL error: , SQL state czen?L@Polaczen in SQLConnect in
/home/manieq/web/db21.php on line 5
--
--- Helmut NoCarrier Tessarek --- [EMAIL PROTECTED] ---
IBM Certified Solution Expert
Microsoft Certified Systems Engineer (MCP, MCP+I, MCSE)
Karmarschgasse 53/1/3/11, A-1100 Vienna, Austria
- http://www.evermeet.cx -
--
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]
[PHP-DB] broken page
I am using Oracle and Apache with PHPLIB in two solaris servers. I wonder why the web pages loaded by using Netscape or IE are always broken. Although there is no error, it usually requires me to reload the page for serveral times before I get the complete page. Do you have any ideas why is this and pls guide what can I do for it? -- 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]
Re: [PHP-DB] Oracle connection
can odbc be used from php on linux, or is it just a windows thing? - Original Message - From: "Andrew Hill" [EMAIL PROTECTED] To: "Joe Brown" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 12, 2001 5:32 PM Subject: Re: [PHP-DB] Oracle connection Or, you can use ODBC :) A PHP/ODBC HOWTO is available at http://www.iodbc.org and driver are available at www.openlinksw.com Please let me know if you require assistance. Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 3/12/01 6:22 PM, "Joe Brown" [EMAIL PROTECTED] wrote: You need to acquire the oracle network drivers for linux, from Oracle. I'm only aware of the ones that come with Oracle for linux, though they may have them bundled seperately. Fight your way through the inconcievably difficult installation process. After defining some environment variables (they can be set after the fact too) which point the the oracle/home;net drivers, compile php --with-oci8 or similar argument. Start apache server the proper set of environment variables, be sure to set your nls_lang, etc... Now you should be able to access 'em. There is a fair amount of work involved, but it seems to be working nicely for me. A little tenacity will prevail. :-) Oh, you can put_env(SID=ORCL) etc... in your php code, instead of setting up environment variables, prior to compile/apache start. If you have mutiple instances, this may be the preferred method. With a single instance, I find it simpler to start apache w/a script that sets the variables prior to startup. Oh yeah, lots of reading is involved too ;-) ""Marco Eyzaguirre"" [EMAIL PROTECTED] wrote in message 002601c0ab42$fac54f40$[EMAIL PROTECTED]">news:002601c0ab42$fac54f40$[EMAIL PROTECTED]... I got a question: How can I access an Oracle database located on an Oracle 8i installed in Windows NT from PHP installed on a Linux box? thanx in advance for you answers Greetings Marco Eyzaguirre DB Administrator Ilender Peru S.A. www.ilender.com.pe -- 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] -- 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] -- 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]
Re: [PHP-DB] PHP-MySQL create table problem
Yes I did it on my test computer. It works fine. ""Cal Evans"" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Maybe it's just me but I've never seen anyone create a table by using a Select statement. Have you verified that you can do this? (like you've checked the manual and this construct is supported?) Cal http://www.calevans.com -Original Message- From: Ivo Stoykov [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP-MySQL create table problem Hello I have following problem and really need your help. I'm trying to create a new table using "CREATE TABLE partlist_back SELECT * FROM partlist" from a php script. The new table have to be based on an existing table. On the machiene I test it works fine when I upload it on the server I receive a query error! Please help me! Ivo -- 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] -- 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] -- 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]
