Campus: Last Name:

\n"; echo "\n"; echo ""; exit; }ELSE{ $lname= check_input($_POST['query']); $campus = check_input($_POST['campus']); $lname = $lname . '%'; } $connectionInfo = array( "UID"=>$dbuser, "PWD"=>$dbpass, "Database"=>$dbname ); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ){ echo "Unable to connect.
"; die( print_r( sqlsrv_errors(), true)); } $query = "declare @pagenumber int SET @PageNumber = 1 declare @pagesize int set @pagesize = 75 select * from (SELECT ROW_NUMBER() OVER (ORDER BY T1.stu_id asc) AS RowNum,T1.stu_id, T1.Student_ControlNumber,T1.StateStudentID, T1.grd_lvl, T1.name_f, T1.name_l ,T1.name_m, CONVERT(varchar(24),T1.StudentDOB) as 'studentDOB', T2.common_name, RTRIM(T1.Pre2000StudentLogin) AS networklogin,RTRIM(T1.Pre2000StudentLogin) + '@test.org' AS gaccount" . " FROM [Students] AS T1 INNER JOIN [Campus] AS T2 ON T1.campus_id = T2.campus_id " . " WHERE name_l LIKE '%s' AND T1.LastUpdate = (SELECT MAX(LastUpdate) FROM [Students])) as student_records where RowNum between (((@pagenumber - 1) * @pageSize )+ 1) and (@pagenumber * @pageSize ) "; if ($campus <> '999'){ $query = $query . " AND common_name = '%s' ORDER BY name_l, name_f"; $tsql = sprintf($query,$lname,$campus); }ELSE{ $query = $query . " ORDER BY name_l, name_f"; $tsql = sprintf($query,$lname); } $stmt = sqlsrv_query( $conn, $tsql); if( $stmt === false ){ echo "Error in executing query.
"; die( print_r( sqlsrv_errors(), true)); } ?>