request help?

fosh387 · May 3, 2010

i'm trying to create a frind system in which the request is sent, and stores both the user and the recipent in database, however having som etrouble below are the scripts i have created so far, the trouble is that when "make friend" is clicked nothing actually happens - any help would be great

<html>

href="web.css"/>

<head>

<title>Social.NET</title>

function ajaxrequest()

{

var a = document.getElementById('school').value;

var request = new Ajax.Request

('http://edward.solent.ac.uk/~FoshRachel/dissertation/search3.php',

{ method: 'post',

parameters: 'school=' + a,

onComplete: resultsReturned }

);

}

function resultsReturned(xmlHTTP)

{

document.getElementById('result').innerHTML = xmlHTTP.responseText;

}

function request(id)

{

var firstname = document.getElementById('id').value;

var request = new Ajax.Request

('http://edward.solent.ac.uk/~FoshRachel/dissertation/request.php?firstname="+firstnamevalue+"',

{ method: 'get',

parameters: 'id=' + id,

onComplete: resultsReturned }

);

}

</script>

#result

{

border-style: ridge;

border-color: #FF3300;

border-width: 5px;

background-color: #ffffff;

width: 800px;

height: 400px;

overflow: auto

}

</style>

</head>

<body>

<h1>Social.NET</h1>

<br/>

<h3>Please enter your search details below</h3>

<label for="school">SCHOOL:</label>

<br/>

</form>

<?php

session_start();

$s=$_POST["school"];

$conn = mysql_connect("localhost", "FoshRachel", "chAcre8E");

mysql_select_db("FoshRachel");

$result=mysql_query("SELECT * FROM Users WHERE school='$s'");

if(mysql_num_rows($result)=="")

{

echo "NO results available<br/>";

echo "Click <a href='ajax3.html'>here</a> to try again";

}

else

{

while($row = mysql_fetch_array($result))

echo "Name: " . $row['firstname'] . " " . $row['secondname'] . " <br/> School: " . $row['school'] . " <br/> Date of Birth: " . $row['day'] . "/" . $row['month'] . "/" . $row['year'] . "<br/>" . "<input type='button' value='Make Friend' action='request(id)'/>" . "<br/><br/>";

}

mysql_close($conn);

?>

<?php

session_start();

$_POST["username"]=$u;

$_POST["password"]=$p;

// Test that the authentication session variable exists

if ( !isset ($_SESSION["gatekeeper"]))

{

echo "You're not logged in. Go away!";

}

else

{

$id = $_GET["firstname"];

$username = $_SESSION["gatekeeper"];

$conn = mysql_connect("localhost", "FoshRachel", "chAcre8E");

mysql_select_db("FoshRachel");

$result = mysql_query("select username from Users where firstname ='$id'");

$result2 = mysql_query("select username from Users where username='$username'");

$row=mysql_fetch_array($result);

$row2=mysql_fetch_array($result2);

mysql_query("INSERT INTO friends (friend, username, request) VALUES ('$row[friend]','$row2[username],'1')");

echo "A friendship request has been sent to $row[friend] ";

mysql_close($conn);

}

?>

Sign In

request help?

Recommended Posts

fosh387

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information