Jump to content

ger_mac74

Members
  • Posts

    24
  • Joined

  • Last visited

    Never

Everything posted by ger_mac74

  1. yes desleted connect details for security reasons. Have tried echoing parts and everything seems fine. i am newish to php. The script is running fine except that when the page loads up first the html stuff below the php file is not appearing on the website. but when the search is done the search finds the articles and the html stuff after php script appears fine then. As for the second part for problem it is saying that 25 reults are found but the link to next 10>> is only displaying the same page with first 10 results. i found the script online. cheers
  2. Hi Here is the form part of html and the php script that follows after it. The html file is called search1.php which is also what the action is calling. Also having prob displaying results. First 10 results are being displayed fine but the next 10>> link is not working..same page being return. Thanks for coming back to me. Cheers [code]<p> <br></br> <form name="form" action="search1.php" method="get">   <input type="text" name="q" />   <input type="submit" name="Submit" value="Search" /> </form> <?php   // Get the search variable from URL   $var = @$_GET['q'];   $trimmed = trim($var); //trim whitespace from the stored variable // rows to return $limit =10; // check for an empty string and display a message. if ($trimmed == "")   {   echo "<p>Please enter a search...</p>";   exit;   } // check for a search parameter if (!isset($var))   {   echo "<p>We dont seem to have a search parameter!</p>";   exit;   } //connect to database mysql_connect("","",""); //specify database   **** mysql_select_db("") or die("Unable to select database"); // Build SQL Query $query = "SELECT * FROM articles1 WHERE (description LIKE '%$trimmed%' ) OR (articlename LIKE '%$trimmed%' ) ORDER BY description"; $numresults=mysql_query($query); $numrows=mysql_num_rows($numresults); // If we have no results, offer a google search as an alternative if ($numrows == 0)   {   echo "Results";   echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>"; // google echo "<p><a href=\"http://www.google.com/search?q="   . $trimmed . "\" target=\"_blank\" title=\"Look up   " . $trimmed . " on Google\">Click here</a> to try the   search on google</p>";   } else{ // next determine if s has been passed to script, if not use 0   if (empty($s)) {   $s=0;   } // get results   $query .= " limit $s,$limit";   $result = mysql_query($query) or die("Couldn't execute query"); // display what the person searched for echo "<p>You searched for: &quot;" . $var . "&quot;</p>"; // begin to show results set echo "Results: <br>"; $count = 1 + $s; // now you can display the results returned   while ($row= mysql_fetch_array($result)) {            $title = $row["articlename"];            $arturl  = $row["articleurl"];            echo "$count.) <a href='$arturl'>$title</a><br>";            $count++; } $currPage = (($s/$limit) + 1); //break before paging   echo "<br />";   // next we need to do the links to other results   if ($s>=1) { // bypass PREV link if s is 0   $prevs=($s-$limit);   print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;   Prev 10</a>&nbsp&nbsp;";   } // calculate number of pages needing links   $pages=intval($numrows/$limit); // $pages now contains int of pages needed unless there is a remainder from division   if ($numrows%$limit) {   // has remainder so add one page   $pages++;   } // check to see if last page   if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {   // not last page so give NEXT link   $news=$s+$limit;   echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";   } $a = $s + ($limit);   if ($a > $numrows) { $a = $numrows; }   $b = $s + 1;   echo "<p>Showing results $b to $a of $numrows</p>"; } ?>[/code][s]
  3. Hi all I am running a php search script within a html webpage. The top part of the web page appears ok when viewed, as does the script part ..but the part of html code after the script is not appearing on page until the script is called. The script is calling itself..i think this may be where the problem is coming from?? I would like to keep the script in the same file. Any ides whats happenin?
  4. does anyone have any ideas on how i would fix one or two incorrect lines in this script? thanks
  5. does anyone have any ideas how i could fix one or two incorrect lines in this script??
  6. Hi there I am using this search script that I found online, in a web page that I am designing. It is searching a table in a database. When I open the file the search script finds and lists the first 10 results but the link to Next 10>> is not working. It does find enough results to have a next page as it is also printing "Showing results 1 to 10 of 35"" below the link. I am new to php and am having problems here. Can anyone help me out? Please! Thank you... Geraldine [code]<form name="form" action="search.php" method="get">   <input type="text" name="q" />   <input type="submit" name="Submit" value="Search" /> </form> <?php   // Get the search variable from URL   $var = @$_GET['q'];   $trimmed = trim($var); //trim whitespace from the stored variable // rows to return $limit =10; // check for an empty string and display a message. if ($trimmed == "")   {   echo "<p>Please enter a search...</p>";   exit;   } // check for a search parameter if (!isset($var))   {   echo "<p>We dont seem to have a search parameter!</p>";   exit;   } //connect to database mysql_connect("cosmos.ucc.ie","gpmc1","itahkauf"); //specify database   **** mysql_select_db("2006_gpmc1") or die("Unable to select database"); // Build SQL Query $query = "SELECT * FROM articles1 WHERE (description LIKE '%$trimmed%' ) OR (articlename LIKE '%$trimmed%' ) ORDER BY description"; $numresults=mysql_query($query); $numrows=mysql_num_rows($numresults); // If we have no results, offer a google search as an alternative if ($numrows == 0)   {   echo "Results";   echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>"; // google echo "<p><a href=\"http://www.google.com/search?q="   . $trimmed . "\" target=\"_blank\" title=\"Look up   " . $trimmed . " on Google\">Click here</a> to try the   search on google</p>";   } // next determine if s has been passed to script, if not use 0   if (empty($s)) {   $s=0;   } // get results   $query .= " limit $s,$limit";   $result = mysql_query($query) or die("Couldn't execute query"); // display what the person searched for echo "<p>You searched for: "" . $var . ""</p>"; // begin to show results set echo "Results: <br>"; $count = 1 + $s; // now you can display the results returned   while ($row= mysql_fetch_array($result)) {            $title = $row["articlename"];            $arturl  = $row["articleurl"];            echo "$count.) <a href='$arturl'>$title</a><br>";            $count++; } $currPage = (($s/$limit) + 1); //break before paging   echo "<br />";   // next we need to do the links to other results   if ($s>=1) { // bypass PREV link if s is 0   $prevs=($s-$limit);   print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><<   Prev 10</a>  ";   } // calculate number of pages needing links   $pages=intval($numrows/$limit); // $pages now contains int of pages needed unless there is a remainder from division   if ($numrows%$limit) {   // has remainder so add one page   $pages++;   } // check to see if last page   if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {   // not last page so give NEXT link   $news=$s+$limit;   echo " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";   } $a = $s + ($limit);   if ($a > $numrows) { $a = $numrows; }   $b = $s + 1;   echo "<p>Showing results $b to $a of $numrows</p>"; ?>[/code]
  7. Hi again I know the code is a bit long but my guess is that there is not much wrong with it. I found the code online and am new to php myself. Mable somebody experienced could help me out...please... thank you
  8. Hi there does anyone have any ideas on how to fix this. The search script is essentially working but i am unable to view any links after the 10th one found.....the next 10>> link is not working/displaying results...when clicked on nothing happens. Cheers
  9. Hi there I am using this search script in a web page that I am designing. It is searching a table in a database. When I open the file the search script finds and lists the first 10 results but the link to Next 10>> is not working. It does find enough results to have a next page as it is also printing "Showing results 1 to 10 of 35"" below the link. I am new enough to php and am having problems here. Can anyone help me out? Cheers [code] <form name="form" action="search.php" method="get">   <input type="text" name="q" />   <input type="submit" name="Submit" value="Search" /> </form> <?php   // Get the search variable from URL   $var = @$_GET['q'];   $trimmed = trim($var); //trim whitespace from the stored variable // rows to return $limit =10; // check for an empty string and display a message. if ($trimmed == "")   {   echo "<p>Please enter a search...</p>";   exit;   } // check for a search parameter if (!isset($var))   {   echo "<p>We dont seem to have a search parameter!</p>";   exit;   } //connect to database mysql_connect("cosmos.ucc.ie","gpmc1","itahkauf"); //specify database   **** mysql_select_db("2006_gpmc1") or die("Unable to select database"); // Build SQL Query $query = "SELECT * FROM articles1 WHERE (description LIKE '%$trimmed%' ) OR (articlename LIKE '%$trimmed%' ) ORDER BY description"; $numresults=mysql_query($query); $numrows=mysql_num_rows($numresults); // If we have no results, offer a google search as an alternative if ($numrows == 0)   {   echo "Results";   echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>"; // google echo "<p><a href=\"http://www.google.com/search?q="   . $trimmed . "\" target=\"_blank\" title=\"Look up   " . $trimmed . " on Google\">Click here</a> to try the   search on google</p>";   } // next determine if s has been passed to script, if not use 0   if (empty($s)) {   $s=0;   } // get results   $query .= " limit $s,$limit";   $result = mysql_query($query) or die("Couldn't execute query"); // display what the person searched for echo "<p>You searched for: "" . $var . ""</p>"; // begin to show results set echo "Results: <br>"; $count = 1 + $s; // now you can display the results returned   while ($row= mysql_fetch_array($result)) {            $title = $row["articlename"];            $arturl  = $row["articleurl"];            echo "$count.) <a href='$arturl'>$title</a><br>";            $count++; } $currPage = (($s/$limit) + 1); //break before paging   echo "<br />";   // next we need to do the links to other results   if ($s>=1) { // bypass PREV link if s is 0   $prevs=($s-$limit);   print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><<   Prev 10</a> ";   } // calculate number of pages needing links   $pages=intval($numrows/$limit); // $pages now contains int of pages needed unless there is a remainder from division   if ($numrows%$limit) {   // has remainder so add one page   $pages++;   } // check to see if last page   if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {   // not last page so give NEXT link   $news=$s+$limit;   echo " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";   } $a = $s + ($limit);   if ($a > $numrows) { $a = $numrows; }   $b = $s + 1;   echo "<p>Showing results $b to $a of $numrows</p>"; ?>[/code] [b]EDITED BY OBER: PLEASE USE CODE TAGS WHEN POSTING CODE.[/b]
  10. Thanks for that. I looked at the manual and cant find what to do. I have tried putting in a letter instead of " " and the letter prints out fine which means the loop and count are working ok. It just doesnt seem to want to print an empty space. I also tried echoing "\s" and "&nbsp;" but neither work. Is there another system I should use to actually print a space or do I use a differnt function. Thanks again.
  11. That's great. Working fine now. I had just left out a comma after articlename in my select query. When it is printing out now the article name is beside the number listed. This is what I want but when it gets to number 10.) it is one space further out the page compared to 9.) Is there a piece of code that I could fit in here to fix this and make 1 to 9 appear one space further out? Not too worried about what happens when it gets to 100. Looks like this at the moment: 8.) Text...... 9.) Text...... 10.)Text...... 11.)Text...... 12.)Text...... Not as obvious here but after 9 text appears out one space further because of extra digit. Hope you can help me out. Regards...
  12. Hi there I am working on a php script for a webpage that will grab two columns from a database (articlename and articleurl) and then number and display just the article name column. This article name column will hopefully appear as a link and when clicked on, the page will then divert to the articles url. Also I am new enough to php and programming so be easy on me! Here is the code that I have so far: <?php $db = mysql_connect("----", "----", "----"); mysql_select_db("-------", $db); $query = "SELECT articlename articleurl FROM articles"; $result = mysql_query($query) or die("Couldn't execute query"); ?> <?php echo "Current List Of Articles: <br>"; $count = 1; while ($row= mysql_fetch_array($result)){ $artname = $row["articlename"]; $arturl = $row["articleurl"]; echo "$count.) <a href='$arturl'>$artname</a><br>"; $count++; } ?> Can anyone see what I am doing wrong? At the moment the code seems to be counting the number of entries in the database but no articlename links seem to be appearing!! Thanks in advance!!!
  13. Hi I am new enough to php. I have designed a website and want to have certain ahref links on this website activate php programs. This is what I would like the php programs to do: When the link is clicked the php program is actived. I would like this php program to load up a certain html template webpage that I have designed and within this template I would like to have a scrolling window that displays the results of a select statement. Each php program and therefore each ahref link will run a different select statement, the statements results will be viewed inside the same scrolling window which will be inside the same website template. Any ideas on how I might do this? I understand that I 'include' the html page at the start of each of these php programs but I dont know how to tell this php program where in the html template the scrolling window will be displayed and also I dont know how to get the select script to run in the scrolling window. Also I dont know if there is a way to view this select statements in scrolling windows. Hope you can help. Regards.
  14. Hi I am new enough to php. I have designed a website and want to have certain ahref links on this website activate php programs. This is what I would like the php programs to do: When the link is clicked the php program is actived. I would like this php program to load up a certain html template webpage that I have designed and within this template I would like to have a scrolling window that displays the results of a select statement. Each php program and therefore each ahref link will run a different select statement, the statements results will be viewed inside the same scrolling window which will be inside the same website template. Any ideas on how I might do this? I understand that I 'include' the html page at the start of each of these php programs but I dont know how to tell this php program where in the html template the scrolling window will be displayed and also I dont know how to get the select script to run in the scrolling window. Also I dont know if there is a way to view this select statements in scrolling windows. Hope you can help. Regards.
  15. Hi i am new to php. Can anyone help me finish off this? Here is what I have put together so far. When someone clicks on say the '10th century articles' link my webpage I want to connect to the database and then grab whatever articles are from the tenth century. The database will have a column called century and in this column I will have tenth, eleventh and so on...depending on what century the article url is about. <html> <head><title>List of articles</title></head> <body> <h1>List of articles about 10th Century</h1> <?php $db = mysql_connect(“localhost”, “username”, “password”); mysql_select_db(“databasename”, $db); /// How do I use $_GET method to check if the century in my table states for example“tenth” or “eleventh” /// etc. $result = mysql_query(“SELECT * FROM SELECT `articles` WHERE `century` = '".$_GET['century'],"databasename"); ?> <table rules=all> <thead> <tr><th>Column1</th><th>Column2</th><th>Column3</th></tr> </thead> <tbody> <?php While ($myrow = mysql_fetch_row($result)) {printf (“<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n, $myrow[0], $myrow[1], $myrow[2]); ?> </tbody> <.table> </body> </html> On my main page I have an <a href="index.php?century=tenth">10 Century Articles</a> I have been told I need to name link like this. Can you explain why? Basically what I want to happen is as follows: Someone visits my page. Click on a link called 'view all articiles that are about the tenth century'. The site will connect to database. select all tenth century articles and then display on website. It will, for example, display in 3 columns ...one for article name one for article url and one for whatever. These columns will also be in database. Maybe someone could help me out with a snippet of code that I may have wrong or am missing?? Thanks in advance...
  16. Hi Can anyone help me finish off this? Here is what I have put together so far. When someone clicks on say the '10th century articles' link my webpage I want to connect to the database and then grab whatever articles are from the tenth century. The database will have a column called century and in this column I will have tenth, eleventh and so on...depending on what century the article url is about. <html> <head><title>List of articles</title></head> <body> <h1>List of articles about 10th Century</h1> <?php $db = mysql_connect(“localhost”, “username”, “password”); mysql_select_db(“databasename”, $db); /// How do I use $_GET method to check if the century in my table states for example“tenth” or “eleventh” /// etc. $result = mysql_query(“SELECT * FROM SELECT `articles` WHERE `century` = '".$_GET['century'],"databasename"); ?> <table rules=all> <thead> <tr><th>Column1</th><th>Column2</th><th>Column3</th></tr> </thead> <tbody> <?php While ($myrow = mysql_fetch_row($result)) {printf (“<tr><td>%s</td><td>%s</td><td>%s</td></tr>\n, $myrow[0], $myrow[1], $myrow[2]); ?> </tbody> <.table> </body> </html> On my main page I have an <a href="index.php?century=tenth">10 Century Articles</a> Why do I name in this way to link? Basically what I want to happen is as follows: Someone visits my page. Click on a link called 'view all articiles that are about the tenth century'. The site will connect to database. select all tenth century articles and then display on website. It will for example display in 3 column ...one for article name one for article url and one for whatever. These columns will also be in database. Maybe someone could help me out with a snippet of code that I may have wrong or am missing?? Cheers.
  17. Thanks again Michael. I now understand that my links will be "index.php?century=tenth" or similar. When someone then clicks on this link I have discovered that a php file will need to be called. This php file i guess will have what you explain below. -------- Coonect to database the variable called $_GET['century'] would be "tenth" you can then use that variable in your mysql query: $result=mysql_query(SELECT * FROM `articles` WHERE `century` = '".$_GET['century']."'"); -------- As this is all I need to display on this site on a simple page would you be able to help me put together a simple php file that will just connect me to a database and then grab the century columns articles and output them. The century column articles will already be urls. I really appreaciate your help so far.
  18. Thanks v much for that. I sort of understand what you are saying but as im am very new to programming I dont know how to put this into effect. I have the html page displaying just general info at the moment. Do i use an ahref link here? I dont know how to code in php yet. Do I have a separate php file and what should it look like if I was to just list the 10th century articles in a simple html page containing just the links. Sorry for being so green. Rgds
  19. Hi there, I am new to php. I am designing a website that is linked to a database using php and mySQL. I have a table in my database that has 4 columns. This table contains data about history articles. One of the column names in the table is called "century". I am creating ahref links on the website I would like to link to a list different articles from differnt centuries. For example if someone clicked on a 10th century link the webpage would then communicate with the database and grab all the 10th centuries articles and list them on this page or another page. I know that a mySQL command something like this SELECT * FROM articles WHERE century = tenth; would list all the articles I need but I dont know if I put this command inbetween an a href or do I need to write some sort of php file? If you know what Im on about would you be able to give me an example script of whatever I need to do. Your help would be much appreciated. Rgds.
  20. Hi I've just begun learning php and mySQL and am having probs working on an assignment. The assignment is as follows: The task in this exercise is to build two systems. The first system which will do the following at least once a day: Visit your chosen news web-page Identify new stories that were not present last time the page was visited Insert the following data about each such story into a mySQL database: the date the story appeared on the website the headline for the story the URL for the story an abstract containing the first few paragraphs of the story The second system will list all the stories in the database on a HTML page. --------------------- I know how to do most of this assignment. I know how to setup the blank database in mySQL. I will be identifying new stories using php, regular expressions, crontab etc. I dont know how to insert the new stories into a mySQL database or list the stories from datbase on an html page. Not very good at programming. I presume I'll be using some kind of INSERT INTO function but how to use this and with what code is the problem. Can anyone help out a confused irishman!? Thanks in advance....
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.