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

Parse multirow HTML table
Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB

Email to a friend script problems
I have this send-to-a-friend script with 2 issues:


1) When you open the form popup on a p

PHP referral database. I would like this form to email the referrer.
Okay, Hello I've been trolling for years. This the first time I've ever asked for php help. Normally

Strange PHP/mySQL error ... am I just tired?
Code: <?

## CONNECT TO DB FUNCTION!
function ConnectTo($db2con)
{
$hostNam

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

db entry based on primary key
My "topics" table contains 10 entires
*--------------*
topicid topic
------

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

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

Implementing Single Sign-On using SAML 1.1, x.509, LDAP in C#.net
Hi, I got a requirement from the client i.e implementing single sing on using SAML 1.1( LDAP &