PHP - To Obtain Image Info

Hey guys,

It's been awhile since I've coded in PHP and I can not for the life of me remember how to do this.

Say I have http://www.example.com/search.php?name=joe&size=small

What the PHP code to grab the ?name=joe&size=small    part?

thanks

Very simple question. I have a table with courses and a table with students registered for those courses. I have a page where I can change the course name. What I want to do is, when changing the course name in the course table, I want all students in the students table who are already registered for that course to have that course name updated as well in the student table.

 I'm currently using a field cid to update the courses in the course table however, the student table doesn't have a cid field rather a cname ( course name) which I want to use to update the fields in the student table.

 Is it possible to use
Code: [Select]
<a href=\"editcourse.php?cid=" for more than one field of info? i.e transfer the cid + cname and so you can use $_GET[cid]"; and $_GET[cname]"; ?

Something like this maybe ( dont know how the code will go) "editcourse.php?cid=&cname=" ?

Do I have the right idea for how to go about this?

In my script, users login with their Username & Password. However, I'd like to be able to echo the email address used on their account. I've tried adding the email to the session
I'm not having much luck... Here's a piece of the login code(untouched);

                $username = $_POST['name'];
                $passwd = $_POST['passwd'];
                $query = "SELECT name,passwd FROM users WHERE CONCAT('0x', hex(passwd)) = '{$salt}'";
		$result = mysql_query($query);
		$login_ok = false;
		if(mysql_num_rows($result) > 0) {
		    $login_ok = true;
		}
		if($login_ok)
		{
		    $row = mysql_fetch_array($result, MYSQL_NUM);
		    $_SESSION['user'] = $row;

I've also tried messing around with this piece below in a few different ways but still nothing.

<?php echo htmlentities($_SESSION['user']['email'], ENT_QUOTES, 'UTF-8'); ?>

Any help is greatly appreciated..

Hi all, Ive latly coded a option for my website which allowes users to send money. Ive finished coding it but when I press the submit button the money dont get sent to the other user it just puts it in the url bar.

Example: http://********.com/newbank.php?touser=Test&sendmoney=1000000000&sendmoney=Send+Money!


<?php
session_start();

include ("includes/db_connect.php");
include ("includes/functions.php");
logincheck();

$username = $_SESSION['username'];

// Fetch users stuff..

$fetch_u = mysql_query("SELECT * FROM users WHERE username='$username'") or die (mysql_error());
           $fetch_users = mysql_fetch_object($fetch_u);
           
// Fetch bank stuff..

$fetch_b = mysql_query("SELECT * FROM bank") or die (mysql_error());
           $fetch_bank = mysql_fetch_object($fetch_b);
           
// User sending money..

if ($_POST['sendmoney']){
 $send_money = strip_tags($_POST['ammount']);
 $to_user = strip_tags($_POST['touser']);

 if (!$to_user){
   echo ("You must enter a username.");
 }elseif ($to_user){

 $user_real = mysql_num_rows(mysql_query("SELECT * FROM users WHERE username = '$to_user'")) or die (mysql_error());
 
 if ($user_real == 0){
   echo ("No such user!");
 }elseif ($user_real != 0){

         if ($send_money > "0"){
           if ($send_money == 0 || !$send_money || ereg('[^0-9]',$send_money)){
              echo ("You carnt send that type of money");
           }elseif ($send_amount != 0 || $send_amount || !ereg('[^0-9]',$send_amount)){

           if ($send_money > $fetch->money){
             echo ("You havent got that much money");
           }elseif ($send_money <= $fetch->money){
             
             // Try sending money to yourself
             
             if (strtolower($to_user) == strtolower($username)){
               echo ("You cannot send money to yourself");
             }elseif (strtolower($to_user) != strtolower($username)){
               
           $to_person = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$to_user'"));
           
           $otherusercash = $send_money;
           $otheruser = $to_user->money + $otherusercash;
           
            mysql_query("UPDATE users SET money = money-$send_money WHERE username='$username'");
        mysql_query("UPDATE users SET money = '$otheruser' WHERE username='$to_person'");
        
        $time = gmdate('Y-m-d h:i:s');
                          mysql_query("INSERT INTO `transfers` ( `id` , `to` , `from` , `amount` , `date` )
                            VALUES ('', '$to_person', '$username', '$send_amount', '$time')") or die (mysql_error());
                            
echo "Money Sent!";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=newbank.php\">";
 }
 }
 }
 }
 }
 }
 }
?>

<html>
<head>
<link rel="stylesheet" href="includes/in.css" type="text/css">

<style type="text/css">
.infobg {
font-family: Arial;
font-weight:normal;
font-size:12px;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
background: URL(textbg1.png);
font-weight:300;
}

.button {
font-size: 12px;
background:url(button.png);
vertical-align: middle;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
color: #FFFFCC;
height:23px;
font-weight:300;
border-radius: 10px;
padding-bottom:2px;
}

</style>
<title>Running-Mafia || Send Money</title>
</head>
<body>
<form action='' name='form1'>
<table width='50%' border='1' bordercolor='#000000' align='center' bgcolor='#808080' cellpadding='0' cellspacing='0' style='border-collapse: collapse'>
<tr>
<td colspan='2' background='header.jpg' align='center'>Send Money</td>
</tr>
<tr>
<td>
Username:
</td>
<td>
<input type='text' name='touser' class='infobg' id='touser'>
</td>
</tr>
<tr>
<td>
Ammout:
</td>
<td>
<input name="sendmoney" class='infobg' type="text" id="send_money">
</td>
</tr>
<tr>
<td>
&nbsp;
</td>
<td>
<input class="button" name="sendmoney" type="submit" id="sendmoney" value="Send Money!">
</td>
</tr>
</table>
</form>
</body>
</html>


Anyone see why its not sending the money?

Thanks.

Ok so for some reasons on my register and edit profile page when i hit submit it says that i have not filled in all the info i need.. Even after i fill all of them in..

but heres the code for the register form..

Code: [Select]
<?php require("top.php"); ?>
<div id='homeright'>
<?php


echo "<font size='6'>Sign up</font>";

echo "<hr width='75%' align='left'/>";
$form = "<form action='index.php' method='post'>
<table cellspacing='5px'>



<tr>
<td>First Name:</td>
<td class='register'><input type='text' name='firstname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Last Name:</td>
<td><input type='text' name='lastname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Username:</td>
<td><input type='text' name='username' class='textbox' size='35'></td>
</tr>

<tr>
<td>E-mail:</td>
<td><input type='text' name='email' class='textbox' size='35'></td>
</tr>

<tr>
<td>Password:</td>
<td><input type='password' name='password' class='textbox' size='35'></td>
</tr>

<tr>
<td>Confirm Password:</td>
<td><input type='password' name='repassword' class='textbox' size='35'></td>
</tr>

<tr>
<td></td>
<td><input type='submit' name='submitbtn' value='Register' class='button'></td>
</tr>
</table>

</form>";


if ($_POST['submitbtn']){


$firstname = fixtext($_POST['firstname']);
$lastname = fixtext($_POST['lastname']);
$username = fixtext($_POST['username']);
$email = fixtext($_POST['email']);
$password = fixtext($_POST['password']);
$repassword = fixtext($_POST['repassword']);
$website = fixtext($_POST['website']);
$youtube = fixtext($_POST['youtube']);
$bio = fixtext($_POST['bio']);

$name = $_FILES['avatar'] ['name'];
$type = $_FILES['avatar'] ['type'];
$size = $_FILES['avatar'] ['size'];
$tmpname = $_FILES['avatar']['tmpname'];
$ext = substr($name, strrpos($name, '.'));

if ($firstname && $lastname && $username && $email && $password && $repassword){
if ($password == $repassword){
if (strstr($email, "@") && strstr($email, ".") && strlen($email) >= 6){

require("scripts/connect.php");
/*$query = mysql_query("SELECT * FROM users WHERE username='$username' ");*/
$query=mysql_query("SELECT * FROM users WHERE username='$username' ") or die(mysql_error());
$numrows = mysql_num_rows($query);
if ($numrows == 0){

/*$query=mysql_query("SELECT * FROM users WHERE email='$email' ");*/
$query=mysql_query("SELECT * FROM users WHERE email='$email' ") or die(mysql_error());
$numrows=mysql_num_rows($query);
if ($numrows == 0){

$pass = md5(md5($password));
$date = date("F d, Y");

if($name){
move_uploaded_file($tmpname, "avatars/$username.$ext");
$avatar = "$username.$ext";
}
else
$avatar = "/avatars/default_avatar.png";

$code = substr (md5(rand(11111111111, 999999999999999)), 2,  25);

 
mysql_query("INSERT INTO users (`first_name`,`last_name`,`username`,`email`,`password`,`avatar`,`bio`,`website`,`youtube`,`last_login`,`active`,`code`,`locked`,`date`) VALUES ( '$firstname', '$lastname', '$username', '$email', '$pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");

/*mysql_query("INSERT INTO users (Field, Type) VALUES ('', '$firstname', '$lastname', '$username', '$email', 'pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");*/

$webmaster = "Admin@trucksite.com";
$subject = "Activate Your Account!";
$headers = "From: Admin <$webmaster>";
$message = "Hello $firstname.\n\nWelcome to trucksite below is a link for you to activate your account!.\n http://tprofiletesting.net23.net/activate.php?code=$code";

mail($email, $subject, $message, $headers);
echo "Your activation email has been sent to <b>$email</b>.";
}
else
echo "That email is currently in use.";

}
else
echo "That username is currently in use.";
}
else
echo "You did not enter a vaild email.";
}
else
echo "Your passwords did not match.";
}
else
echo"You did not fill in all the required fields.";
}
echo "$form";


?>

</div>
<div id='homeleft'>
<center><font size='6'>Create! Showoff! Educate!</font></center>
<hr />

</div>
</body>
</html>

Hi.  I have built a form on a page call join.php  On this form I pass a variable in this manner;

 $url = "thankyou.php?val_id=".$validation."";        
header("Location: {$url}");  

So on the next page (which is the thankyou for registering page I want this page on load to find the user from the $validation and then email the user.  I have done this many times but for some reason this time the output is "No database selected!"  There really is though.  Also I can see in the browser window the code I have passed so its not like that is not working!  Here is the code,  can anyone see my error because I just have no idea whats up!


<?php  include(thedatabase.php'); 
session_start(); 

 $val_id = $_GET['val_id'];
 $FullRec__query=sprintf("SELECT * FROM users WHERE val_id= %s", $val_id);
 $FullRec = mysql_query($FullRec__query) or die(mysql_error());
 $userInfo = mysql_fetch_array($FullRec);

  
  $user = $userInfo['username'];
  
  
  mail($userInfo['email'],"Validation Link From Us","Dear ".$userInfo['username'].",\n\nThank you for signing up to www.thesite.co.uk. Please find below you validation link to gain access to the site.\n\n  link:\nhttp://www.thesite.co.uk/val_entrance.php?validation_id=" . $_GET['val_id'] . "\n\nTeam site\n\n\n\nFor a full list of terms and conditions please go to the main area on your page and click the terms at the bottom of the page!");
?>

Hello Guys...
I'm new to php & mySQL... I need help... Need something to know... please help me...
I'm using ubuntu 11.10, Aptana Studio 3, xampp 1.7.7.
Also i'm using windows 7, notepad++ & wamp.
When I visit "localhost" on my firefox. I saw a xampp or wamp welcome page. The name of the file is "index.php".

1. I need to know can I delete this file ? Bcoz i'm working on another file but it's the same file name.

2. When I upload my site on host like hostgator. How do i edit my live site? And preview it.

3. How do i store my post on database ? Like fb status update, blogger post or forum post

I wanna write a site that i can post something without using html <p></p>. The main problem when i need to post something then everytime I need to edit the source code. Example:<p>some text here</p>.

I don't wanna edit source everytime.

Another Ques: Is Aptana Studio and notepad++ enough to write a site or I need another tool ?

Any book suggestion ?

please guys help me i'm new to php & mySQL..

let's say I have 100,000 users on my forum

i want to cache there PROFILE INFO (About me) in .php files

which is easy/etc but would that be more space than 100k rows in a db table, or 100k .php files?

just wondering,

prob a stupid question but

atm I cache some lottery info and some other stuff, but that's only 1 .php

it would be dumb to cache info and have 100k .php's for each user ID right?

or maybe story it all in 1 .php? would be a HUGE Filesize? rather just keep the data in MYSQL right?

Hi Experts,

How can I check whether I have FSOCKOPEN support from phpinfo() page?

Thanks,

For some odd reason, my MySQL array is not returning any data. I echo'd the query and it is correct, I looked at the database and that row is in there, but when I print_r the array, nothing. Here is the code.

$infoquery = "SELECT * FROM '$endotype' WHERE ID = '$typeid' ORDER BY ID DESC LIMIT 1";
$info = mysql_query($infoquery);
echo $infoquery;
$infoout = mysql_fetch_array($info);
print_r($infoout); Its a very simple query and its driving me nuts.

This is a multiplication test for students to take and when they finish they click the score button. after they click the score button it tells them what their score is, with the opportunity to take it again.

What I am trying to do is make this able to keep the recent score and just post the next score. Right now my app just gives the first score and then when I take the test again it just refreshes and gives the new score. I want it to play the new score under the old score. I can't seem to figure out how to do this. If someone could help point me in the right direction. Would appreciate the help.


Here is my code for my app....



Code: [Select]
<?php

require_once('database.php');






define ('ROWS', 3);
define ('COLS', 3);
define ('MAX_NUMBER', 12);
date_default_timezone_set('America/New_York');



if (isset($_POST['btn_score']))
{

$result_name= $_POST['result_name'];

$correct = 0;


//print_r ($_POST);
$time1 = $_POST['ts'];
$time1_object = new DateTime($time1);
$now = new DateTime();
$time_span = $now->diff($time1_object);

$minutes = $time_span->format('%i');
$seconds = $time_span->format('%s');
$seconds+= $minutes * 60;

echo "It took $seconds seconds to complete the test<hr />";



foreach ($_POST as $problem => $answer)
{
if ($problem <> "btn_score" && $problem <> "ts" && $problem <> "result_name")
{
//echo "$problem -- $answer <br />";
$problem = explode('_', $problem);
$num1 = $problem[2];
$num2 = $problem[3];



$right = $num1 * $num2;


if ($answer != $right)
{
echo "$num1 * $num2 = $answer , The right answer is $right<br />";
}else 
{
$correct = $correct + 1;

}




}
}
$result_score= 0;
$result_score= ($correct / 9) * 100;

echo "your score is <br/>$result_score<br/>";

}


$sql = "INSERT INTO results (result_name, result_score, result_date_time) VALUES ('$result_name','$result_score', NOW());";










?>

<h1>Multiplication Test</h1>

<form name="lab5" method="post" action="lab5b.php">
<?php
$now = new DateTime();
//echo $now->format('Y-m-d H:i:s');
echo "<input type='hidden' name='ts' value='" . $now->format('Y-m-d H:i:s') . "'>";
?>
<table border="1" cellspacing="5" cellpadding="5">

<?php


$no_of_problems = 0;
for ($row=0; $row<ROWS; $row++)
{
echo "<tr>";
for ($col=0; $col<COLS; $col++)
{
$num1 = mt_rand(1,MAX_NUMBER);
$num2 = mt_rand(1,MAX_NUMBER);

echo "<td>$num1 * $num2 </td>";
echo "<td><input type='text' size='2' name=${no_of_problems}_mult_${num1}_${num2}></td>";
$no_of_problems++;
}
echo "</tr>";
}
$colspan = 2 * COLS;
echo "<tr><td colspan=$colspan align='right'><input type='submit' value='Score' name='btn_score'></td></tr>";
?>

I am parsing an rss feed from my flickr photostream using this:-

<?php

$url = "http://api.flickr.com/services/feeds/photos_public.gne?id=49466419@N05&lang=en-us&format=rss_200";
$rss = simplexml_load_file($url);
	if($rss)
	{
	echo '<h1>'.$rss->channel->title.'</h1>';
	echo '<li>'.$rss->channel->pubDate.'</li>';
	$items = $rss->channel->item;
		foreach($items as $item)
		{
		$title = $item->title;
		$link = $item->link;
		$published_on = $item->pubDate;
		$description = $item->description;
		echo '<h3><a href="'.$link.'">'.$title.'</a></h3>';
		echo '<span>('.$published_on.')</span>';
		echo '<p>'.$description.'</p>';
	}
}

?>

which gives me this as the description for each image:-

public 'description' => string '
<p><a href="http://www.flickr.com/people/alfthomas/">Alf Thomas</a> posted a photo:</p>
	
<p><a href="http://www.flickr.com/photos/alfthomas/14064465890/" title="harlaw_12">
<img src="http://farm6.staticflickr.com/5077/14064465890_83c02ecec6_m.jpg" width="240" height="110" alt="harlaw_12" />
</a>
</p>

<p>A view of Harlaw Reservoir.</p>' (length=338)

What I actually want is the photo (linked back) without the "Alf Thomas posted a photo" bit, does anyone have any idea how I would go about cloning that bit out?
Edited by foucquet, 31 May 2014 - 08:14 AM.

ok im back quicker than i thought....

i got my drop box sorted and i got it reloading the page. so it all works correctly.

but how do i get the page to display information regarding the film i have selected in the drop box.? i have no code for this at the mo.

also i would like the drop box to display the selected item at top of box when it refreshes

code for drop box:

Code: [Select]
<FORM>
<?php $result = mysql_query( "SELECT * FROM movie_info ORDER BY title ASC ")
;
echo "<select name= Film onChange='submit()' >film name</option>";
while
($nt=mysql_fetch_array($result)){
?>
<?php
  echo "<option value='$nt[id]'>$nt[title] </option>";
}
?>
</select>
</FORM>



any help would be great

When I get a hit on my site I like to see where they came from and if they came from a search engine what keywords they used. So here is the refer info:

http://www.google.com/search?q=dog+training&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

I guess I need to split everything into an array or something.

Has anyone done this?  Any Ideas?

Thank you!