[PHP] MySQL to csv

2002-08-15 Thread Djurovski Dejan 

Hi

Can someone show me how to export MySQL table to a csv file?

Thanks!



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SQL datetime ERROR !

2002-08-13 Thread Djurovski Dejan 

Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs 1.1.0001 into database (as value of expire).
what is wrong?

My table:

CREATE TABLE korpa (
   idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
   mernaj varchar(255) NOT NULL,
   nazivproizvoda varchar(255) NOT NULL,
   ip_adresa_narucioca varchar(255) NOT NULL,
   id_proizvoda varchar(255) NOT NULL,
   kolicina_proizvoda decimal(255,2) DEFAULT '1.00' NOT NULL,
   cena decimal(255,2),
   datum datetime DEFAULT '-00-00 00:00:00' NOT NULL,
   expire datetime,
   PRIMARY KEY (idnarudzbeukorpi)
);

MySQL query:

$aSQL2=insert into korpa  (mernaj, nazivproizvoda, ip_adresa_narucioca,
id_proizvoda, cena, datum, expire) values ('$mernaj', '$naziv', '$ip',
'$id', '$cena', now(), now()+3000);

Please help me!

--
--
  Djurovski Dejan
[EMAIL PROTECTED]







-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] SQL datetime ERROR !

2002-08-13 Thread Djurovski Dejan 

Hi,
I use this query to input data into MySQL DB.
EXPIRE is Expire Date!
My script allways inputs 1.1.0001 into database (as value of expire).
what is wrong?

My table:

CREATE TABLE korpa (
   idnarudzbeukorpi int(255) DEFAULT '0' NOT NULL auto_increment,
   mernaj varchar(255) NOT NULL,
   nazivproizvoda varchar(255) NOT NULL,
   ip_adresa_narucioca varchar(255) NOT NULL,
   id_proizvoda varchar(255) NOT NULL,
   kolicina_proizvoda decimal(255,2) DEFAULT '1.00' NOT NULL,
   cena decimal(255,2),
   datum datetime DEFAULT '-00-00 00:00:00' NOT NULL,
   expire datetime,
   PRIMARY KEY (idnarudzbeukorpi)
);

MySQL query:

$aSQL2=insert into korpa  (mernaj, nazivproizvoda, ip_adresa_narucioca,
id_proizvoda, cena, datum, expire) values ('$mernaj', '$naziv', '$ip',
'$id', '$cena', now(), now()+3000);

Please help me!

--
--
  Djurovski Dejan
[EMAIL PROTECTED]









-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] picture upload error!

2002-08-12 Thread Djurovski Dejan 

I can't upload picture to MySQL database:
What is wrong with my script:
I use PHP  MySQL database.
After submiting form my script says that everything is OK, but in database I
see that a picture is not uploaded.(date, size, name, type are inputed, but
data is not!).

Table:

CREATE TABLE pictures (
picture_id int(11) DEFAULT '0' NOT NULL,
name varchar(30) NOT NULL,
date datetime DEFAULT '-00-00 00:00:00' NOT NULL,
pic_data mediumblob NOT NULL,
pic_size int(11) DEFAULT '0' NOT NULL,
pic_type varchar(30) NOT NULL,
PRIMARY KEY (picture_id)
);



My PHP page:


?php
include_once(db_mysql.php);
class pictures_db extends DB_Sql
{
var $Host=localhost;
var $Database=sajt;
var $User=root;
var $Password=;
}
$aErrors=False;
if (!empty($PicFile_name))
{
if ( ($PicFile_type == image/gif) ||
($PicFile_type == image/pjpeg) ||
($PicFile_type == image/jpeg))
{
$aFile=fopen($PicFile, rb);
$aFileContents=addslashes(fread($aFile, filesize($PicFile)));
fclose($aFile);
$aDB=new pictures_db();
$aSQL=select(max(picture_id) + 1) as new_id from pictures;
$aDB-query($aSQL);
if ($aDB-next_record() )
{
$aNewID=$aDB-f(new_id);
}
if(empty($aNewID) == True)
{
$aNewID=1;
}
$aSQL=insert into pictures (picture_id, name, .
date, pic_data, ;
$aSQL .=pic_size, pic_type) values ($aNewID, .
'$PicName', ;
$aSQL .= NOW(), '$aFileContents', '$PicFile_size', .
'$PicFile_type' );
print($aSQL);
$aDB-query($aSQL);
if ($aDB-Errno != 0)
{
$aErrors = True;
}
}
else
{
$aErrors= True;
}
}
else
{
$aErrors = True;
}
if ($aErrors == False)
{
print(OK);
}
else
{
print(ERROR!!!);
}
?


 -
 -
 Ðurovski Dejan
   [EMAIL PROTECTED]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] proba

2002-08-12 Thread Djurovski Dejan 

proba



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] erwt

2002-08-12 Thread Djurovski Dejan 

trerter



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] MsSQL connection !!! HELP !

2002-07-16 Thread Djurovski Dejan 

I can't connect to mssql!
When I start PHP page with MsSQL connection, PHP craches and I receive this:

PHP caused an invalid page fault in
module NTWDBLIB.DLL at 0167:73330fde.
Registers:
EAX=0020 CS=0167 EIP=73330fde EFLGS=00010246
EBX=0010 SS=016f ESP=0063f600 EBP=0063f610
ECX=00797fe0 DS=016f ESI=0012 FS=4b5f
EDX= ES=016f EDI=00797fe0 GS=
Bytes at CS:EIP:
c6 04 01 00 8b 45 f4 d1 e0 8b e5 5d c2 14 00 cc
Stack dump:
760014d7 0010  0010 0063f67c 7333165e 014d7980 00797fe0
0010   00797fe0 0012 000b 7335a294 0030

What is the problem?
lease help!



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] proba

2002-07-10 Thread Djurovski Dejan 



--



  Ðurovski Dejan
   [EMAIL PROTECTED]



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] sessions

2002-07-10 Thread Djurovski Dejan 

How can I configure my scripts to store sessions in MySQL?

--



  Ðurovski Dejan
   [EMAIL PROTECTED]







-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php