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

Displaying different page content, depending on the logged in user.
Hi all, I am new to ASP.net (and web development in general), and have a question about how I can di

Multidimensional Array into an Html table, help!
Hello all, I am new to HTML/PHP so any help would be great.

I have a multidimensional array f

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi

Suggestions for Functional module
Hello experts,
I Have done B.Sc(Mathematics) and MCA & have learnt SAP/ABAP but do n

i need help with php header and footer
I have designed a header and footer for my site and they seem to be ok when they are running individ

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

generating all possible random letters
hi'

how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the res

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items