Re: help wanted! - need to convert to php [message #172427 is a reply to message #172422] |
Thu, 17 February 2011 14:58 |
Denis McMahon
Messages: 634 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 17/02/11 09:08, Luuk wrote:
> On 17-02-11 10:04, Luuk wrote:
>> On 17-02-11 09:21, P E Schoen wrote:
>>> "richard" wrote in message news:vly8ffy9470j$(dot)dlg(at)evanplatt(dot)sux...
>>>
>>>> http://1littleworld.net/oldies/test.html
>>>
>>>> I am willing to hire someone to write the basic script that would
>>>> convert this monster into a more manageable item.
>>>
>>>> What I would really like, is a 3 column list of the names under
>>>> each of the tabs. When the user clicks on a name, a box appears
>>>> in the window (not a new window) that displays the rest of the
>>>> information.
>>>
>>> I'm not really interested in taking on this as a job, but I think it
>>> would be a good learning experience for you to work on this a little bit
>>> at a time and then add increasingly fancy stuff.
>>>
>>> One nice thing about PHP is that you can take an HTML document and
>>> change the file extension to PHP, and it will still appear and work the
>>> same. But then you can add the PHP programming to automate the
>>> repetitive stuff and create the HTML document seen by the user from a
>>> database.
>>>
>>> I've played around with both Perl and PHP, and also SQLite, since
>>> sometime in September, and I've had a lot of "fun" figuring out how to
>>> make things work. You can check my posts here as well as on
>>> comp.lang.perl.misc to see where I had problems and how I solved them.
>>> My goal was different from yours but some of the basics will still
>>> apply. I am not especially concerned with the visual aspects of a
>>> website, but more so its simplicity and functionality.
>>>
>>> As a start, you can create a database using a PHP script which would
>>> best be tested on a local server such as xampp. Setting that up and
>>> getting it to work will be a challenge in itself. You can also create,
>>> view, and modify an SQLite3 database using a utility called:
>>> http://sqlitebrowser.sourceforge.net/
>>>
>>> Then the PHP code will need to execute queries based on the user input
>>> to read the data such as song title, artist, and record ID, then you can
>>> have it generate the HTML for presentation to the user.
>>>
>>> Try making an outline or pseudocode to describe just what you want, and
>>> maybe make some simple HTML pages for the visual presentation you want.
>>>
>>> Good luck.
>>>
>>> Paul
>>
>> For these lines you do not actually NEED a database..
>> A simple textfile could do also...
>>
>> "title", "title2", "title3"
>> "A Fool In Love", "Ike and Tina Turner", "The Way You Love Me"
>> "A Kissin' And A Twistin'", "Fabian", "Long Before"
>> ....
> Obviously you need some more fiels than these 3, but ....
Loading a 700 record array from a text file every time it generates a
page (or holding it all in session data) is going to be a bit of an
overhead, he really ought to use a database behind it if the server
supports one.
Especially when he's only trying to display data for a single record.
Rgds
Denis McMahon
|
|
|