PHP Dosql函数代码示例

    //insert into st_stateresult.
    Debug("\n[" . __FILE__ . "][" . __LINE__ . "]intostateresult:\n" . $sql . "\n");
    ####################################################################################################################################################################
    if ($intostateresult && $inserttoissuestateresult) {
        //插入成功，提交成功然后发邮件
        echo $intostateresult . " line insert into st_stateresult successfully!<br/>";
        echo $inserttoissuestateresult . " line insert into st_issueresult successfully!<br/>";
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]#send all mail\n" . $dailytest_id . "\n");
        #send all mail
        SendAllMail($dailytest_id);
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]#send all mail\n" . $dailytest_id . "\n");
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]#send testsuite mail按照模块分组发送邮件    \n" . $dailytest_id . "\n");
        #send testsuite mail按照模块分组发送邮件
        SendTestsuiteMail($dailytest_id);
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]#send testsuite mail按照模块分组发送邮件    \n" . $dailytest_id . "\n");
    } else {
        //插入st_stateresult 表格失败时
        echo $dailytest_id . " dailytest_id<br/>";
        echo $intostateresult . "insert into st_stateresult Fail!<br/>";
        $sql = "delete from st_dailytest where dailytest_id='{$dailytest_id}'";
        Dosql($sql);
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]delete:\n" . $sql . "\n");
    }
    //end if()
}
?>

</form>
</body>
</html>

echo "<td width=\"10%\">{$modifyplatformonlineto}</td>\n ";
echo "</tr>\n";
echo "</table>\n";
?>

<h3>After Modify Platform:</h3>
<table class="altrowstable" width="30%">
<tr bgcolor="#d2d2d2" align="center">
<td>Platform</td><td>Description</td><td>Online</td>
</tr>
<?php 
if ($updateplatformresult) {
    $modifyplatform = $modifyplatformto;
}
$sql = "select platform,platformdescription,platform_online as online from st_platform where platform='{$modifyplatform}'";
$platresult = Dosql($sql);
$plat_num = $platresult->num_rows;
for ($i = 0; $i < $plat_num; $i++) {
    $row = $platresult->fetch_assoc();
    echo "<tr bgcolor=\"#ffffff\">\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['platform'])) . "</td>\n";
    echo "<td width=\"70%\">" . htmlspecialchars(stripslashes($row['platformdescription'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['online'])) . "</td>\n";
    echo "</tr>\n";
}
$platresult->free();
?>
</table>

<h3>You can :<a href="/smoketest/php/createplatform.php" target="mainFrame">Create Platform</a></h1>

</table>

<input type="submit" value="commit" />

</form>

<h3 style="font-family:arial">已有的 Testsuite：</h3>
<table class="altrowstable" width="60%">
<tr bgcolor="#d2d2d2">
<td>ID</td><td>Testsuite</td><td>DepartmentID</td><td>Department</td><td>Description</td><td>Online</td>
</tr>
<?php 
$sql = "select testsuite_id, testsuite, testsuitedescription, st_testsuite.department_id as department_id, department, testsuite_online as online \n    from st_testsuite, st_department\n    where st_testsuite.department_id=st_department.department_id order by testsuite_id";
$testsuiteresult = Dosql($sql);
$testsuite_num = $testsuiteresult->num_rows;
for ($i = 0; $i < $testsuite_num; $i++) {
    $row = $testsuiteresult->fetch_assoc();
    if ($i % 2) {
        $bgcolor = "#ffffff";
    } else {
        $bgcolor = "#f2f2f2";
    }
    echo "<tr bgcolor=\"{$bgcolor}\">\n";
    echo "<td width=\"5%\">" . htmlspecialchars(stripslashes($row['testsuite_id'])) . "</td>\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['testsuite'])) . "</td>\n";
    echo "<td width=\"5%\">" . htmlspecialchars(stripslashes($row['department_id'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['department'])) . "</td>\n";
    echo "<td width=\"70%\">" . htmlspecialchars(stripslashes($row['testsuitedescription'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['online'])) . "</td>\n";

</head>
<?php 
require_once "./libraries/common.inc.php";
$newbranch = $_POST['newbranch'];
$newbranchdesc = $_POST['newbranchdesc'];
if (!$newbranch) {
    echo 'You have not entered all details.<br/>Branch name mull fill';
    exit;
}
if (!$newbranchdesc) {
    $newbranchdesc = "no description!";
}
if (!get_magic_quotes_gpc()) {
    $newbranch = addslashes($newbranch);
    $newbranchdesc = addslashes($newbranchdesc);
}
$sql = "insert into st_branch(branch, branchdescription, branch_online) values('{$newbranch}', '{$newbranchdesc}', 1)";
$insertresult = Dosql($sql);
if (!$insertresult) {
    echo "<h1>Insert Fail!\n</h1>";
} else {
    echo 'insertresult = ' . $insertresult . '<br/>' . "\n";
    echo "Insert st_branch Successfully!\n<br/>";
}
?>


<h1>You can :<a href="/smoketest/php/createbranch.php" target="mainFrame">Create Branch</a></h1>

<h1>Or :<a href="/smoketest/php/modifybranch.php" target="mainFrame">Modify Branch</a></h1>

function PrintAllNoDetailandTable($platform, $branch, $testsuiteid, $testcasestateid, $date)
{
    $sql = "select st_platform_branch.platform as platform,st_platform_branch.branch as branch\n        from\n        st_branch,st_platform,st_platform_branch\n        where\n        st_platform.platform = st_platform_branch.platform\n        and st_branch.branch = st_platform_branch.branch\n        and st_branch.branch = '{$branch}'\n        and platform_online = 1\n        and branch_online = 1\n        and st_platform_branch.pb_online=1";
    $pbresult = Dosql($sql);
    $num_pb = $pbresult->num_rows;
    for ($i = 0; $i < $num_pb; $i++) {
        $rowpb = $pbresult->fetch_assoc();
        if ($testsuite == -1) {
            if ($testcasestateid == -1) {
                #00,11
                SearchNoNoAllAll($rowpb['platform'], $rowpb['branch'], $testsuiteid, $testcasestateid, $date);
            } else {
                #00,10
                SearchNoNoAllNo($rowpb['platform'], $rowpb['branch'], $testsuiteid, $testcasestateid, $date);
            }
            //end if()
        } else {
            #00,01
            if ($testcasestateid == -1) {
                SearchNoNoNoAll($rowpb['platform'], $rowpb['branch'], $testsuiteid, $testcasestateid, $date);
            } else {
                #00,00
                SearchNoNoNoNo($rowpb['platform'], $rowpb['branch'], $testsuiteid, $testcasestateid, $date);
            }
            //end if()
        }
        //end if()
        echo "<br/>\n";
    }
    $pbresult->free();
}

?>
    var strURL = "/smoketest/php/showalldetail.php?platformbranchproduct=" + pbp + "&date=" + datetime + str;
    $.ajax({
        type:"GET",
        url:strURL,
        success:function(msg){
            $('#detail').html(msg);
        }
    });
}

$(function () {
<?php 
echo "var failtestsuite=new Array();\n";
$sql = "select st_platform_branch.platform as platform,branch,product\n    from\n    st_platform_branch,st_platform_product\n    where\n    st_platform_branch.platform = st_platform_product.platform\n    and pb_online='1'\n    and pp_online=1\n    and st_platform_branch.online='1'\n    and st_platform_product.online='1'\n    ";
$pbpresult = Dosql($sql);
$num_pbp = $pbpresult->num_rows;
for ($pbi = 0; $pbi < $num_pbp; $pbi++) {
    $row = $pbpresult->fetch_assoc();
    $platformbranchproduct = $row['platform'] . $row['branch'] . "_" . $row['product'];
    $failtestsuitearray = $allfailtestsuite[$platformbranchproduct];
    $failtestdatearray = $alltestdate[$platformbranchproduct];
    echo "var {$platformbranchproduct} = new Array();\n";
    foreach ($failtestdatearray as $i => $date) {
        echo "{$platformbranchproduct}" . "[\"{$date}\"] = \"" . $failtestsuitearray[$i] . "\";\n";
    }
    echo "failtestsuite[\"{$platformbranchproduct}\"] = {$platformbranchproduct};\n";
}
$pbpresult->free();
?>
    var chart;

    $platform = addslashes($platform);
    $product = addslashes($product);
    $online = intval($online);
}
$sql = "update st_platform_product set pp_online='{$online}' where platform='{$platform}' and product='{$product}'";
$updateresult = Dosql($sql);
?>

<h3>修改后的platform product relation：</h3>
<table class="altrowstable" width="30%">
<tr bgcolor="#d2d2d2" align="center">
<td>Platform</td><td>Product</td><td>Online</td><td>Platform * Product</td>
</tr>
<?php 
$sql = "select platform,product,online, pp_online from st_platform_product";
$relationresult = Dosql($sql);
$num_relation = $relationresult->num_rows;
for ($i = 0; $i < $num_relation; $i++) {
    $row = $relationresult->fetch_assoc();
    if ($row['pp_online'] && $row['online']) {
        echo "<tr bgcolor=\"#ffffff\" align=\"center\">\n";
    } else {
        echo "<tr bgcolor=\"#ce0000\" align=\"center\">\n";
    }
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['platform'])) . "</td>\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['product'])) . "</td>\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['pp_online'])) . "</td>\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['online'])) . "</td>\n";
    echo "</tr>\n";
}
$relationresult->free();

if (!get_magic_quotes_gpc()) {
    $platform = addslashes($platform);
    $branch = addslashes($branch);
}
if ($fromflag == "platform") {
    $sql = "select st_platform_branch.platform as platform,st_platform_branch.branch as branch ,branchname,createdate,purpose,androidversion\n        from\n        st_branch,st_platform,st_platform_branch,st_branchdetail\n        where\n        st_platform.platform=st_platform_branch.platform\n        and st_platform_branch.platform='{$platform}'\n        and st_branchdetail.branch=st_platform_branch.branch\n        and    st_branch.branch=st_platform_branch.branch\n        ";
}
if ($fromflag == "branch") {
    $sql = "select distinct st_platform_branch.branch as branch ,branchname,createdate,purpose,androidversion\n        from\n        st_branch,st_platform,st_platform_branch,st_branchdetail\n        where\n        st_platform.platform=st_platform_branch.platform\n        and st_platform_branch.branch='{$branch}'\n        and st_branchdetail.branch=st_platform_branch.branch\n        and    st_branch.branch=st_platform_branch.branch\n        ";
}
$branchresult = Dosql($sql);
$num_branch = $branchresult->num_rows;
echo "<table class=\"altrowstable\" width=40%>\n";
for ($i = 0; $i < $num_branch; $i++) {
    $row = $branchresult->fetch_assoc();
    echo "<tr bgcolor=\"d2d2d2\"><th colspan=2>" . $row['branchname'] . "</th></tr>\n";
    echo "<tr><td width=30%>Create Date</td><td>" . $row['createdate'] . "</td></tr>\n";
    echo "<tr><td>Android Version</td><td>" . $row['androidversion'] . "</td></tr>\n";
    echo "<tr><td>Purpose</td><td>" . $row['purpose'] . "</td></tr>\n";
    $sql = "select releasename,codedroplink from st_release where branchname='" . $row['branchname'] . "'";
    $releaseresult = Dosql($sql);
    $num_release = $releaseresult->num_rows;
    for ($j = 0; $j < $num_release; $j++) {
        $rowrelease = $releaseresult->fetch_assoc();
        $array = split('[\\]', $rowrelease['codedroplink']);
        echo "<tr><td colspan=2><b>" . $rowrelease['releasename'] . ":&nbsp;&nbsp;&nbsp;&nbsp;</b><a href=\"file://" . $rowrelease['codedroplink'] . "\">" . $array[count($array) - 1] . "</a></td></tr>\n";
    }
    $releaseresult->free();
}
echo "</table>\n";
$branchresult->free();

<html>
<head>
<title>create tester</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="/smoketest/css/main.css">
</head>

<body>
<h3 style="font-family:arial">已有的 Tester：</h3>
<table class="altrowstable" width="40%">
<tr bgcolor="#d2d2d2" align="center">
<td>Name</td><td>E-mail</td><td>Description</td><td>Level</td>
</tr>
<?php 
$sql = "select tester,email,testerdescription,tester_level as level from st_tester";
$testerresult = Dosql($sql);
$tester_num = $testerresult->num_rows;
for ($i = 0; $i < $tester_num; $i++) {
    $row = $testerresult->fetch_assoc();
    echo "<tr bgcolor=\"#ffffff\">\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['tester'])) . "</td>\n";
    echo "<td width=\"30%\">" . htmlspecialchars(stripslashes($row['email'])) . "</td>\n";
    echo "<td width=\"40%\">" . htmlspecialchars(stripslashes($row['testerdescription'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['level'])) . "</td>\n";
    echo "</tr>\n";
}
$testerresult->free();
?>
</table>

<form action="commitcreatetester.php" method="post">

<head>
<title>modify branch</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="/smoketest/css/main.css">
</head>

<body>
<form action="commitmodifybranch.php" method="post" >
<h3>已有的Branch：</h3>
<table class="altrowstable" width="30%">
<tr bgcolor="#d2d2d2">
    <td>Branch</td><td>Description</td><td>Online</td>
</tr>
<?php 
$sql = "select branch,branchdescription,branch_online as online from st_branch";
$branchresult = Dosql($sql);
$branch_num = $branchresult->num_rows;
$brancharray = array();
for ($i = 0; $i < $branch_num; $i++) {
    $row = $branchresult->fetch_assoc();
    $brancharray[$i] = $row;
    echo "<tr bgcolor=\"#ffffff\">\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['branch'])) . "</td>\n";
    echo "<td width=\"70%\">" . htmlspecialchars(stripslashes($row['branchdescription'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['online'])) . "</td>\n";
    echo "</tr>\n";
}
$branchresult->free();
?>
</table>
<script language="JavaScript">

$pbresult->free();
$platform_to_product = array();
$sql = "select st_platform_product.platform as platform,st_platform_product.product as product\r\n    from\r\n    st_product,st_platform,st_platform_product\r\n    where\r\n    st_platform.platform=st_platform_product.platform and\r\n    st_product.product=st_platform_product.product and\r\n    platform_online=1 and product_online=1 and\r\n    st_platform_product.pp_online=1";
$ppresult = Dosql($sql);
$num_pp = $ppresult->num_rows;
for ($i = 0; $i < $num_pp; $i++) {
    $row = $ppresult->fetch_assoc();
    $platform_to_product[$row['platform']][] = $row['product'];
}
$ppresult->free();
$platform_to_boardno = array();
$platform_to_hardware = array();
$platform_to_imageinfo = array();
$platform_to_note = array();
$sql = "select platform,branch,boardno,hardware,imageinfo,note\r\n    from (select platform,branch, boardno, hardware, imageinfo, note\r\n            from st_dailytest\r\n            where tester='" . $_SESSION['tester'] . "'\r\n            order by testdate desc) as temptable\r\n    group by platform";
$platformresult = Dosql($sql);
$num_p = $platformresult->num_rows;
for ($i = 0; $i < $num_p; $i++) {
    $row = $platformresult->fetch_assoc();
    $platform_to_boardno[$row['platform']] = htmlspecialchars(stripslashes($row['boardno']));
    $platform_to_hardware[$row['platform']] = htmlspecialchars(stripslashes($row['hardware']));
    $platform_to_imageinfo[$row['platform']] = $row['imageinfo'];
    $platform_to_note[$row['platform']] = htmlspecialchars(stripslashes($row['note']));
}
$platformresult->free();
?>

<html>
<head>
<link rel="stylesheet" href="/smoketest/css/jquery-ui.css" />
<link rel="stylesheet" href="/smoketest/css/newtest.css" />

# modify to name
$modifystatecolorto = $_POST['modifystatecolorto'];
#modify to color
if (!get_magic_quotes_gpc()) {
    $modifystateto = addslashes($modifystateto);
    $modifystatecolorto = addslashes($modifystatecolorto);
}
if ($_SESSION['level'] > 1 && $modifystateto) {
    $updatesql = "update st_state set state = '" . $modifystateto . "' ";
    $updatesql .= " where state_id = '" . $modifystateid . "' ";
    $updatestateresult = Dosql($updatesql);
}
if ($modifystatecolorto) {
    $updatesql = "update st_state set color= '" . $modifystatecolorto . "' ";
    $updatesql .= " where state_id = '" . $modifystateid . "' ";
    $updateresult = Dosql($updatesql);
}
echo '<table cellspacing="1" cellpadding="0" border="0" bgcolor="#000000" width="30%">';
echo '<tr bgcolor="#6dc22c">';
echo '<td>ID</td><td>State</td><td>Color</td><td></td>';
echo '</tr>';
echo "<tr bgcolor=\"#ffffff\">\n";
echo "<td >{$modifystateid}</td>\n ";
echo "<td >{$modifystateto}</td>\n ";
echo "<td >{$modifystatecolorto}</td>\n ";
echo "<td >&nbsp;&nbsp;&nbsp;&nbsp;</td>\n ";
echo "</tr>\n";
echo "</table>\n";
?>

$num_count = $countresult->num_rows;
for ($i = 0; $i < $num_count; $i++) {
    $row = $countresult->fetch_assoc();
    $totalpages = $row['num'];
}
$countresult->free();
$page = $_GET['page'];
$targetpage = "/smoketest/php/searchissuehistory.php";
$limit = 10;
if ($page) {
    $start = ($page - 1) * $limit;
} else {
    $start = 0;
}
$sql = "select dailytest_id,testdate,testdetailtime,imageinfo,platform,branch,product,st_tester.testerdescription as tester,email,newissue,remainissue\n    from\n    st_dailytest,st_tester\n    where\n    st_tester.tester=st_dailytest.tester\n    order by testdetailtime desc limit {$start},{$limit}";
$issueresult = Dosql($sql);
$num_issue = $issueresult->num_rows;
$table = "<table class=\"altrowstable\" width=\"80%\">\n";
$table .= "<tr bgcolor=\"#ffffff\" align=\"center\" ><th colspan=\"7\">Issue History Table</th></tr>\n";
$table .= "<tr bgcolor=\"#d2d2d2\" align=\"center\">\n";
$table .= "\n            <td widht=\"20%\">Image</td>\n            <td widht=\"15%\">Platform</td>\n            <td width=\"15%\">Branch</td>\n            <td width=\"10%\">Product</td>\n            <td width=\"15%\" align=\"center\">Tester</td>\n            <td width=\"10%\">Detail</td>\n            <td width=\"15%\">TestDetailDateTime</td>\n            \n";
$table .= "</tr>\n";
for ($i = 0; $i < $num_issue; $i++) {
    $row = $issueresult->fetch_assoc();
    if ($i % 2) {
        // 隔行换色
        $bgcolor = "#ffffff";
    } else {
        $bgcolor = "#f2f2f2";
    }
    $table .= "<tr bgcolor=\"{$bgcolor}\" align=\"center\">\n";

function SendTestsuiteMail($dailytest_id)
{
    # 按照模块分别发送mail
    Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $dailytest_id . "\n");
    $message .= PrintCss();
    //打印链接
    $message .= PrintDetailLink($dailytest_id);
    $message .= "<br/>\n";
    //打印每个模块的测试详细信息
    $message .= PrintTestsuiteTestDetail($dailytest_id);
    $sql = "select st_tester.testerdescription, st_tester.email,testdate,platform,branch,product,imageinfo\n        from\n        st_tester,st_dailytest\n        where\n        st_dailytest.tester=st_tester.tester and\n        st_dailytest.dailytest_id='{$dailytest_id}'";
    Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $sql . "\n");
    $testerresult = Dosql($sql);
    $num_tester = $testerresult->num_rows;
    for ($i = 0; $i < $num_tester; $i++) {
        $row = $testerresult->fetch_assoc();
        $testername = $row['testerdescription'];
        $testeremail = $row['email'];
        $reportdate = $row['testdate'];
        $platform = $row['platform'];
        $branch = $row['branch'];
        $product = $row['product'];
        $imageinfo = stripslashes($row['imageinfo']);
    }
    $testerresult->free();
    $sql = "select distinct st_testsuite.department_id ,department,department_email\n        from\n        st_testsuite,st_department\n        where\n        st_testsuite.department_id = st_department.department_id\n        and st_testsuite.testsuite_online = '1'\n        and st_department.department_online = '1'\n        order by department_id";
    Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $sql . "\n");
    $departmentresult = Dosql($sql);
    $num_depart = $departmentresult->num_rows;
    for ($depart = 0; $depart < $num_depart; $depart++) {
        $rowdepart = $departmentresult->fetch_assoc();
        //收件人//$to ="$testeremail,mamh@marvell.com";
        $to = "{$testeremail},mamh@marvell.com," . $rowdepart['department_email'];
        $sql = "select testsuite_id,testsuite from st_testsuite where testsuite_online = '1' and department_id = '" . $rowdepart['department_id'] . "'";
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $sql . "\n");
        $suiteresult = Dosql($sql);
        $num_suite = $suiteresult->num_rows;
        for ($suite = 0; $suite < $num_suite; $suite++) {
            $rowsuite = $suiteresult->fetch_assoc();
            $suitenewissueemessage .= PrintTestsuiteNewIssue($dailytest_id, $rowsuite['testsuite_id']);
            $suiteremainissuemessage .= PrintTestsuiteRemainIssue($dailytest_id, $rowsuite['testsuite_id']);
            //fail 状态的表
            $suitefailmessage .= "<h3 style=font-family:arial;>Fail Testcase <font style=color:blue>" . $rowsuite['testsuite'] . "</font></h3>\n";
            $suitefailmessage .= PrintFailStateTable($dailytest_id, $rowsuite['testsuite_id']);
            $suitefailmessage .= "<br/>\n";
            //统计各个状态的个数的表
            //$suitefailmessage .= PrintStateStatisticsTable($dailytest_id, $rowsuite['testsuite_id']);
            //所有状态的统计表
            $suitestatusmessage .= PrintTestsuiteTable($dailytest_id, $rowsuite['testsuite_id'], $rowsuite['testsuite']);
            $rowsuitestr .= " - " . $rowsuite['testsuite'];
        }
        $suiteresult->free();
        $messagetemp .= "<h3 style=font-family:arial;color:red>New Issues</h3>\n";
        $messagetemp .= $suitenewissueemessage;
        $messagetemp .= "<h3 style=font-family:arial;color:red>Remaining Issues</h3>\n";
        $messagetemp .= $suiteremainissuemessage;
        $messagetemp .= "<br/>\n";
        $messagetemp .= $suitefailmessage;
        $messagetemp .= "<h3 style=font-family:arial>Feature Status</h3>\n";
        $messagetemp .= $suitestatusmessage;
        $smoketest_imagedate = get_imageinfo_imagedate($imageinfo);
        if ($smoketest_imagedate) {
            $subject = "[Daily Smoke Test][" . stripslashes($product) . "][{$smoketest_imagedate}] " . $rowsuitestr;
        } else {
            $subject = "[Daily Smoke Test] - " . stripslashes($reportdate) . "_" . stripslashes($platform) . "_" . stripslashes($branch) . " _ " . stripslashes($product) . " " . $rowsuitestr;
        }
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $subject . "\n");
        $from = "{$testername}<{$testeremail}>";
        $headers = "Content-type:text/html; charset=utf-8\n";
        $headers .= "From:{$from}";
        //$to="mamh@marvell.com";
        $sendmailresult = mail($to, $subject, $message . $messagetemp, $headers);
        echo "SendTestsuiteMail:sendmailresult = {$sendmailresult}<br/>\n";
        echo "From = {$from}<br/>\n";
        echo "To = {$to}<br/>\n";
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $to . "\n");
        Debug("\n[" . __FILE__ . "][" . __LINE__ . "]:\n" . $from . "\n");
        $messagetemp = "";
        $suiteremainissuemessage = "";
        $suitenewissueemessage = "";
        $suitefailmessage = "";
        $suitestatusmessage = "";
        $rowsuitestr = "";
    }
    //end for()
    $departmentresult->free();
}

<title>create product</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="/smoketest/css/main.css">
</head>

<body>
<h3 style="font-family:arial">Product：</h3>

<table class="altrowstable" width="30%">
<tr bgcolor="#d2d2d2">
<td>Product</td><td>Description</td><td>Online</td>
</tr>

<?php 
$sql = "select product,productdescription,product_online as online from st_product order by product";
$productresult = Dosql($sql);
$pro_num = $productresult->num_rows;
for ($i = 0; $i < $pro_num; $i++) {
    $row = $productresult->fetch_assoc();
    echo "<tr bgcolor=\"#ffffff\">\n";
    echo "<td width=\"20%\">" . htmlspecialchars(stripslashes($row['product'])) . "</td>\n";
    echo "<td width=\"70%\">" . htmlspecialchars(stripslashes($row['productdescription'])) . "</td>\n";
    echo "<td width=\"10%\">" . htmlspecialchars(stripslashes($row['online'])) . "</td>\n";
    echo "</tr>\n";
}
$productresult->free();
?>

</table>

<form action="commitcreateproduct.php" method="post">