PHP - Simple Db Interaction

Hello, im very green to php and I am having trouble creating a simple log in script. Not sure why this is not working, maybe a mysql_query mistake? I am not receiving any errors but nothing gets updated in the members table and my error message to the user displays.  any help is appreciated! here is my php:


<?php
session_start();

$errorMsg = '';
$email = '';
$pass = '';

if (isset($_POST['email'])) {
   $email = ($_POST['email']);
   $pass = ($_POST['password']);
   
   $email = stripslashes($email);
    $pass = stripslashes($pass);
   $email = strip_tags($email);
   $pass = strip_tags($pass);
   
if ((!$email) || (!$pass)) {
   $errorMsg = '<font color="#FF0000">Please fill in both fields</font>';
}else {
   include 'scripts/connect_db.php';
   $email = mysql_real_escape_string ($email);
   $pass = md5($pass);
   
   $sql = mysql_query("SELECT * FROM members WHERE email='$email' AND password='$pass'");
   
   $log_check = mysql_num_rows($sql);
   
if ($log_check > 0) {
    while($row = mysql_fetch_array($sql)) {
      
      $id = $row["id"];
      $_SESSION['id'];
      $email = $row["email"];
      $_SESSION['email'];
      $username = $row["username"];
      $_session['username'];
      
      mysql_query("UPDATE members SET last_logged=now() WHERE id='$id' LIMIT 1");
      
   }//Close while loop
   echo "You are logged in";
             exit();
}
else {
   $errorMsg = '<font color="#FF0000">Incorrect login data, please try again</font>';
}


     }
}
?>



and the form:

<?php echo $errorMsg; ?>
<form action="log_in.php" method="post">
Email:<br />
<input name="email" type="text" /><br /><br />
Password:<br />
<input name="password" type="password" /><br /><br />
<input name="myBtn" type="submit" value="Log In" />
</form>

Hi can someone pls help, im tryin a tutorial but keep getting errors, this is the first one i get after registering.

You Are Registered And Can Now Login
Warning: Cannot modify header information - headers already sent by (output started at /home/aretheyh/public_html/nealeweb.com/regcheck.php:43) in /home/aretheyh/public_html/nealeweb.com/regcheck.php on line 46

Code: [Select]
<?php
//ob_start();
include "../connect.php";
Header('Cache-Control: no-cache');
Header('Pragma: no-cache');




$UserId=$_POST['UserId'];
$UserId = stripslashes($UserId);
$UserId = mysql_real_escape_string($UserId);
 
$UserName=$_POST['UserName'];
$UserName = stripslashes($UserName);
$UserName = mysql_real_escape_string($UserName);

$UserFirstName=$_POST['UserFirstName']; 
$UserFirstName = stripslashes($UserFirstName);
$UserFirstName = mysql_real_escape_string($UserFirstName); 

$UserLastName=$_POST['UserLastName']; 
$UserLastName = stripslashes($UserLastName);
$UserLastName = mysql_real_escape_string($UserLastName);

$UserGender=$_POST['UserGender']; 
$UserGender = stripslashes($UserGender);
$UserGender = mysql_real_escape_string($UserGender);

$UserLink=$_POST['UserLink']; 
$UserLink = stripslashes($UserLink);
$UserLink = mysql_real_escape_string($UserLink);

$UserPicture=$_POST['UserPicture']; 
$UserPicture = stripslashes($UserPicture);
$UserPicture = mysql_real_escape_string($UserPicture);





$sql="SELECT * FROM Fb_Profile WHERE UserId='$UserId' and UserName ='$UserName' and UserFirstName ='$UserFirstName' and UserLastName ='$UserLastName' and UserGender ='$UserGender' and UserLink ='$UserLink' and UserPicture ='$UserPicture'";

$result=mysql_query($sql);

$count=mysql_num_rows($result);
//Lets add a first time active check 0 or 1 if 1 skip and check for update<br />
if($UserId == 'undefined')
{
return true;
}
if($count==1)
{

echo "&msgText=Facebook MySql Copy Successfully!\n";



return false;
}


else
{
echo "&msgText=Invalid Login!\n";
//THIS HERE IS WHAT I AM HAVING A PROBLEM WITH, IF STATEMENT STATING THAT IF $UserId IS EMPTY AND THE OTHER VARIABLES RETURN NOTHING BUT IF IS HAS A VALUE IT INSERTS
//IF(!empty $UserId)
$FB_Profile_Copy = mysql_query("INSERT INTO Fb_Profile(UserId,UserName,FirstName,LastName,Gender,Link,Picture) VALUES('$UserId','$UserName','$UserFirstName','$UserLastName','$UserGender','$UserLink','$UserPicture')");
$FB_BackGround_Copy = mysql_query("INSERT INTO Fb_BackGround(UserId) VALUES('$UserId')");
return false;
}
?>

Code: [Select]
<?php 
if ( $_SERVER['HTTP_REFERER'] == "http://domain.net/sub/index.php" ) {
echo "true";
} else {
echo "false";
}
?>
is the code i'm using. /sub/index.php redirects to http://domain.net/index.php
it's not seeming to work. please help sort out this bug.

Please .i want php code to get metacfe thumbnail from url
this is the url
http://www.metacafe.com/watch/5823413/the_sinister_eyes_of_dr_orloff_movie_trailer/

php code to grab 5823413

for thumbnail links this

http://www.metacafe.com/thumb/5823413.jpg

I think I'm using simple xml wrong

I'm trying to read strings of xml and get it to list the "attributes" in the strings but it's not working. 

How would I read and list the attributes of this string
<Address><to>Joshua</to><from>Rockhampton</from><country>Australia</county></Address>

It needs to out put a string that can be printed and look like (or something like)

to:Joshua
from:Rockhampton
country:Australia

All my code produces errors and the page just goes blank and I don't know what is wrong.l 

Hi Guys   I'm updating my website and I'm stumped on the last section.

I have a dynamic Table with various fields showing from Mysql, I use MS Access as a front end, and I have a field named Download, I enter the file location of a customers invoice and it stores the link in mysql, works perfectly. BUT, the dynamic table looks like this:

Download - \users\MM4512\Invoices\Invoice23.PDF which is hyperlinked so they can download it etc.. Is there a way I can change this section from the above to a simple (Download Invoice) instead of all that text?

The code used is :
 

<td><a href="<?php echo $row_Invoices['download']; ?>" target="_blank"><?php echo $row_Invoices['download']; ?></a></td>

I am trying to write a PHP page that takes an XML file stored on an external server, parses it, and rewrites the data to a new XML file formatted to my liking.  The feed is for events and has about 250 events to parse.  The problem is that if one event has an empty node, the script will use the same event data for the node used previously.  Upon research, I see that empty nodes are parsed as an empty SimpleXMLElement Object. See my code for example:

XML Original:
Code: [Select]
<event_info>
<event id="1222209">
                <outcome_score><![CDATA[L, 1-0 (OT)]]></outcome_score>
<quotes></quotes>
<radio>102.9 FM</radio>
<sched_opp><![CDATA[Toledo]]></sched_opp>
        </event>
<event id="1222210">
                <outcome_score><![CDATA[]]></outcome_score>
<quotes></quotes>
<radio>107.1 FM</radio>
<sched_opp><![CDATA[Ohio]]></sched_opp>
        </event>
</event_info>

Output XML (note <outcome_score> on second event):
Code: [Select]
<event_info>
<event id="1222209">
                <outcome_score><![CDATA[L, 1-0 (OT)]]></outcome_score>
<quotes></quotes>
<radio>102.9 FM</radio>
<sched_opp><![CDATA[Toledo]]></sched_opp>
        </event>
<event id="1222210">
                <outcome_score><![CDATA[L, 1-0 (OT)]]></outcome_score>
<quotes></quotes>
<radio>107.1 FM</radio>
<sched_opp><![CDATA[Ohio]]></sched_opp>
        </event>
</event_info>


PHP code:

$xml = simplexml_load_file($source);
echo "<event_info>"; 
foreach($xml->event as $event) {
        echo "<event>";
        if($event->outcome_score != '') { echo "<outcome_score><!CDATA[{$event->outcome_score]]></outcome_score>"; }
        if($event->quotes != '') { echo "<quotes><!CDATA[{$event->quotes]]></quotes>"; }
}
        if($event->radio != '') { echo "<radio><!CDATA[{$event->radio]]></radio>"; }
        if($event->sched_opp != '') { echo "<sched_opp><!CDATA[{$event->sched_opp]]></sched_opp>"; }
        echo "</event>";
}
echo "</event_info>";


Basically, whenever an event has no outcome score, the most recent outcome score is repeated for all events after.  Any help would be greatly appreciated!  Thanks!

Im trying to parse this xml but i can get it to output a simple string, can someone see what im doing wrong??

Code: [Select]
$str = "<channel><item>
<id>cb-uA4QHmpDxYdpgW1jPwiYsUwjBViwlinS</id>
<title>Rules of Engagement - Play Ball Extended Preview - Season 5 - Episode 12</title>
</item>
</channel>";


$n_data = new SimpleXmlElement($str, LIBXML_NOCDATA);
foreach ($n_data->channel->item as $d) {
$vid = $d->id;
$title = $d->title;

print_r($d->title); //testing
die(); //testing
$arr2[] = array('vid' => $vid, 'title' => $title, 'site_id' => 10 ,'time' => 456);
}
The print_r() returns
Code: [Select]
SimpleXMLElement Object
(
    [0] => Rules of Engagement - Play Ball Extended Preview - Season 5 - Episode 12
)
If i simply echo $d->title it returns a string, but i need to reapply $d->title to another array as shown above

Hello, i am newbie at PHP codes and i need help little! How to limit of chars of song? I uploaud an images and post php code!

$fp_data = ereg_replace("^.*<body>","",$fp_data); 
$fp_data = ereg_replace("</body>.*","",$fp_data); 

list($currentlisteners,$status,$peak,$max,$reported,$bit,$song) = explode(",", $fp_data, 7);

if($showsong == '1')
{
$stationinfo = '   '.$currentsong.' '.$song.'  ';
}

if($showlisteners == '1')
{
$stationinfo = $stationinfo.'   '.$currentlisteners.' of '.$peak.' '.$listenerlabel.'  ';
}
}
}


// Include the layout for display
require(JModuleHelper::getLayoutPath('mod_ngs_shoutcast'));
 ?>

Thank you!

Have tried to do this myself all day now and i`m getting a little frustrated now.

I have a contact form with a select box which can have multiple options selected, i`m using formmail.php to process the info. Problem is I have forgot how to list the values within the array and format them within the email body.

$licences is the multiple select box

any help would be gratefully received!!
 
Code: [Select]
<?php
  $name=addslashes($_POST['name']);
  $email=addslashes($_POST['email']);
  $town=addslashes($_POST['town']);
  $phone=addslashes($_POST['phone']);
  $licences=addslashes($_POST['licences']);
  $message=addslashes($_POST['message']);

 // you can specify which email you want your contact form to be emailed to here

  $toemail = "admin@mysite.com";
  $subject = "Question : mysite.com";

  $headers = "MIME-Version: 1.0\n"
            ."From: \"".$name."\" <".$email.">\n"
            ."Content-type: text/html; charset=iso-8859-1\n";

  $body = "Name: ".$name."<br>\n"
            ."Email: ".$email."<br>\n"
            ."Town/City: ".$town."<br>\n"
            ."Phone: ".$phone."<br>\n"
            ."Interested in Licence/s: ".$licences."<br>\n"
            ."Message:<br>\n"
            .$message;

  if (!ereg("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$", $email))
  {
    echo "That is not a valid email address.  Please return to the"
           ." previous page and try again.";
    exit;
  }

    mail($toemail, $subject, $body, $headers);
    echo "Thanks for submitting your message.";
?>

Hello EXPERTS ,

i want to Frame many pages of same code so how to do it from one page

example 1 =
 www.abcd.com/Frame1.html [has the code given below in it]
<iframe src="http://abcdsecond.com/Frame1.html" border="0" framespacing="0" marginheight="0" marginwidth="0" vspace="0" hspace="0" frameborder="0" height="100%" scrolling="yes" width="100%"></iframe>

www.abcd.com/Frame2.html [has the code given below in it]

<iframe src="http://abcdsecond.com/Frame2.html" border="0" framespacing="0" marginheight="0" marginwidth="0" vspace="0" hspace="0" frameborder="0" height="100%" scrolling="yes" width="100%"></iframe>

and so on , so is it possible to create one php script in www.abcd.com so when abcd.com/Frame1.html or Frame2.html or Frame3.html is run it will run this code
<iframe src="http://abcdsecond.com/Frame1.html" border="0" framespacing="0" marginheight="0" marginwidth="0" vspace="0" hspace="0" frameborder="0" height="100%" scrolling="yes" width="100%"></iframe>
<iframe src="http://abcdsecond.com/Frame2.html" border="0" framespacing="0" marginheight="0" marginwidth="0" vspace="0" hspace="0" frameborder="0" height="100%" scrolling="yes" width="100%"></iframe>
<iframe src="http://abcdsecond.com/Frame3.html" border="0" framespacing="0" marginheight="0" marginwidth="0" vspace="0" hspace="0" frameborder="0" height="100%" scrolling="yes" width="100%"></iframe>

would appreciate help

Hey Again;

trying to have the code select the top 5 players bases on exper field in the DB

'SELECT * from players WHERE exper = '';

My friend has this problem, it needs a solution. I have no PHP experience, I don't know how to work with MD5 hash. A programming unit was compulsory on her course, but she completely fails on it. So let's be unethical and help her survive it.

thanks in advance

=====================

You are the website administrator for a website that requires a low level password
for entry. The previous owner of the website forget to code in a password recovery feature
and as such you now have to recover the passwords for a number of users of the website.

You do have acess to the website databse BUT you are NOT allowed to manually change the
passswords for users in the database as those passwords are heavily used in defining
what permissions a user of the website has. e.g Moderators for the website forum all have a password begining with the lower case letter "m" in lower case. ALL letters are lowercase.

Passwords were allocated to all users and the method of choice was to create a password which was built on two parts - a lowercase letter "m" and a number between 1 and 10000. An md5 hash was then created to form a 32 digit string.

e.g the user with password

"m1234" is represented in the database as the md5 hash: 77c12394ef7d4f23a8fa07d87309afd9

You have five users who need their orignal password. You know that the passwords all
start with the letter "m". You decide that the simplest thing to do is to write some PHP
code that uses a while loop to increment through the numbers 0 to 10000, concatenate that number with the "m" and then compare the md5 hash to that you recovered from the database. If the two hashes are the same then you have "cracked" the password.

This technique is known as a "brute force" method of cracking passwords.

You have a number of hashes to "crack" and you must enter the unique password into the answer box for each.

As a starting point, the following PHP snippet will produce all of the lowercase letters:
___________________________________

Code: [Select]
for ($i=97; $i<=122; $i++){
$x = chr($i);
echo $x;
}
?>