[PHP-DB] php.exe Application Error

2002-11-12 Thread Radovan Radic
Hi all, I have tried this in php.windows, no answers there and since this is kind of db question i will try here. IIS Win2000, MSSQL 7, PHP 4.2.3 I have script that reads about 100-200 rows in the SELECT list and it is ok. After that, i have robust sql query for select some data from 4-5 tables,

[PHP-DB] Re: php.exe Application Error

2002-11-12 Thread Radovan Radic
"Radovan Radic" <[EMAIL PROTECTED]> wrote in message news:20021112093111.53801.qmail@;pb1.pair.com... > Hi all, > > I have tried this in php.windows, no answers there and since this is kind of > db question i will try here. > > IIS Win2000, MSSQL 7, PHP 4.2.3

[PHP-DB] Re: mssql.datetimeconvert bug ?

2002-11-14 Thread Radovan Radic
What format do you want? You can use select convert(char(10),date_field,101) and you will get mm/dd/, or look at the convert function in the SQL Server Books Online, or u can use php function date and format whatever you want. Radovan "Matt Brown" <[EMAIL PROTECTED]> wrote in message news:MO

[PHP-DB] MySql security

2002-11-19 Thread Radovan Radic
Hi, Since i dont know any mysql group, i will try here - it is anyway related to php. When i want to make php/mysql application i have mysql on the server and i connect to it with mysql_pconnect("localhost","root","") and it works. I assume that any user or hacker could connect to mysql database l

Re: [PHP-DB] MySql security

2002-11-19 Thread Radovan Radic
> > how i do this in mysql. > > If this is offtopic can someone point me to any mysql newsgroup. > > I would say this is very offtopic, but this query should do the trick: > GRANT select, update, insert ON your_db_name.* TO > your_username@localhost IDENTIFIED BY 'your_password' > Take a look in th

[PHP-DB] MySQL: charset

2002-11-27 Thread Radovan Radic
Hi How can i change default charset for mysql database. I want to change default charset on cp1251 just for one database 'dblibrary'. I have seen something like mysql --default-character-set=cp1251, but i dont know does it work? Thanks -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: MySQL: charset

2002-11-27 Thread Radovan Radic
"Radovan Radic" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi > > How can i change default charset for mysql database. > I want to change default charset on cp1251 just for one database > 'dblibrary'. I hav

[PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
Hi all (I post questions although i dont get answers, but i am trying. I must say i dont give answers because i dont know much about php yet) I have problems with script exceedded time. Script is executing mssql stored procedure which executes about 5-6 mins. I need to execute it and then get res

Re: [PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
Thx for the quick response, i ll see if that helps me "Ryan Jameson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'd use this: set_time_limit (3600); <>< Ryan -----Original Message- From: Radovan Radic [mailto:[EM

Re: [PHP-DB] Max execution time

2002-12-02 Thread Radovan Radic
another one: Is there some kind of explorer timeout for scripts that execute too long? Radovan "Ryan Jameson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'd use this: set_time_limit (3600); <>< Ryan -----Original Me

[PHP-DB] Re: adding in array

2002-12-10 Thread Radovan Radic
"Bastian Vogt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > I'ld suggest this: > > // inside your loop > $array[$year] += $value; > > HTH, > Bastian > Lets say $year is 2000 There is not defined index 2000 at $array. It is going to be undefined offset

[PHP-DB] Re: adding in array

2002-12-10 Thread Radovan Radic
"Bastian Vogt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Lets say $year is 2000 > > There is not defined index 2000 at $array. > > It is going to be undefined offset. > > Hm... I think it's gonna work, but if it's one of the "don'ts" in > progamming styl

[PHP-DB] Re: flytte bsd harddisk til anden pc

2002-12-12 Thread Radovan Radic
Dutch, swedish...? "Martin Allan Jensen" <[EMAIL PROTECTED]> wrote in message 002501c2a1e2$092e8640$020a@asus">news:002501c2a1e2$092e8640$020a@asus... Hej Allesammen, har et strt problem, jeg skal IDAG skifte server, men kan jeg bare tage mine harddiske med FreeBSD på og smide over i den n

[PHP-DB] Re: problem with PHP+flash programming

2002-12-18 Thread Radovan Radic
"Hermanto Kurniawan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > i have a problem with this flash actionscript : > loadVariablesNum > ("GuestBook.php?NumLow="+NumLow+"&NumHigh="+NumHigh+"&R="+random(999), 0); > > when i run this script i got an error message

[PHP-DB] Re: how to call a stored procedure in SQL Server 2000

2002-12-27 Thread Radovan Radic
I have sp like this in MSSQL CREATE procedure dsp_ani_usage_period @from_date datetime, @to_date datetime, @max_usage money which does join select from some tables using these params for where And i execute it from PHP if(!isset($date_from)) { $date_from=date("m/d/Y",strtotime("-1 month"));

[PHP-DB] Re: Drawing chart

2003-01-03 Thread Radovan Radic
Check these: http://www.aditus.nu/jpgraph/ http://www.phplot.com/ "Matthias Steiner" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[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: d

[PHP-DB] Re: undefined function: mssql_connect()

2003-01-08 Thread Radovan Radic
Do you have php_mssql.dll extension loaded? Check better with phpinfo(); Radovan "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, Hope someone can help me with this. I need to connect to a MS SQL database but my attemps fail once and

[PHP-DB] PHP Oci8 segmntation fault

2003-08-14 Thread Radovan Radic
Hello I have php 4.3.2 installed as apache 2.0.45 module on RH Linux (7.3) with oci8 support. Things work fine when php scripts are accessed via web, but when i try to start them from command line using /usr/local/php4.3.2/bin/php test.php i get an error Segmentation fault. test.php has only 4-5 l

[PHP-DB] Re: PHP Oci8 segmntation fault

2003-08-15 Thread Radovan Radic
gt; This probably wont solve your problem, but is fun to do anyway. > > Lang > > > Radovan Radic wrote: > > > Hello > > > > I have php 4.3.2 installed as apache 2.0.45 module on RH Linux (7.3) with > > oci8 support. > > Things work fine when php scrip

[PHP-DB] Re: PHP Oci8 segmntation fault

2003-08-22 Thread Radovan Radic
get a backtrace. > There are instructions for doing this are at > http://bugs.php.net/bugs-generating-backtrace.php > This probably wont solve your problem, but is fun to do anyway. > > Lang > > > Radovan Radic wrote: > > > Hello > > > > I have php 4.3.2 i

[PHP-DB] Re: Oracle and PHP

2003-08-25 Thread Radovan Radic
Hi Roger, There is Oracle Commander , but it is not very good as phpMyAdmin. Try it: http://www.bitesser.de/downloads/download.php?filename=oraclecommander Oracle is similar to other databases used from PHP, only difference is calling stored procedures that return resultset. Dont use oracle funct

[PHP-DB] MySQL latin1 to utf8 conversion

2006-02-02 Thread Radovan Radic
to real utf8 file and then try to use LOAD INFILE for importing the contents of the tables. If php can show correct contents in html using latin1, i think it is possible to export it to plain utf file. This is my question - does anyone know how to do it in php? -- Pozdrav, Radovan Radic -- Pozdrav, Radovan Radic -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php