PHP - Moved: On Duplicate Key Update Wont Work?

require_once 'includes/upload.class.php';
$upload = new uploads();
$details = $upload->getFileInformation($id);

<?php echo $details['upload_desc']; ?>

then here the class.

require_once 'db.class.php';



class uploads extends database

{

   private $uploadData;

   function uploadFile() {

   public function getFileInformation($id)

   {

      $this->uploadData = $this->readData("uploadfiles", "upload_id", $id);

      return $this->uploadData;

   }


But it wont work!
      

Hi Guys

I have created a registration page where when users login they can pay to become premium, however everything looks fine but paypal wont update the field. The field is 0 and needs to be 1 once payment has been made. Below is my code,

<?php

     //connect to database
    $error = "Problem connecting";
    mysql_connect('localhost','_prince','getmeout') or die($error);
    mysql_select_db('hmt_cms') or die($error);


   

// read the post from PayPal system and add 'cmd'

$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('ssl://www.sandbox.paypal.com', 443, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {

if ($payment_status=="completed")

{

if ($payment_amount==1.00&&$payment_currency=="GBP")
{

$update = mysql_query("UPDATE cms SET premium='1' WHERE email='$payer_email'");

}


}


// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// check that payment_amount/payment_currency are correct
// process payment


}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>


im testing it from sanbox and these are my settings.

IPN handler URL is correct
Transaction type : cart checkout
payment_status : completed
payment type: instant

email is the same email registered
mc_fee  = 1
the rest of mcs are set to 0

currency is GBP


any help would be appreciated,

thanks in advance

I use mysql and this code that I will show says that the info was sucessfully updated, but it wasnt.  please help.  By the way, I am designing a website for a boy scout troop that has asked me to help.  any help appreciated:
Code: [Select]
<?php
session_start(); // Must start session first thing
/*
Created By Adam Khoury @ [URL=http://'http://www.flashbuilding.com/']www.flashbuilding.com[/URL]
-----------------------June 20, 2008-----------------------
*/
// Here we run a login check
if (!isset($_SESSION['id'])) {
echo 'Please <a href="login.php">log in</a> to access your account';
exit();
}
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$id = $_SESSION['id'];

// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE id='$id' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$rank = $row['rank'];

}



// Process the form if it is submitted
if ($_POST['rank']) {
$rank = $_POST['rank'];
$sql = mysql_query("UPDATE members SET rank='$rank' where id='$id'");
echo 'Your account info has been updated, visitors to your profile will now see the new info.<br /><br />
<meta HTTP-EQUIV="REFRESH" content="3; url=http://final.net46.net/myprofile.php">';
exit();
} // close if post
?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="scout.php" onsubmit="return validate_form ( );">
  <label for="rank"></label>
  <select name="rank" id="rank">
    <option value="Scout">Scout</option>
    <option value="Tenderfoot">Tenderfoot</option>
    <option value="Second Class Scout">Second Class Scout</option>
    <option value="First Class Scout">First Class Scout</option>
    <option value="Star Scout">Star Scout</option>
    <option value="Life Scout">Life Scout</option>
    <option value="Eagle Scout">Eagle Scout</option>
    <option value="<?php echo $rank; ?>" selected="selected"></option>
  </select>
  <input type="submit" name="submit" id="submit" value="Save" />
</form>
</body>
</html>

the sql statement dont execute: what would be the problem?                                                                            $sql = "UPDATE ".prefix("loanapplication")." SET                                                                           firstname = :firstname,                                                                          secondname = :secondname,                                                                          surname = :surname,                                                                          officialworkemail = :officialworkemail";                                                                           $sql.= " WHERE username=:username";                           $sql.= " WHERE username=:username";                                         echo "$sql: $sql<br>";                         //print_r($sql);                         $stmt = $database->connection->prepare($sql);                         $stmt->bindParam(':username',$session->username);                         $stmt->bindParam(':firstname',$firstname);                         $stmt->bindParam(':secondname',$secondname);                         $stmt->bindParam(':surname',$surname);                         $stmt->bindParam(':officialworkemail',$officialworkemail);                         $stmt->execute();       sql =UPDATE `emr_loanapplication` SET firstname = :firstname, secondname = :secondname, surname = :surname, officialworkemail = :officialworkemail WHERE username=:username

I am having a big problem in MySQL and a part in my PHP coding as well.

I created a registration form, where the user will have to fill his names, email address, choose a username and so on. I do not want duplicate email address and username in my database, thus, if a user choose either an email address or a username which has already taken, he will be notified.

To prevent this duplication, I have set both the email address and username fields as UNIQUE KEY in MySQL.

My problems a

Even by setting both the username and email address fields as UNIQUE KEY, it is not working as I can register using the same email address or username. How to solve this?

I have coded also to prevent this problem of duplicate so that the user will be notified to choose another email or username, but I am having a warning.

My PHP codes:
Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (isset($_POST['fname']) && isset($_POST['lname'])&& isset($_POST['emailr']) && isset($_POST['user']) && isset($_POST['pass'])) {
//Assignng variables        
$firstname = mysql_real_escape_string($_POST['fname']);
$lastname = mysql_real_escape_string($_POST['lname']);    
$email = mysql_real_escape_string($_POST['emailr']);
$uname = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pass']);
$pmd= md5($pwd);
//Database
$connect = mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('registration', $connect) or die ('Connection Failed');

//Registration codes

if (empty($firstname) || empty($lastname) || empty($email) || empty($uname) || empty($pmd)) {
echo '<p class="error">All fields are required to fill!</p>';
return false;
} elseif (strlen($firstname) && (strlen($lastname) < '2')) {
echo '<p class="error">Invalid first name or last name!</p>';
return false;
} elseif (filter_var($firstname, FILTER_VALIDATE_INT) || (filter_var($lastname, FILTER_VALIDATE_INT))) {
echo '<p class="error">First name or last name cannot be integers!</p>';
return false;
} elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Email address not valid!</p>';
return false;    
} elseif (strlen($uname) && (strlen($pmd) < '6' )) {
echo '<p class="error">Username or password must be minimum 6 characters!</p>';
return false;
} else {
$query = "INSERT INTO login (id, firstname, lastname, emailaddress, username, password) VALUES('', '$firstname', '$lastname', '$email', '$uname', '$pmd')";
mysql_query($query, $connect);    
if (mysql_num_rows(mysql_query("SELECT * FROM login WHERE emailaddress = '$email' username = '$uname'"))) {
echo '<p class="fail">This email or username is already taken!</p>';
}
}
}
}
?>
The warning message I am getting:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\miniimagehosting\register.php on line 44

$last = mysql_query("SELECT MAX('id') FROM comments WHERE submittedby='$username'");


can any1 help me?

Ok, I am a complete noob when it comes to php. I am slowly learning it but I turned to youtube for a tutorial on a registration/login page. I found a good tutorial http://www.youtube.com/watch?v=ngqeWUIDlnk&feature=channel but for some reason my php is NOT working. I have it exactly the way he does but it wont echo anything or work at all. The login page worked great in his tutorial. What do I have wrong? I cant figure it out. Please help!

 

echo "<h1>Register</h1>";

 $submit = $_POST['submit'];
 $fullname = strip_tags($_POST['name']);
 $username = strip_tags($_POST['user']);
 $password = strip_tags($_POST['password']);
 $verifypassword = strip_tags($_POST['verifypassword']);
 $date = date("Y-m-d");

 if ($submit)
 {
     if($fullname&&$username&&$password&&$verifypassword)
     {
          password = md5($password);
          verifypassword= = md5($verifypassword);
     }
     else
         echo "Please fill in all fields!";

 }
Code: [Select]
<html>
<form action='register.php' method='POST'>
      <table>
              <tr>
                   <td>Full Name:</td>
                   <td><input type='text' name='name'></td>
              </tr>
             
              <tr>
                   <td>Username:</td>
                   <td><input type='text' name='user'></td>
              </tr>
               
               <tr>
                   <td>Password:</td>
                   <td><input type='password' name='password'></td>
              </tr>

              <tr>
                   <td>Verify Password:</td>
                   <td><input type='password' name='verifypassword'></td>
              </tr>
      </table>
      <p><input type='submit' name='submit' value='Submit'></p>
</form>

</html>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309981.0

It works other then the fact it won't go to another page to see results.

<?php

  // Get the search variable from URL

  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("localhost","username","password"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("database") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "select * from the_table where 1st_field like \"%$trimmed%\"  
  order by 1st_field"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
 echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the 
  search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
echo "Results";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\"><< 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";

?>

Any idea why I cant get the order by to work?

$res =  mysql_query ("SELECT COUNT(*), LEFT(`comment`, 3) AS truncated from comments where navn='$rows[navn]' AND adresse='$rows[adresse]' ORDER BY time desc" ) or die(mysql_error());

Test code

test.php
Code: [Select]
<script type="text/javascript">
$(document).ready(function(){

$("#sub").click(function(){
$("#test").load("sub.php");
$.get("sub.php", {
uid: $("#sub").attr('uid')
});
});
});

</script>
<a href="#" id="sub" uid="1">Sub</a>
<div id="test">

</div>

sub.php
Code: [Select]
<?php
$id = $_GET['uid'];
echo $id;
?>

I am trying to load a file after clicking the href which has an extra attribute so i can query the database with it, however the get method seems to be not working, it works on other pages though.

Error message i get

Quote

Notice: Undefined index: uid in C:\xampp\htdocs\sub.php on line 2

Hi, I am not sure why but my script is not working. Choose a post is not working
http://beta.cwuforum.com/stock/tech.php

Code: [Select]
<?PHP $idofp = $_REQUEST['bida']; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Ryan Weekly</title>
<style type="text/css">
body {
background-color: #E3E5E2;
}
</style>
</head>
<style type="text/css">
<!--
body {
font-size:12px;
font-family:Verdana, Arial, Helvetica, sans-serif;
}
div#wrapper {
width: 80%;
background-color:#FFFFFF;
margin-top: 50px;
margin-bottom: 50px;
margin-left: auto;
margin-right: auto;
padding: 0px;
border: thin solid #000000;
}
div#header {
padding: 15px;
margin: 0px;
text-align: center;
}
div#nav {
width: 25%;
padding: 10px;
margin-top: 1px;
float: left;
border: thin solid #000000;

}
div#main {
margin-left: 30%;
margin-top: 1px;
padding: 10px;
border: thin solid #000000;
}
div#underhead {
padding: 15px;
margin: 0px;
border-top: thin solid #000000;
}

{
ul.nav a:hover, ul.nav a:active, ul.nav a:focus { /* this changes the background and text color for both mouse and keyboard navigators */
background: #6F7D94;
color: #FFF;
}
.content ul, .content ol {
padding: 0 15px 15px 40px; /* this padding mirrors the right padding in the headings and paragraph rule above. Padding was placed on the bottom for space between other elements on the lists and on the left to create the indention. These may be adjusted as you wish. */
}

/* ~~ The navigation list styles (can be removed if you choose to use a premade flyout menu like Spry) ~~ */
ul.nav {
list-style: none; /* this removes the list marker */
border-top: 1px solid #666; /* this creates the top border for the links - all others are placed using a bottom border on the LI */
margin-bottom: 15px; /* this creates the space between the navigation on the content below */
}
ul.nav li {
border-bottom: 1px solid #666; /* this creates the button separation */
}
ul.nav a, ul.nav a:visited { /* grouping these selectors makes sure that your links retain their button look even after being visited */
padding: 5px 5px 5px 15px;
display: block; /* this gives the link block properties causing it to fill the whole LI containing it. This causes the entire area to react to a mouse click. */
text-decoration: none;
background: #8090AB;
color: #000;
}
ul.nav a:hover, ul.nav a:active, ul.nav a:focus { /* this changes the background and text color for both mouse and keyboard navigators */
background: #6F7D94;
color: #FFF;
}

/* ~~ The footer ~~ */
.footer {
padding: 10px 0;
background: #6F7D94;
position: relative;/* this gives IE6 hasLayout to properly clear */
clear: both; /* this clear property forces the .container to understand where the columns end and contain them */
}

/* ~~ miscellaneous float/clear classes ~~ */
.fltrt {  /* this class can be used to float an element right in your page. The floated element must precede the element it should be next to on the page. */
float: right;
margin-left: 8px;
}
.fltlft { /* this class can be used to float an element left in your page. The floated element must precede the element it should be next to on the page. */
float: left;
margin-right: 8px;
}
.clearfloat { /* this class can be placed on a <br /> or empty div as the final element following the last floated div (within the #container) if the #footer is removed or taken out of the #container */
clear:both;
height:0;
font-size: 1px;
line-height: 0px;
}
-->
</style>

<body>
<div align="Left">
  <p><img src="indexp.png" width="728" height="90" /></p>
</div>
<div id="underhead">
  <form id="bida2" name="form1" method="post" action="tech.php">
    Choose Post:
    <label for="id"></label>
    <select name="id" id="bida">
      <option value="ad1">Google Chrome Netbook </option>
    </select>
    <input type="submit" name="send" id="send" value="View" />
  </form>
</div>
<?php include("menu.php"); ?>
<div id="main">
 <?PHP
 if (empty($idofp))
 include ("canoncamera1.php");
 if ($idofp == ad1)
 include ("chromenetbook.php");
  ?>
</div>
Ryan Weekly 2009 - 2011 (May 11, 2011 at 6:00PM Is our 3 Year anniversary!)
</body>
</html>

For some reason this wont work.. Index is jsut returned blank ... Hmm

Index.php :
<?php
include("http://www.website.com/cookie.php");
?>


Cookie.php:
<?php
if (isset($_COOKIE["background"]))
  $background = $_COOKIE['background'];
else
  $background = " bgcolor='#FFFFFF'";
?>

It works perfectly if I just enter the code without using a include ...