PLEASE NOTE: Due to the large number of entries in the database, list filtering is highly recommended. connect_error) { die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $conn->prepare("SELECT * FROM `tb_conf_usr_fee` $sqlstr "); $stmt->bind_param("s", $filter); $stmt->execute(); $result = $stmt->get_result(); $stmt->close(); //Have to run a second query on the database to determine the number of counties $stmt2 = $conn->prepare("SELECT * FROM `tb_conf_usr_fee` $sqlstr "); // "s" means the database expects a string $stmt2->bind_param("s", $filter); $stmt2->execute(); $result2 = $stmt2->get_result(); $stmt2->close(); //While loop to determine the number of counties while($row2 = $result2->fetch_assoc()) { $temp = $row2["usr_country"]; //country to compare to the list of countries already present $size=1000; //get the size of the array $boolean = "false"; //boolean to determine if the number of countrys should be incremented for($x = 0; $x<$size; $x++) //for loop that runs through the current list of countries { if($temp==$country[$x]) //if the country is already in the list then set the boolean true { $boolean="true"; } } if($boolean=="false") //if the country isnt in the list then increment the counter and number of countries. { $i++; $country[$i]=$temp; $numberOfCountry++; } } //Must do a third query to query the database that tells if the abstract is aproved. //Must pull out author and then compare to author $stmt3 = $conn->prepare("SELECT * FROM `tb_conf_abstract` ;") ; $stmt3->execute(); $result3 = $stmt3->get_result(); ?> fetch_assoc()) { $stm22 = $conn->prepare("SELECT * FROM `tb_conf_usr` WHERE `uid`=" . $row["uid"]); $stm22->execute(); $result22 = $stm22->get_result(); $row22=$result22->fetch_assoc(); /* while($row3=mysql_fetch_array($result3)) { //Find the correct author in the abstract table. if($row["uid"] ==$row3["abs_author_id"]) { if($row3["abs_ss_status"]=="A") { $showAbs="yes"; } else { $showAbs="no"; } } } */ ?> close(); ?>
Reg. No