N
Nikos
Hello and Good Morning,
I'll try to be as exact as possibl to what iam trying to do:
Today i decided to change entirely my index.pl page and template and to
create a new one.
I will no longer presentate religious scripts from my webpage but i
think its a good idea to create a webpage
that will show up a list of movies that i do have from the current drop
down menu that i already have or better just
tweak the already games.pl script to a movies.pl script that would
presentate the movies as it now have presentated the
games.
Users have to signup first and their username and password will be
stored in a mysql users database and then everytime
they visit my webpage they would have to log in first and after that
they are ready to view and select movies from
a dropdown menu and add them to a basket or something.
Then they will hit "done" and their selection would be stored in a mysql
order database that will have some connection
to the users database table.
Then if they want to see what they ordered they could be able to press a
"show what i ordered" button and then that will
be presenatte to them. I currently have a show.pl so that too is almost
ready except that its a cgi one and needs
converting to a template.
Will you please help me make the appropriate tweaks to the already
created scripts to implement that.
Iam trying too but unfortunately iam no expert.
Thank you.
ps. iam trying now to chnage the column names from games and otehr
database tables to more appropriate ones.
Do you agree with those names of the database tables and the columns in
it to what i want to do? Dis i pick them correctly?
I tried the names to be as much self-explanatory as i can:
$dbh->do( "CREATE DATABASE user (username text, password text, name
text, surname text, address text, phone text, mail text)" );
$dbh->do( "CREATE DATABASE userselect (username text auto_increment
primary key, moviename text" ) or die $!;
$dbh->do( "CREATE DATABASE userdesire (title text, remark text, mail
text, date text, host text )" ) or die $!;
$dbh->do( "CREATE DATABASE movies (moviename text, moviedesc text,
moviecount int )" ) or die $!;
I'll try to be as exact as possibl to what iam trying to do:
Today i decided to change entirely my index.pl page and template and to
create a new one.
I will no longer presentate religious scripts from my webpage but i
think its a good idea to create a webpage
that will show up a list of movies that i do have from the current drop
down menu that i already have or better just
tweak the already games.pl script to a movies.pl script that would
presentate the movies as it now have presentated the
games.
Users have to signup first and their username and password will be
stored in a mysql users database and then everytime
they visit my webpage they would have to log in first and after that
they are ready to view and select movies from
a dropdown menu and add them to a basket or something.
Then they will hit "done" and their selection would be stored in a mysql
order database that will have some connection
to the users database table.
Then if they want to see what they ordered they could be able to press a
"show what i ordered" button and then that will
be presenatte to them. I currently have a show.pl so that too is almost
ready except that its a cgi one and needs
converting to a template.
Will you please help me make the appropriate tweaks to the already
created scripts to implement that.
Iam trying too but unfortunately iam no expert.
Thank you.
ps. iam trying now to chnage the column names from games and otehr
database tables to more appropriate ones.
Do you agree with those names of the database tables and the columns in
it to what i want to do? Dis i pick them correctly?
I tried the names to be as much self-explanatory as i can:
$dbh->do( "CREATE DATABASE user (username text, password text, name
text, surname text, address text, phone text, mail text)" );
$dbh->do( "CREATE DATABASE userselect (username text auto_increment
primary key, moviename text" ) or die $!;
$dbh->do( "CREATE DATABASE userdesire (title text, remark text, mail
text, date text, host text )" ) or die $!;
$dbh->do( "CREATE DATABASE movies (moviename text, moviedesc text,
moviecount int )" ) or die $!;