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

2001-07-18 Thread David Balatero
Theoretically...but if you expect lots of traffic you'd better invest in a T1+, or at least a DSL line that has at least 1.5Mbit up and down. -- David Balatero -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 2:25 AM To: [EMAIL

[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

[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

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 ...

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 ? $dbname=name; $dbuser=user; $dbpass=pass; ? Than

[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

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

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.

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 then ...

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; // ... prints the

[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

[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,

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',

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 timestamp(12)

[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: ?php session_start(); session_register(user); $user=$username; session_register(pass); $pass=$password; ? where

[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 ? session_start() ? 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

[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

[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

[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 //BLOB2JPG // in = id_product $host = 10.10.0.200:/home/interbase/WEB02/WEBG02; $user = TEST_USER; $pass = PassUser; $charset=;

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:- html ? session_start(); session_register(SESSION); ? head /head body $SESSION[user]=$whatever; $SESSION[password]=$whatever; echo(Welcome . $SESSION[user] ., Please Click On A Link);

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