[PHP] MySQL to csv
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 !
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 !
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!
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
proba -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] erwt
trerter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MsSQL connection !!! HELP !
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
-- Ðurovski Dejan [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] sessions
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