When I do something like the following:
$site = ORM::factory( site )->where( name , = , Test Site )->find();
$users = $site->users;
$deletedusers = $users->where( deleted , = , 1 )->find_all();
$nondeletedusers = $users->where( deleted , = , 0 )->find_all();
The contents of $deletedusers is correct, but the $nondeletedusers contains every non-deleted user, not just the ones in the loaded $site.
What am I doing wrong?
Its because of find_all() and find() methods will reset your model state. For example, $user has a where( site_id , = , <site_id>) condition (it was applied in the line#1 of your code). When you call find_all(), ORM resets all conditions, so $nondeletedusers works with empty model.
To avoid this behavior, you can try to clone $users, or retrieve all users ids from $user and add AND WHERE id IN <id list> condition.
I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
I found this script online that creates a thumbnail out of a image but the thumbnail image is created with poor quality how can I improve the quality of the image. And is there a better way to create ...
如何确认来自正确来源的数字。
Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...
I wonder there is a way to post a message to a facebook business page with cURL? thanks
I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...
How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...