AW: [PHP-DB] PHP4-ODBC-MSSQL7

2001-07-10 Thread Stefan Siefert

Hi,

I'm not sure about the probeme you have, but if the probleme is based on
ODBC, why do use ODBC? You could also use the Sybase-Ct libs.. should work
also with MSSQL...

Greetings,
Stefan


-Ursprüngliche Nachricht-
Von: Michael Yevdokimov [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 10. Juli 2001 13:09
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] PHP4-ODBC-MSSQL7


Hello Everyone!!

We are making on the project with PHP4 and MSSQL7. Everything is based on
NT4 platform.
Certainly, in this case we are operating by SQL stored procedures.

The question is..

I found some problems while extracting data from database over ODBC
which we need to use to make a bridge between PHP and MSSQL.

For example, we created a table with columns:

col_subj_id int
col_subj_owner_id int
col_subj_last_update timestamp(8)
col_subj_title varchar(512)
col_subj_content text(16)
col_subj_keywords varchar(256)
col_subj_secur int
col_subj_reg_page varchar(128)


Then I try to execute a stored procedure usp_get_subj:

Create Procedure usp_get_subj
(
@subj_id int
)
As
SELECT  *
FROM tbl_subject
WHERE col_subj_id = @subj_id

RETURN

Well, everything is working in Query Analyzer and in ASP but not in
PHP...

If obviously to define the column names like:

SELECT
col_subj_id,
col_subj_owner_id,
col_subj_last_update,
col_subj_title,
col_subj_content,
col_subj_keywords,
col_subj_secur,
col_subj_reg_page
FROM tbl_subject
WHERE col_subj_id = @subj_id

it will not be working either...

But! If to order the columns in the query of the stored procedure by
data types like:

SELECT  col_subj_id, -- int
col_subj_owner_id, -- int
col_subj_secur, -- int
col_subj_last_update, -- timestamp(8)
col_subj_title, -- varchar(512)
col_subj_reg_page, -- varchar(128)
col_subj_keywords, -- varchar(2560
col_subj_content -- text(16)
FROM tbl_subject
WHERE col_subj_id = @subj_id


everything will be working pretty good..


WHY?

Do you have any ideas on this subject? ;-)

Hope to obtain help from your side..

Thank you in advance.

Mike

P.S.

The friend of mine who is ASP programmer just told me that there was such a
problem with the old versions of ODBC. I am not sure but I am afraid that
the PHP's  ODBC support is aimed on that old ODBC driver. Could anyone
advice me anything on this subject please?









Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]


Globalocity B.V.
Tel.: +31 (0)70 312 2814
Fax.: +31 (0)70 312 2808
http://www.globalocity.com
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]




AW: [PHP-DB] image resizing

2001-07-09 Thread Stefan Siefert

There are several possibilities to do this... first PHP has the possibility
to use the GD - Libs (which doesn't support Gif's because of licence
problems). The second (and in my opinion better) posibility is ImageMagick
which are some programs to modify pictures (you have to call them externaly
from your php - scripts) (www.imagemagick.org). I think, I have seen several
Tutorials to do so (PHP/ImageMagick) but on the fly.. I don't find them in
my bookmarks now...

Hope this helps,

Stefan Siefert

-Ursprungliche Nachricht-
Von: Adv. Systems Design [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 9. Juli 2001 16:04
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] image resizing


Is there a way of sizing image resolution on the fly?

TIA

Luis

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.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 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] mysql_query returns nothing?

2001-07-04 Thread Stefan Siefert

Hm, since we are using PHP 4.0.6 we do get sometimes no
returnvalue...(function mysql_query) I think, this is always then, when we
are executing update oder delete syntax hm, does anyone know anything
about it?

Stefan Siefert


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




AW: [PHP-DB] newbie: Trying to select a database in php

2001-06-20 Thread Stefan Siefert

Try it with mysql_select_db($database,$connect) instead of
msql_select_db($database,$connect) :-)

msql is a different Database System (in general, it is a lot older than
mysql I think)

Stefan

-Ursprüngliche Nachricht-
Von: Paul Lockyer [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Juni 2001 10:07
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] newbie: Trying to select a database in php


Im using win2k and php to retrieve and dipslay database records, however
whenever the page is loaded in a browser I get the following error (the line
in question is in bold)

Fatal error: Call to undefined function: msql_select_db() in
D:\ASP\test\php\default.php on line 18

The code I am using is below

";
echo "DVD Title";

while($row = mysql_fetch_array($sql_result)){

$title = $row["main_title"];
echo "$title";

}

echo "";

mysql_free_result($sql_result);
mysql_close($connection);
?>

Any help would be appreciated


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




AW: [PHP-DB] mssql_connect() function not found when I load the page...

2001-06-20 Thread Stefan Siefert

You need to uncomment the mssql.dll (or  something called like this) in your
php.ini (In the section Windows DLL's).

Greetings,

Stefan

-Ursprüngliche Nachricht-
Von: lwneo [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Juni 2001 06:21
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] mssql_connect() function not found when I load the
page...


Hi,
I am running PHP with apache as server at Windows 98 platform. When I open a
page I write that will connect to Microsoft SQL Server 7.0 in my intranet, I
get the error :

mssql_connect( ) function not found.

Could someone tell me how to solve this problem?
Thanks.

lwneo.




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




AW: [PHP-DB] Connection to AS/400.

2001-05-07 Thread Stefan Siefert

Also if ODBC isn't native for linux (not yet) there are several ports (or
Projects) for linux the best I know is unixODBC (www.unixODBC.org), but
there is also the iodbc project (www.iodbc.org). Last but not least, is
there a company which sells ODBC solutions and support them
(www.openlinksw.com). The support is very usefull!!

Greetings,

Stefan Siefert

-Ursprüngliche Nachricht-
Von: Nicolas Machado [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 7. Mai 2001 21:36
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] Connection to AS/400.


OK, I have Linux, Apache and PHP, somebody knows if exist something like
ODBC to connect to DB2/400.
I mean, exist ODBC for linux?

Thank for all.
Best Regards


---
Este Mail NO contiene Virus.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01



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




AW: AW: AW: [PHP-DB] configure with sybase-ct option

2001-04-27 Thread Stefan Siefert

ok let's see take those:
ftp://ftp.metalab.unc.edu/pub/Linux/ALPHA/freetds/freetds-0.51.tgz
and compile them...

in your configure script of php, you
enter --with-sybase-ct=/your/freetds/installpath

Greetings,

Stefan Siefert

-Ursprungliche Nachricht-
Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 27. April 2001 11:07
An: Stefan Siefert; [EMAIL PROTECTED]
Betreff: Re: AW: AW: [PHP-DB] configure with sybase-ct option



OK. But we're running on Solaris.


At 11:11 AM 4/27/01 +0200, Stefan Siefert wrote:
>Normaly, they are shipped with the database, you try to connect to... but
if
>you don't have them you could get them from:
>www.php.net/extra/ctlib-linux-elf.tar.gz
>
>Stefan Siefert
>
>-Ursprungliche Nachricht-
>Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
>Gesendet: Freitag, 27. April 2001 10:58
>An: Stefan Siefert; [EMAIL PROTECTED]
>Betreff: Re: AW: [PHP-DB] configure with sybase-ct option
>
>
>
>You mean I need to install the sybase-ct libraries before I configure PHP?
>Where can I get them?
>
>Thanks,
>Lester
>
>At 10:58 AM 4/27/01 +0200, Stefan Siefert wrote:
> >Do you have the sybasect - libraries installed??? You need to have them
> >installed in order to compile PHP succesfully!
> >Also, if you have sybase-ct installed, specify the path
> >with: --with-sybase-ct=/path/to/sybasectlibs
> >
> >Hope this helps,
> >
> >Stefan Siefert
> >
> >-Ursprungliche Nachricht-
> >Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
> >Gesendet: Freitag, 27. April 2001 10:38
> >An: [EMAIL PROTECTED]
> >Betreff: [PHP-DB] configure with sybase-ct option
> >
> >
> >
> >I tried to configure PHP4.0.2 with sybase-ct support. But I got this
error
> >when running "make install"
> >
> >In file included from internal_functions.c:33:
> >/export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58:
ctpublic.h:
> >No such file or directory
> >
> >
> >I used the following commands:
> >
> > ./configure --with-nsapi=
> > --enable-libgcc
> > --with-mysql=/usr/local/mysql
> > --enable-track-vars
> > --enable-short-tags
> > --enable-asp-tags
> > --with-sybase-ct
> > make
> > make install
> >
> >
> >Did I miss anything? Or should I download the latest version and install
>it?
> >
> >Thanks,
> >Lester
> >
> >
> >
> >-
> >Lester June Cabrera
> >Chief Web Programmer
> >I-Quest Corporation
> >
> >Tel: (632) 867 8150 local 301 or 302
> >Fax: (63 2) 867 8077
> >E-mail: [EMAIL PROTECTED]
> >
> >Visit the most comprehensive on-line business travel resource at
> >http://www.worldroom.com
> >
> >Successful events start here. Visit http://www.worldroomevents.com .
> >The one-stop online exchange for event planners and suppliers to the MICE
> >industry.
> >
> >
> >--
> >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]



-
Lester June Cabrera
Chief Web Programmer
I-Quest Corporation

Tel: (632) 867 8150 local 301 or 302
Fax: (63 2) 867 8077
E-mail: [EMAIL PROTECTED]

Visit the most comprehensive on-line business travel resource at
http://www.worldroom.com

Successful events start here. Visit http://www.worldroomevents.com .
The one-stop online exchange for event planners and suppliers to the MICE
industry.


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




AW: AW: [PHP-DB] configure with sybase-ct option

2001-04-27 Thread Stefan Siefert

Normaly, they are shipped with the database, you try to connect to... but if
you don't have them you could get them from:
www.php.net/extra/ctlib-linux-elf.tar.gz

Stefan Siefert

-Ursprungliche Nachricht-
Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 27. April 2001 10:58
An: Stefan Siefert; [EMAIL PROTECTED]
Betreff: Re: AW: [PHP-DB] configure with sybase-ct option



You mean I need to install the sybase-ct libraries before I configure PHP?
Where can I get them?

Thanks,
Lester

At 10:58 AM 4/27/01 +0200, Stefan Siefert wrote:
>Do you have the sybasect - libraries installed??? You need to have them
>installed in order to compile PHP succesfully!
>Also, if you have sybase-ct installed, specify the path
>with: --with-sybase-ct=/path/to/sybasectlibs
>
>Hope this helps,
>
>Stefan Siefert
>
>-Ursprungliche Nachricht-
>Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
>Gesendet: Freitag, 27. April 2001 10:38
>An: [EMAIL PROTECTED]
>Betreff: [PHP-DB] configure with sybase-ct option
>
>
>
>I tried to configure PHP4.0.2 with sybase-ct support. But I got this error
>when running "make install"
>
>In file included from internal_functions.c:33:
>/export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58: ctpublic.h:
>No such file or directory
>
>
>I used the following commands:
>
> ./configure --with-nsapi=
> --enable-libgcc
> --with-mysql=/usr/local/mysql
> --enable-track-vars
> --enable-short-tags
> --enable-asp-tags
> --with-sybase-ct
> make
> make install
>
>
>Did I miss anything? Or should I download the latest version and install
it?
>
>Thanks,
>Lester
>
>
>
>-
>Lester June Cabrera
>Chief Web Programmer
>I-Quest Corporation
>
>Tel: (632) 867 8150 local 301 or 302
>Fax: (63 2) 867 8077
>E-mail: [EMAIL PROTECTED]
>
>Visit the most comprehensive on-line business travel resource at
>http://www.worldroom.com
>
>Successful events start here. Visit http://www.worldroomevents.com .
>The one-stop online exchange for event planners and suppliers to the MICE
>industry.
>
>
>--
>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]



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




AW: [PHP-DB] configure with sybase-ct option

2001-04-27 Thread Stefan Siefert

Do you have the sybasect - libraries installed??? You need to have them
installed in order to compile PHP succesfully!
Also, if you have sybase-ct installed, specify the path
with: --with-sybase-ct=/path/to/sybasectlibs

Hope this helps,

Stefan Siefert

-Ursprungliche Nachricht-
Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 27. April 2001 10:38
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] configure with sybase-ct option



I tried to configure PHP4.0.2 with sybase-ct support. But I got this error
when running "make install"

In file included from internal_functions.c:33:
/export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58: ctpublic.h:
No such file or directory


I used the following commands:

./configure --with-nsapi=
--enable-libgcc
--with-mysql=/usr/local/mysql
--enable-track-vars
--enable-short-tags
--enable-asp-tags
--with-sybase-ct
make
make install


Did I miss anything? Or should I download the latest version and install it?

Thanks,
Lester



-
Lester June Cabrera
Chief Web Programmer
I-Quest Corporation

Tel: (632) 867 8150 local 301 or 302
Fax: (63 2) 867 8077
E-mail: [EMAIL PROTECTED]

Visit the most comprehensive on-line business travel resource at
http://www.worldroom.com

Successful events start here. Visit http://www.worldroomevents.com .
The one-stop online exchange for event planners and suppliers to the MICE
industry.


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




AW: [PHP-DB] Connecting and Viewing a Database

2001-03-27 Thread Stefan Siefert

Maybe you tell us, which system you are running, like linux, or windows. If
you use linux you should try to use unixODBC (Tutorial for uinxODBC and PHP:
www.unixODBC.org).. If you use windows, it should be done by uncommenting
the odbc-library in php.ini like:
extension=php_odbc.dll

Greetings,

Stefan Siefert

-Ursprüngliche Nachricht-
Von: Anyangwe, Tanwani [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 27. März 2001 17:49
An: '[EMAIL PROTECTED]'
Betreff: [PHP-DB] Connecting and Viewing a Database


Does anyone know how to connect and display table rows from an ODBC source
MS Access & MySQL databases?


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




AW: [PHP-DB] Structure Question

2001-03-27 Thread Stefan Siefert

I think you should store all files in a table with an extra table with the
filetypes (like you suggest in the end of your mail)!! In my opinion this is
a well designed database modell, 'cause you have only one table (instead of
10 or twelve depending on the count of your datatypes), but you are able to
select over the filetyp criteria!!

Stefan Siefert

-Ursprüngliche Nachricht-
Von: Jordan Elver [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 27. März 2001 14:38
An: PHP Database Mailing List
Betreff: [PHP-DB] Structure Question


Hi,
I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
articles in a db table. Would it be best to store each kind of media in a
different table like one table for real audio, one for quicktime, one for
mp3. Or, would it better to store them all in the same table but with
another
table telling me what kind of file it is?

Like:

media table

id | name | filename | type_id

media types

type_id | name

Any ideas folks?

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]



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




AW: [PHP-DB] Naming cookies

2001-03-13 Thread Stefan Siefert

Hi Tristan,

I'm not sure about this, but try to use ob_start() at the beginning. This
tells php to execute the page in cache and put it to the client when it's
execution is finish. It enables you, to use cookies not only before html,
but from every position in html... maybe this works...

Stefan Siefert


-Ursprungliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Marz 2001 16:52
An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: [PHP-DB] Naming cookies




Afternoon guys and girls
I have a queston regarding cookies...

I have a login form that takes the member name and password from a MySQL
Database.

I have three fields:
member
pw
userlevel

I want to set a cokkie to remember the user and thier user level, so I named
the
cookie  -   authlevel$userlevel  --- as I have three levels of security
access,
I opted for a dynamic cookie name,that changed depending on thier userlevel.

Can I include a variable in the cookie name?
I am having probs getting this to work correctly, and this is my first guess
as
to why it isn't working.

I have included two codes, the first is my login script, and the second is
on my
secure pages above the head tag.

If anyone can spot my error, I'll gladly furnish them with a beer and a
toblerone.

Thanks in advance,
Tris...






http://www.mysite.com");
 exit;
}

$db_name = "my_database";
$table_name = "userlist";

$connection = @mysql_connect("my_database_host", "my_username",
"my_password")
 or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
 or die("Couldn't select database.");

$sql = "SELECT * FROM $table_name
 WHERE member = \"$member\" AND pw = \"$pw\"
 ";

$result = mysql_query($sql)
or die ("Can't execute query.");

while($row = mysql_fetch_array($result)) {
 $userlevel = $row['userlevel'];
 $member = $row['member'];
 $pw = $row['pw'];
}

$num = mysql_numrows($result);

if (($num != 0) && ($userlevel = '1') || ($userlevel = '2') || ($userlevel =
'3')) {

$cookie_name = "authlevel$userlevel";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain ="";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/", $cookie_domain,
0);

$display_block ="

You are now logged into STN TreasuryYou are logged in under
the
mail address, $member, you can now access the site as per your
assigned
access level $userlevel.Link to level
1Link to level 2Link to level 3
";

} else {

 header("Location: http://www.mysite.com");
 exit;
}

?>


==


Hello, and welcome to level 1 of the secret test area...";

} else {
 header( "location:http://www.mysite.com");
 exit;
 }

?>



===




**
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] PHP Bug or configuration error?

2001-03-13 Thread Stefan Siefert

Hi Pierre...

I think the problem is, that you have configured php as cgi-apliction, and
not as an ISAPI module. I'm not sure how to configure PHP this way (cause we
run only linux - server, and no IIS..) but this should be the problem.

Greetings,

Stefan Siefert


>Hallo listmembers,

>i have a misterious error with php4.0.4 on windows-2000. If i call a script
>this lines will be displayed in the Adress-Part of my Browsers (IE5.0 &
>Netscape 4.75/6):
>http://localhost/php/php.exe/test/funwin/normal.php3?show=10
>I dont know why "/php/php.exe" is in the Adress. I hope somebody could help
>me.


-- 
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] Really strange behaviour of PHP with Sybase ASE 11.9.2 + ODBC + Linux

2001-03-13 Thread Stefan Siefert

Hi there...

I have experienced really strange behaviour of PHP and Sybase. Our
configuration:

Linux (Suse Linux 7.0), Apache 1.3.17, PHP 4.0.4pl1, Sybase ASE 11.9.2 on an
Linux Box, unixODBC with a Sybase ODBC - Driver.

It was hard work, to get this working, but after some time we got it
running. Running means, that we were able to connect to an Sybase Database
over ODBC. Then we copied a PHP - Website (developed under Windows, Sybase
ASE 11.9.2 ODBC) into the webroot. Well, we expected somme problems, but not
the things we found:

Some pages loaded without any problems, but some more complex-scripts would
crash php. Crash php means, that the scripts produced segmentation faults
(Entries in the error log file like pid 15978: Segmentation Fault).

Any Ideas what could crash php when the same scripts works with windows???

Thx,

Stefan Siefert

P.S.: If you have any questions, feel free to mail :-))


-- 
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] unixODBC and Sybase ASE 11.9.2 on a linux box

2001-02-27 Thread Stefan Siefert

Hi,

we are trying the above combination, but we do not find any hints how
(which?) we configure an ODBC - Driver for Sybase in an odbc.ini file... if
anyone has experience with this combination we would be very glad if you
could post a small overview or a source, where we can find informations
about this combination...

thx

Stefan Siefert


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




AW: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0

2001-01-18 Thread Stefan Siefert

I'm not 100 % sure (cause we don't use the win binaries) but I think I can
remember that you have to uncomment some lines in the php.ini file. There
should be a section with database modules like oracle odbc or somethink like
this. try to uncomment the sybase module.

Hope this works,

Greetings

Stefan

-Ursprungliche Nachricht-
Von: Come Italia s.r.l. - Webmaster [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 18. Januar 2001 16:05
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Betreff: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0


I've installed and correctly configured (I suppose) the binary version of
PHP 4.04 on a Win NT server with Microsoft IIS.
I'm using CGI version of IIS.
when I try to connect my script with Microsoft SQL 7.0 DB I get this error
"Fatal error: Call to undefined function: sybase_pconnect() in
./db/sybase.php on line 17"
This means that the binary version of PHP doesn't support SQL 7.0??
Must I compile the source code of PHP?
Thanks a lot
Luca


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




AW: [PHP-DB] SQL coloring in BBEdit 6.0?

2001-01-16 Thread Stefan Siefert

Try Multiedit or Ultraedit.. this are Editor's which can be taught to
highlight Syntax.. you only need a config - file for the programing language
you need.

Greetings,

Stefan

-Ursprüngliche Nachricht-
Von: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 16. Januar 2001 16:03
An: 'Michael Zornek'; [EMAIL PROTECTED]
Betreff: RE: [PHP-DB] SQL coloring in BBEdit 6.0?


Hi All,
I am new to PHP and am using TextPad 4.0 at the moment but it doesn't colour
code PHP.  Can anyone recommend a Text Editor that does this.  The BBEdit is
only for Mac.
Thanks for your help
All the Best
Lisa

-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 2:51 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] SQL coloring in BBEdit 6.0?


Hello,

I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the
PHP commands differently. I also do mySQL. I usually write up a whole
list of SQL statements in a text editor and then feed them into the
server. Is there a way to have BBEdit color code the mySQL commands
that same way it does HTML and PHP?

Thanks
Mike

--

  Mike Zornek, Web Development
  Seybold Publications
  428 East Baltimore Avenue
  P.O. Box 644
  Media, PA 19063, USA
  http://www.seyboldreports.com

  Phone: (610) 565-2480 x131
  Fax: (610) 565-4659
  Email: [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]