PHP - Php-mysql Update With Joined Variable And String

Hi, I have been on and off this forum loads of time and it has helped me out so much over the past few months with different projects. But today there is one thing i simply cant figure out or find any kind of answer anywhere and would be really grateful if someone could give me a pointer.

I have a form which which i use to input data into a mysql database. One of the variables Code: [Select]
$budget=$_POST['budget']; which I use to add data to the 'budget' field in my database.

In the form, budget is a dropdown with a few options:
Code: [Select]
<select name="budget" id="budget">
    <option selected="selected">Please Choose One</option>
    <option>up to 500 Euros</option>
    <option>500 to 1000 Euros</option>
    <option>1000 to 1500 Euros</option>
    <option>1500 to 3000 Euros</option>
    <option>3000 to 5000 Euros</option>
    <option>Over 5000</option>
    <option>No Budget Set Yet</option>
  </select>

I have another field in my database called 'price'. What I would like to do is, if someone chooses a budget of 3000 to 5000 I would like this to enter 5.00 in the price field in the database.

I have tried a number of things, but nothing is working for me. This is where I am at now, which doesn't work either but thought it might give a better explanation of what I am trying to achieve.

Code: [Select]
$budget=$_POST['budget'];
$price=$budget['up to 500 Euros']='3.50';
$price=$budget['500 to 1000 Euros']='5.00';
$price=$budget['1000 to 1500 Euros']='4.50';
$price=$budget['1500 to 3000 Euros']='5.00';
$price=$budget['3000 to 5000 Euros']='5.50';
$price=$budget['Over 5000']='6.00';
$price=$budget['No Budget Set Yet']='4.00';

Also keep in mind that there is no 'price' field in the form. So no price is being posted to the processing page. I need to price to be worked out by what is posted from the budget field.

This is the only thing I am stuck with without having to ask for any help, and these forums have been a saviour to me and an excellent place for learning. But sometimes I think you have to give in and just ask for help! lol

Many thanks,

DB

Hi there   Just joined.

Hi

This does not make sense to me, I hope someone can tell me why this query don't work:

Code: [Select]
safe_query("UPDATE ".PREFIX."cup_challenges SET reply_date='$postdate', $select_map $select_date challenged_info='".$_POST['info']."', status='2' WHERE chalID='".$_GET['challID']."'");;
and this query does work:

Code: [Select]
safe_query("UPDATE ".PREFIX."cup_challenges SET reply_date='$postdate', map1='".$_POST['map1']."', map2='".$_POST['map2']."', map3='".$_POST['map3']."', date1='".$_POST['date1']."', date2='".$_POST['date2']."', date3='".$_POST['date3']."', date4='".$_POST['date4']."', challenged_info='".$_POST['info']."', status='2' WHERE chalID='".$_GET['challID']."'");

Variables in $select_map and $select_date makes the query fail but when I copy/paste this (bold) in query it works:

$select_map = map1='".$_POST['map1']."', map2='".$_POST['map2']."', map3='".$_POST['map3']."',
$select date = date1='".$_POST['date1']."', date2='".$_POST['date2']."', date3='".$_POST['date3']."', date4='".$_POST['date4']."',

am I using the variable in query incorrectly?

Below is my query, I have a column called boolActivate in my tblProperties table but I can't figure out how to put in a where clause so it reads something like WHERE boolActivate = 1     $strQuery = sprintf( "SELECT p.*, a.strAreaName FROM tblProperties p LEFT JOIN tblAreas a ON p.intAreaID = a.intID WHERE p.intID = %d", intval($intPropertyID));   Using MYSQL 5
Edited by datoshway, 04 November 2014 - 06:35 PM.

Here is the original query:

Code: [Select]
$query_extract = mysql_query("SELECT downloads,date,title,username,views,id FROM skins ORDER BY id DESC LIMIT 100");

Is it possible to also grab the row username from the table users, without making multiple queries?

Please help me with this: been doing this for 2 days and still cannot solve it. it won't update...

I have attached my file:

<?php
include('connect-database.php');
if (isset($_POST['submit']) AND $_POST['submit'] == 'update') {
   $error = false;
   extract($_POST);
   if (empty($full_name)) $error = true;
   if (!$error) {
      $update = "UPDATE users SET
               full_name = '$full_name',
               WHERE id=$id
               ";
      mysql_query($update) or die(mysql_error() . "<br><br>" . $update);
      $full_name = '';
      $message = "Record successfully updated.";
   } else {
      $message = "There is an error in your entry";
   }
} else {
   $id = intval(isset($_GET['id']) ? $_GET['id'] : 0);
}
if ($id == 0) {
   echo "<div style='margin-bottom:10px'>Invalid ID.</div>";
   exit;
}
$query = "SELECT * FROM users WHERE id=$id";
$result = mysql_query($query) or die(mysql_error() . "<br><br>" . $query);
if (mysql_num_rows($result) == 0) {
   echo "<div style='margin-bottom:10px'>Record Not Found in Database!</div>";
   exit;
}
$row = mysql_fetch_array($result);
extract($row);

?>
  <div id="mainContent" class="tab_container">
    <div id="tab1" class="tab_content">
    <h1>Edit Personal Data</h1>
   <div style="color:red;font-weight:bold"><? echo $message; ?></div>
          <form name="submit" action="" method="post">
        <ul>
           <li><b>ID # :</b> <?php echo $id?></li>
           <li><b>Name :</b> <input type="text" name="full_name" id="" size="30" value="<?php echo $full_name ?>" /></li>
            <li><b>Address :</b> <input type="text" name="address" id="" size="55" maxlength="100" value="<?php echo $address ?>" /></li>
            <li><b>Contact Number :</b> <input type="text" name="contact_number" id="" size="11" value="<?php echo $contact_number ?>" /></li>
            <li><b>Email Address :</b> <input type="text" name="user_email" id="" size="30" value="<?php echo $user_email ?>" /></li>
            <li><b>Status :</b> <input type="text" name="status" id="" size="10" value="<?php echo $status ?>" /></li>
            <li><b>Nationality :</b> <input type="text" name="nationality" id="" size="20" value="<?php echo $nationality ?>" /></li>
            <li><b>Religion :</b> <input type="text" name="religion" id="" size="20" value="<?php echo $religion ?>" /></li>
        </ul>
    <h2>Self Description</h2>
    <p><textarea rows="9" cols="40" name="self_description" ><?php echo $self_description ?></textarea></p>
   <input type="hidden" name="id" value="<?php echo $id; ?>" />
   <input type="submit" name="submit" value="update" />
   
   </form>
    </div>

im trying to make a breadcrumbs feature on my site. this feature is driven using the session variables. My problem here is that.. i just wondering what make the session variables display its own value (not expected value).. this variable name got no similar across the whole site.


i just wanna hear what are the possible causes why this happen...


thanks

I am trying to get a simple thing working.  I have a domain with google that I want to change the point to IP when I access a PHP page.  I have a DB table with settings that I am using for the username, password, etc.  The issue is that the command to change the IP always sends the same IP.  No matter what I try.  I have tried assigning a fixed entry for the variable $localip, I have set that variable to 0 ahead of the query to get the info from the table.  Nothing I do will change the variable in the command.  I can manually put the command in a browser and it will perform the change.  Can anyone comment on what I am missing here?

 

<?php
ini_set("display_errors", 1);
ini_set("track_errors", 1);
ini_set("html_errors", 1);
error_reporting(E_ALL); 
require('/var/www/html/cqadmin/utils/connect.php');

$sql = "SELECT * FROM `failover` LIMIT 0, 30";
$result = mysqli_query($link,$sql) or die(mysql_error());
$row = mysqli_fetch_array($result);
$localip = ($row['localip']);
$dnsusername = ($row['dnsusername']);
$dnspassword = ($row['dnspassword']);
$domain = ($row['failoverurl']);
$location = ($row['location']);
$dealer = ($row['dealer']);
$output = shell_exec("curl -s https://$dnsusername:$dnspassword@domains.google.com/nic/update?hostname=$domain&myip=$localip");
mysqli_close($link);
?>

I get no errors on the page and if I echo $output I get a nochng message back from Google

 

Thanks for looking!!

This topic has been moved to Other.

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

How can I make my on change in the form pass through the year thats been selected, then use that in the second query?

Code: [Select]
<select name="mySelect" onchange="">
<?php $result= mysql_query('SELECT DISTINCT Year FROM MonthlySales'); ?>
        <?php while($row= mysql_fetch_assoc($result)) { ?>
            <option value="<?php echo htmlspecialchars($row['Year']);?>">
                <?php echo htmlspecialchars($row['Year']); ?>
            </option>
        <?php } ?>
  </select>
       
    <?php

$query="SELECT * FROM MonthlySales WHERE Year = PASS YEAR SELECTED VARIABLE TO THIS BIT HERE";
$results = mysql_query ( $query, $conn);

Hi there,
im trying to have a form show up when user clicks "add joke". I need the variable to be retrieved from the url query string. I cant get the form to show up.  I think its either an issue with the GET function at the top or the link down at the bottom. Please help!


<?php
  // If the user wants to add a joke
  
    $_GET['addjoke'] = $addjoke;

  if (isset($addjoke)):
?>

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST>
<P>Type your joke he <BR>
<TEXTAREA NAME="joketext" ROWS=10 COLS=40 WRAP>
</TEXTAREA><BR>
<INPUT TYPE=SUBMIT NAME="submitjoke" VALUE="SUBMIT">
</FORM>

<?php
  else:

    // Connect to the database server
    $dbcnx = @mysql_connect("servername", "username", "password");
    if (!$dbcnx) {
      echo( "<P>Unable to connect to the " .
            "database server at this time.</P>" );
      exit();
    }

    // Select the jokes database
    if (! @mysql_select_db("jhodara2") ) {
      echo( "<P>Unable to locate the joke " .
            "database at this time.</P>" );
      exit();
    }

    // If a joke has been submitted,
    // add it to the database.

$joketext = $_POST['joketext']; 
$submitjoke = $_POST['submitjoke']; 

    if ("SUBMIT" == $submitjoke) {
      $sql = "INSERT INTO jokes SET " .
             "JokeText='$joketext', " .
             "JokeDate=CURDATE()";
      if (mysql_query($sql)) {
        echo("<P>Your joke has been added.</P>");
      } else {
        echo("<P>Error adding submitted joke: " .
             mysql_error() . "</P>");
      }
    }
  
    echo("<P> Here are all the jokes " .
         "in our database: </P>");
  
    // Request the text of all the jokes
    $result = mysql_query(
              "SELECT JokeText FROM jokes");
    if (!$result) {
      echo("<P>Error performing query: " .
           mysql_error() . "</P>");
      exit();
    }
  
    // Display the text of each joke in a paragraph
    while ( $row = mysql_fetch_array($result) ) {
      echo("<P>" . $row["JokeText"] . "</P>");
    }
  
    // When clicked, this link will load this page
    // with the joke submission form displayed.
    echo("<P><A HREF='$PHP_SELF?addjoke=1'>Add a Joke!</A></P>");
  
  endif;
  
?>


see the problem live at http://www.freewaycreative.com/insert2.php

below is the script.i use it for to edit a single .html file. but now i want to edit multiple .html file by this script.

so i think i have to change dynimacaly (may be a dropdown form)  this line $url = "p".$page.".html";    and this line.

can any body help?


Code: [Select]
<?php   
  
function br2nl($str) {   
return preg_replace('=<br */?>=i', "", $str);   
}   
 
$action=$_POST['action'];   
$textarea=$_POST['textarea'];   
 
if($_GET['p']){   
$page=$_GET['p'];   
}   
 
// Assume your text pages are called, p1.db or p2.db, etc.   
$url = "p".$page.".html";   
if (file_exists($url)) {   
// do nothing   
} else {   
$url = "p0.html";   
}   
 
// where to go back to after the edit ...   
$return="edit.php?p=$edit";   
 
// Get page   
$data = implode("", file($url));   
 
if($action=="save"){   
$newtext=stripslashes($textarea);   
$newtext = str_replace("<?", "", $newtext);   
$newtext = str_replace("?>", "", $newtext);   
$newtext = nl2br($newtext);   
//echo "page: $url<br><br>\n";   
//echo $newtext;   
$fh = fopen($url, 'w') or die("can't open file");   
fwrite($fh, $newtext);   
fclose($fh);   
header ("location:edit.php?p=$page");   
}   
else{   
 
?> 
<!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>abeer cms</title> 
<script type="text/javascript" src="jscripts/tiny_mce/tiny_mce.js"></script> 
<script type="text/javascript"> 
tinyMCE.init({ 
        // General options 
        mode : "textareas", 
        theme : "advanced", 
        plugins : "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,imagemanager,filemanager", 
 
        // Theme options 
        theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect", 
        theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor", 
        theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen", 
        theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage", 
        theme_advanced_toolbar_location : "top", 
        theme_advanced_toolbar_align : "left", 
        theme_advanced_statusbar_location : "bottom", 
        theme_advanced_resizing : true, 
 
        // Example content CSS (should be your site CSS) 
        content_css : "css/example.css", 
 
        // Drop lists for link/image/media/template dialogs 
        template_external_list_url : "js/template_list.js", 
        external_link_list_url : "js/link_list.js", 
        external_image_list_url : "js/image_list.js", 
        media_external_list_url : "js/media_list.js", 
 
        // Replace values for the template plugin 
        template_replace_values : { 
                username : "Some User", 
                staffid : "991234" 
        } 
}); 
</script> 
<style>   
body,html{   
margin:0px auto;   
width:700px;   
text-align:center;   
}   
#content{   
margin:0px auto;   
width:700px;   
}   
#middle h1 {   
    color: transparent;   
    font-family:georgia;   
    font-size:12pt;   
    margin:0;   
    color: #dF9100;   
    padding:10px 0px 15px 0px;   
    text-align:left;   
}   
</style>   
</head> 
 
<body> 
<div id='content'>   
<? 
 
$ta=br2nl($data);   
 
echo"   
<a href='$return'><-- Return to Page</a><br /><br />   
Make Changes and click \"Save Changes\" at the very bottom ...<br />   
<form action='edit.php' method='post'>   
<input type='hidden' name='action' value='save'>   
<input type='hidden' name='p' value='$page'>   
<input type='hidden' name='n' value='$n'>   
<textarea name='textarea' rows='25' cols='80'>$ta</textarea>   
<br />   
<input type='submit' name='submit' value='Save Changes'>   
</form>   
 
<div id='middle' style='width:680px; text-align:left; padding-left:20px; border:1px solid #ccc;'>   
</div>   
</div>   
</body>   
</html>   
";   
}   
 
?>

I need to see if someone can point out something that I have missed or maybe even point me in the right direction on something.  I have a PHP script that I have run into a problem on.  The basic idea of the script is that it will send out HTML formatted emails to users of my web site.  The problem I am running into is storing the HTML content in memory so I can do a str_replace() looking for certain markers in the HTML and replace them with lets say the users name and custom links that pertain to the particular user that the email is going to.  Currently the HTML is being stored in a MySQL database, but I have already tried reading it from a flat file.  Each time I only get the first 1024 characters returned.  The problem seems to be that I am running into a PHP STRING limitation.  From the reading that I have done on the subject, the limit should be 1024 characters PER LINE with the variable able to hold somewhere around 8MB worth of data.  I can tell you that it does not matter how many \n I put into the HTML I still only get the first 1024 characters.  Is there a way I can get the entire HTML file (about 12k characters) in memory so I can work with it and hand it off to the mail function?

Thanks,

whit3fir3

//$value1 = $_POST['game'];

$value1 = "game7h";

if (strpos($value1, 'a')) {
$team = 'a';
}elseif (strpos($value1, 'h')) {
$team = 'h';
}      
if (strpos($value1, '7')) {
$num = '7';
} elseif (strpos($value1, '8')) {
$num = '8';
} elseif (strpos($value1, '9')) {
$num = '9';
}

$gm7hodds = $games[41]["BP"];
$gm7aodds = $games[40]["BP"];

$gm8hodds = $games[47]["BP"];
$gm8aodds = $games[46]["BP"];

$gm9hodds = $games[53]["BP"];
$gm9aodds = $games[52]["BP"];


/* 
$getratio = $num + $team;

echo $getratio;

Team is not a math operation so I'll finesse that later.

*/


$findratio = 'gm' . $num . 'h' . 'odds';
echo $findratio;

gm7hodds

How would I add the $ to it and return its array value $gm7hodds?

Solved whoops ->

echo eval('return $'. $findratio. ';');

Edited April 28 by Minzer
solved