PHP createJavaScript Exemples

Exemple #1

Fichier : coordination_of_services.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    $coordlist_query = "SELECT DISTINCT `agency`, COUNT(`agency`) AS `count` FROM coordination_of_services GROUP BY `agency` ORDER BY `count` DESC LIMIT 200";
    $coordlist_result = mysql_query($coordlist_query);
    if (!$coordlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        if (mysql_num_rows($coordlist_result)) {
            echo createJavaScript($coordlist_result, "popuplist");
        }
    }
}

Exemple #2

Fichier : edit_support_member.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message, $student_id;
    //get a list of all available goal categories...
    $catlist_query = "SELECT name FROM typical_long_term_goal_category WHERE is_deleted='N' ORDER BY name ASC";
    $catlist_result = mysql_query($catlist_query);
    if (!$catlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        return;
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($catlist_result, "popuplist");
    }
}

Exemple #3

Fichier : accomodations.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    $acclist_query = "SELECT accomodation FROM typical_accomodation WHERE 1 ORDER BY `order` DESC, accomodation ASC LIMIT 400";
    $acclist_result = mysql_query($acclist_query);
    if (!$acclist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        if (mysql_num_rows($acclist_result)) {
            echo createJavaScript($acclist_result, "popuplist");
        }
    }
}

Exemple #4

Fichier : add_goal_1.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    //while($catlist=mysql_fetch_array($catlist_result)) {
    if (isset($_GET['goal_area']) && !$_GET['goal_area'] == "") {
        $objlist_query = "SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . mysql_real_escape_string($_GET['goal_area']) . " AND typical_long_term_goal.is_deleted='N'";
        $objlist_result = mysql_query($objlist_query);
        if (!$objlist_result) {
            $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$objlist_query}'<BR>";
            $system_message = $system_message . $error_message;
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        } else {
            //call the function to create the javascript array...
            if (mysql_num_rows($objlist_result)) {
                echo createJavaScript($objlist_result, "popuplist");
            }
        }
    }
    //}
}

Exemple #5

Fichier : long_term_goal_view.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    //get a list of all available goal categories...
    $catlist_query = "SELECT * FROM typical_long_term_goal_category where is_deleted='N'";
    $catlist_result = mysql_query($catlist_query);
    if (!$catlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        return;
    }
    while ($catlist = mysql_fetch_array($catlist_result)) {
        $objlist_query = "SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . $catlist['cid'] . " AND typical_long_term_goal.is_deleted='N'";
        $objlist_result = mysql_query($objlist_query);
        if (!$objlist_result) {
            $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$objlist_query}'<BR>";
            $system_message = $system_message . $error_message;
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        } else {
            //call the function to create the javascript array...
            echo createJavaScript($objlist_result, $catlist['name']);
        }
    }
}

Exemple #6

Fichier : program_area.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    $coordlist_query = "SELECT DISTINCT `name`, COUNT(`name`) AS `count` FROM typical_long_term_goal_category WHERE is_deleted='N' GROUP BY `name` ORDER BY `name` DESC LIMIT 200";
    $coordlist_result = mysql_query($coordlist_query);
    if (!$coordlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($coordlist_result, "popuplist");
    }
}

Exemple #7

Fichier : user_audit.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    $acclist_query = "SELECT DISTINCT egps_username FROM support_list WHERE 1 ORDER BY egps_username ASC";
    $acclist_result = mysql_query($acclist_query);
    if (!$acclist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($acclist_result, "popuplist");
    }
}

Exemple #8

Fichier : short_term_objectives.php Projet : Byrnesz/MyIEP

function echoJSServicesArray()
{
    global $system_message;
    //get a list of all available goal categories...
    $catlist_query = "SELECT typical_short_term_objective.goal FROM long_term_goal RIGHT JOIN typical_long_term_goal ON long_term_goal.goal LIKE typical_long_term_goal.goal RIGHT JOIN typical_short_term_objective ON typical_long_term_goal.ltg_id=typical_short_term_objective.ltg_id WHERE long_term_goal.goal_id=" . mysql_real_escape_string($_GET['goal_id']) . " AND student_id=" . mysql_real_escape_string($_GET['student_id']);
    $catlist_result = mysql_query($catlist_query);
    if (!$catlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        return;
    } else {
        //$system_message = $system_message . "Rows returned=" . mysql_num_rows($catlist_result) . " Query=$catlist_query<BR><BR>";
        echo createJavaScript($catlist_result, "popuplist");
    }
    //This code block was commented out by dev.
    //while($catlist=mysql_fetch_array($catlist_result)) {
    //$objlist_query="SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . $catlist['cid'] . " AND typical_long_term_goal.is_deleted='N'";
    //$objlist_result = mysql_query($objlist_query);
    //if(!$objlist_result) {
    // $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '$objlist_query'<BR>";
    // $system_message= $system_message . $error_message;
    //  IPP_LOG($system_message,$_SESSION['egps_username'],'ERROR');
    //} else {
    //call the function to create the javascript array...
    //  echo createJavaScript($objlist_result,$catlist['name']);
    //}
    //}
}