A Few Questions

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcut" system on my website, where users can add shortcuts from pages by clicking the link and it will write the URL and the users ID into the database, the only problem I don't know how PHP can grab the URL of the page?

2) I can't seem to get cookies working on my site:

Code: //get the posted values
$email1=($_POST['user_name']);
$email=htmlspecialchars($_POST['user_name'],ENT_QUOTES);
$pass=sha1($_POST['password']);
$post_autologin=($_POST['checkbox']);

//MYSQL
$abc = mysql_query("SELECT * FROM accounts WHERE email='".$email1."'") or die(mysql_error());
$a = mysql_fetch_array($abc);

//Select whatever..
$sql="SELECT user_id, email, password FROM accounts WHERE email='".$email."'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$userid = $a['user_id'];
$displayname = $a['display_name'];

$_SESSION['user_id']=$userid;
$_SESSION['email']=$email;

//if username exists
if(mysql_num_rows($result)>0)
{
//compare the password
if(strcmp($row['password'],$pass)==0)
{
echo "yes";
if($post_autologin == YES)
{
$password_hash = sha1($pass); // will result in a 32 characters hash

setcookie ($cookie_name, 'usr='.$email.'&hash='.$pass, time() + $cookie_time);
}
$_SESSION['user_id']=$userid;
$_SESSION['email']=$email;
$_SESSION['dname']=$displayname;

}
else
echo "no";
}
else
echo "no"; //Invalid Login


?>
Is this correct? Its a Ajax login I found but when I check the checkbox and close the browser it logs me out.. I use $_SESSION['user_id] in places where I want stuff to show for logged in users, where do I put $_COOKIE['user_id']???

http://mymediaupload.com/media.php?v=130 if you look on this page and click "More by Cheryl Cole" it shows the current song, how would I get it to view the rest of the songs by that artist and not the one thats playing?

This is what I have..

Code: if($_GET['morelikethis'])
{
$name2 = mysql_real_escape_string($_GET['morelikethis']);
$s = mysql_query("SELECT * FROM music WHERE musicartist LIKE '".$name2."%' ORDER BY `musicartist` ASC LIMIT 0,6") or die(mysql_error());
$t = mysql_query("SELECT * FROM music WHERE musicartist LIKE '".$name2."%' ORDER BY `musicartist` ASC") or die(mysql_error());
$u = mysql_query("SELECT * FROM music WHERE musicartist LIKE '".$name2."%' ORDER BY `musicartist` ASC LIMIT 1,5") or die(mysql_error());
$len = 19;

while($x = mysql_fetch_array($s))
{
$q3 = mysql_query("SELECT * FROM accounts WHERE user_id = ".$x['musicuploaderid']."") or die(mysql_error());
$q4 = mysql_fetch_array($q3);
echo "<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="40"><img src="".$x['musicalbumart']."" height="40" width="40"></td><td width="5"></td>";
echo "<td align="left" valign="top"><a target="_top" title="".$x['musictitle']." - ".$x['musicartist']."" href="media.php?v=".$x['musicid']."">";
echo (strlen($x['musictitle']) > $len ? substr($x['musictitle'], 0, $len).".." : $x['musictitle']);
echo "
";
echo (strlen($x['musicartist']) > $len ? substr($x['musicartist'], 0, $len).".." : $x['musicartist']);
echo "</a>
<a target="_top" title="Click here to go to ".$q4['display_name']."'s Station" href="stations.php?s=".$q4['user_id']."">".$q4['display_name']."</a>";
echo "</div></td>
</tr>
</table>";
echo "
<hr noshade color="#c0c0c0">
";
}
if(mysql_num_rows($t)<=0)
{

echo "<div id="content">There is no results</div>";

}
if(mysql_num_rows($t)>=6)
{
echo "<table width="90%" align="center"><tr><td><div id="sub4">More..</div></td></tr></table>";
}
}
Thanks

Your Answer:

Login to answer

Other forums

my two tables
table1 : col1 = topicid , col2 = topic

table2 : col1 = sentid, col2 = sentence

Cod

Securing a user input - need some confirmation
Hello All,

I am in the process of recoding a large proportion of an e-commerce site, one of t

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

echo $rows help
Hi all,

Hopefully something simple that I don't know!

I have this:

Code: [Selec

LIMIT $start, 10... how to pass last value queried into next page with GET??
Ok I know how to display the first or last 10 results of a query...

$result = mysql_query(&q

insert Multiple rows into the table from that table data
Hi All,

I have a requirement like to insert mulitple rows into the table from that

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in