PHP - Create A New Record Text Link Clicked

Hi I was thinkin that I wanna make a simulor function to the one they use on betting site...

User sees
Team1 vs Team2

When he clicks "team2" it gets registered somewhere before he clicks "bet" wich inserts all his bets somewhere.

Hello,
I had a web page which had sharing (share issue on facebook, twitter....) and I want to record what each user had shared. So, they will click on alink to share it. I want to call a php function when the user click on a link, whats the best method to do this?
Thanks in advance

I have a page that reads from a database to list employees from different states. Under each name is a link that pulls up a new window with a contact form. My goal is to get the name from that link to appear on that new window. (Which I will then use to ultimately add the name into the email that was generated so the recipient can know who the email was intended for.)

I've tried using the GET and POST methods but nothing seems to work. Any help would be appreciated greatly. I will name my firstborn after anything you desire.

I've included my code below. (The last line is what I've been primarily working with)

Code: [Select]
//Open Database Connection
$db = open_db_connection();
$sql = "SELECT DISTINCT 1 from users where active = 'Y' and show_on_contactus = 'Y'";
$results = mysql_query($sql, $db);
$emaillink = "<a target='main'   onclick=window.open('contactform/contactCentral.php?name=$state_row[state]','popup','width=380,height=400,scrollbars=no,resizable=no,toolbar=yes,directories=no,location=no,menubar=yes,status=no,left=0,top=0'); return false>";
if(!mysql_num_rows($results) == FALSE)

        while($row = mysql_fetch_array($results, MYSQL_BOTH))
        {
           echo "<ul id=\"directors\">\n";
           $state_sql = "SELECT * from users where active = 'Y' and show_on_contactus = 'Y' and state_full = 'indiana' order by last_name";
   $state_results = mysql_query($state_sql, $db);
           if(!mysql_num_rows($results) == FALSE)
           {
              while($state_row = mysql_fetch_array($state_results, MYSQL_BOTH))
              {
                 echo "<li>\n";
                 echo "   <div class=\"fl dirimg\">\n";
                 if($state_row[photo] == "")
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"images/exe_placeholder.jpg\" alt=\"$state_row[first_name] $state_row[last_name]\" />\n";
                 }
                 else
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"n2team/pictures/$state_row[photo]\" alt=\"$state_row[firstname] $state_row[last_name]\" />\n";
                 }
                 echo "   </div>\n";
                 echo "   <span class=\"fr\">$state_row[first_name] $state_row[last_name]<br />\n";
                 echo "       $state_row[title]<br />\n";
                 echo "       $state_row[city], $state_row[state]<br />\n";
echo " $emaillink Contact $state_row[first_name] </a></span></li>\n";
              }

I have a "Members" page that displays my organizations members info via My SQL. Currently, the database displays "State" quick links at the top and has the members organized by State down the page. If you click on one of the State links at the top, it will navigate to the section of the page with that state and associated members. I want the members associated with a specific state to be displayed only once I click the associated state link -- instead of all of the information showing at once like it is now. The page I am referring to can be seen at this link: http://homesforhorse...rs.com/members/

<?php

update_option('image_default_link_type','none');

include("/home/cingen/config_admin.php");


function listMembers() {

    $sql = mysql_query("SELECT c.*, s.*
	    FROM (".TABLE_MEMBERS." c LEFT JOIN ".TABLE_STATE." s on c.state = s.state_abbr)
        WHERE c. status = '1'
	    ORDER BY c.country, c.state, c.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
        $display_members = false;

    	$organization = stripslashes($row['organization']);
	    $website = stripslashes($row['website']);

    	if ($website) {
	    	$link = "<a href='http://".$website."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    $display_members .= $link.$organization.$endlink."<br />";

    	if ($row['address'])    $display_members .= stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />";
        if ($row['city'])       $display_members .= stripslashes($row['city']).", ";
        if ($row['state'])      $display_members .= stripslashes($row['state'])."";
        if ($row['zip'])        $display_members .= "  ".$row['zip'];

        $display_members .= "<br />";

    	if ($row['contact_name'])       $display_members .= "Contact: ".stripslashes($row['contact_name']);
	    if ($row['contact_title'])      $display_members .= ", ".stripslashes($row['contact_title']);
    	if ($row['phone']) 	    	    $display_members .= "<br />Tel: ".stripslashes($row['phone']);
	    if ($row['email']) 		        $display_members .= "<br />".$row['email'];
	    if ($row['website']) 	        $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a><br/>";
	    if ($row['year_est'])           $display_members .= "Founded in ".$row['year_est'].".";
		if ($row['org501c3'] == "1")    $display_members .= " A 501(c)3 non-profit.";
	    if ($row['gfas'] == "1")   		$display_members .= "<br />GFAS: Accredited Sanctuary.";
	    if ($row['gfas'] == "2")        $display_members .= "<br />GFAS: Verified Sanctuary.";
		if ($row['member_category'])    $display_members .= "<br />".$row['member_category'];

      $display_members .= "<br /><br />";

      $entries[$row['country']][$row['state_name']][] = $display_members;
    }

    $countrylinks = false;
    $statelinks   = false;
    $display      = false;



    if(is_array($entries)){
        $display .= '
        <div class="memberlist">';
        foreach($entries as $country=>$state_members){
            $countrylinks .= '<a href="#'.$country.'">'.$country.'</a> &nbsp;&nbsp;&nbsp;';

            $display .= '
            <h2 id="'.$country.'">'.strtoupper($country).'</h2>
            <div class="country">';


            if(($state_members)){
                foreach($state_members as $state=>$members){
                   $statelinks .= '<a href="#'.$state.'">'.$state.'</a> ';

                    $display .= '
                    <h3 id="'.$state.'">'.strtoupper($state).'</h3>
                    <div class="state">';
                    if(is_array($members)){
                        foreach($members as $key=>$member){
                            $display .= '
                            <div class="member">
                                '.$member.'
                            </div>';
                        }
                    }
                    $display .= '
                    </div>';
                }
            }
            $display .= '
            </div>';
        }
        $display .= '
        </div>';
    }
    $statelinks1 = '
    <h2>Members List</h2>
    <strong>Quick Links</strong><br /><br />
    '.$statelinks.'<br /><br />'
    .$display;


    return $statelinks1;
}



 add_shortcode('memberlist', 'listMembers');


function listRescueStandards() {

    $display_members = '';
    $sql = mysql_query("SELECT vc.*, s.*, m.*
	    FROM ".TABLE_COMPLIANCE." vc, ".TABLE_STATE." s, ".TABLE_MEMBERS." m
    	WHERE vc.member_id = m.cid
	    AND m.status = '1'
    	AND m.state = s.state_abbr
	    ORDER BY m.state, m.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
	    $organization = stripslashes($row['organization']);

    	if ($row['website']) {
	    	$link = "<a href='http://".$row['website']."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    if($x!=$row['state_name']){
            $display_members .= "<br /><strong>".strtoupper($row['state_name'])."</strong><br />";
            $x = $row['state_name'];
        }

    	$display_members .= $link.$organization.$endlink."<br />
	       ".stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />
    	   ".stripslashes($row['city']).", ".stripslashes($row['state'])."  ".$row['zip']."<br />";

	    if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
    	if ($row['contact_title']) 	$display_members .= ", ".stripslashes($row['contact_title']);
	    if ($row['phone']) 		$display_members .= "<br />Tel: ".stripslashes($row['phone']);
    	if ($row['fax']) 	$display_members .= "<br />Fax: ".stripslashes($row['fax']);
	    if ($row['email']) 	$display_members .= "<br />".$row['email'];
    	if ($row['website']) 		$display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a>";
	    if ($row['year_est']) 		$display_members .= "<br />Founded in ".$row['year_est'].".";
    	if ($row['org501c3'] == "1") 		$display_members .= "<br />This organization IS registered with the IRS as a 501(c)3.";
        if ($row['org501c3'] != "1") 	$display_members .= "<br />This organization is NOT registered with the IRS as a 501(c)3.";

    	$display_members .= "<br /><br />";
    }

            return "<div class='memberlist'>" . $display_members . "</div>";

}
add_shortcode('standardslist', 'listRescueStandards');

 

Hi there,

I've been tasked with the job of re-doing the company website from scratch and I'm having a bit of trouble with some of the logic involved as I'm not a web designer by trade. Or by any reasonable stretch of the imagination.

Anywhoot, what I'm struggling with is this:

I have laid out the website so for each of the core business units there is one php page, call it 'page x'. On page x there are two sections; a sidebar and a content section. At the top of page x there is a menu bar with a links to a different category (eg. services, products, about, contacts, etc). What I have at the moment for page x is an INCLUDE statement in each of the subsection which pulls through a html page and plops it down in the right place.

What I am struggling with is how to use the links at the top of the page to pull through a different html page depending on what link I click.

I was thinking that I could use something a couple of variables, $sidebar and $content, and then some kind of on-click function to pass a string to each of the variables and then use the INCLUDE statement to call the correct pages.

What I have tentatively come up with is this :

Code: [Select]
<a href=#><img src="/MS_Images/service_hlight.jpg" width="100" height="42" onclick=$sidebar = "OutsourceIT_Website/Managed Services/services_side.html" /></a>

and then:

Code: [Select]
<?php
include $sidebar;
?>

Would this work in principle? How do I go about making sure that the variable in the link is declared properly? Is there a better way to go about doing this that I am missing due to my ignorance?

Hope someone can help because Uncle Google is getting fed up with my vague search terms.