[PHP-DB] mysql BDB with php problem....

2001-07-18 Thread Koutsogiannopoulos Karolos
Hello everyone I am trying to use the mysql BDB tables option for safe transaction tables. I have finally activated BDB support with a 3.23.. mysql Max binary version using the latest version of php... I use the following script to test if the BEGIN & COMMIT option works but i always get th

[PHP-DB] Protecting database password

2001-07-18 Thread Marco Draijer
For a PHP-application on Windows NT, I am using an Oracle database and the database-interface db_oci8.inc (a PHP-class, downloaded from the net). To be able to make the connection to the database, the class has to know the databasename, username, and password. At the moment, it is hardcoded in t

RE: [PHP-DB] Protecting database password

2001-07-18 Thread Walter, Marcel
On Unix it is possible to make an include file with all the settings like $user, $passwd and so on and store it somewhere in the filesystem (not under your htdocs-path) So no one can access this file via web You can include this file with its variables with the include() - statement ... Im

Re: [PHP-DB] Protecting database password

2001-07-18 Thread Dobromir Velev
Hi, I suggest you use a .php file to declare your database variables and include it everywhere you need it. Even if someone guesses the name of this file when he tries to open it, nothing will be outputed to the screen. an example file is Than you'll have to set the permissions of this file in

[PHP-DB] Re: mysql_query troubles

2001-07-18 Thread Steve Brett
> Hi all', > I have a mysql_query that reads: > > $testResult = mysql_query("SELECT * FROM login_table where Pass = > password('$password')") or die ("ouch"); > is $password the var that stores the password ? i don't understand why you have password('$password') $testResult = mysql_query("SELEC

[PHP-DB] Re: A question about MSSQL! Help!!

2001-07-18 Thread ftb
You can try to modify the connect string because php's connect to database through TCP/TP. Tell me the result. Graycloud <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, My php is running at RedHatLinux ,but now I want to connect to a > MssqlServer2000 d

[PHP-DB] Inserting Variable Variable?

2001-07-18 Thread Jeff Oien
I want to INSERT a variable like this using MySQL. If I use this \"(${"C_First_Name"}.$x)\", or \"(${C_First_Name}.$x)\", or \"${C_First_Name}.$x\", only the $x gets interpolated in the insertion. If I use \"${"C_First_Name$x"}\", only $C_First_Name get interpolated. Any solutions? Thanks. J

RE: [PHP-DB] Inserting Variable Variable?

2001-07-18 Thread Michael Rudel
Hi Jeff. $varname = "C_First_Name".$x; // e.g. if $x == 3 then ... echo $$varname; // ... prints the content of $C_First_Name3 Hope this is what you wanted ?! Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-

Re: [PHP-DB] Re: A question about MSSQL! Help!!

2001-07-18 Thread Frank M. Kromann
Hi All, Microsoft SQL Server used to be identical with Sybase (back arround version 4.xx). This makes it possible to use the sybase extension (using FreeTDS) on a *nix box to talk to a SQL Server on a NT/2000 box. Due to product development SQL 2000's db-library is no longer 100% compatible. Th

[PHP-DB] Problem with BDB

2001-07-18 Thread marcos
I have a Linux Server, with Apache 1.3.19 + PHP 4.0.6 and MySQL 3.23.37, and i have a trouble with Transactions in PHP code: When i write a transaction, and some error (PHP lang error) occurs, the transaction are autocommited, and only part of the querys are made, with the inconsistence of data,

RE: [PHP-DB] Inserting Variable Variable?

2001-07-18 Thread Jeff Oien
Hi, I'm not quite getting it. If $x is 1 here is what happens. $varname = "C_First_Name".$x; echo $$varname; then $$varname prints as $C_First_Name1. However $C_First_Name1 prints the contents of the variable. Jeff Oien > Hi Jeff. > > $varname = "C_First_Name".$x; > > // e.g. if $x == 3 the

RE: [PHP-DB] Inserting Variable Variable?

2001-07-18 Thread Jeff Oien
I found a solution but not sure if it's the most efficient. I need to first define a simpler variable: $C_First_Name = "${"C_First_Name".$x}"; then INSERT VALUE $C_First_Name. Jeff Oien > Hi Jeff. > > $varname = "C_First_Name".$x; > > // e.g. if $x == 3 then ... > echo $$varname; // ... prin

[PHP-DB] static compile oracle libs

2001-07-18 Thread Christopher McCrory
Hello... What would I need to change to get my php compile to staticly link only the oracle libraries? I need to distribute the php stuff to multiple servers and I would prefer not to have to move the libclntsh.so.8.0 and libwtc8.so to every machine. I would think this is a libtool ar

[PHP-DB] Only Insert on Error?

2001-07-18 Thread Jeff Oien
I can't figure this out. The first code works as far as inserting into a MySQL database with the !result error checking. The second with the error code commented out doesn't. I can't figure out why. Jeff Oien if ($M_First_Name) { $sql = "INSERT INTO $table_name (First_Name, Last_Name, Family_Posi

RE: [PHP-DB] Only Insert on Error?

2001-07-18 Thread Cami
Try using ' instead of \" like: if ($M_First_Name) { $sql = "INSERT INTO $table_name (First_Name, Last_Name, Family_Position, Address, Address1, City, State, Zip, Email, Home_Phone, Work_Phone, Coop_Month, Timestamp) VALUES ('$M_First_Name', '$M_Last_Name', '$MatherFamilyPosition','$M_Address1',

[PHP-DB] MySQL Timestamp

2001-07-18 Thread Jeff Oien
I have a field that's timestamp(12) which should be MMDDhhmm but what I'm getting is 010718125000 what I was expecting was 200107181250 How can I get what I was expecting? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For add

[PHP-DB] DSO for odbc functions

2001-07-18 Thread E. Peter K. Chan
Hi I've just installed RHL 7.1, and would like to test out the PHP4.0.6 ODBC functions. How can I get the DSO for this easily instead of recompiling. Is there a website I can download this extension from? Thanks Peter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

[PHP-DB] Re: DSO for odbc functions

2001-07-18 Thread Christopher McCrory
Hello... You might try: ftp://ftp.redhat.com/pub/redhat/linux/rawhide/i386/RedHat/RPMS/ there are php 4.0.6 rpms you might have to update a few other things, openssl, freetype, etc or recompile rpm --rebuild ftp://ftp.redhat.com/pub/redhat/linux/rawhide/SRPMS/SRPMS/php-4.0.6-2.src.rpm E. Peter

RE: [PHP-DB] MySQL Timestamp

2001-07-18 Thread Jeff Oien
Thanks. I was using MySQL by DuBois book as a reference. Jeff > According to the manual, 12 is YYMMDDHHMMSS and 14 is MMDDHHMMSS. > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME > > > "Jeff Oien" <[EMAIL PROTECTED]> wrote: > I have a field that's time

[PHP-DB] Still stuck on Sessions :-(

2001-07-18 Thread chris
Hi there everyone, Thanks to everyone that replied to my session help - but i'm still having problems. I use the below to open a session - Say at the start of my website: where username and pass would be defined by a variable - either from a form or hardcoded. Now, if I use on the SAME p

[PHP-DB] A BIG thank you for sessions

2001-07-18 Thread chris
Hi There, Thank you SO much for all your help with Sessions, I didn't find information anywhere else which said you had to put at the top of EVERY page so I assumed that initialised it on the first page. All of your help is very much appreciated and added about 10 years to my life span :-) R

Re: [PHP-DB] Still stuck on Sessions :-(

2001-07-18 Thread chris
Hi Marios, Unfortunately i'm very new to PHP so i'm not sure how to do some of this (Sorry). Cookies are deffinately enabled. Chris > Firstly, try initializing the variable, and then registering. > Also are you accessing the user and pass variables in a function in the > other pages?...if so

[PHP-DB] Re: Probably a stupid home server question

2001-07-18 Thread Al Savage
** Reply to note from [EMAIL PROTECTED] 18 Jul 2001 14:24:27 - Hello, Chris: > I currently run a unix web server from a company in the UK, i'm > getting a cable modem soonish and was wondering if I can run a > server from home rather than hiring one as I am now? If so what > will I need? I

[PHP-DB] cannot create database

2001-07-18 Thread Andy
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using Apache, PHP4 and MySQL 3.23 on NT and i cannot get php to create a new database. If i create the database through the command line PHP will not acces it. All the settings on PHP look OK. It has worked in the past and I cannot understand why

[PHP-DB] cannot create database

2001-07-18 Thread Andy
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using Apache, PHP4 and MySQL 3.23 on NT and i cannot get php to create a new database. If i create the database through the command line PHP will not acces it. All the settings on PHP look OK. It has worked in the past and I cannot understand why

[PHP-DB] Interbase & BLOB

2001-07-18 Thread Enrico Comini
This is my page to extract image (as blob) in a interbase table. I call it with :echo "src=\"blob2img.php?id_product=".$id_product."\" "; but i don't see the image -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [PHP-DB] Still stuck on Sessions :-(

2001-07-18 Thread Mark Collin
I personally tend to use arrays for my sessions, i just find it easier that way this sort of thing works for me:- $SESSION["user"]=$whatever; $SESSION["password"]=$whatever; echo("Welcome ". $SESSION["user"] .", Please Click On A Link"); - Original Message - From: <[EMAIL PROTECTED

Re[2]: [PHP-DB] password

2001-07-18 Thread Alexey Borzov
Greetings, Sharmad! At 18.07.2001, 07:41, you wrote: SN> Thanks Alexey, SN> I have set the passwd for the root user,but now how do i set SN> the passwd for other users. CREATE USER another_user WITH PASSWORD 'password'; or ALTER USER another_user WITH PASSWORD 'password'; SN>