Re: PHP/MySQL project
From: Tony (nospam_at_nospam.net)
Date: 09/27/04
- Next message: DaRemedy: "Re: Header help"
- Previous message: Design: "build a paging system to this script"
- In reply to: oo.arNOSP_at_AMtiscali.co.uk: "PHP/MySQL project"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 27 Sep 2004 21:00:55 GMT
oo.arNOSP@AMtiscali.co.uk wrote:
> Hi,
>
> Looking to build a dynamic site using PHP/MySQL.
>
> I have a CSV file with over 20,000 entries with the following
> structure-
>
> '1591', 'tones', '100280', '50s', 'Blue Moon', 'Elvis Presley', 'Blue
> Moon,elvis presley,grease', '', '', '',
> 'http://www.mms3.com/data/ringtones/100280.wma'
>
> The file will be updated on a regular basis so will have to be able to
> import changes to the database easily.
Import the csv file into the MySql db, and then use phpmyadmin in the future
to update the database accordingly. Once the initial records are imported
into the database, forget the csv file.
> Which equates to the third listing here-
> http://www.jazytones.com/ringtone_1.html
>
> What I want to do is add this file into a MySQL database and then use
> a small number of PHP template files to create a site.
>
> I have lots of experience with HTML, but have avoided database driven
> sites and server side scripting until now.
>
> The server has Apache 2.040, PHP (not sure which version) installed,
> phpMyAdmin 2.5.1 and MySQL 3.23.58. I can upgrade if required.
The version of PHP will be important if you are considering finding / buying
a pre made script. Register Globals were switched off by default since 4.2
and any scripts that depend on these being "on" may have a nil or very short
shelf life (depending on your hosts view on this). Either way, your PHP code
should be designed assuming register_globals are "off" since it's probable
that all hosts / servers will eventually follow that route.
http://uk2.php.net/register_globals
To establish what version of PHP is running, upload the following code into
a plain text file called test.php and then call it via your browser
http://www.example.com/test.php
<?php phpinfo(); ?>
> I really need something online within weeks and don't have the time to
> devote to learning enough of this myself in this time frame, so
> considering hiring someone.
>
> I'm after something along these lines - http://www.jazytones.com/ but
> without the javascript and generated dynamically (the above is a
> static affiliate site <not mine, but uses the same affiliate links>).
>
> This site http://www.bananatones.co.uk/ is kind of what I'm after (not
> the look, the structure). I'm not too concerned about the look right
> now, I can sort that out later.
>
> How easy/hard would this be for a first PHP/MySQL project and if I go
> with hiring someone what sort of cost am I looking at?
If you want to d-i-y within a few weeks, that sounds very unlikely. Maybe a
£1K - £2K job (ish) in the UK, or try subbing out to
http://www.getafreelancer.com/
> Or are there short cuts I can take, maybe a place to buy a templae
> that I could adapt for this?
A quick search at hotscripts.com came up with this:
http://hotscripts.com/search/417021.html
Can't personally vouch for any of those though.
>
> Thanks
>
.
- Next message: DaRemedy: "Re: Header help"
- Previous message: Design: "build a paging system to this script"
- In reply to: oo.arNOSP_at_AMtiscali.co.uk: "PHP/MySQL project"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
