PHP - I've Got The Info In The Db. How Do I Put It Into The Form?

I have a contact form with a file upload button, when you click on “submit” you are redirected on Paypal everything works fine but, I would like to send the contact form only when visitors have paid on Paypal. I’ve searched on google but I have not found a way to do this.

Can anyone help?

Cheers,

Aidan.

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?

Hi Experts,

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

Thanks,

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

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?

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.

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.

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.

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!

Hi Ive currently developed a script that connects via an API to send a message, and tested it with one user and it works perfectly. But now im bit stuck to send it to multiple users. All my visitors unique IDs are being stored into a file called unique.csv all in 1 column under each other. But what im currently trying to do is to recall the info from the csv and make a contact list to broadcast the message to.   The csv file looks like:     27823116700 m59317461002

hello guys

i heard there is a way that you can make something like a database on a text editor and when ever u want to change the info you just open a text editor and change the information


How is this called? where can i find a tutorial? any tips? thanks you very much 

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..

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>

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..