Forum FAQForum FAQSearchSearch MemberlistMemberlist Forum ignore listForum ignore list RegisterRegister ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in
MySQL baza to Excel

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side
View previous topic :: View next topic  
Author Message
les



Joined: 25 Oct 2004
Posts: 370
PostPosted: 26.11.2005 21:13    Post subject: MySQL baza to Excel Add user to your forum ignore list Reply with quote
Zanima me sljedeća stvar: naime vidio sam da se iz phpMyAdmina može baza eksportirati u različitim formatima - jedan od njih je i za Excel. Ono što bih htio napraviti je to da se klikom na jedan link na bazi izvrši unaprijed zadani kveri i rezultat spremi u Excel tablicu koja se onda downloadira. Problem mi je kako to izvesti - kako "napravit" .xls file. Da stavljam stvari u .txt nebi bilo problema, ali ovak me malo gnjavi.... Smile
Ima li netko od vas možda kakvih iskustava sa tim problemcichem?? Možda neki tutorial ili slično...
Thanx unaprijed na odgovorima!
Back to top
View user's profile Send private message Send e-mail
retro_one



Joined: 16 Sep 2003
Posts: 880
Location: DUBRAVA.
PostPosted: 27.11.2005 02:46    Post subject: Add user to your forum ignore list Reply with quote
imas na www.phpclasses.org gro klasa za to...pa pogledaj

_________________
Just your average eccentric programmer.
Back to top
View user's profile Send private message
/dev/null



Joined: 22 Dec 2004
Posts: 144
PostPosted: 27.11.2005 03:40    Post subject: Add user to your forum ignore list Reply with quote
Ako ti se neda cimati sa tim klasama koje usput ne rade uvjek 100% kak treba možeš da probaš da edžportuješ u CSV format. Eksel ga čita super, PHP generiše bez problema sve sa "našim" karakerima... divota.

Lično sam to radio sa par klijenata koji su htjeli eksel format i ljudi su zadovoljni a kod je lako održavati.
Back to top
View user's profile Send private message
Sulien



Joined: 04 Jan 2004
Posts: 2905
Location: Zagreb
PostPosted: 27.11.2005 15:46    Post subject: Add user to your forum ignore list Reply with quote
Moguće je direkt spojiti Excel i bazu sa ODBC driverima... tome uostalom oni i služe

look here: http://www.automateexcel.com/index.php/2005/11/01/connect_excel_to_mysql_database

thank you, thank you Smile
Back to top
View user's profile Send private message Send e-mail Visit poster's website
les



Joined: 25 Oct 2004
Posts: 370
PostPosted: 27.11.2005 23:01    Post subject: Add user to your forum ignore list Reply with quote
I kažem thank you, thank you Smile
Uglavnom našao sam jednu klasu za koju mi se čini da će odraditi posao koji mi treba (moram se samo još malo pozabaviti nekim sitnicama). Rješnje da mi podaci idu u CSV mi nije odgovarajuće, jer korisnik mora dobiti kao output excel tablicu, a ne da mora onda sam ubacivati stvari unutra.
@Sulien: nisam znao za ovo - u svakom slučaju korisna stvar, dobro će doć za ubuduće Smile
Thanx još jednom na odgovorima!
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group