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);
?> 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;
