School project.

[Dako]

Hello.
I need help.
I have to do a project for my programming class and i don't know what to do.
I need ideas.
I was thinking about something like the facebook's comicbook app where you choose your writers/artist/etc and they let you know when an issue is released and stuff like that, but i don't know.

HELP!!

thanks in advance.

PS: i know php and c. But i can learn other things. The project if for October.

[Mark Seifert]

will you have access to a mysql database also?

[Dako]

yes yes, it's like a free project. I can do whatever i want. My skills and imagination are the only limit. xD

[Static-Pulse]

The hardest part to this is going to acquiring the data. Where are you going to get your list of issues and creators?

[Dako]

That's one problem and because i was asking for another ideas.

[Mark Seifert]

here's something:

you could get the weekly text release listings at diamond's site: http://previewsworld.com/public/default.asp?t=3

There's weekly listings there back to 2005 so it's plenty of data.

You could make a program where you could enter a search term like "superman" and get an organized list of what superman issues came out when over the time period. stuff like that. you could also use it to make a bar chart showing how many superman (or x-men, or whatever) comics came out every month and so on.

[Static-Pulse]

I'll second Mark's suggestion. A program that took all that data and pushed it into a database, with search and graphing features, would be slick. You could build an entire portal around that kind of thing, a lot like HeardOnTV with comments about and links to reviews of the comic.

[Dako]

oh thanks, that would be great.
I'll see what can i do.

thanks again.

[Dako]

Well, i forgot about this.
My partner, the one that i have to the project with, reject the idea. But i'm doing it anyway just for fun.

I found a function that put a the information in a txt into a database.LOAD DATA INFILE
I'm doing something like this:

<?php
    $connect = mysql_connect ("localhost","root",""); 
    mysql_select_db ("comic"); 
    $sql = "LOAD DATA INFILE 'D:\comic.txt' INTO TABLE comic FIELDS TERMINATED BY '\n' ";
    
    echo "done";

?>

I guess i'm doing something wron because it doesn't work. PLease help! ;_;
comic.txt contains this:

comic1
comic2
comic3

The table have 1 field. Just for testing.

thanks in advance.

[Static-Pulse]

<?php

$cfile = "D:\comic.txt";

$connect = mysql_connect("localhost","root",""); 

mysql_select_db ("comic");

$fh = fopen($cfile, "r");
$contents = fread($fh, filesize($cfile));
fclose($fh);

$lines = preg_split("/\n/", $contents);

foreach($lines as $line) {
    $sql = "INSERT INTO TABLE (column) VALUES('" . $line . "')";
    // your SQL execute command goes here
}

mysql_connect($connect);

exit;

?>

That might work.