General topic about portal
Moderator: General Moderators
General topic about portal
Hello
I wish to develop a portal for online examination. Please suggest me
1. If i use PHP which is best backgroud (MYSQL or someone)
2. I have datas in word file and jpg format. IS it possible to convert data from word and jpg to mysql or some other database.
Please suggest me how can i convert datas to database ?
Thanks
senthil kumar.A
I wish to develop a portal for online examination. Please suggest me
1. If i use PHP which is best backgroud (MYSQL or someone)
2. I have datas in word file and jpg format. IS it possible to convert data from word and jpg to mysql or some other database.
Please suggest me how can i convert datas to database ?
Thanks
senthil kumar.A
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Re: General topic about portal
PHP can work with many different databases, but the two most common are MySQL and Postgres. The vast majority being on MySQL. Libraries like PDO will allow you to interface with lots of DBMSs without having to write lots of different code to support them all.
As for "converting" MS word files and JPEG files into a database I'm not entirely sure what you mean. You can store the files in the database as BLOB types (binary data) but it's generally more advisable to store them on disk and reference the path in the database instead (faster and easier to maintain the DB!).
As for "converting" MS word files and JPEG files into a database I'm not entirely sure what you mean. You can store the files in the database as BLOB types (binary data) but it's generally more advisable to store them on disk and reference the path in the database instead (faster and easier to maintain the DB!).
Re: General topic about portal
I think what he means is that he wants to take the data from a word file (or what have you) and insert it into a database. I would imagine that the easiest way to do that is to create a php file to parse all of that data one file at a time. As long as you don't have an ungodly number of files, and the data is formated the same way across each file, it shouldn't be too hard.
Edit: Wait. You have data in a jpg format? why? That seems like an incredibly un-useful way to store any information (other than a picture).
The main reason I posted in this thread: The cake is a lie!
Edit: Wait. You have data in a jpg format? why? That seems like an incredibly un-useful way to store any information (other than a picture).
The main reason I posted in this thread: The cake is a lie!
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: General topic about portal
The main reason I clicked on it.The main reason I posted in this thread: The cake is a lie!
As the others have said, this...
...is going to need further qualification in order for us to understand.Please suggest me how can i convert datas to database ?
Re: General topic about portal
thanks for your reply
I mean not database to database. For online examination i have questions and answers(multiple choice answer type) in word file. My question how can i store data. Whether i have convert (Questions and answers) to Mysql.
If possible give me one sample
Thanks
senthil kumar
I mean not database to database. For online examination i have questions and answers(multiple choice answer type) in word file. My question how can i store data. Whether i have convert (Questions and answers) to Mysql.
If possible give me one sample
Thanks
senthil kumar
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: General topic about portal
Could be difficult. Depending on how consistent the data it might take an experienced programmer a few hours or days to do. I think the general process would be saving the word files into plain text, loading in PHP with file_get_contents(), and then doing a whole load of filtering and extracting of data using the preg_replace() and preg_match() functions.
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact:
Re: General topic about portal
ole wrote:The main reason I clicked on it.Chalks wrote:The main reason I posted in this thread: The cake is a lie!
Oh <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span>, I just freaked out the cat laughing. Damn you ole!ole wrote:$yourPipe->stickInto($that)->smokeIt();
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: General topic about portal
I'm glad you like itOh smurf, I just freaked out the cat laughing. Damn you ole!
- Jonah Bron
- DevNet Master
- Posts: 2764
- Joined: Thu Mar 15, 2007 6:28 pm
- Location: Redding, California
Re: General topic about portal
Yeah. Pretty good.