Using data from MySQL

[Rob (SA)]

Hi Folks,

I am busy developing a page which has a custom html in it.

In adding the script / php I have got to a point and for some reason cannot add additional information to this page / custom html.

Any advice here would be welcome

See also: http://www.dynamicdrive.com/forums/s...d.php?p=239416

[jscheuer1]

Most likely you made a syntax error somewhere that's stopping additional content being added. However, pages should not be overloaded. But there is no limit to what you can put on an HTML page. PHP has certain buffering/cache limitations in regards to certain operations which require them. Some operations require the code to wait for things, this must be built in where applicable. And PHP must be written correctly and logically or else it will throw a warning or an error in an unexpected spot that might throw everything else off.

Other possible problems causing this:

• a die() or exit() in your PHP code that stops all further processing
• an unclosed HTML comment tag that renders the rest of the page after it as a comment.
• a javascript error that halts all further javascript processing

There could be other things.

[Rob (SA)]

Hi John,

Thanks for the reply.

I think what I have done is pretty tidy - as a person not knowledgeable of php. It is pretty consequential and repetitive so I am at a loss as to what could be the constraint.

The page is not a dynamic setup but rather a static setup and maybe that is were problems are occuring?

The page can be veiwed here

From the word Erinvale I am trying to edit the page and I am not being allowed to.

I look forward to your replies

Regards
Rob

[jscheuer1]

I see 12 entries after ERINVALE. What browser are you using? Or do you mean something else when you say, "From the word Erinvale I am trying to edit the page and I am not being allowed to"?

There is an error in the generated HTML code here:

<tr class="alt">
<td>PAARL</td>
<td>05 JULY 2011</td>
<td>?</td>
<td>OPEN/CLOSED</td>
<td><form action="https://www.payfast.co.za/eng/process" method="post"> 
<input type="hidden" name="cmd" value="_paynow"> 
<input type="hidden" name="receiver" value="junior@hayesgolf.co.za"> 
<input type="hidden" name="item_name" value="Payment - Paarl - Glacier Series"> 
<input type="hidden" name="item_description" value="payment"> 
<input type="hidden" name="amount" value="120.00"> 
<input type="hidden" name="return_url" value="http://www.gnjgf.co.za/entryform.php"> 
<input type="hidden" name="cancel_url" value="http://www.gnjgf.co.za/Glacier_Main.html"> 
<input type="submit" style="width:66px;height:20px;background-color:#B5CCE4;font-size:10px; font-family: arial, sans-serif;" value="PAY NOW"> 
</td>

</tr>>

But all that appears to do is add (highlighted) here:

UPCOMING TOURNAMENTS ARE LISTED BELOW
>

At the end of the served source, there is this:

<!---------------------------

</table>
</body>
</html>
</div>
</div>
</body>
</html>

All those closing tags are implied anyway, so they aren't 'missed' by the browser. However, anything added after that highlighted line will appear to be part of an unclosed HTML comment and will not be displayed.

You could try running the PHP code that makes this on its own in such a way that any errors or warnings will be displayed.

If that doesn't clear it up for you and if the problem is with PHP, I need to see the PHP code.

[Rob (SA)]

Hi John,

Thanks for taking a look at the file.

I have made those changes suggested - much appreciated.

When I try attach the entire file for your perusal - it asks me to reduce the size of the file to 10 000 characters from 30228.

Is there perhaps another way I can foward you the file for inspection.

Regards
rob

[Rob (SA)]

Hi John,

I reply to some other questions:

I am using IExplorer as a browser.

From the word Erinvale I am trying to edit the html file so as to have the same visual effect and result as everything above it (bar the last item)

Howvever the problem of entering any further is restricted as explained earlier.

With your experiance you would be able to see why - I however cannot find the error.

I look forward to your assitance.

I attach my [email mercifully removed] if this be the only manner to forward you the file.

Regards
Rob

[traq]

Hi John,

Thanks for taking a look at the file.

I have made those changes suggested - much appreciated.

When I try attach the entire file for your perusal - it asks me to reduce the size of the file to 10 000 characters from 30228.

Is there perhaps another way I can foward you the file for inspection.

Regards
rob

you can post the file as an attachment (change the extension from php to .txt).

[jscheuer1]

I removed your email from your post. It's just an invitation to spammers to send you all manner of unsolicited junk.

Feel free to PM me your email address. But, as traq says, you should be able to attach the file as a .txt version.

Let's put that to one side for a moment though, go ahead and attach it, I may well need it, but I still want to know what exactly you mean by:

From the word Erinvale I am trying to edit the html file so as to have the same visual effect and result as everything above it (bar the last item)

I think I get what you're saying, that ? for the ROYAL CAPE row's ENTRY STATUS column followed by all those OPEN/CLOSED entries in the ENTRY STATUS column for subsequent rows until the UMKOMAAS row. But I'm not sure. If that's what it is, perhaps there's nothing wrong with the PHP, rather the database just doesn't have entries for those tables/records.

Regardless, though I'd still like to know if I've got that right, I'm at least a little puzzled by your use of the term "edit". What exactly do you mean by that?

[Rob (SA)]

Hi Guys,

I appreciate your efforts to assist.

The file created needs to have changes made in order that the functionality improve.

The "CLOSED/OPEN" needs to reflect in "OPEN" in Blue as this shows to me that the change made to that row includes for the if then statement that I have introduced.

I have been able to make the changes where the color blue can be seen.

I cannot change /edit the remainder as the change requires additional input or ammendments to what already exists.

In terms of sending the .txt file - thank you for "mercifully" protecting my email address.

I tried that option but we are limited to 19.5Kb of file size. This file is ±35.2Kb

I will therefore try the PM option in order to get the file to you some how.

Agian I appreciate your time and effort

Regards
Rob

[jscheuer1]

I cannot change /edit the remainder as the change requires additional input or ammendments to what already exists.

I'd still like more on what "edit" means here. I'm beginning to think you just mean something like:

"make the served source code look the way I want it to"

Have I got that right?

Anyways, I was going to say before but didn't because I figured your file probably wasn't as large as you now indicate that it is, that you could zip it and attach the .zip version.

That is if you want other forum members to be able to weigh in on it.

If not, email it to me as an attachment. I will email you my address after posting this.