PHP - Select List: Assigning Variable And Making Sticky

Hi folks,

I was wondering how to do this. I want the if statement to detect if the query string has any of these values. so im trying to assign them all to the same variable. However, this code wont work. Whats the trick here?

<?php
$primary=$_GET['intro'];
$primary=$_GET['port'];
$primary=$_GET['about'];
$primary=$_GET['contact']; 

         if(isset($primary)){
     echo "<img src='graphics/left-a.png'>";}
else {echo "<img src='graphics/leftb.png'>";}?>

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

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. 

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

I am facing problem to execute query by assigning NULL value to a variable and then executing query.In MySQL DB four fields Mobile,landline, pincode,dob are set as integer and date(for dob) respectively.The default is set as  NULL and NULL option is selected as yes.All these fields are not mandatory.The problem is that when I edit the form my keeping the value as empty in DB these are saved as 0, 0 , 0 & 0000-00-00 inspite of Null. I have tried everything but still the defect persist. Please help me to come out of the problem 

The code, I have used:

<?php
//require_once 'includes/config.php';

      $dbusername = $_POST['email'];
        $dbfirstname = $_POST['first_name'];
        $dblastname = $_POST['last_name'];
        //$dbmobile_number = $_POST['mobile'];
      if (isset($_POST['mobile']))
      
      {
         $dbmobile_number = $_POST['mobile'];
         
      }
       
      else
      
      {
         $dbmobile_number = "NULL";
         
      }
            
      $dblandline_number = $_POST['landline'];
        $dbdob = $_POST['dob'];
      
      if(isset($_POST['is_email']))
      {
         $dbSubscribe_Email_Alert = '1';
      }
      else
      {
         $dbSubscribe_Email_Alert = '0';
      }
      
      if(isset($_POST['is_sms']))
      {
         $dbSubscribe_SMS = 0;
      }
      else
      {
         $dbSubscribe_SMS = 0;
      }
       
      
        $dbAddress_firstname = $_POST['shipping_first_name'];
        $dbAddress_lastname = $_POST['shipping_last_name'];
        $dbAddress = $_POST['shipping_address'];
        $dbcity = $_POST['shipping_city'];
        $dbpincode = $_POST['shipping_pincode'];
        $dbstate = $_POST['shipping_state'];
        $dbcountry = $_POST['shipping_country'];
      
      echo "Welcome".$dbusername;

//if($_POST['btnSave'])

      //if ($_POST['btnSave'])

//{
   
   //echo "Inside query loop";
$connect = mysql_connect("localhost","root","") or die("Couldn't connect!");
mysql_select_db("salebees") or die ("Couldn't find DB");

//$query = mysql_query("SELECT * FROM users WHERE username='$username'");

$query = mysql_query("update users set firstname = '$dbfirstname', lastname = '$dblastname', mobile_number = '$dbmobile_number', landline_number = '$dblandline_number', dob = '$dbdob', Subscribe_Email_Alert = '$dbSubscribe_Email_Alert', Subscribe_SMS = '$dbSubscribe_SMS',  Address_firstname = '$dbAddress_firstname', Address_lastname = '$dbAddress_lastname', Address = '$dbAddress', city = '$dbcity', pincode = '$dbpincode', state = '$dbstate', country = '$dbcountry'      where username = '$dbusername' ");

header("location:my_account.php");


//}

//else

//{
//die();

//}


?>

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

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

I get the following error when I try to pass a value to a methiod in a loop:

Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670

This one has me very baffled. It will work the first time, and seems to work every other time, so I have no clue what is wrong. Here is the code:

This code is part of my "display" class:

function display_partner ($type,$loc,$rand=0,$narrow=0) {
$this->partners = new partner($this->cxn);
$display = '
<div id="cont_info" class="partner-list">
<div>
<h3 class="settings">'.ucfirst($loc).' '.ucfirst($type).last_letter($type).'s</h3>
</div>
<div class="settings-value" style="height:12px;padding:0;margin:0;text-align:right;padding-right:10px;">
<a href="" class="trunc">Add your organization to this list</a></p>
</div>
<div style="height:2px;padding:0;margin:0;">
<hr class="account" />
</div>
';
$ids = $this->partners->get_partners_list($type,$loc,$rand);
for ($b=0;$b<sizeof($ids->id);$b++) {
$this->partnerID = $ids->id[$b];
$display .= ($narrow)? $this->card_partner_narr():$this->card_partner();
if ($b!=(sizeof($ids->id)-1)) { $display .= '<hr class="account" />'; }
}

if (sizeof($ids->id)==0) {
$display .= '<div style="color:#999999;display:line;text-align:center;height:20px;">No Partners found for '.ucfirst($loc).' '.ucfirst($type).'</div>';
}

$display .= '
</div>';

return $display;

}

function card_partner () {
$this->partners->set_partner_id($this->partnerID);
$part_info = $this->partners->get_partner_info();
if ($part_info) {
$display .= '
<table class="settings">
<tr>
'.$this->show_if($part_info['partLogo']['val'],'<td class="settings-value" rowspan="2"><img src="'.LOGO_FOLDER.$part_info['partLogo']['val'].'" '.resize_img(LOGO_FOLDER.$part_info['partLogo']['val'],175).'alt="'.$part_info['partName']['val'].'" /></td>').'
<td class="settings-value" colspan="2"><h5>'.$part_info['partName']['val'].'</h5></td>
</tr>
<tr>
<td class="settings-value">
<span style="color:999999;">'.$part_info['partAddress']['val'].'<br />
'.$part_info['partCity']['val'].', '.$part_info['partST']['val'].' '.$part_info['partZIP']['val'].'<br />
'.$part_info['partPhone']['val'].'</span><br />
<a href="'.$this->form->show_href($part_info['partWeb']['val']).'" target="_blank">'.$part_info['partWeb']['val'].'</a>
</td>
<td class="settings-value">'.$part_info['partInfo']['val'].'</td>
</tr>
</table>
';
}

return $display;
}



This code is part of my "partners" class:

function set_partner_id($partID) {
echo '<p>partID: '.$partID.' '.gettype($partID).'<br>
$this->partner->id: '.$this->partner->id.'</p>';
$this->partner->id = $partID; ///*** ERROR HAPPENS HERE ***/
echo '<p>id set: '.$this->partner->id.'<br>
$this->partner->id: '.$this->partner->id.'</p><hr>';
}

function get_partner_id() {
return $this->partner->id;
}

// gets user info at login
function get_partner_info() {
$this->partner = $this->cxn->proc_info('partner','partID',$this->partner->id);//$this->partner->id
return $this->partner;
}


The following is the output generated:

partID: 24 string
$this->partner->id:
id set: 24
$this->partner->id: 24

partID: 26 string
$this->partner->id:
Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670
id set:
$this->partner->id:

partID: 17 string
$this->partner->id:
id set: 17
$this->partner->id: 17


partID: 25 string
$this->partner->id:
Warning: Attempt to assign property of non-object in /Users/staceyschaller/Sites/dev_zone/ckwv2/classes/class.php on line 670
id set:
$this->partner->id:

As you can see, the value passes to $this->set_partner_id($partID) each time. It is formatted as a string. When it assigns the value to $this->partner->id, however, sometimes it works, and sometimes it doesn't. It's probably something obvious, but I've racked my brain to see what it is. Any ideas?

Now that i have my code that shows my list on the localhost I want to try and put this into a table and beable to add a delete from the table. Here's my code any help would be much appreciated.

<?PHP
// please add login and pass here//
$host = "localhost";
$login  = "root" ;
$pass  = "";

mysql_connect("$host","$login","$pass") OR DIE
        ("There is a problem with the system.  Please notify your system administrator." .mysql_error());

//Seems in this case we can use a general call
$connection = mysql_connect("$host","$login","$pass") or die(mysql_error());

$dbs = @mysql_list_dbs($connection)or die(mysql_error());
$db_list="<ul>";

$i =0;

while ($i < mysql_num_rows($dbs)){
    $db_names[$i] = mysql_tablename($dbs,$i);

    $db_list .="<li>$db_names[$i]";

    $i++;
    }


//Start Create DB//
IF (isset($_POST['result'])){
$database=$_POST['database'];
$sql="CREATE DATABASE $database ";
$result = mysql_query($sql,$connection) or die(mysql_error());
echo "Database $database has been added";

}

IF (isset($_POST['delete'])){
$db=$_POST['db'];
$query=mysql_query("DROP DATABASE $db");
echo "Database $db has been deleted";

}
?>
<html>
<head>
<title>MySQL Databases</title>
</head>
<body>
<p><strong>Databases on localhost</strong>:</p>
<? echo "$db_list"; ?>


<?PHP
//print_r($_POST);
?>
<form action="pretask.php" method="post">
<select name="db">
<?PHP
$db_list = mysql_list_dbs($connection);
while ($row = mysql_fetch_object($db_list)) {
//Here you are listing anything that should not be included
if ($row->Database!="information_schema" && $row->Database!="mysql" && $row->Database!="phpmyadmin"){
echo "<option value=\"".$row->Database."\">".$row->Database."</option>";

 }

}

?>
</select>
<input type="submit" name="delete" value="Delete"/>
</form>
<form action="pretask.php" method="post">
Create Database <input type="text" name="database" />
<input type="submit" name="result" value="Create" />
</form>
</body>

Good evening,

Im using GenRandomString, and wondered how I can get $confirm to keep its first value throughout my script.
I have put comments on the lines that use $confirm.
Do I need to change $confirm to a constant and how can I go about this?

$firstname = $_GET['firstname'];
$lastname = $_GET['lastname'];
$companyname = $_GET['companyname'];
$doornumber = $_GET ['doornumber'];
$street = $_GET ['street'];
$town = $_GET['town'];
$postcode = $_GET['postcode'];
$useremail = $_GET ['usermail'];
$telephone = $_GET['telephone'];
$shortcode = substr($postcode,0,2);
function genRandomString() {
$length = 10;
$characters = '0123456789abcdefghijklmnopqrstuvwxyz';
$string = "";    
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters))];}
return $string;}
$confirm = genRandomString(); //creating a random number
$query =mysql_query
("INSERT INTO treesurgeons (firstname, lastname, companyname, doornumber, street, town, postcode, useremail, telephone, Id) 
  VALUES ('$firstname', '$lastname', '$companyname','$doornumber', '$street', '$town', '$postcode', '$useremail', '$telephone', '$confirm')");//1st Value
echo mysql_error();
echo "<p>Thankyou for submiting your details.\r\n Please check your inbox and click on your confirmation link.</p>";
$message = "The following details have been submited to the tree directory and are awaiting confirmation;
 \r\n Please click on the link below to confirm these details are correct\r\n
 '$firstname', '$lastname', '$companyname','$doornumber', '$street', '$town', '$postcode', '$usermail', '$telephone'
<a href='http://www.mywebsite.co.uk/confirmed.php?Id=$confirm'>"; //2nd Value 
$subject = "Your tree directory details";
$to = "$useremail";
$email = "$emailad";
mail( "$to", "$subject","$message", "$headers"); 
?></body></html>

I havent really played around with constants before, so please an advice appreciated! 
Im guessing im using DEFINE but im unsure how I would combine this with GenRandomString in my code.

I have a form created with code already written. I am in need of a push in the right direction or a potential tutorial on this issue i have. I am running a fanatsy golf website where the user will pick one golfer each week and the cannot select them again. Is there a way I can remove that data from the list for the next week when the user makes his selection or can I have that data another color and unselectable. If you want code, please let me know and i can provide it. Thanks in advance for your help.


p.s. the list data is stored in a MySQL database.

$link	=	?><a href="post?id=<?php echo $id; ?>&title=<?php echo $slug_title; ?>"><?php echo $title; ?></a><?php

Basically what I am trying to do is get a url link of a current page that I'll be sending in an email. I have all the $_GET variables I need to duplicate the current url.  For some reason it's giving me an error.    Can you please fix what is shown above into something that'll work?   Thanks.
Edited by man5, 15 July 2014 - 07:09 PM.

So what i mean is if i set a variable to "[" ($some_variable = "[") the rest of my code is now going to go CRAZY because there is an open [. Is there a way I can just make everything inside the first set of "" not relevant to the code? thanks!

I run these functions to find the key of a given element inside an array.  Like so;

$ban_ip_file = file("ip_file.txt");
foreach($ban_ip_file as $key => $value)
{
$value = trim($value);
if($value == $ip_from_form)// passed to page by a form
$set = $key;
}

How do I make $set available for testing and file writing further down the script?

Tried assigning global $set; just above the $set=$key; ----but it did not work.

nothing gets put into the select list