General topic about portal

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
imagetvr
Forum Newbie
Posts: 2
Joined: Wed Feb 27, 2008 10:39 pm

General topic about portal

Post by imagetvr »

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
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Re: General topic about portal

Post by Chris Corbyn »

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!).
User avatar
Chalks
Forum Contributor
Posts: 447
Joined: Thu Jul 12, 2007 7:55 am
Location: Indiana

Re: General topic about portal

Post by Chalks »

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!
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: General topic about portal

Post by Ollie Saunders »

The main reason I posted in this thread: The cake is a lie!
The main reason I clicked on it.

As the others have said, this...
Please suggest me how can i convert datas to database ?
...is going to need further qualification in order for us to understand.
imagetvr
Forum Newbie
Posts: 2
Joined: Wed Feb 27, 2008 10:39 pm

Re: General topic about portal

Post by imagetvr »

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
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: General topic about portal

Post by Ollie Saunders »

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.
User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Re: General topic about portal

Post by Kieran Huggins »

ole wrote:
Chalks wrote:The main reason I posted in this thread: The cake is a lie!
The main reason I clicked on it.
:rofl: - me too! I just may have a little bit of a crush on her :oops: On the plus side, she's no crazier than my last two girlfriends... so there's that. Yeah.
ole wrote:$yourPipe->stickInto($that)->smokeIt();
Oh <span style='color:blue' title='I&#39;m naughty, are you naughty?'>smurf</span>, I just freaked out the cat laughing. Damn you ole!
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: General topic about portal

Post by Ollie Saunders »

Oh smurf, I just freaked out the cat laughing. Damn you ole!
I'm glad you like it :). I've had it for a while though.
User avatar
Jonah Bron
DevNet Master
Posts: 2764
Joined: Thu Mar 15, 2007 6:28 pm
Location: Redding, California

Re: General topic about portal

Post by Jonah Bron »

Yeah. Pretty good.
Post Reply