PHP - Assigning Div Content To Php Variable

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

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

I will start off trying to explain what I am trying to make the best I can. What I want to create is a script that gets the gold value from this website: http://www.lbma.org.uk/pages/index.cfm?page_id=46&title=current_statistics and then save it to a variable which I will use to calculate values of different gold karats.

Here is the content in bold I need on the website I linked:
Quote

LONDON GOLD FIXING
          USD             GBP              EUR
AM   1588.00     1005.127      1251.083
PM   1589.50     1004.741     1249.803




So what help do I need? Well, I don't expect you to figure out the calculating part for me but some help how to get that content pointed out above and save it to a variable is what I would appreciate getting some help with.

I don't know much PHP, only some and I have been trying to figure this out for a day now without any success.  I suppose php get contents and/or curl should be used here but I don't know how really. I would very much appreciate the help I can get on this.

Thank you!

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?

I am trying to retain information from the $get variable after checking if a user, (Joomla code), is logged in but it is not working. (url: http://domain.com/script.php?file=data)

define( '_JEXEC', 1 );
define( 'DS', DIRECTORY_SEPARATOR );
define('JPATH_BASE', '/path/to/joomla/dir/');
require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
$mainframe =& JFactory::getApplication('site');
$mainframe->initialise();
$session =& JFactory::getSession();
$user =& JFactory::getUser();
// get username and name of user
$username = $user->get('username');
$name = $user->get('name');
if (empty($username)) {
    die('Not logged in');
}
   $file = $_GET['file'];
   echo &file;
   exit;
Any help appreciated.

I am making  a website where writers can share stories.
One of the fields is other stories.
So I used this code to make it a array with the links in each f the items.

$other_split = explode(',', $other_form);
$other_int = count($other_split);

$x = 0;
while ($x>$other_int)
{

$other_link[$x] = "<a href = '$other_split[$x]'> Chapter $x </a>";
}


How can I insert the data in that array into one non array variable.

Hello World,

I need some tips on how to make a button that does something like the code below.
 
.......echo '<tr><td align="left"><a href="add_cart.php?pid=' . $row1['item_id'] . '">Add to Cart</a></td>........

I've been messing with html form and button type with no success. This code does the job but I prefer a button.

Thanks

$showCountSql      =   "select cad_count from counteraccountdtl WHERE cad_userid =".$_SESSION['UID']." LIMIT 1";
$showCountresult    =    mysql_query($showCountSql);
$showCountrow      =    mysql_fetch_array($showCountresult);
$newCount      =   $showCountrow[cad_count];


if(is_int($newCount))
 echo "Value  is Integer";
else
 echo "Value not Integer";


i m fetching value by Mysql "cad_count integer(5)" and  feild then i cheak this value is interger  or not it show the "Value not Integer". What is wrong in it ???

Hi, I want to be able to let user type in xml text and it will be parsed and uploaded to db, but it doesn't work, it just keeps redirecting me back to this form below!

here is html form:
Code: [Select]
<html>
 <body>
   <form method='post' method='form.php'>
     <p>
        <textarea name="pastedXML" rows="10" cols="30">
    Please paste your xml file here.
        </textarea>
     </p>
      <p>
         <input type="submit" value="Convert to SQL" name="textXML" />
      </p>
   </form>

  </body>
</html>

Here is script (form.php;I just want to retrieve the contents typed in text area to store to variable...how??)
Code: [Select]
<?php
//get the text in textarea and shred it!
if(isset($_POST['textXML']))
print $_POST['pastedXML'];
?>

Any help much appreciated!

Hi there.

How do I reflect the text content of the variable $a in this text form:

<input type="text" name="artist">

Regards Morris

I just have a quick question, what happens if I don't assign a visibility element to methods?

In other words, if I just have:

[php]
class Article_model
{
   public $data;

   function index()
   {
      return $data;
   }
[php]
...instead of declaring public, private, static, and so on before the function. Will php just consider it public?

I have two tables in my MySQL database:

1. user
user_id | firstname | lastname | nickname etc.

and

2. con (for contribution)
con_id | user_id (foreign key) | name | contribution | category etc.


Here's how I wanted to solve the problem of assigning the foreign key to the 2nd table (I'm a beginner so bear with me. )

When logging in, I assigned the user_id to the session variable like this:

// do the while loop

while ($assoc = mysqli_fetch_assoc($rows)) {

// assign database COLUMNS to the variables

$dbuser_id = $assoc['user_id'];

$dbuser_name = $assoc['nickname'];

$dbuser_password = $assoc['password'];

etc.....................


// set a session after login

$_SESSION['user'] = $dbuser_name . $dbuser_id;



This prints out the user_id just like I wanted to:


echo "Your user_id is: " . $_SESSION['user_id'] = $dbuser_id;


Gives:
Code: [Select]
Your user_id is: 35


... and this is how the assignment of the foreign key looks like WHILE posting the contribution:


 $user_id = $_SESSION['user'] = $dbuser_id;

  if (!empty($knuffix_name) && !empty($knuffix_category) && !empty($knuffix_contribution)) {
      // Write the data into the database
      $query = sprintf("INSERT INTO con (con_id, user_id, name, contribution, category, contributed_date) VALUES (' ', '$user_id', '%s', '%s', '%s', now())",

mysqli_real_escape_string($dbc, $knuffix_name),

mysqli_real_escape_string($dbc, $knuffix_contribution),

mysqli_real_escape_string($dbc, $knuffix_category));



When I now do a contribution through the input areas, nothing gets inserted into the database and I automatically get logged out. Obviously it's not working as I thought it would and I'd like to know why is that?
Notice that if I take the user_id part OUT, it's working again, so the rest of the code must be right then.

Another question I have is:
Is this common practice to solve this problem of assigning a foreign key, or is there a better way of doing it?

I need to assign unknown array keys and their values to strings.

The code I am using is:
Code: [Select]
$cart = $_SESSION['cart'];
$items = explode(',',$cart);
$qty = array();


foreach ($items as $item) {
$qty[$item] = $qty[$item] + 1;
}
print_r($qty);
The keys change and are not ordered. I do not know what the key or it's value may be.  So as an example, I might have:
Code: [Select]
Array ( [2] => 5 [4] => 8 ) or in a different scenario, I might have:
Code: [Select]
Array ( [1] => 6 )
What those numbers represent is a product id (the key), and the quantity (the value of the key).

Can someone help me to assign these to a string?  I have been reading all morning, and not making any progress. 

Thank you!