PHP - Assigning Null Values To Variable And Executing Sql Update Query

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);

I have the following query where $userid is about 100,000 userids separated by commas.

Code: [Select]
<?
$getpostid=mysql_query("SELECT DISTINCT post.username,post.threadid,thread.threadid,thread.forumid from post,thread WHERE post.username='$username' AND post.threadid=thread.threadid AND post.userid IN ($userid) AND thread.forumid IN ($forumids)") or die (mysql_error());
?>can i just print all the usernames from above result separated by ';' without looping it multiple times?
 
Could someone help me out how to do above in an efficient manner?

I have a query that pulls 1 field with 20 rows of data.  I need to assign each row to a different variable so that I can then display them in different locations on a page.
I cannot make each row of data a different field because of other constraints.
My data is very well normalized.
I am using mysqli so something like the old mysql_result would be lovely!
How can this be done without hitting my database 20 times?
Thanks for the help.

hey guys im sure this is possible im wondering how a user can execute a mysql query by a click of a button but without the page reloading...thanks guys

hi,
i am updating records from database using ajax and javascript on php page.
The result is displayed inside a div (<div id="show"></div>).
Now i want to assign the content of the above div(say y) to php variable for further calculations.

How can i assign the value displayed in div tag to a php variable?

Thanks.

Hi all,

I can't seem to designate an array key by using a variable and I was wondering if this is possible. I'm looking to do something like this:

Code: [Select]

<?php
$key = "apple";
$arr = array($key => "fruit");
?>
Any suggestions would be appreciated!

hi there,
i'm trying to put a message in the footer of a page which welcomes a person who is logged in with his/her name, using sessions of course; when i place this:
Code: [Select]
$username = $_SESSION['valid_user'];
in the footer before the echo:
Code: [Select]
echo "You are logged in as $username";
but the session is also needed before the footer to use the username for other things , such as -checking his credit- so if place in footer the footer shows name in browser but checking credit would not happen as the assignment is at the buttom.

IF i place the assignment above at the top of the file:

everything works for the user and checking credit ..etc...but the footer is not there...

cud not put this any clearer..sorry...hope if someone cud help...thanks

What is the best way to display the next record on a web page, from a list of records, without executing the query over and over again each time you display the next record?

For example, imagine my user has a list of messages displayed on a web page, and the user filters that list to display all messages with the title "Test", and let's say that returns 12 records.

He then clicks on record 1 to read that message. Once he is done reading it, he then wants to read msg 2, and then msg 3 etc.

He could hit the Back button in his browser and click on the next record from the list, but it would be more useful to just click on a link that says "Next" which displays the next message in the filtered list of messages (without having to go back to the list).

A lot of web sites do this sort of thing, but what is the best way to do it? Do you have to run the original query again each time a new message is loaded, so you know which message is next, or can you somehow store the query to save the server from having to run the same query over and over again?

If a user is viewing a list of pictures for example, they could be flicking through the pictures quite quickly, and I would not like to have the server running the same query over and over again every few seconds when it doesn't need to.

Advice? (Thanks.) 

Hi, I have just started creating my first class in php. I'm trying to assign $_SERVER['REMOTE_ADDR']; to a protected variable but I keep getting an error message. I'm still trying to get my head around oop php. 

My current code is "protected $user_ip = $_SERVER['REMOTE_ADDR'];" and the error message is "Parse error: syntax error, unexpected T_VARIABLE".

Hi, I know this has to be possible but I have been unable to get this to work properly.

I have a page with two forms.   The first form is a list of sources associated with a subject, with checkboxes, so that it is possible to remove these associations, like so:

Code: [Select]
$qs = "SELECT s.source_id, s.source_name
from source s, source_subject ss, subject sb
where s.source_id = ss.source_id
and sb.subject_id = ss.subject_id
and sb.subject_id = $subject_id
order by source_name";
$rs  = mysqli_query($dbc, $qs)
  or die ('Error querying database');


while($row = mysqli_fetch_array($rs)) {


echo '<input type="checkbox" value="' . $row['source_id'] . '" name="markdelete[]">' . $row['source_name'] . '<br />' ;

}


The second form is a list of sources that are not associated with this subject, with checkboxes enabling the addition of more sources to this subject, like so:

Code: [Select]
$r = "SELECT source_id, source_name
FROM source
WHERE source_id NOT IN
(select s.source_id
from source s, source_subject ss
where s.source_id = ss.source_id
and ss.subject_id = '$subject_id')";

$r1  = mysqli_query($dbc, $r)
or die ('Update Error: '.mysqli_error($dbc));


while ($row = mysqli_fetch_array($r1)) {
echo '<input type="checkbox" id="source_id" name="source_id[]" ' ;

echo 'value="'. $row['source_id'] .'"';


    echo '> ' . $row['source_name'] . '<br />';


} 


The first form works fine... when the "remove" submit button is clicked, it successfully removes any selected sources and then shows the remaining sources still associated, and then automatically populates this source in the below list (form 2) as one that is not selected.

On the second form, when adding a new source to the subject, it successfully enters the data into the database, and removes this source from the list of unselected sources, but it does not seem to re-populate in the first form.

The data is correct on the tables, but the page needs to reload the first query... how do I get it to do this?  I'd like to be able to make this page editable, and re-editable (in case someone makes a mistake) without having to go back and reload the entire page.

Note, both forms call the page itself; not sure if this is part of it.  Using this:
Code: [Select]
<form  method="POST" action="<?php echo $_SERVER['PHP_SELF'].'?subject_id='.$subject_id ;    ?>"> 
Does anyone have any ideas?

Hello,

I am creating a class which contains one private function that deals with connecting to a SQL Server and executing the sql that is passed in to that function.
I have defined a class variable which is assigned the value of sqlsrv_query like so.

$this->QueryResult = sqlsrv_query($conn,$sql);
I have placed private $QueryResult at the top of my class.

The other public methods call this private function to assign the result set to the class variable, the private method returns and then the public methods loop through the results array like so.

while($row = sqlsrv_fetch_array($this->QueryResult))

.. but the while loop never gets entered.

If I declare everything in the same method then it works, however there are going to be several public methods that will use this private method and I don't want to duplicate all the database coding.

Hope someone can help

Hello Everyone,

I am new to forum and could use some help with some php code that isn't working.  I am very new to php/html/javascript and all of what I have learned, I learned from forums like this one so first....thank you!

I am trying to assign a value from a php variable to the value of my form element.  I'm sure there must be a way to do this but I can't seem to get the syntax right.  here is my code...

first I set the value of $loginname elsewhere in the script like so...

<?php
$loginname =strtolower(htmlspecialchars(strip_tags($_GET["loginname"])));
?>
This part works fine..

Then I try to set the value of my hidden text field inside the form to the value of $loginname to be passed to a javascript program.  Everything works except that the value passed ends up being <?echo and not the expected user name inside of $loginname.

<?php

echo '<form name ="currentactivity" Id="currentactivity" action="<?php'.htmlspecialchars($_SERVER['PHP_SELF']).'?>"      method="post">';

echo '<fieldset><legend><b>Your Current Activity Information</b></legend>';
echo '<input type="text" name="loginnm"  style="visibility: hidden" value="<?php echo $loginname;?>">';

echo "<label for='myactivities'>Activity Name:</label>";

 
echo "<select name='myactivities' Id='myactivities' onchange=\"showdetails(this.form)\" value=''>";
echo "<option value = 'Select an activity'>Select an activity</option>";
for ($i = 1; $i <=$rowcount; $i++) {
   echo"<option value=$row[activity_name]>$row[activity_name] </option>";
   
   $row = mysql_fetch_array($result);
}
       
echo "</select>";
 
echo '</fieldset>';

echo '</form>';
?>

Please note..the rest of the code is working perfectly, it is just this one value I can't seem to get.
Any help you can give will be greatly appreciated. 

Okay, really newbie question, but for this code...
Code: [Select]
<!-- Gender -->
<label for="gender">Gender:</label>
<select id="gender" name="gender">
<option value="">--</option>
<option value="F">Female</option>
<option value="M">Male</option>
</select>

1.) How do I assign a variable to this?

2.) How do I make this "sticky"?


Here is how I have usually done other form types...
Code: [Select]
<!-- First Name -->
<label for="firstName">First Name:</label>
<input id="firstName" name="firstName" type="text" maxlength="30"
value="<?php if(isset($firstName)){echo htmlentities($firstName, ENT_QUOTES);} ?>" /><!-- Sticky Field -->
<?php
if (!empty($errors['firstName'])){
echo '<span class="error">' . $errors['firstName'] . '</span>';
}
?>


Oh, by the way, at the top of my PHP file I have this code...
Code: [Select]
if ($_SERVER['REQUEST_METHOD']=='POST'){
// Form was Submitted (Post).

// Initialize Errors Array.
$errors = array();

// Trim all form data.
$trimmed = array_map('trim', $_POST);

Thanks,


Debbie

I have a php page where user/db info is being passed:


<?php
include "include/dbc.php";

include "include/header.inc";

$exerciseid = $_POST["exerciseid"];
$duration = $_POST["duration"];
$distance = $_POST["distance"];
$metric = $_POST["metric"];

echo'<h1>Added Activities</h1>';



// name of array
echo '<h1>Exercise</h1>';
if (is_array($exerciseid)) {
        foreach ($exerciseid as $key => $value) {

        echo $key .' : '. $value .'<br />';

        }
}



// name of array
echo '<h1>Duration</h1>';
if (is_array($duration)) {
        foreach ($duration as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}


// name of array
echo '<h1>Distance</h1>';
if (is_array($distance)) {
        foreach ($distance as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

// name of array
echo '<h1>Metric</h1>';
if (is_array($metric)) {
        foreach ($metric as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

?>


And here is the output from that code:

Added Activities

Exercise
0 : Canoeing, on camping trip
1 : Canoeing, rowing, over 6 mph, vigorous effort
2 : Canoeing, rowing, crewing, competition
3 : Canoeing, rowing, light effort
4 : Canoeing, rowing, moderate effort
5 : Diving, springboard or platform
6 : Kayaking
7 : Sailing, boat/board, windsurfing, general
8 : Sailing, in competition
9 : Skiing, water
10 : Ski-mobiling, water
11 : Skin diving, scuba diving, general
12 : Snorkeling
13 : Surfing, body or board
14 : Swimming laps, freestyle, fast, vigorous effort
15 : Swimming laps, freestyle, light/moderate effort
16 : Swimming, backstroke, general
17 : Swimming, breaststroke, general
18 : Swimming, butterfly, general
19 : Swimming, leisurely, general
20 : Swimming, sidestroke, general
21 : Swimming, sychronized
22 : Swimming, treading water, fast/vigorous
23 : Swimming, treading water, moderate effort
24 : Water polo
25 : Water volleyball
26 : Whitewater rafting, kayaking, or canoeing

Duration
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Distance
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Metric
0 : mile
1 : mile
2 : mile
3 : mile
4 : mile
5 : mile
6 : mile
7 : mile
8 : mile
9 : mile
10 : mile
11 : mile
12 : mile
13 : mile
14 : mile
15 : mile
16 : mile
17 : mile
18 : mile
19 : mile
20 : mile
21 : mile
22 : mile
23 : mile
24 : mile
25 : mile
26 : mile


As you can see, null values are being passed as well. I am hoping that someone can show me the correct way to use php unset to get rid of these null values. Thank you.

hey guys,
I'm quite new to PHP and i was wondering if someone would be able to help me out with this.
The code i have checks the database to see if a user has provided a Vimeo ID. If they haven't, $video_check will equal a line of html that says the user hasn't added any videos to their portfolio. If the a vimeo ID is present, i want $video_check to equal a bunch of html and css with a foreach function inside that is used to display the users videos from vimeo.
The foreach function works fine when its not assigned to the $video_check variable. How do i structure it so that it displays correctly?

If you click on videos on this page you might get a better idea of what i'm talking about.
http://www.myfilmportfolio.ie/profile.php?id=33

and here is the code i'm having the problem with:

///////  check if user has provided vimeo id  //////////////////////////
$vimeoID = $row["vimeoID"];   
$video_check='';
if (empty($vimeoID)){
     $video_check = '<h3>'.$firstname .' has not added any videos to their portfolio</h3>';
     }
     else{
     $video_check = '<div id="stats">
                    <div style="clear: both;"></div>
               </div>
               <div id="wrapper">
               <div id="embed"></div>
                         <div id="thumbs">
               <ul>
               <?php foreach ($videos->video as $video): ?>
                    <li>
                                        <h4><?=$video->title?></h4>
                    <a href="<?php echo $video->url ?>">
                    <img src="<?php echo $video->thumbnail_medium ?>" class="thumb" /></a>
                    <p><?=$video->description?></p>
                                             <br />
                    </li>
                    <?php endforeach ?>
               </ul>
               </div>
            </div>';
   }


if anyone could help me out id really appreciate it.
Cheers,
G