|
|
| Re: help wanted! - need to convert to php [message #172420 is a reply to message #172419] |
Thu, 17 February 2011 08:21   |
P E Schoen
Messages: 86
Registered: January 2011
Karma: 0
|
Member |
|
|
"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
|
|
|
|
| Re: help wanted! - need to convert to php [message #172421 is a reply to message #172420] |
Thu, 17 February 2011 09:04 |
Luuk
Messages: 329
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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"
.....
--
Luuk
|
|
|
|
| Re: help wanted! - need to convert to php [message #172422 is a reply to message #172421] |
Thu, 17 February 2011 09:08 |
Luuk
Messages: 329
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
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 ....
;)
--
Luuk
|
|
|
|
| Re: help wanted! - need to convert to php [message #172426 is a reply to message #172419] |
Thu, 17 February 2011 14:09 |
Denis McMahon
Messages: 634
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 17/02/11 06:07, richard wrote:
> I am willing to hire someone to write the basic script that would convert
> this monster into a more manageable item.
It would be more useful if you could supply a link to the original data,
rather than your html encapsulation of it.
A sensible php program would operate on the underlying data and generate
the pages as required, rather than wrap all the data up in one page and
then make sections (in)visible on demand.
Rgds
Denis McMahon
|
|
|
|
| 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: 0
|
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
|
|
|
|
| Re: help wanted! - need to convert to php [message #172428 is a reply to message #172426] |
Thu, 17 February 2011 15:12 |
Geoff Berrow
Messages: 16
Registered: September 2010
Karma: 0
|
Junior Member |
|
|
On Thu, 17 Feb 2011 14:09:36 +0000, Denis McMahon
<denis(dot)m(dot)f(dot)mcmahon(at)googlemail(dot)com> wrote:
> A sensible php program would operate on the underlying data and generate
> the pages as required, rather than wrap all the data up in one page and
> then make sections (in)visible on demand.
On the other hand, it's all text and loads pretty quick so why worry?
Converting it to PHP will almost certainly make it slower.
--
Geoff Berrow (Put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs www.4theweb.co.uk/rfdmaker
|
|
|
|
| Re: help wanted! - need to convert to php [message #172429 is a reply to message #172428] |
Thu, 17 February 2011 16:53 |
Denis McMahon
Messages: 634
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 17/02/11 15:12, Geoff Berrow wrote:
> On Thu, 17 Feb 2011 14:09:36 +0000, Denis McMahon
> <denis(dot)m(dot)f(dot)mcmahon(at)googlemail(dot)com> wrote:
>
>> A sensible php program would operate on the underlying data and generate
>> the pages as required, rather than wrap all the data up in one page and
>> then make sections (in)visible on demand.
>
> On the other hand, it's all text and loads pretty quick so why worry?
>
> Converting it to PHP will almost certainly make it slower.
Depends on lots of things. Not everyone has dsl connections. I
understand large chunks of rural USA are still at the end of POTS modems.
I suspect the page will get a lot larger, with eg 690 images of record
sleeves, each (on the current design) in a hidden div until you select
the tab etc. Also, apart from the first few records, most of the data
isn't loaded yet. I suspect that the page as envisaged by the OP will,
when "complete" be about 1.25k per song * 690 songs (based on averaging
the text and markup of the first five items) for 870 Kb plus images 12kb
(I only checked the size of the first one) * 690 = about 8.3 Mb of images.
That's about 9 Mb for the single page load.
I still think it would be a lot more user friendly to have a php back
end to look the individual songs up in a database and present the
individual songs one at a time, instead of trying to load the whole lot
to the clients machine and then switching between them by hiding /
unhiding divs.
Rgds
Denis McMahon
|
|
|
|
| Re: help wanted! - need to convert to php [message #172430 is a reply to message #172429] |
Thu, 17 February 2011 20:00 |
Jeff North
Messages: 58
Registered: November 2010
Karma: 0
|
Member |
|
|
On Thu, 17 Feb 2011 16:53:01 +0000, in comp.lang.php Denis McMahon
<denis(dot)m(dot)f(dot)mcmahon(at)googlemail(dot)com>
<4d5d534c$0$2280$bed64819(at)gradwell(dot)net> wrote:
> | On 17/02/11 15:12, Geoff Berrow wrote:
> | > On Thu, 17 Feb 2011 14:09:36 +0000, Denis McMahon
> | > <denis(dot)m(dot)f(dot)mcmahon(at)googlemail(dot)com> wrote:
> | >
> | >> A sensible php program would operate on the underlying data and generate
> | >> the pages as required, rather than wrap all the data up in one page and
> | >> then make sections (in)visible on demand.
> | >
> | > On the other hand, it's all text and loads pretty quick so why worry?
> | >
> | > Converting it to PHP will almost certainly make it slower.
> |
> | Depends on lots of things. Not everyone has dsl connections. I
> | understand large chunks of rural USA are still at the end of POTS modems.
> |
> | I suspect the page will get a lot larger, with eg 690 images of record
> | sleeves, each (on the current design) in a hidden div until you select
> | the tab etc. Also, apart from the first few records, most of the data
> | isn't loaded yet. I suspect that the page as envisaged by the OP will,
> | when "complete" be about 1.25k per song * 690 songs (based on averaging
> | the text and markup of the first five items) for 870 Kb plus images 12kb
> | (I only checked the size of the first one) * 690 = about 8.3 Mb of images.
> |
> | That's about 9 Mb for the single page load.
> |
> | I still think it would be a lot more user friendly to have a php back
> | end to look the individual songs up in a database and present the
> | individual songs one at a time, instead of trying to load the whole lot
> | to the clients machine and then switching between them by hiding /
> | unhiding divs.
Also features like sorting and searching could easily be implemented.
The current page relies on javascript being enabled. Stats show that
between 3% and 10% of users have javascript disabled.
|
|
|
|
|
|
|
|
| Re: help wanted! - need to convert to php [message #172434 is a reply to message #172432] |
Thu, 17 February 2011 22:37 |
Captain Paralytic
Messages: 204
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On Feb 17, 9:41 pm, Jeff North <jnort...@yahoo.com.au> wrote:
> On Thu, 17 Feb 2011 22:25:23 +0100, in comp.lang.php Luuk
> <L...@invalid.lan>
>
> <0bg038-aap....@luuk.invalid.lan> wrote:
>> | On 17-02-11 21:00, Jeff North wrote:
>> | > Stats show that
>> | > between 3% and 10% of users have javascript disabled.
>> |
>> | not my stats.... ;)
>
> You're stats come from google, right?
I think you mean "Your" since the (expanded) sentence: "You are stats
come from google, right?" doesn't make sense.
|
|
|
|
| Re: help wanted! - need to convert to php [message #172435 is a reply to message #172434] |
Fri, 18 February 2011 00:31 |
The Natural Philosoph
Messages: 993
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
Captain Paralytic wrote:
> On Feb 17, 9:41 pm, Jeff North <jnort...@yahoo.com.au> wrote:
>> On Thu, 17 Feb 2011 22:25:23 +0100, in comp.lang.php Luuk
>> <L...@invalid.lan>
>>
>> <0bg038-aap....@luuk.invalid.lan> wrote:
>>> | On 17-02-11 21:00, Jeff North wrote:
>>> | > Stats show that
>>> | > between 3% and 10% of users have javascript disabled.
>>> |
>>> | not my stats.... ;)
>> You're stats come from google, right?
>
> I think you mean "Your" since the (expanded) sentence: "You are stats
> come from google, right?" doesn't make sense.
All our bases belong to you.
|
|
|
|
|
|
| Re: help wanted! - need to convert to php [message #172442 is a reply to message #172438] |
Fri, 18 February 2011 10:38 |
Michael Fesser
Messages: 215
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
.oO(Luuk)
> On 17-02-11 22:41, Jeff North wrote:
>> On Thu, 17 Feb 2011 22:25:23 +0100, in comp.lang.php Luuk
>> <Luuk(at)invalid(dot)lan>
>> <0bg038-aap(dot)ln1(at)luuk(dot)invalid(dot)lan> wrote:
>>
>>> | On 17-02-11 21:00, Jeff North wrote:
>>> | > Stats show that
>>> | > between 3% and 10% of users have javascript disabled.
>>> |
>>> | not my stats.... ;)
>>
>> You're stats come from google, right?
>
> no, because i don't have stats on javascript enabled or disabled, they
> simply don't show this figure.....
One of the sites I maintain shows 16% with JS off in 2010 (based on
AWStats with a JS addon). Quite a lot.
Micha
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]