PHP - Php Get Url Info

Very simple question. I have a table with courses and a table with students registered for those courses. I have a page where I can change the course name. What I want to do is, when changing the course name in the course table, I want all students in the students table who are already registered for that course to have that course name updated as well in the student table.

 I'm currently using a field cid to update the courses in the course table however, the student table doesn't have a cid field rather a cname ( course name) which I want to use to update the fields in the student table.

 Is it possible to use
Code: [Select]
<a href=\"editcourse.php?cid=" for more than one field of info? i.e transfer the cid + cname and so you can use $_GET[cid]"; and $_GET[cname]"; ?

Something like this maybe ( dont know how the code will go) "editcourse.php?cid=&cname=" ?

Do I have the right idea for how to go about this?

This is a multiplication test for students to take and when they finish they click the score button. after they click the score button it tells them what their score is, with the opportunity to take it again.

What I am trying to do is make this able to keep the recent score and just post the next score. Right now my app just gives the first score and then when I take the test again it just refreshes and gives the new score. I want it to play the new score under the old score. I can't seem to figure out how to do this. If someone could help point me in the right direction. Would appreciate the help.


Here is my code for my app....



Code: [Select]
<?php

require_once('database.php');






define ('ROWS', 3);
define ('COLS', 3);
define ('MAX_NUMBER', 12);
date_default_timezone_set('America/New_York');



if (isset($_POST['btn_score']))
{

$result_name= $_POST['result_name'];

$correct = 0;


//print_r ($_POST);
$time1 = $_POST['ts'];
$time1_object = new DateTime($time1);
$now = new DateTime();
$time_span = $now->diff($time1_object);

$minutes = $time_span->format('%i');
$seconds = $time_span->format('%s');
$seconds+= $minutes * 60;

echo "It took $seconds seconds to complete the test<hr />";



foreach ($_POST as $problem => $answer)
{
if ($problem <> "btn_score" && $problem <> "ts" && $problem <> "result_name")
{
//echo "$problem -- $answer <br />";
$problem = explode('_', $problem);
$num1 = $problem[2];
$num2 = $problem[3];



$right = $num1 * $num2;


if ($answer != $right)
{
echo "$num1 * $num2 = $answer , The right answer is $right<br />";
}else 
{
$correct = $correct + 1;

}




}
}
$result_score= 0;
$result_score= ($correct / 9) * 100;

echo "your score is <br/>$result_score<br/>";

}


$sql = "INSERT INTO results (result_name, result_score, result_date_time) VALUES ('$result_name','$result_score', NOW());";










?>

<h1>Multiplication Test</h1>

<form name="lab5" method="post" action="lab5b.php">
<?php
$now = new DateTime();
//echo $now->format('Y-m-d H:i:s');
echo "<input type='hidden' name='ts' value='" . $now->format('Y-m-d H:i:s') . "'>";
?>
<table border="1" cellspacing="5" cellpadding="5">

<?php


$no_of_problems = 0;
for ($row=0; $row<ROWS; $row++)
{
echo "<tr>";
for ($col=0; $col<COLS; $col++)
{
$num1 = mt_rand(1,MAX_NUMBER);
$num2 = mt_rand(1,MAX_NUMBER);

echo "<td>$num1 * $num2 </td>";
echo "<td><input type='text' size='2' name=${no_of_problems}_mult_${num1}_${num2}></td>";
$no_of_problems++;
}
echo "</tr>";
}
$colspan = 2 * COLS;
echo "<tr><td colspan=$colspan align='right'><input type='submit' value='Score' name='btn_score'></td></tr>";
?>

Ok so for some reasons on my register and edit profile page when i hit submit it says that i have not filled in all the info i need.. Even after i fill all of them in..

but heres the code for the register form..

Code: [Select]
<?php require("top.php"); ?>
<div id='homeright'>
<?php


echo "<font size='6'>Sign up</font>";

echo "<hr width='75%' align='left'/>";
$form = "<form action='index.php' method='post'>
<table cellspacing='5px'>



<tr>
<td>First Name:</td>
<td class='register'><input type='text' name='firstname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Last Name:</td>
<td><input type='text' name='lastname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Username:</td>
<td><input type='text' name='username' class='textbox' size='35'></td>
</tr>

<tr>
<td>E-mail:</td>
<td><input type='text' name='email' class='textbox' size='35'></td>
</tr>

<tr>
<td>Password:</td>
<td><input type='password' name='password' class='textbox' size='35'></td>
</tr>

<tr>
<td>Confirm Password:</td>
<td><input type='password' name='repassword' class='textbox' size='35'></td>
</tr>

<tr>
<td></td>
<td><input type='submit' name='submitbtn' value='Register' class='button'></td>
</tr>
</table>

</form>";


if ($_POST['submitbtn']){


$firstname = fixtext($_POST['firstname']);
$lastname = fixtext($_POST['lastname']);
$username = fixtext($_POST['username']);
$email = fixtext($_POST['email']);
$password = fixtext($_POST['password']);
$repassword = fixtext($_POST['repassword']);
$website = fixtext($_POST['website']);
$youtube = fixtext($_POST['youtube']);
$bio = fixtext($_POST['bio']);

$name = $_FILES['avatar'] ['name'];
$type = $_FILES['avatar'] ['type'];
$size = $_FILES['avatar'] ['size'];
$tmpname = $_FILES['avatar']['tmpname'];
$ext = substr($name, strrpos($name, '.'));

if ($firstname && $lastname && $username && $email && $password && $repassword){
if ($password == $repassword){
if (strstr($email, "@") && strstr($email, ".") && strlen($email) >= 6){

require("scripts/connect.php");
/*$query = mysql_query("SELECT * FROM users WHERE username='$username' ");*/
$query=mysql_query("SELECT * FROM users WHERE username='$username' ") or die(mysql_error());
$numrows = mysql_num_rows($query);
if ($numrows == 0){

/*$query=mysql_query("SELECT * FROM users WHERE email='$email' ");*/
$query=mysql_query("SELECT * FROM users WHERE email='$email' ") or die(mysql_error());
$numrows=mysql_num_rows($query);
if ($numrows == 0){

$pass = md5(md5($password));
$date = date("F d, Y");

if($name){
move_uploaded_file($tmpname, "avatars/$username.$ext");
$avatar = "$username.$ext";
}
else
$avatar = "/avatars/default_avatar.png";

$code = substr (md5(rand(11111111111, 999999999999999)), 2,  25);

 
mysql_query("INSERT INTO users (`first_name`,`last_name`,`username`,`email`,`password`,`avatar`,`bio`,`website`,`youtube`,`last_login`,`active`,`code`,`locked`,`date`) VALUES ( '$firstname', '$lastname', '$username', '$email', '$pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");

/*mysql_query("INSERT INTO users (Field, Type) VALUES ('', '$firstname', '$lastname', '$username', '$email', 'pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");*/

$webmaster = "Admin@trucksite.com";
$subject = "Activate Your Account!";
$headers = "From: Admin <$webmaster>";
$message = "Hello $firstname.\n\nWelcome to trucksite below is a link for you to activate your account!.\n http://tprofiletesting.net23.net/activate.php?code=$code";

mail($email, $subject, $message, $headers);
echo "Your activation email has been sent to <b>$email</b>.";
}
else
echo "That email is currently in use.";

}
else
echo "That username is currently in use.";
}
else
echo "You did not enter a vaild email.";
}
else
echo "Your passwords did not match.";
}
else
echo"You did not fill in all the required fields.";
}
echo "$form";


?>

</div>
<div id='homeleft'>
<center><font size='6'>Create! Showoff! Educate!</font></center>
<hr />

</div>
</body>
</html>

When I get a hit on my site I like to see where they came from and if they came from a search engine what keywords they used. So here is the refer info:

http://www.google.com/search?q=dog+training&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

I guess I need to split everything into an array or something.

Has anyone done this?  Any Ideas?

Thank you!

Hi Ive currently developed a script that connects via an API to send a message, and tested it with one user and it works perfectly. But now im bit stuck to send it to multiple users. All my visitors unique IDs are being stored into a file called unique.csv all in 1 column under each other. But what im currently trying to do is to recall the info from the csv and make a contact list to broadcast the message to.   The csv file looks like:     27823116700 m59317461002