How to use notIn method of name class

Best Prophecy code snippet using name.notIn

get_feed.php

Source:get_feed.php

...57        $response = $res->fetch_all(MYSQLI_ASSOC);58        $response = json_encode($response);59        return 0;60    }61    public function Recent(&$response, &$notIn, &$count = 10)62    {63        $notIn = $this->conn->real_escape_string($notIn);64        $count = $this->conn->real_escape_string($count);65        $res = $this->conn->query("SELECT66                qn.Id  as Ids67                FROM68                Question qn69                WHERE qn.Id NOT IN ($notIn)70                ORDER BY qn.LastActive DESC71                LIMIT $count72            ;") or die($this->conn->error);73        if ($res->num_rows == 0) { // $notIn contains all of our posts.74            $response = 1;75            return 1;76        }77        $res = $res->fetch_all(MYSQLI_NUM);78        /* Join those ids with comma */79        $questions = "";80        for ($i = 0; $i < count($res) - 1; $i++) {81            $questions .= $res[$i][0] . ",";82        }83        $questions .= $res[count($res) - 1][0];84        /**************/85        return $this->makePosts($questions, $response);86    }87    public function searchQuery($query, &$response, $notIn, $count)88    {89        /*90         * SearchQuery() method also do not gurantee the result to $count91         * and i also don't know why92        */93        $query = $this->conn->real_escape_string(trim(urldecode($query)));94        $notIn = $this->conn->real_escape_string(trim(urldecode($notIn)));95        $count = $this->conn->real_escape_string(trim(urldecode($count)));96        if (strlen($query) == 0) { // empty query97            $this->Recent($response, -1);98            return 1;99        }100        $res = $this->conn->query("SELECT101                qn.Id as Ids102                FROM Question qn103                LEFT JOIN104                QuestionTag qt ON qt.Question=qn.Id105                LEFT JOIN106                Tags tg ON tg.Id=qt.Tag107                LEFT JOIN Answer ans ON ans.WrittenFor=qn.Id108                LEFT JOIN User user ON (user.Id = ans.Author) OR (user.Id = qn.Author)109                WHERE110                (111                    (qn.URLTitle LIKE '%$query%') OR112                    (qn.Title LIKE '%$query%') OR113                    (CONCAT(user.FirstName, user.LastName) LIKE '%$query%') OR114                    (tg.Name LIKE '%$query')115                ) AND116                qn.Id NOT IN ($notIn)117                LIMIT $count118        ;") or fail($this->conn->error, __LINE__);119        if ($res->num_rows == 0) {120            return 1;121        }122        $res = $res->fetch_all(MYSQLI_NUM);123        /* Join those ids with comma */124        $questions = "";125        for ($i = 0; $i < count($res) - 1; $i++) {126            $questions .= $res[$i][0] . ",";127        }128        $questions .= $res[count($res) - 1][0];129        /**************/130        return $this->makePosts($questions, $response);131    }132    public function postedBy($person, &$response, &$notIn, &$count)133    {134        $person = $this->conn->real_escape_string(trim(urldecode($person)));135        $notIn = $this->conn->real_escape_string(trim($notIn));136        $count = $this->conn->real_escape_string(trim($count));137        $res  = $this->conn->query("SELECT138                qn.Id FROM139                Question qn140                LEFT JOIN141                User user On user.Id = qn.Author142                WHERE user.UserName='$person'143                AND qn.Id NOT IN ($notIn)144                LIMIT $count145        ;") or fail($this->conn->error, __LINE__);146        if ($res->num_rows == 0) {147            $response = 1;148            return 1;149        }150        $res = $res->fetch_all(MYSQLI_NUM);151        /* Join those ids with comma */152        $questions = "";153        for ($i = 0; $i < count($res) - 1; $i++) {154            $questions .= $res[$i][0] . ",";155        }156        $questions .= $res[count($res) - 1][0];157        /**************/158        return $this->makePosts($questions, $response);159    }160    public function answerBy($person, &$response, &$notIn, &$count)161    {162        $person = $this->conn->real_escape_string(trim(urldecode($person)));163        $notIn = $this->conn->real_escape_string(trim($notIn));164        $count = $this->conn->real_escape_string(trim($count));165        $res  = $this->conn->query("SELECT166                qn.Id FROM167                Question qn168                LEFT JOIN169                Answer ans ON ans.WrittenFor = qn.Id170                LEFT JOIN171                User user ON user.Id = ans.Author172                WHERE user.UserName='$person'173                AND qn.Id NOT IN($notIn)174                LIMIT $count175        ;") or fail($this->conn->error, __LINE__);176        if ($res->num_rows == 0) {177            $response = 1;178            return 1;179        }180        $res = $res->fetch_all(MYSQLI_NUM);181        /* Join those ids with comma */182        $questions = "";183        for ($i = 0; $i < count($res) - 1; $i++) {184            $questions .= $res[$i][0] . ",";185        }186        $questions .= $res[count($res) - 1][0];187        /**************/188        return $this->makePosts($questions, $response);189    }190    public function bookmarkBy($person, &$response, &$notIn, &$count)191    {192        $person = $this->conn->real_escape_string(trim(urldecode($person)));193        $notIn = $this->conn->real_escape_string(trim($notIn));194        $count = $this->conn->real_escape_string(trim($count));195        $res  = $this->conn->query("SELECT196                    qn.Id197                    FROM Question qn198                    LEFT JOIN199                    UserBookmarks ub IN ub.Question=qn.Id200                    WHERE ub.User=$person201                    AND qn.Id NOT IN ($notIn)202                    LIMIT $count203        ;") or fail($this->conn->error, __LINE__);204        if ($res->num_rows == 0) {205            $response = 1;206            return 1;207        }208        $res = $res->fetch_all(MYSQLI_NUM);209        /* Join those ids with comma */210        $questions = "";211        for ($i = 0; $i < count($res) - 1; $i++) {212            $questions .= $res[$i][0] . ",";213        }214        $questions .= $res[count($res) - 1][0];215        /**************/216    }217    public function activityBy($person, &$response, &$notIn, &$count)218    {219        /*220         * For activityBy() function we cannot gurantee that returened question can match 221         * $count paramater222         * At worst case it will be twise(when user has many answer and many question too)223         * but it will nor exceed $count*2224        */225        $got = $this->postedBy($person, $response, $notIn, $count);226        $res = ($got == 0) ? json_decode($response) : array();227        $got = $this->answerBy($person, $response, $notIn, $count);228        $response  = json_encode(229            array_merge(230                $res,231                ($got == 0) ? json_decode($response) : array()232            )233        );234    }235    public function taggedFor($tag, &$response, &$notIn, &$count)236    {237        $tag = $this->conn->real_escape_string(trim($tag));238        $notIn = $this->conn->real_escape_string(trim($notIn));239        $count = $this->conn->real_escape_string(trim($count));240        $res  = $this->conn->query("SELECT241                qt.Question242                FROM QuestionTag qt243                WHERE qt.Question NOT IN ($notIn)244                AND qt.Tag=(SELECT245                    Id FROM Tags Where Name='$tag'246                ) LIMIT $count;247        ;") or fail($this->conn->error, __LINE__);248        if ($res->num_rows == 0) {249            $response = 1;250            return 1;251        }252        $res = $res->fetch_all(MYSQLI_NUM);253        /* Join those ids with comma */254        $questions = "";255        for ($i = 0; $i < count($res) - 1; $i++) {256            $questions .= $res[$i][0] . ",";257        }258        $questions .= $res[count($res) - 1][0];259        /**************/260        return $this->makePosts($questions, $response);261    }262};263if ($_SERVER['REQUEST_METHOD'] == 'POST') {264    if (265        (isset($_POST['NotIn']) == false) ||266        (isset($_POST['Count']) == false) ||267        (isset($_POST['LoadQuestion']) == false) ||268        (isset($_POST['Param']) == false)269    ) {270        echo 2;271        //echo "Not all paramater found...";272        exit;273    }274    $notIn = trim($_POST['NotIn']);275    $count = trim($_POST['Count']);276    $param = trim(urlencode($_POST['Param']));277    $loadQuestion = trim($_POST['LoadQuestion']);278    if (strlen($count) == 0 || strlen($notIn) == 0 || strlen($param) == 0) {279        echo 2;280        //echo "Empty paramater...";281        exit;282    }283    $handler = new Getfeed;284    $notIn = json_decode($notIn);285    $notIn = implode(',', $notIn);286    $response = "";287    $res = 1;288    if ($loadQuestion == 'Recent') {289        $res = $handler->Recent($response, $notIn, $count);290    } else if ($loadQuestion == 'TaggedFor') {291        $res = $handler->taggedFor($param, $response, $notIn, $count);292    } else if ($loadQuestion == 'QuestionBy') {293        $res = $handler->postedBy($param, $response, $notIn, $count);294    } else if ($loadQuestion == 'AnswerBy') {295        $res = $handler->answerBy($param, $response, $notIn, $count);296    } else if ($loadQuestion == 'BookmarkBy') {297        $res = $handler->bookmarkBy($param, $response, $notIn, $count);298    } else if ($loadQuestion == 'ActivityBy') {299        $res = $handler->activityBy($param, $response, $notIn, $count);300    } else if ($loadQuestion == 'SearchQuery') {301        $res = $handler->searchQuery($param, $response, $notIn, $count);302    } else { // unknown feed request..303        echo 2;304        //echo "Unknown Request...";305        exit;306    }307    if ($res == 0) {308        echo $response;309    } else {310        echo $res;311    }312}...

demo_new.php

Source:demo_new.php

1<style type="text/css">2.error { border: solid red 1px; color: red; }3.ok { border: solid green 1px; color: green; }4</style>5<link rel="stylesheet" type="text/css" media="screen" href="../../css/screen.css" /> 	6<?php 7include('db.php') ;8$routine_id = $_REQUEST['routine_id'];9$branch_id = $_REQUEST['branch_id'];10/*$period_array = array();11$sql_period = "select `period_id`, `break_flag` from `std_class_period` where `branch_id`='$branch_id' and `flag`=1 order by `start_time`";12$res_period = mysql_query($sql_period);13while($row_period = mysql_fetch_array($res_period))14{15	$period_array[] = array('period_id'=>$row_period[0],'break_flag'=>$row_period[1]);16}17$search_period = 3;18myArraySrch($search_period);19//echo array_search($search_period,$period_array);20function myArraySrch($search_period)21{22	global $period_array;23	foreach($period_array as $key => $value)24	{25		if($value['period_id'] == $search_period){26			echo $value['break_flag'];27			echo $key;//return index 28			break;29		}30	} 31}*/32$sql_routine_info = "select * from `std_class_routine_new` where `active_flag`=1 and `id`=$routine_id and `branch_id`='$branch_id'";33$res_routine_info = mysql_query($sql_routine_info);34while($row_routine_info=mysql_fetch_array($res_routine_info))35{36	$day = $row_routine_info['day'];37	$period_id = $row_routine_info['period_id'];38	$class_id = $row_routine_info['class_id'];39	$section_id = $row_routine_info['section_id'];40	$teacher_id = $row_routine_info['teacher_id'];41	$subject_id = $row_routine_info['subject_id'];42}43$teach_ids_notin_prd = '-1,';44$teacher_cndtn = '';                    45if($teacher_id!=0)46{47	$teacher_cndtn = ' and `teacher_id`!='.$teacher_id;48}49	$sql_teach_ids_notin_prd = "select `teacher_id` from `std_class_routine_new` where `day`=$day and `period_id`=$period_id $teacher_cndtn and `branch_id`=$branch_id";50	$res_teach_ids_notin_prd = mysql_query($sql_teach_ids_notin_prd);51	if(mysql_num_rows($res_teach_ids_notin_prd))52	{53		while($row_teach_ids_notin_prd=mysql_fetch_array($res_teach_ids_notin_prd))54		{55			$t_id = $row_teach_ids_notin_prd[0];56			if($t_id!=0)57				$teach_ids_notin_prd.=$t_id.',';	58		}		59	}60	61$teach_ids_notin_prd .= '-1';62$sub_ids_notin_prd = '-1,';63                    64if($subject_id!=0)65{66	$sql_sub_ids_notin_prd = "select `subject_id` from `std_class_routine_new` where `day`=$day and `period_id`=$period_id and `subject_id`!=$subject_id and `class_id`=$class_id and `branch_id`=$branch_id";67	$res_sub_ids_notin_prd = mysql_query($sql_sub_ids_notin_prd);68	if(mysql_num_rows($res_sub_ids_notin_prd))69	{70		while($row_sub_ids_notin_prd=mysql_fetch_array($res_sub_ids_notin_prd))71		{72			$sub_id = $row_sub_ids_notin_prd[0];73			if($sub_id!=0)74				$sub_ids_notin_prd.=$sub_id.',';	75		}		76	}77	78}79$sub_ids_notin_prd .= '-1';80?>81<!--<hr> -->82<fieldset>83	<legend>Add/Edit Routine Data</legend>84	<form method="POST"  action="">85    	<table style="border:0px;" cellpadding="10" cellspacing="5">86            <!--<tr>87                <td><label>Break</label></td>88                <td><select name="break_flag" id="break_flag">89                    <option value="0">No</option>90                    <option value="1"> Yes</option>91                </select>92                </td>93            </tr> -->94            <tr>95                <td><label>Teacher</label></td>96                <td><select name="teacher_list" id="teacher_id">97                    <option value="0">-Select-</option>98                    <?php99					$sql_teacher = "select `id`,`teacher_name` from `std_teacher_info` where `branch_id`='$branch_id' and `id` not in ($teach_ids_notin_prd)";100					$res_teacher = mysql_query($sql_teacher);101					while($row_teacher=mysql_fetch_array($res_teacher))102					{103						$selected_t = '';104						if($row_teacher[0]==$teacher_id)105							$selected_t = 'selected="selected"';106						echo '<option value="'.$row_teacher[0].'" '.$selected_t.'>'.$row_teacher[1].'</option>';107					}108					?>109                </select>110                </td>111            </tr>    112            <tr>113            	<td><label>Subject</label></td>114            	<td><select name="sub_list" id="sub_list">115                	<option value="0">-Select-</option>116                    <?php117					$sql_sub = "select `id`,`subject_name` from `std_subject_config` where `branch_id`='$branch_id' and `class_id`=$class_id and `id` not in ($sub_ids_notin_prd)";118					$res_sub = mysql_query($sql_sub);119					while($row_sub=mysql_fetch_array($res_sub))120					{121						$selected_s = '';122						if($row_sub[0]==$subject_id)123							$selected_s = 'selected="selected"';124						echo '<option value="'.$row_sub[0].'" '.$selected_s.'>'.$row_sub[1].'</option>';125					}126					?>127            	</select>128                </td>129            </tr>130            <!--<tr>131            	<td><label>Extand With</label></td>132                <td>133                	<input type="radio" name="extand_with" id="extand_withNone" value="none" checked="checked" />&nbsp;None&nbsp;134                    <input type="radio" name="extand_with" id="extand_withNxt" value="nxt" />&nbsp;Next&nbsp;135                    <input type="radio" name="extand_with" id="extand_withPrev" value="prev" />&nbsp;Previous&nbsp;136                </td>137            </tr> -->    138			<tr>139            	<td>&nbsp;</td>140                <td><input type="submit" name="save" id="save" value="save" /><input type="hidden" name="id" value="<?php echo $_REQUEST['routine_id'];?>"/><input type="hidden" name="h_day" id="h_day" value="<?php echo $day;?>" /><input type="hidden" name="h_period" id="h_period" value="<?php echo $period_id;?>" /></td>141			</tr>142		</table>143    </form>    144	<legend>145</fieldset>146<?php 147if(isset($_REQUEST['save']))148{149	$sel_tch = $_REQUEST['teacher_list'];150	//echo '<br />';151	$sel_sub = $_REQUEST['sub_list'];152	//echo '<br />';153	//$extand_with = $_REQUEST['extand_with'];154	$extand_with = 'none';155	//echo '<br />';156	$sel_day = $_REQUEST['h_day'];157	$sel_period = $_REQUEST['h_period'];158	$rtn_id = $_REQUEST['id'];159	if($extand_with=='none')160	{161		/*$sql_chk_t = "select `id` from `std_class_routine_new` where `day`=$sel_day and `period_id`=$sel_period and `teacher_id`=$sel_tch";162		$res_chk_t = mysql_query($sql_chk_t);163		if(mysql_num_rows($res_chk_t)>0)164		{165			echo '<font style="color:#FF0000; font-weight:bold;">>This Teacher already has class in this period!!!</font>';166		}*/167		$sql_up = "update `std_class_routine_new` set `teacher_id`=$sel_tch, `subject_id`=$sel_sub where `id`=$rtn_id";168		if(mysql_query($sql_up)){169			echo '<font style="color:#006600; font-weight:bold;">Your Action was Successfull!!!</font>';170		}171	}172}173?>...

notIn

Using AI Code Generation

1$names = new name();2$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','name11','name12','name13','name14','name15','name16','name17','name18','name19','name20'));3$names = new name();4$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','name11','name12','name13','name14','name15','name16','name17','name18','name19','name20'));5$names = new name();6$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','name11','name12','name13','name14','name15','name16','name17','name18','name19','name20'));7$names = new name();8$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','name11','name12','name13','name14','name15','name16','name17','name18','name19','name20'));9$names = new name();10$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','name11','name12','name13','name14','name15','name16','name17','name18','name19','name20'));11$names = new name();12$names->notIn(array('name1','name2','name3','name4','name5','name6','name7','name8','name9','name10','

notIn

Using AI Code Generation

1$names = new Names();2$names->notIn(array('name1','name2','name3'));3$names->notIn(array('name4','name5','name6'));4$names->notIn(array('name7','name8','name9'));5$names->notIn(array('name10','name11','name12'));6$names->notIn(array('name13','name14','name15'));7$names->notIn(array('name16','name17','name18'));8$names->notIn(array('name19','name20','name21'));9$names->notIn(array('name22','name23','name24'));10$names->notIn(array('name25','name26','name27'));11$names->notIn(array('name28','name29','name30'));12$names->notIn(array('name31','name32','name33'));13$names->notIn(array('name34','name35','name36'));14$names->notIn(array('name37','name38','name39'));15$names->notIn(array('name40','name41','name42'));16$names->notIn(array('name43','name44','name45'));17$names->notIn(array('name46','name47','name48'));18$names->notIn(array('name49','name50','name51'));19$names->notIn(array('name52','name53','name54'));20$names->notIn(array('name55','name56','name57'));21$names->notIn(array('name58','name59','name60'));22$names->notIn(array('name61','name62','name63'));23$names->notIn(array('name64','name65','name66'));24$names->notIn(array('name67','name68','name69'));25$names->notIn(array('name70','name71','name72'));26$names->notIn(array('name73','name74','name75'));27$names->notIn(array('name76','name77','name78'));28$names->notIn(array('name79','name80','name81'));29$names->notIn(array('name82','name83','name84'));30$names->notIn(array('name85','name86','name87'));31$names->notIn(array('name88','name89','name90'));32$names->notIn(array('name91','name92

notIn

Using AI Code Generation

1require_once 'name.php';2$names = new name();3$names->notIn('name1','name2','name3');4$names->notIn('name4','name5','name6');5echo $names->getNotIn();6require_once 'name.php';7$names = new name();8$names->notIn('name1','name2','name3');9$names->notIn('name4','name5','name6');10echo $names->getNotIn();11require_once 'name.php';12$names = new name();13$names->notIn('name1','name2','name3');14$names->notIn('name4','name5','name6');15echo $names->getNotIn();16require_once 'name.php';17$names = new name();18$names->notIn('name1','name2','name3');19$names->notIn('name4','name5','name6');20echo $names->getNotIn();21require_once 'name.php';22$names = new name();23$names->notIn('name1','name2','name3');24$names->notIn('name4','name5','name6');25echo $names->getNotIn();26require_once 'name.php';27$names = new name();28$names->notIn('name1','name2','name3');29$names->notIn('name4','name5','name6');30echo $names->getNotIn();31require_once 'name.php';32$names = new name();33$names->notIn('name1','name2','name3');34$names->notIn('name4','name5','name6');35echo $names->getNotIn();36require_once 'name.php';37$names = new name();38$names->notIn('name1','name

notIn

Using AI Code Generation

1$set1 = new name(array("a", "b", "c"));2$set2 = new name(array("a", "b", "c", "d", "e"));3$set3 = $set1->notIn($set2);4echo $set3->toString();5$set1 = new name(array("a", "b", "c", "d", "e"));6$set2 = new name(array("a", "b", "c"));7$set3 = $set1->notIn($set2);8echo $set3->toString();9$set1 = new name(array("a", "b", "c"));10$set2 = new name(array("a", "b", "c"));11$set3 = $set1->notIn($set2);12echo $set3->toString();13$set1 = new name(array("a", "b", "c"));14$set2 = new name(array("d", "e"));15$set3 = $set1->notIn($set2);16echo $set3->toString();17$set1 = new name(array("a", "b", "c"));18$set2 = new name(array("d", "e"));19$set3 = $set2->notIn($set1);20echo $set3->toString();21$set1 = new name(array("a", "b", "c"));22$set2 = new name(array("d", "e"));23$set3 = $set1->notIn($set2);24echo $set3->toString();

notIn

Using AI Code Generation

1require_once('name.php');2$names = array('Jim', 'John', 'Jane', 'Jack', 'Jill');3$names2 = array('Jim', 'Jane', 'Jill');4$name = new Name($names);5$name->notIn($names2);6print_r($name->getNames());

notIn

Using AI Code Generation

1require_once('name.php');2$name = new name();3$name->notIn('name',array('john','jane','jill'));4echo $name->getSql();5require_once('name.php');6$name = new name();7$name->notIn('name',array('john','jane','jill'));8echo $name->getSql();9require_once('name.php');10$name = new name();11$name->notIn('name',array('john','jane','jill'));12echo $name->getSql();13require_once('name.php');14$name = new name();15$name->notIn('name',array('john','jane','jill'));16echo $name->getSql();17require_once('name.php');18$name = new name();19$name->notIn('name',array('john','jane','jill'));20echo $name->getSql();21require_once('name.php');22$name = new name();23$name->notIn('name',array('john','jane','jill'));24echo $name->getSql();25require_once('name.php');26$name = new name();27$name->notIn('name',array('john','jane','jill'));28echo $name->getSql();29require_once('name.php');30$name = new name();31$name->notIn('name',array('john','

notIn

Using AI Code Generation

1$names = new name;2$names->notIn('Bob', 'Joe', 'Mary', 'Pete');3echo "Names not in array: " . $names->getNotIn();4$names = new name;5$names->in('Bob', 'Joe', 'Mary', 'Pete');6echo "Names in array: " . $names->getIn();7$names = new name;8$names->notIn('Bob', 'Joe', 'Mary', 'Pete');9echo "Names not in array: " . $names->getNotIn();10$names = new name;11$names->in('Bob', 'Joe', 'Mary', 'Pete');12echo "Names in array: " . $names->getIn();13$names = new name;14$names->notIn('Bob', 'Joe', 'Mary', 'Pete');15echo "Names not in array: " . $names->getNotIn();16$names = new name;17$names->in('Bob', 'Joe', 'Mary', 'Pete');18echo "Names in array: " . $names->getIn();19$names = new name;20$names->notIn('Bob', 'Joe', 'Mary', 'Pete');21echo "Names not in array: " . $names->getNotIn();22$names = new name;23$names->in('Bob', 'Joe', 'Mary', 'Pete');24echo "Names in array: " . $names->getIn();25$names = new name;26$names->notIn('Bob', 'Joe', 'Mary', 'Pete');27echo "Names not in array: " . $names->getNotIn();

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.