Dynamic Links (MySQL/PHP) [message #179218] |
Tue, 25 September 2012 17:27 |
tom.rankin51
Messages: 17 Registered: September 2012
Karma: 0
|
Junior Member |
|
|
Hello
I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
My code on the main page is :
<?
include("php/dbinfo.inc.php");
mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$mydate=date("Y-m-d",strtotime("-2 weeks"));
$news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
mysql_close();
?>
<div>
<ol>
<!-- START OF PHP SCRIPT (NEWS) -->
<?
while($r=mysql_fetch_assoc($news_query)) {
echo '<li id="'.$r["id"].'">';
echo '<h2 class="body-headline">';
echo $r["title"];
echo '</h2>';
echo '<h3 class="date-heading">';
echo date("d-M-Y",strtotime($r["postdate"]));
echo '</h3>';
echo nl2br ($r["preview_text"]);
echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
echo '</li><hr />';
} ?>
<!-- END OF PHP SCRIPT (NEWS) -->
</ol>
</div>
Note that I'm using a fancybox script, but this happens without using that script also.
In my news item page I have done the following:
<?
include("php/dbinfo.inc.php");
mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$id = $_GET['id'];
$sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
$news_query=mysql_query($sql);
IF ($news_query){
$r = mysql_fetch_row($news_query);
$title = $r["title"];
$body = $r["body"];
}
mysql_close();
?>
<div>
<h2>
<?
echo $r["title"];
?>
</h2>
<div class="modal-nav-links">
<p><?php echo $r["body"] ?></p>
<!-- <div style="clear: both;"></div> -->
</div>
</div>
I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
Thanks in advance
Tom
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179219 is a reply to message #179218] |
Tue, 25 September 2012 17:41 |
The Natural Philosoph
Messages: 993 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
tom(dot)rankin51(at)googlemail(dot)com wrote:
> Hello
>
> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
> My code on the main page is :
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
> mysql_close();
> ?>
>
> <div>
> <ol>
> <!-- START OF PHP SCRIPT (NEWS) -->
> <?
> while($r=mysql_fetch_assoc($news_query)) {
> echo '<li id="'.$r["id"].'">';
> echo '<h2 class="body-headline">';
> echo $r["title"];
> echo '</h2>';
> echo '<h3 class="date-heading">';
> echo date("d-M-Y",strtotime($r["postdate"]));
> echo '</h3>';
> echo nl2br ($r["preview_text"]);
> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
> echo '</li><hr />';
> } ?>
> <!-- END OF PHP SCRIPT (NEWS) -->
> </ol>
> </div>
>
> Note that I'm using a fancybox script, but this happens without using that script also.
>
> In my news item page I have done the following:
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $id = $_GET['id'];
> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
> $news_query=mysql_query($sql);
> IF ($news_query){
> $r = mysql_fetch_row($news_query);
>
> $title = $r["title"];
> $body = $r["body"];
> }
>
> mysql_close();
> ?>
>
> <div>
> <h2>
> <?
> echo $r["title"];
> ?>
> </h2>
> <div class="modal-nav-links">
> <p><?php echo $r["body"] ?></p>
> <!-- <div style="clear: both;"></div> -->
> </div>
> </div>
>
>
> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
> Thanks in advance
> Tom
Haven't time to explore your source, but if its on a server that you
administer, look in apache* error logs: that's where PHP errors can end up.
*or whatever web server it is
--
Ineptocracy
(in-ep-toc’-ra-cy) – a system of government where the least capable to
lead are elected by the least capable of producing, and where the
members of society least likely to sustain themselves or succeed, are
rewarded with goods and services paid for by the confiscated wealth of a
diminishing number of producers.
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179221 is a reply to message #179219] |
Tue, 25 September 2012 17:58 |
tom.rankin51
Messages: 17 Registered: September 2012
Karma: 0
|
Junior Member |
|
|
I'm looking into my error logs but can't find an error anywhere. For the record, I found a .log file in my Apache Logs folder, and a .htaccess file that contains nothing in my Error Logs folder.
I apologise, this is not something I've ever had to do before.
Tom
On Tuesday, September 25, 2012 6:41:09 PM UTC+1, The Natural Philosopher wrote:
> tom wrote:
>
>> Hello
>
>>
>
>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
>>
>
>> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
>>
>
>> My code on the main page is :
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
>>
>
>> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <ol>
>
>> <!-- START OF PHP SCRIPT (NEWS) -->
>
>> <?
>
>> while($r=mysql_fetch_assoc($news_query)) {
>
>> echo '<li id="'.$r["id"].'">';
>
>> echo '<h2 class="body-headline">';
>
>> echo $r["title"];
>
>> echo '</h2>';
>
>> echo '<h3 class="date-heading">';
>
>> echo date("d-M-Y",strtotime($r["postdate"]));
>
>> echo '</h3>';
>
>> echo nl2br ($r["preview_text"]);
>
>> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
>
>> echo '</li><hr />';
>
>> } ?>
>
>> <!-- END OF PHP SCRIPT (NEWS) -->
>
>> </ol>
>
>> </div>
>
>>
>
>> Note that I'm using a fancybox script, but this happens without using that script also.
>
>>
>
>> In my news item page I have done the following:
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $id = $_GET['id'];
>
>> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
>
>> $news_query=mysql_query($sql);
>
>> IF ($news_query){
>
>> $r = mysql_fetch_row($news_query);
>
>>
>
>> $title = $r["title"];
>
>> $body = $r["body"];
>
>> }
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <h2>
>
>> <?
>
>> echo $r["title"];
>
>> ?>
>
>> </h2>
>
>> <div class="modal-nav-links">
>
>> <p><?php echo $r["body"] ?></p>
>
>> <!-- <div style="clear: both;"></div> -->
>
>> </div>
>
>> </div>
>
>>
>
>>
>
>> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
>>
>
>> Thanks in advance
>
>> Tom
>
>
>
>
>
> Haven't time to explore your source, but if its on a server that you
>
> administer, look in apache* error logs: that's where PHP errors can end up.
>
>
>
> *or whatever web server it is
>
>
>
> --
>
> Ineptocracy
>
>
>
> (in-ep-toc’-ra-cy) – a system of government where the least capable to
>
> lead are elected by the least capable of producing, and where the
>
> members of society least likely to sustain themselves or succeed, are
>
> rewarded with goods and services paid for by the confiscated wealth of a
>
> diminishing number of producers.
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179222 is a reply to message #179218] |
Tue, 25 September 2012 18:02 |
Luuk
Messages: 329 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)com wrote:
> Hello
>
> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
> My code on the main page is :
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
> mysql_close();
> ?>
>
> <div>
> <ol>
> <!-- START OF PHP SCRIPT (NEWS) -->
> <?
> while($r=mysql_fetch_assoc($news_query)) {
> echo '<li id="'.$r["id"].'">';
> echo '<h2 class="body-headline">';
> echo $r["title"];
> echo '</h2>';
> echo '<h3 class="date-heading">';
> echo date("d-M-Y",strtotime($r["postdate"]));
> echo '</h3>';
> echo nl2br ($r["preview_text"]);
> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
> echo '</li><hr />';
> } ?>
> <!-- END OF PHP SCRIPT (NEWS) -->
> </ol>
> </div>
>
> Note that I'm using a fancybox script, but this happens without using that script also.
>
> In my news item page I have done the following:
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $id = $_GET['id'];
> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
> $news_query=mysql_query($sql);
> IF ($news_query){
> $r = mysql_fetch_row($news_query);
>
> $title = $r["title"];
> $body = $r["body"];
> }
>
> mysql_close();
> ?>
>
> <div>
> <h2>
> <?
> echo $r["title"];
> ?>
> </h2>
> <div class="modal-nav-links">
> <p><?php echo $r["body"] ?></p>
> <!-- <div style="clear: both;"></div> -->
> </div>
> </div>
>
>
> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
> Thanks in advance
> Tom
>
There is a missing 'mysql_select_db()'
http://php.net/manual/en/function.mysql-select-db.php
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179224 is a reply to message #179222] |
Tue, 25 September 2012 18:17 |
tom.rankin51
Messages: 17 Registered: September 2012
Karma: 0
|
Junior Member |
|
|
Both sections of code contain 'mysql_select_db() - should it be included a third time?
On Tuesday, September 25, 2012 7:10:02 PM UTC+1, Luuk wrote:
> On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)com wrote:
>
>> Hello
>
>>
>
>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
>>
>
>> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
>>
>
>> My code on the main page is :
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
>>
>
>> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <ol>
>
>> <!-- START OF PHP SCRIPT (NEWS) -->
>
>> <?
>
>> while($r=mysql_fetch_assoc($news_query)) {
>
>> echo '<li id="'.$r["id"].'">';
>
>> echo '<h2 class="body-headline">';
>
>> echo $r["title"];
>
>> echo '</h2>';
>
>> echo '<h3 class="date-heading">';
>
>> echo date("d-M-Y",strtotime($r["postdate"]));
>
>> echo '</h3>';
>
>> echo nl2br ($r["preview_text"]);
>
>> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
>
>> echo '</li><hr />';
>
>> } ?>
>
>> <!-- END OF PHP SCRIPT (NEWS) -->
>
>> </ol>
>
>> </div>
>
>>
>
>> Note that I'm using a fancybox script, but this happens without using that script also.
>
>>
>
>> In my news item page I have done the following:
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $id = $_GET['id'];
>
>> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
>
>> $news_query=mysql_query($sql);
>
>> IF ($news_query){
>
>> $r = mysql_fetch_row($news_query);
>
>>
>
>> $title = $r["title"];
>
>> $body = $r["body"];
>
>> }
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <h2>
>
>> <?
>
>> echo $r["title"];
>
>> ?>
>
>> </h2>
>
>> <div class="modal-nav-links">
>
>> <p><?php echo $r["body"] ?></p>
>
>> <!-- <div style="clear: both;"></div> -->
>
>> </div>
>
>> </div>
>
>>
>
>>
>
>> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
>>
>
>> Thanks in advance
>
>> Tom
>
>>
>
>
>
> There is a missing 'mysql_select_db()'
>
> http://php.net/manual/en/function.mysql-select-db.php
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179230 is a reply to message #179219] |
Tue, 25 September 2012 18:34 |
tom.rankin51
Messages: 17 Registered: September 2012
Karma: 0
|
Junior Member |
|
|
Just to update, my error logs are completely empty
On Tuesday, September 25, 2012 6:41:09 PM UTC+1, The Natural Philosopher wrote:
> tom(dot)rankin51(at)googlemail(dot)com wrote:
>
>> Hello
>
>>
>
>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
>>
>
>> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
>>
>
>> My code on the main page is :
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
>>
>
>> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <ol>
>
>> <!-- START OF PHP SCRIPT (NEWS) -->
>
>> <?
>
>> while($r=mysql_fetch_assoc($news_query)) {
>
>> echo '<li id="'.$r["id"].'">';
>
>> echo '<h2 class="body-headline">';
>
>> echo $r["title"];
>
>> echo '</h2>';
>
>> echo '<h3 class="date-heading">';
>
>> echo date("d-M-Y",strtotime($r["postdate"]));
>
>> echo '</h3>';
>
>> echo nl2br ($r["preview_text"]);
>
>> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
>
>> echo '</li><hr />';
>
>> } ?>
>
>> <!-- END OF PHP SCRIPT (NEWS) -->
>
>> </ol>
>
>> </div>
>
>>
>
>> Note that I'm using a fancybox script, but this happens without using that script also.
>
>>
>
>> In my news item page I have done the following:
>
>>
>
>> <?
>
>> include("php/dbinfo.inc.php");
>
>>
>
>> mysql_connect($hostname,$username,$password);
>
>> @mysql_select_db($database) or die( "Unable to select database");
>
>>
>
>> $id = $_GET['id'];
>
>> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
>
>> $news_query=mysql_query($sql);
>
>> IF ($news_query){
>
>> $r = mysql_fetch_row($news_query);
>
>>
>
>> $title = $r["title"];
>
>> $body = $r["body"];
>
>> }
>
>>
>
>> mysql_close();
>
>> ?>
>
>>
>
>> <div>
>
>> <h2>
>
>> <?
>
>> echo $r["title"];
>
>> ?>
>
>> </h2>
>
>> <div class="modal-nav-links">
>
>> <p><?php echo $r["body"] ?></p>
>
>> <!-- <div style="clear: both;"></div> -->
>
>> </div>
>
>> </div>
>
>>
>
>>
>
>> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
>>
>
>> Thanks in advance
>
>> Tom
>
>
>
>
>
> Haven't time to explore your source, but if its on a server that you
>
> administer, look in apache* error logs: that's where PHP errors can end up.
>
>
>
> *or whatever web server it is
>
>
>
> --
>
> Ineptocracy
>
>
>
> (in-ep-toc’-ra-cy) – a system of government where the least capable to
>
> lead are elected by the least capable of producing, and where the
>
> members of society least likely to sustain themselves or succeed, are
>
> rewarded with goods and services paid for by the confiscated wealth of a
>
> diminishing number of producers.
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179234 is a reply to message #179230] |
Tue, 25 September 2012 19:07 |
Luuk
Messages: 329 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 25-09-2012 20:34, tom(dot)rankin51(at)googlemail(dot)com wrote:
> Just to update, my error logs are completely empty
>
> On Tuesday, September 25, 2012 6:41:09 PM UTC+1, The Natural Philosopher wrote:
>> tom(dot)rankin51(at)googlemail(dot)com wrote:
>>
>>> Hello
>>
>>>
>>
>>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>>
>>>
try to add some 'debugging' code
and change '@mysql_select_db' to 'mysql_select_db'
add some echo statements after assignements
and see where the output stops, or is wrong/unexpected.......
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179235 is a reply to message #179224] |
Tue, 25 September 2012 19:04 |
Luuk
Messages: 329 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 25-09-2012 20:17, tom(dot)rankin51(at)googlemail(dot)com wrote:
> Both sections of code contain 'mysql_select_db() - should it be included a third time?
>
> On Tuesday, September 25, 2012 7:10:02 PM UTC+1, Luuk wrote:
>> On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)com wrote:
>>
>>> Hello
>>
>>>
>>
>>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>>
>>>
>>
>>> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>>
>>>
>>
>>> My code on the main page is :
>>
>>>
>>
>>> <?
>>
>>> include("php/dbinfo.inc.php");
>>
>>>
>>
>>> mysql_connect($hostname,$username,$password);
>>
>>> @mysql_select_db($database) or die( "Unable to select database");
>>
>>>
>>
>>> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>>
>>>
>>
>>> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>>
>>>
>>
>>> mysql_close();
>>
>>> ?>
>>
>>>
>>
>>> <div>
>>
>>> <ol>
>>
>>> <!-- START OF PHP SCRIPT (NEWS) -->
>>
>>> <?
>>
>>> while($r=mysql_fetch_assoc($news_query)) {
>>
>>> echo '<li id="'.$r["id"].'">';
>>
>>> echo '<h2 class="body-headline">';
>>
>>> echo $r["title"];
>>
>>> echo '</h2>';
>>
>>> echo '<h3 class="date-heading">';
>>
>>> echo date("d-M-Y",strtotime($r["postdate"]));
>>
>>> echo '</h3>';
>>
>>> echo nl2br ($r["preview_text"]);
>>
>>> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
>>
>>> echo '</li><hr />';
>>
>>> } ?>
>>
>>> <!-- END OF PHP SCRIPT (NEWS) -->
>>
>>> </ol>
>>
>>> </div>
>>
>>>
>>
>>> Note that I'm using a fancybox script, but this happens without using that script also.
>>
>>>
>>
>>> In my news item page I have done the following:
>>
>>>
>>
>>> <?
>>
>>> include("php/dbinfo.inc.php");
>>
>>>
>>
>>> mysql_connect($hostname,$username,$password);
>>
>>> @mysql_select_db($database) or die( "Unable to select database");
>>
>>>
>>
>>> $id = $_GET['id'];
>>
>>> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
>>
>>> $news_query=mysql_query($sql);
>>
>>> IF ($news_query){
>>
>>> $r = mysql_fetch_row($news_query);
>>
>>>
>>
>>> $title = $r["title"];
>>
>>> $body = $r["body"];
>>
>>> }
>>
>>>
>>
>>> mysql_close();
>>
>>> ?>
>>
>>>
>>
>>> <div>
>>
>>> <h2>
>>
>>> <?
>>
>>> echo $r["title"];
>>
>>> ?>
>>
>>> </h2>
>>
>>> <div class="modal-nav-links">
>>
>>> <p><?php echo $r["body"] ?></p>
>>
>>> <!-- <div style="clear: both;"></div> -->
>>
>>> </div>
>>
>>> </div>
>>
>>>
>>
>>>
>>
>>> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>>
>>>
>>
>>> Thanks in advance
>>
>>> Tom
>>
>>>
>>
>>
>>
>> There is a missing 'mysql_select_db()'
>>
>> http://php.net/manual/en/function.mysql-select-db.php
>
aaargh ;)
you did not pos the content of "php/dbinfo.inc.php"
and i missed $database.....
so i got a 'No database selected'... message
sorry...
|
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179255 is a reply to message #179218] |
Wed, 26 September 2012 12:05 |
Captain Paralytic
Messages: 204 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On Sep 25, 6:27 pm, tom.ranki...@googlemail.com wrote:
> Hello
>
> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>
> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>
> My code on the main page is :
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>
> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>
> mysql_close();
> ?>
>
> <div>
> <ol>
> <!-- START OF PHP SCRIPT (NEWS) -->
> <?
> while($r=mysql_fetch_assoc($news_query)) {
> echo '<li id="'.$r["id"].'">';
> echo '<h2 class="body-headline">';
> echo $r["title"];
> echo '</h2>';
> echo '<h3 class="date-heading">';
> echo date("d-M-Y",strtotime($r["postdate"]));
> echo '</h3>';
> echo nl2br ($r["preview_text"]);
> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
> echo '</li><hr />';
> } ?>
> <!-- END OF PHP SCRIPT (NEWS) -->
> </ol>
> </div>
>
> Note that I'm using a fancybox script, but this happens without using that script also.
>
> In my news item page I have done the following:
>
> <?
> include("php/dbinfo.inc.php");
>
> mysql_connect($hostname,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
>
> $id = $_GET['id'];
> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
> $news_query=mysql_query($sql);
> IF ($news_query){
> $r = mysql_fetch_row($news_query);
>
> $title = $r["title"];
> $body = $r["body"];
> }
>
> mysql_close();
> ?>
>
> <div>
> <h2>
> <?
> echo $r["title"];
> ?>
> </h2>
> <div class="modal-nav-links">
> <p><?php echo $r["body"] ?></p>
> <!-- <div style="clear: both;"></div> -->
> </div>
> </div>
>
> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>
> Thanks in advance
> Tom
You haven't got any php in your files. In order for the contents of a
file to be parsed as php, it must be within a pair of php open/close
tags. The php open tag is <?php and the closing one is ?>
Since you have no <?php tag, you have no php to be parsed.
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179258 is a reply to message #179251] |
Wed, 26 September 2012 14:03 |
Denis McMahon
Messages: 634 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On Tue, 25 Sep 2012 23:24:33 -0700, tom.rankin51 wrote:
> So is this worth debugging even though my error logs show nothing?
You're error logs might be showing nothing if you use "@" before function
calls, as this prevents errors from being logged.
Remove any "@" symbols that precede function calls and see if the logs
are still empty? It may be that you're looking at the wrong logs - what
web server are you using? On my ubuntu server with apache2, the errors
turn up in /var/log/apache2/error.log, which seems to be the default as I
have nothing specific in /etc/php5/apache2/php.ini to send them anywhere
else
If you (a) can identify the relevant php config file and (b) have the
access needed to edit it, check the settings in the "error handling and
logging" section and adjust if appropriate.
If you need guidance, don't post the whole section, just post the current
settings. Also post details of OS and server (eg linux/suse + apache2 or
windows XP server + IIS etc)
Rgds
Denis McMahon
|
|
|
Re: Dynamic Links (MySQL/PHP) [message #179260 is a reply to message #179255] |
Wed, 26 September 2012 15:16 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 9/26/2012 8:05 AM, Captain Paralytic wrote:
> On Sep 25, 6:27 pm, tom.ranki...@googlemail.com wrote:
>> Hello
>>
>> I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
>>
>> I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item. It must be quite a simple thing to do, however, I am getting a completely blank page. I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
>>
>> My code on the main page is :
>>
>> <?
>> include("php/dbinfo.inc.php");
>>
>> mysql_connect($hostname,$username,$password);
>> @mysql_select_db($database) or die( "Unable to select database");
>>
>> $mydate=date("Y-m-d",strtotime("-2 weeks"));
>>
>> $news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
>>
>> mysql_close();
>> ?>
>>
>> <div>
>> <ol>
>> <!-- START OF PHP SCRIPT (NEWS) -->
>> <?
>> while($r=mysql_fetch_assoc($news_query)) {
>> echo '<li id="'.$r["id"].'">';
>> echo '<h2 class="body-headline">';
>> echo $r["title"];
>> echo '</h2>';
>> echo '<h3 class="date-heading">';
>> echo date("d-M-Y",strtotime($r["postdate"]));
>> echo '</h3>';
>> echo nl2br ($r["preview_text"]);
>> echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
>> echo '</li><hr />';
>> } ?>
>> <!-- END OF PHP SCRIPT (NEWS) -->
>> </ol>
>> </div>
>>
>> Note that I'm using a fancybox script, but this happens without using that script also.
>>
>> In my news item page I have done the following:
>>
>> <?
>> include("php/dbinfo.inc.php");
>>
>> mysql_connect($hostname,$username,$password);
>> @mysql_select_db($database) or die( "Unable to select database");
>>
>> $id = $_GET['id'];
>> $sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
>> $news_query=mysql_query($sql);
>> IF ($news_query){
>> $r = mysql_fetch_row($news_query);
>>
>> $title = $r["title"];
>> $body = $r["body"];
>> }
>>
>> mysql_close();
>> ?>
>>
>> <div>
>> <h2>
>> <?
>> echo $r["title"];
>> ?>
>> </h2>
>> <div class="modal-nav-links">
>> <p><?php echo $r["body"] ?></p>
>> <!-- <div style="clear: both;"></div> -->
>> </div>
>> </div>
>>
>> I was under the impression that this would work, but no dice. Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
>>
>> Thanks in advance
>> Tom
>
> You haven't got any php in your files. In order for the contents of a
> file to be parsed as php, it must be within a pair of php open/close
> tags. The php open tag is <?php and the closing one is ?>
>
> Since you have no <?php tag, you have no php to be parsed.
>
He's probably using short_open_tags, Paul. Another bad habit he needs
to break.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|