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
No comments posted yet
Your Answer:
Login to answer
124
24
Other forums
How do I use a global footer..?
If my index.php has a bole bunch of if functions and exit's in them
Pagination won't carry results past page 2.
Hi all,
I've worked out my pagination script and its paginating fine until I click next from
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s
php/mysql problem
Hey all,
Problem: im trying to setup a shop where people can use a drop-down list to select t
Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but
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
Help with explandable category tree
I have the below query:
SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.categ
$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown
EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t
Loosing changed contents when used FM REUSE_ALV_GRID_DISPLAY
Hi,
I have used FM REUSE_ALV_GRID_DISPLAY in my program as below.
CALL FUNCT