PHP - Constructive Criticism On Parsing Text?

As a long time CodeIgniter user, I made the decision to move away from CodeIgniter a while back. I still maintain, and in some cases develop new features for websites that I made using CodeIgniter.   Still somewhat active in the CodeIgniter forum, I have seen a recent question, "How do we get CodeIgniter back to the PHP framework of choice?". I have offered my own criticism of the framework, but the thread is located on the CodeIgniter forum, so many just protect their beloved CI, not willing to accept that it is in great need of change.   I would appreciate if phpfreaks members would be critical, and hopefully specific in regards to CodeIgniter's problems. I intend to link to this thread, with the hopes that your opinions will help future development of CodeIgniter. Thank you.

All criticism/suggestions/improvements appreciated

Registration.php
Code: [Select]
<?php
$con = mysql_connect("localhost","","") or die(mysql_error());
mysql_select_db('Users');

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password == $cookie_results['Password']) {
echo "<div id=\"login_msg\">You are already logged on. Redirecting...</div><br />" && header("location:/index.php");
}
}

if(isset($_POST['submit'])) {
$Username = mysql_real_escape_string(filter_input(INPUT_POST, 'Username', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Email = mysql_real_escape_string(filter_input(INPUT_POST, 'Email', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Password = sha1($_POST['Password']);
$Password2 = sha1($_POST['Password2']);

if (!$Username | !$Email | !$Password | !$Passord2) {
echo "<div id=\"error_msg\">You did not complete all of the required fields, please try again.</div><br />";
}

if ($Password != $Password2) {
echo "<div id=\"error_msg\">Your passwords do not match, please try again.</div><br />";
}

$check_username = mysql_query("SELECT * FROM Users WHERE (Username = $Username)");
$result_username = mysql_fetch_row($check_username);
$check_email = mysql_query("SELECT * FROM Users WHERE (Email = $Email)");
$result_email = mysql_fetch_row($check_email);

if ($result_username == true) {
echo "<div id=\"error_msg\">The Username: '$Username', already exists. Please enter another username.</div><br />";
}

if ($result_email == true) {
echo "<div id=\"error_msg\">The Email Adress: '$Email', is already in our Database.</div><br />";
}

$sql = "INSERT INTO Users (Id, Username, Email, Password) VALUES ('', '$Username','$Email','$Password')";
$add_member = mysql_query($sql) or die(mysql_error());

if (mysql_query($add_member)) {
$week = time() + 604800; 
setcookie(ID_, $_POST['Username'], $week); 
setcookie(Key_, $_POST['Password'], $week);
echo "<div id=\"login_msg\">Successfully added to our Database.</div><br />"  &&  header ("location:/Login.php"); 
}

else {
echo "<div id=\"error_msg\">Invalid input.</div><br />"; 
}
}
?>

Login.php
Code: [Select]
<?php
include("db.php");

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password == $cookie_results['Password']) {
echo "<div id=\"login_msg\">You are already logged on. Redirecting...</div><br />" && header("location:/index.php");
}
}

if(isset($_POST['submit'])) { 
$Username = mysql_real_escape_string(filter_input(INPUT_POST, 'Username', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$Password = sha1($_POST['Password']);

if (!$Username | !$Password) {
echo "<div id=\"error_msg\">You did not complete all of the required fields, please try again.</div><br />";
}

$sql = "SELECT * FROM Users WHERE (Username, Password) = ('$Username', '$Password')";
$db_check = mysql_num_rows($sql) or die(mysql_error());

if (mysql_query($db_check)) {
$week = time() + 604800; 
setcookie(ID_, $cookie_username, $week); 
setcookie(Key_, $cookie_password, $week);
echo "<div id=\"login_msg\">Successfully Logged In.</div><br />"  &&  header ("location:/index.php");
}

elseif (($Username | $Password) != $db_check) {
echo "<div id=\"error_msg\">Invalid username or password, please try again.</div><br />";
}
}
?>

Logout.php
Code: [Select]
<?php
include("db.php");

if(isset($_COOKIE['ID_my_site'])) {
$cookie_username = mysql_real_escape_string(filter_input(INPUT_COOKIE, 'ID_', FILTER_SANITIZE_FULL_SPECIAL_CHARS));
$cookie_password = sha1($_COOKIE['Key_']);
$cookie_check = mysql_query("SELECT * FROM Users WHERE username = '$cookie_username'") or die(mysql_error());
$cookie_results = mysql_fetch_array($cookie_check);

if ($cookie_password != $cookie_results['Password']) {
header("location:/login.php");
}
else {
$past = time() - 604800; 
setcookie(ID_, gone, $past); 
setcookie(Key_, gone, $past); 
echo "<div id=\"error_msg\">Sucessfully logged out. Good Bye!</div><br />" && header ("location:/login.php");
}
} 

?>

I'm trying to create a video system, and I have everything set, except the input, it integrates with youtube and I need to convert a link such as:
>http://youtu.be/ty62YzGryU4<
or
>http://www.youtube.com/watch?v=ty62YzGryU4<
into: ty62YzGryU4
I have looked into all of the commands and I don't really understand how to get them to work properly, Do any of you know how to do this?

Hi to all!! I am still new to php.. I need help in reading my text file and inserting it to mysql database.
My text file contains 5 fields and has several rows..
The format of my text file:

1 romeo 8877 2010-07-07 abc1
2 nick 7686 2010-07-07 abc2
3 mark 5456 2010-07-07 abc3
4 karm 3432 2010-07-07 abc4

The first field is an INTEGER, the second third fifth fields are VARCHAR and the fourth field is a DATE.
I am having trouble with my php code..
My code is this:

<?php
 mysql_connect("localhost","root","");
    mysql_select_db("personss");

$textFileName = $_POST['textFileName'];

    $myFile = "$textFileName";
    $fh = fopen($myFile, 'r');
    $theData = fread($fh, filesize($myFile));
    fclose($fh);
   
    $person = explode("\n", $theData);
    $count = 0;

foreach($person as $i => $line) {
    $nameParts = explode(" ", $person[$count]);

       
        $q = "insert into logged (id, name, num, datess, letters) values ('" . implode("','",$nameParts) . "')";
        $rw = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());
   
}
?>

This code can insert to the database but it only inserts the first row and it loops the insert according to how many rows there are in the text file..For example in my text file there are are 4 rows, it inserts the first row: 1 romeo 8877 2010-07-07 abc1 4times..If there are 6 rows, 6 times the first row will also be inserted..

What i need Sir's is that i need to be able to insert the rows line by line.. if there are 4 rows, i need to insert them all in the database.. Please help me to fix the code.