[PHP-DB] MySQL latin1 to utf8 conversion

2006-02-02 Thread Radovan Radic
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

[PHP-DB] Re: Oracle and PHP

2003-08-26 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

[PHP-DB] Re: PHP Oci8 segmntation fault

2003-08-22 Thread Radovan Radic
-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 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

[PHP-DB] Re: PHP Oci8 segmntation fault

2003-08-15 Thread Radovan Radic
compile php with --enable-debug as a configure option. run the script again and use gdb to 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

[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

[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] 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: does

[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: 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 like this :

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

[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

[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 style, could you

[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

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:[EMAIL PROTECTED]] Sent: Monday, Dec

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 Message- From: Radovan Radic [mailt

[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

[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 have seen something like mysql --default-character-se

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

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 the MySQL

[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

[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

[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 I have script that reads about 100-200 rows