943,636 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 3704
  • PHP RSS
Mar 1st, 2004
0

Help with a script

Expand Post »
Hi all, i need help for a little php script, here is what i need:

I have a table named "clans" with 4 field in it (name, url, logo, description)
I have a php page with "A-B-C-D-E-F-G-H-I-........."
I need to create the links on the letters that will only show all clans that begins with the clicked letter

I just dont have a damn idea on how to do this, i am sure that the php gurus out there can help me with something simple, i only code for fun and im still newb. Thanks in advance

fred
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fred999 is offline Offline
11 posts
since Feb 2004
Mar 1st, 2004
0

Re: Help with a script

Do u mean a mysql table?

Try something like this


Letters:
<a href="<?php echo $PHP_SELF; ?>?letter=a">A</a>
<a href="<?php echo $PHP_SELF; ?>?letter=b">B</a>
<a href="<?php echo $PHP_SELF; ?>?letter=c">C</a>
...
<a href="<?php echo $PHP_SELF; ?>?letter=z">Z</a> <br /><br />

[php]
<?php

// Connect to DB... blah blah blah

$db_host = 'localhost'; // Probably OK
$db_user = 'Bob'; // Change to your MySQL Username
$db_pass = 'bar'; // Change to your MySQL Password
$db_name = 'database'; // Change to your MySQL Database name

$db_connect = mysql_connect($db_host, $db_user, $db_pass);
$db = mysql_select_db($db_name);

// END DB Connection


// Find the letter=whatever stuff in the URL and assign it to
// the $starting_letter variable
$starting_letter = $_GET['letter'];

// Create + execute SQL
$sql = "SELECT * FROM clans
WHERE LEFT(name, 1) = '$starting_letter'";

$result = mysql_query($sql);

// While there are results, keep looping...
while( $row = mysql_fetch_assoc($result) )
{
// Echo the results...
echo 'Clan: <a href="' . $row['url'] . '">' . $row['name'] . '</a><br />';
echo '<img src="' . $row['logo'] . '" /><br />';
echo $row['description'] . '<br /><br />';
}

// End
?>
[/php]
Team Colleague
Reputation Points: 63
Solved Threads: 6
Supreme Evil Overlord
Roberdin is offline Offline
282 posts
since Feb 2003
Mar 1st, 2004
0

Re: Help with a script

Roberdin ! thanks alot !!

This code did everything i wanted thank you!

fred
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fred999 is offline Offline
11 posts
since Feb 2004
Mar 5th, 2004
0

Re: Help with a script

No probs.

Actually that isn't too secure - you may wish to change

$starting_letter = $_GET['letter'];

to

$starting_letter = addslashes($_GET['letter']);
Team Colleague
Reputation Points: 63
Solved Threads: 6
Supreme Evil Overlord
Roberdin is offline Offline
282 posts
since Feb 2003
Mar 6th, 2004
0

Re: Help with a script

I have a function I use when I'm inserting snippets of code into a MySQL database:

PHP Syntax (Toggle Plain Text)
  1. function mysql_safe_data($string) {
  2. $string = stripslashes($string);
  3. $string = str_replace("'", "''", $string);
  4. $string = str_replace("\\", "<a rel="nofollow" href="http://\\\" target="_blank">\\\\</a>", $string);
  5. return $string;
  6. }

If you don't replace \\ with \\\\ you're going to have problems with slashes when you insert them into MySQL. Just try inserting this code that highlights text into MySQL through an HTML form and see what I mean.

PHP Syntax (Toggle Plain Text)
  1. function highlight($string, $words_to_highlight, $delimiter=" ", $case=0,
  2. $left_string="<b span style=\"background-color: yellow;\">", $right_string="</b>") {
  3. // This is so it highlights the first word. Each word in a textblock must be surrounded by
  4. // [^A-Za-z] in order to highlight whole words, and not subwords.
  5. /* Filtering Process:
  6. Replace statements take out all malicious chars that would break the
  7. search part of a regular expression. Takes unwanted chars and only lets the chars:
  8. [^-a-zA-Z0-9&] in. */
  9. $list_of_words = eregi_replace("[^-a-zA-Z0-9&']", " ", $words_to_highlight);
  10. // This portion of code is to take out single word characters.
  11. $list_array = explode(" ", $list_of_words);
  12. for($i=0; $i<sizeof($list_array); $i++)
  13. if(strlen($list_array[$i]) == 1)
  14. $list_array[$i] = "";
  15. $list_of_words = implode(" ", $list_array); // Use space as delimiter
  16. $list_of_words = eregi_replace(" +", "|", $list_of_words);
  17. // Make sure there aren't any pipes | around $list_of_words
  18. if($list_of_words{0}=="|")
  19. $list_of_words{0} = "";
  20. if($list_of_words{strlen($list_of_words)-1}=="|")
  21. $list_of_words{strlen($list_of_words)-1}="";
  22. $list_of_words = "(".trim($list_of_words).")";
  23. if($case==0)
  24. return eregi_replace("$list_of_words", "$left_string"."<a rel="nofollow" href="file://1%22.%22$right_string/" target="_blank">\\1"."$right_string</a>", $string);
  25. else
  26. return ereg_replace("$list_of_words", "$left_string"."<a rel="nofollow" href="file://1%22.%22$right_string/" target="_blank">\\1"."$right_string</a>", $string);
  27. } // end function highlight
Team Colleague
Reputation Points: 262
Solved Threads: 18
a.k.a inscissor
samaru is offline Offline
1,227 posts
since Feb 2002
Mar 8th, 2004
0

Re: Help with a script

...what's wrong with addslashes()? It add slashes to already existing slashes
Team Colleague
Reputation Points: 63
Solved Threads: 6
Supreme Evil Overlord
Roberdin is offline Offline
282 posts
since Feb 2003
Mar 9th, 2004
0

Re: Help with a script

thanks alot guys! i really appreciate!

if you want to see the result go there: http://www.battlefield-vietnam.ca/clans.php



fred
Reputation Points: 10
Solved Threads: 0
Newbie Poster
fred999 is offline Offline
11 posts
since Feb 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: Not allowed to reply a post
Next Thread in PHP Forum Timeline: Getting Contents Inbetween





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC