[Writing to open documents]

awesome..thanks

[Writing to open documents]

I am trying to write to a document that is open doc format.

 

Are there any libraries that help out with this specifically mailing labels?

[Check this out recursive]

Haha I found my problem.  It would help if I added the value of the recursion to the return value.  Ha.  Thanks for your help though.

[Check this out recursive]

Not quite what I'm after.  The userID changes based on the children found.  We then find their children and count those as well.  So each user found can have their own set of children and this can continue for 8 levels.

[Check this out recursive]

Here is another version that only displays the first level.... any help is appreciated.

        public function getBonusChildren($userID)
        {
	// retrieve all children of $parent
	$sql = 'SELECT userID FROM jos_backoffice_users WHERE parentID ="'. $userID .'";';
	$stmt = conn::getInstance()->prepare($sql);
	$stmt->execute();

        	while($row = $stmt->fetchObject())
	{
                	$memStatus = checkUserMemStatus($row->userID);

                	if($memStatus == true)
                	{
                    		$memberCounter++;
			$this->getBonusChildren($row->userID);
                	}
	}
	return $memberCounter;
}

[Check this out recursive]

        public function getBonusChildren($userID)
        {
	if($userID != NULL)
	{
		$sql = 'SELECT COUNT(*) AS count, userID FROM jos_backoffice_users WHERE parentID= ' . $userID . ';';
		$stmt = conn::getInstance()->prepare($sql);
		$stmt->execute();
                	$obj = $stmt->fetchAll(PDO::FETCH_ASSOC);
		if(is_object($obj))
		{
			$obj->count += $this->getBonusChildren($obj->userID);
		}
	}
                return $obj->count;
}

 

I get no error.  It just always return null.  How can I get this done?

[prepared queries recommendation]

I see.  This prevents all forms of injection?

[prepared queries recommendation]

ahh...whats the point of that then?  Is there any way to have it stay prepared for all user sessions?  It is like loading program resources into memory much faster.

[prepared queries recommendation]

How many queries should I limit myself to preparing?  Is there any overhead I should be worried about?  Do the prepared queries only stay "prepared" for one session or does it stay prepared as long as the server hasn't restarted?

[[Game] Time Underground (beta) Critique Appreciated]

It was alright man.  Although I'm personally not into browser games nice work though.

[mysql Insertion errors]

I have a news posting system I created and it works fine although I have issues with insertion errors.  I have avoided using add slashes because I often post code and I don't want it to interfere with that.  I would also like to be able to include html in my posts.  I have been using the html encode function and then decoding it on the way out, but this isn't really the way I want to do it and I often get errors on insertion still.

 

Any suggestions?

[Can someone check my registration script?]

No you should also use salt on your passwords.

[Can someone check my registration script?]

Whats the speed comparison with something like this? http://pear.php.net/manual/en/package.html.html-quickform.tutorial.php

 

Seems kind of outrageous to me.

 

You could use a function like this at the top of a header page instead of an MVC design pattern which is in my opinion over kill for a web application although the MVC pattern does make all the new graduates giddy with excitement because the first language they learned was Java and it is so object oriented.

 

	function SECURITY($debug){
	if((count($_POST)!=0) || (count($_GET)!=0)){
		if(count($_POST)!=0){
			foreach($_POST as $key => $val){
				$val = addslashes($val);
				$val = htmlspecialchars($val);
				$val = mysql_real_escape_string($val); 
				$_POST[$key] = $val;
				if($debug==1){
					echo "POST ARRAY - Field : $key Value: $val<br />";
				}
			}
			return $_POST;
		}elseif(count($_GET)!=0){
			foreach($_GET as $key => $val){
				$val = addslashes($val);
				$val = htmlspecialchars($val);
				$val = mysql_real_escape_string($val);
				$_GET[$key] = $val;
				if($debug==1){
					echo "GET ARRAY - Field : $key Value: $val<br />";
				}
			}
			return $_GET;
		}else{
			die("ERROR with the http phaser");
		}
	}
}

 

You would also want to make sure no one could access any script individually.

[change to link]

I appreciate the post, but I am not sure what to do with that.  I am not trying to code a bunch of javascript and I also don't want to use some bloated library.  I just need ajax to add a +1 or -1 on my site for a user rating news system type of thing.  I have found tons and tons of them that use forms, but I was hoping to just use a link click then after it is clicked to show the results.

 

Real simple no extras.  Thanks for any help.

[change to link]

I am still looking for some help.  Can anyone tell me or point me in the right direction.

[compare array]

in_array worked great thank you.

[compare array]

I need to compare an array, but I am not sure how.  I wanted to compare an array in an if statement with a GET variable.

 

$array = array('test1', 'test2'
);

if($_GET['check']!=$array){
     $this = $default;
}

[Why doesn't my hit counter code work?]

This might not be what you want, but I made a little counter that is pretty simple if you want to check it out go to http://www.kinggoddard.com/portfolio.php and look at the image counter and text counter.  You could easily modify it to do more.

[change to link]

I was looking at the tutorials and I am following along pretty well, but I would like to be able to use pictures or links instead of forms to send data.

 

Using this as my example how would I use a link instead of a form to send info

 

http://www.w3schools.com/PHP/php_ajax_poll.asp

 

Thanks.

[W3C ajax examples]

Alright thanks.

[W3C ajax examples]

Oh it wasn't that I was getting errors I was wondering security wise.  I am not far into ajax and I was curious.

[W3C ajax examples]

Has anyone noticed any problems with these examples?

 

http://www.w3schools.com/PHP/php_ajax_database.asp

 

I guess if you ignore any of the PHP code is what I'm talking about.  The ajax itself.

[captcha not cutting it]

Any other ideas?

[captcha not cutting it]

I remember reading something about this one being beaten by bots as well.

[captcha not cutting it]

On my site I use a captcha to attempt and stop spam bots from registering at my site.  So far it has worked fairly well, but I am still getting bots probing and getting through every once in awhile.  I need to beef it up.  Any recommendations?