Jump to content


Photo

php causing error no clue...


  • Please log in to reply
4 replies to this topic

#1 west4me

west4me
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 16 June 2006 - 08:13 PM

I am getting this error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/west4mec/public_html/multiplication/index.php on line 12

Warning: Cannot modify header information - headers already sent by (output started at /home/west4mec/public_html/multiplication/index.php:12) in /home/west4mec/public_html/multiplication/index.php on line 21

I had someone write this for me awhile ago and I must have messed somehting up. Anyone see an error in the code?
I borrowed the layout from WordPress so there is a bunch of extra stuff in there.

THis is the index page:
<?php
require_once("dbconnect.php");
session_start();

if ($_POST) {

    
    $user = $_POST["username"];
    $pass = md5($_POST["password"]);
    
    $query = mysql_query("SELECT * FROM login WHERE username = '$user' AND password = '$pass'");
    $row = mysql_fetch_array($query);
    
    
    if ($user == $row["username"] && $pass = $row["password"]) {
        session_register('username');
        $_SESSION['username'] = $user;
    
        header ("location: admin.php");
    } else {
        header ("location: index.php");
    }
    
}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://gmpg.org/xfn/11">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Multiplication Administration</title>
    <meta name="generator" content="WordPress 1.5.2" /> <!-- leave this for stats please -->
    <style type="text/css" media="screen">
    </style>    
    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://west4me.com/wordpress/?feed=rss2" />
    <link rel="alternate" type="application/atom+xml" title="Atom 0.3" href="http://west4me.com/wordpress/?feed=atom" />
    <link rel="pingback" href="http://west4me.com/wordpress/xmlrpc.php" />

        <link rel='archives' title='October 2005' href='http://west4me.com/wordpress/?m=200510' />
    <link rel='archives' title='September 2005' href='http://west4me.com/wordpress/?m=200509' />
    <link href="style.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
<!--
.style2 {font-size: 16px; }
.style3 {font-size: 16px; color: #676E04; }
-->
    </style>
</head>

<body>
<div id="rap">
    <div id="header">
    <ul id="topnav">
        <li><a href="http://west4me.com/moodle" id="navHome" title="Posted Recently" accesskey="h">Home</a></li>
        <li><a href="http://west4me.com/cal" id="navHome" title="Posted Recently" accesskey="c">Calendar</a></li>
        <li><a href="http://west4me.com/story2" id="navHome" title="Posted Recently" accesskey="s">Stories</a></li>
        <li><a href="http://west4me.com/bookmarks" id="navHome" title="Posted Recently" accesskey="b">Bookmarks</a></li>
        <li><a href="http://west4me.com/wordpress" id="navHome" title="Posted Recently" accesskey="w">Blog</a></li>
        <li><a href="http://west4me.com/webcollab/index.php" id="navHome" title="Posted Recently" accesskey="p">Writing Progress</a></li>
         <li><a href="http://west4me.com/kidscms/index.php" id="navHome" title="Posted Recently" accesskey="f">Student Pages</a></li>
        <li><a href="http://west4me.com/daily/name.php" id="navHome" title="Posted Recently" accesskey="f">Name Draw</a></li>
    <li><a href="http://west4me.com/daily/job2.php" id="navHome" title="Posted Recently" accesskey="f">Jobs</a></li>
    <li><a href="http://west4me.com/daily/lunch.php" id="navHome" title="Posted Recently" accesskey="f">Lunch Choice</a></li>     
        <li><a href="http://west4me.com/daily/" id="navHome" title="Posted Recently" accesskey="f">Daily</a></li>
    </ul>

    <h1><a href="http://west4me.com/daily" title=""></a></h1>        
    <div id="desc">Classroom Schedule</div>
</div>
    <div id="main">
    <div id="content">
                        <div class="post">
                
<div class="post-info"><h2 class="post-title">Welcome to another wonderful day!</a></h2>
  <p>Make sure you take care of all your morning tasks before the bell rings.</p>
  </div>

<div class="post-content">
        <form name='login' method='POST'>
<table style='width:300px;'>
    <tr><td>Username</td><td><input type='text' name='username' /></td></tr>
    <tr><td>Password</td><td><input type='password' name='password' /></td></tr>
    <tr><td></td><td><input type='submit' value='Login' /></td></tr>
</table>
        
        
        <div id="content"></div>
        <p>&nbsp;</p>
</div>                            </div>
                                                
                    <p align="center"></p>        
    </div>
    
    
<p id="footer"><a href="http://www.west4me.com/moodle" title="Cunningham">Mr. Cunningham's Classroom</a></p></div>
</div>
</body>
</html>

and this is the admin page:
<?php 
/********************************************\
*                                            *
*          class test administation          *
*         copyright 2005 Phil Pedlar         *
*                                            *
\********************************************/
session_start();
if (!$_SESSION['username']) {
    header ("location: index.php");
}
include ("dbconnect.php");

require_once("dbconnect.php");

function print_footer() {
 print  "<div class='page-content'>
         <div colspan='5' class='post-footer'>&nbsp;</div>
         </div>
         </div>
         </div>
         </div>
         <p align='center'></p>        
         </div>
         <p id='footer'><a href='http://www.west4me.com/moodle' title='Cunningham'>Mr. Cunninghams Classroom</a></p></div>
         </div>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://gmpg.org/xfn/11">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Multiplication Administration</title>
    <meta name="generator" content="WordPress 1.5.2" /> <!-- leave this for stats please -->
    <style type="text/css" media="screen">
    </style>    
    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://west4me.com/wordpress/?feed=rss2" />
    <link rel="alternate" type="application/atom+xml" title="Atom 0.3" href="http://west4me.com/wordpress/?feed=atom" />
    <link rel="pingback" href="http://west4me.com/wordpress/xmlrpc.php" />

        <link rel='archives' title='October 2005' href='http://west4me.com/wordpress/?m=200510' />
    <link rel='archives' title='September 2005' href='http://west4me.com/wordpress/?m=200509' />
    <link href="http://west4me.com/multiplication/style.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
<!--
.style2 {font-size: 16px; }
.style3 {font-size: 16px; color: #676E04; }
-->
#scores { border: 1px solid black; background:#ffffff; text-align:center; padding-left: 10px; padding-right: 10px;}
#scores td { border: 1px solid black; background:#F3F6ED; padding-left: 3px; padding-right: 3px; width: 725px;}
    </style>
</head>

<body>
<div id="rap">
    <div id="header">
    <ul id="topnav">
        <li><a href="http://west4me.com/moodle" id="navHome" title="Posted Recently" accesskey="h">Home</a></li>
        <li><a href="http://west4me.com/cal" id="navHome" title="Posted Recently" accesskey="c">Calendar</a></li>
        <li><a href="http://west4me.com/story2" id="navHome" title="Posted Recently" accesskey="s">Stories</a></li>
        <li><a href="http://west4me.com/bookmarks" id="navHome" title="Posted Recently" accesskey="b">Bookmarks</a></li>
        <li><a href="http://west4me.com/wordpress" id="navHome" title="Posted Recently" accesskey="w">Blog</a></li>
        <li><a href="http://west4me.com/webcollab/index.php" id="navHome" title="Posted Recently" accesskey="p">Writing Progress</a></li>
         <li><a href="http://west4me.com/kidscms/index.php" id="navHome" title="Posted Recently" accesskey="f">Student Pages</a></li>
        <li><a href="http://west4me.com/daily/name.php" id="navHome" title="Posted Recently" accesskey="f">Name Draw</a></li>
    <li><a href="http://west4me.com/daily/job2.php" id="navHome" title="Posted Recently" accesskey="f">Jobs</a></li>
    <li><a href="http://west4me.com/daily/lunch.php" id="navHome" title="Posted Recently" accesskey="f">Lunch Choice</a></li>     
        <li><a href="http://west4me.com/daily/" id="navHome" title="Posted Recently" accesskey="f">Daily</a></li>
    </ul>

    <h1><a href="http://west4me.com/daily" title=""></a></h1>        
    <div id="desc">Multiplication Tests</div>
</div>
    <div id="main">
    <div id="content">
                        <div class="post">
                
<div class="post-info"><h2 class="post-title">Multiplication Test Administration</a></h2>
  <p></p>
  </div>

<div class="post-content">
        
        <div align="center"><span>| <a href='admin.php?add=class'>Add Class</a> | <a href='admin.php?add=student'>Add Student</a> | <a href='admin.php?add=scores'>Add Scores</a> | <a href='admin.php?show=completetests'>View Complete Tests</a> |</span></div>


<?
print "<div class='post-content'>";
//this section is for adding a class
if ($_GET["add"] == "class") {
    if ($_GET["add"] == "class" && $_POST["classname"]) {
        $classname = $_POST["classname"];
        $query = mysql_query("INSERT INTO classes (`classid`, `classname`) VALUES ('', '$classname')");
        print "<p>Class $classname was succesfully added to the the classes list</p>";
        exit();    
    }
    print "<div class='post-title'><p>Please type in the box below which classname you would like to add to the list</p></div>";
    print "<form method='post'>
            <table style='width:300px;'>
                <tr><td>Classname</td><td><input type='text' name='classname' /></td></tr>
                <tr><td></td><td><input type='submit' value='Add Class' /></td></tr>
            </table>
            </form>";
    

    
    
//this section is for adding a student
} else if ($_GET["add"] == "student") {
    if ($_GET["add"] == "student" && $_POST["student_classname"] == "select") {
        print "<p>You did not select a class for this student</p>
                <p><a href='admin.php?add=student'>back</a></p>";
        exit();
    } else if ($_GET["add"] == "student" && $_POST["student_studentname"] && $_POST["student_classname"]) {
        
        $studentname = $_POST["student_studentname"];
        $classname     = $_POST["student_classname"];
        $query = mysql_query("INSERT INTO students (`studentid`, `student_name`, `classname`) VALUES ('', '$studentname', '$classname')");
    
        print "<p>Succsfully added student: $studentname to class: $classname</p>";
        
        exit();
    }
    print "<p>Please type the name of the student you would like to add in the box and select the classname that they belong to.</p>";
    print "<form method='post'>
                <table style='width:300px;'>
                    <tr><td>Student Name:</td><td><input type='text' name='student_studentname' /></td></tr>
                    <tr><td>Student Class:</td><td>
                        <select name='student_classname'>
                            <option value='select' selected='selected'>Select</option>";
    $query = mysql_query("SELECT * FROM classes");    
        while ($row = mysql_fetch_array($query)) {
            print "<option value='".$row["classname"]."'>".$row["classname"]."</option>";    
        }
    
    print "    </select>
                    </td></tr>
                    <tr><td></td><td><input type='submit' value='Add Student' /></td></tr>
                    </table>
                    </form>";
    
    
    
    
    
    
    
    
        
} else if ($_GET["add"] == "scores") {
 print "<h2>Please select the class you would like to add results for</h2>";
        $query = mysql_query("SELECT * FROM classes");
        print "<form method='post'>
                <table> 
                    <tr><td>Class</td><td>
                        <select name='add_byclass' onchange='this.form.submit();'>
                            <option value='select' selected='selected'>Select</option>";
        while ($row = mysql_fetch_array($query)) {
            print "<option value='".$row["classname"]."'>".$row["classname"]."</option>";    
        }    
    print "</select></td></tr></table></form>";
            
    
            if ($_GET["add"] == "scores" && $_POST["add_byclass"]) {
                print "<h2>Please select the student you would like to add results for</h2>";
                
                $class = $_POST["add_byclass"];
                $query = mysql_query("SELECT * FROM students WHERE classname = '$class'");
                print "<form method='post'>
                <table> 
                    <tr><td>Student</td><td>
                        <select name='add_byname' onchange='this.form.submit();'>
                            <option value='select' selected='selected'>Select</option>";
                while ($row = mysql_fetch_array($query)) {
                    print "<option value='".$row["student_name"]."'>".$row["student_name"]."</option>";    
                
                }
                print "<input type='hidden' name='student_name' value='".$row["student_name"]."' />
                        </table>
                        </form>";
                print_footer();        
                exit();
            
            }
            if ($_GET["add"] == "scores" && $_POST["add_byname"]) {
                    
                $name = $_POST["add_byname"];        
                $query = mysql_query("SELECT * FROM students WHERE student_name = '$name' ORDER BY student_name");
                if ($row = mysql_fetch_array($query))    {
                        print "<form method='post' action='addscores.php'>                
                        <table width='100%' id='scores'>
                        <tr><th>Name</th><th>Class</th><th>2 x 2</th><th>3 x 3</th><th>4 x 4</th><th>5 x 5</th><th>6 x 6</th><th>7 x 7</th><th>8 x 8</th><th>9 x 9</th>
                            <th>10 x 10</th><th>11 x 11</th><th>12 x 12</th></tr>";
                    do {
                
                        print "<td style='width:50px;'>".$row["student_name"]."</td><td style='width:50px;'>".$row["classname"]."</td>";
                        print "<td><select name='add_2by2'><option value='".$row["2by2"]."'>".$row["2by2"]."</option><option value='Pass'>Pass</option><option value='Fail'>Fail</option></select></td>";
                        for ($n = 3; $n <= 12; $n++) {
                            print "<td><select name=\"add_$nby$n\"><option value='".$row["$nby$n"]."'>".$row["$nby$n"]."</option><option value='Pass'>Pass</option><option value='Fail'>Fail</option></select></td>";
                        }
                        print "</tr>";
                        
                
                    } while ($row = mysql_fetch_array($query));
                }
            
            print "</table>";
            print "<input type='submit' name='add_class_scores' value='Add Scores' />
                    <input type='hidden' value='".$name."' name='student_name' />
                    </form>";
            print_footer();
            exit();    
        }

    
    
    
    
    
    
    
    
    
    
// this section is for showing completed test results, by class or by individual
} else if ($_GET["show"] == "completetests") {
    print "<div class='post-title'><p>Please select by what you would like to view scores</p></div>
            <p><a href='admin.php?show=completetests&type=class'>By Class</a><br /><a href='admin.php?show=completetests&type=individual'>By Individual</a></p>";
    
    if ($_GET["show"] == "completetests" && $_GET["type"] == "class") {
        if ($_GET["show"] == "completetests" && $_GET["type"] == "class" && $_POST["results_byclass"]) {
            $class = $_POST["results_byclass"];
            $query = mysql_query("SELECT * FROM students WHERE classname = '$class'");
            
            if ($row = mysql_fetch_array($query)) {
                print "<h2>Viewing Results by Class</h2>
                        <table width='100%' id='scores'>
                        <th>Name</th><th>Class</th><th>2 x 2</th><th>3 x 3</th><th>4 x 4</th><th>5 x 5</th><th>6 x 6</th><th>7 x 7</th><th>8 x 8</th><th>9 x 9</th>
                        <th>10 x 10</th><th>11 x 11</th><th>12 x 12</th>";            
                do {            
                    
                    print "<tr><td>".$row["student_name"]."</td><td>".$row["classname"]."</td><td class='$class'>".$row["2by2"]."</td>
                            <td class='$class'>".$row["3by3"]."</td><td class='$class'>".$row["4by4"]."</td><td class='$class'>".$row["5by5"]."</td>
                            <td class='$class'>".$row["6by6"]."</td><td class='$class'>".$row["7by7"]."</td><td class='$class'>".$row["8by8"]."</td>
                            <td class='$class'>".$row["9by9"]."</td><td class='$class'>".$row["10by10"]."</td><td class='$class'>".$row["11by11"]."</td>
                            <td class='$class'>".$row["12by12"]."</td>";
                } while ($row = mysql_fetch_array($query));    
                
                print "</table>";
                print_footer();
            }
                
            exit();
        } 
        
        $query = mysql_query("SELECT * FROM classes");
        
        print "<p>Please select which class you would like to see the results for</p>
                <form method='post'>
                    <table style='width:300px'>
                        <tr><td style='width:30px;'>Class</td><td>
                            <select name='results_byclass' onchange='this.form.submit();'>
                                <option value='select' selected='selected'>Select</option>";
        while ($row = mysql_fetch_array($query)) {
                print "<option value='".$row["classname"]."'>".$row["classname"]."</option>";
        }
        
        print "</select></td></tr>
                </table>
                </form>";
                print_footer();
    } else if ($_GET["show"] == "completetests" && $_GET["type"] == "individual") {
        if ($_GET["show"] == "completetests" && $_GET["type"] == "individual" && $_POST["results_byind"]) {
            
            $name = $_POST["results_byind"];
            $query = mysql_query("SELECT * FROM students WHERE student_name = '$name'");
            if ($row = mysql_fetch_array($query)) {
                print "<h2>Viewing Results by Student</h2>
                        <table width='100%' id='scores'>
                        <th>Name</th><th>Class</th><th>2 x 2</th><th>3 x 3</th><th>4 x 4</th><th>5 x 5</th><th>6 x 6</th><th>7 x 7</th><th>8 x 8</th><th>9 x 9</th>
                        <th>10 x 10</th><th>11 x 11</th><th>12 x 12</th>";            
                do {
                    
                for ($n = 2; $n <= 12; $n++) {
                    if ($row["$nby$n"] == " ") $class = "amber";
                    if ($row["$nby$n"] == "Fail") $class = "red";
                    if ($row["$nby$n"] == "Pass") $class = "green";
                }
                    
                    
                    
                    print "<tr><td>".$row["student_name"]."</td><td>".$row["classname"]."</td><td class='$class'>".$row["2by2"]."</td>
                            <td class='$class'>".$row["3by3"]."</td><td class='$class'>".$row["4by4"]."</td><td class='$class'>".$row["5by5"]."</td>
                            <td class='$class'>".$row["6by6"]."</td><td class='$class'>".$row["7by7"]."</td><td class='$class'>".$row["8by8"]."</td>
                            <td class='$class'>".$row["9by9"]."</td><td class='$class'>".$row["10by10"]."</td><td class='$class'>".$row["11by11"]."</td>
                            <td class='$class'>".$row["12by12"]."</td>";
                } while ($row = mysql_fetch_array($query));    
                
                print "</table>";
                print_footer();
                exit();
            }
                
            
        }
        
        $query = mysql_query("SELECT * FROM students");
            
        print "<form method='post'>
                <table>
                    <tr><td>Student</td><td>
                        <select name='results_byind' onchange='this.form.submit();'>
                            <option value='select' selected='selected'>Select</option>";
        while ($row = mysql_fetch_array($query)) {
            print "<option value='".$row["student_name"]."'>".$row["student_name"]."</option>";    
        }    
        
        print "</select></td></tr>
                </table></form>";
                
    }
                        
}

?>
          
          <div class="page-content">
            <div colspan="5" class="post-footer">&nbsp;</div>
          </div>
        </div>
        
        
</div>                            </div>
                                                
                    <p align="center"></p>        
    </div>
    
    
<p id="footer"><a href="http://www.west4me.com/moodle" title="Cunningham">Mr. Cunningham's Classroom</a></p></div>
</div>
</body>
</html>


#2 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 16 June 2006 - 08:20 PM

there's a white space before your <?php in your code. is that from just c/p it here or does your script really have that. that could be your headers already sent error. as far as your invalid resource error, can you post your dbconnect.php code?
Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#3 west4me

west4me
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 16 June 2006 - 09:50 PM

That is a copy/paste error. here is the db-connect
<?

$location = "localhost";
$user = "******";
$password    = "****";
$db = "*****";

$conn = mysql_connect($location, $user, $password) or die("Could not connect to MySQL");
$db = mysql_select_db($db) or die("Could not select database".mysql_error());

?>

THanks for taking the time to look.

#4 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 16 June 2006 - 11:09 PM

add the red part on and tell me what error you get
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
if ($_POST) {


$user = $_POST["username"];
$pass = md5($_POST["password"]);

$query = mysql_query("SELECT * FROM login WHERE username = '$user' AND password = '$pass'")[!--coloro:red--][span style=\"color:red\"][!--/coloro--] or die(mysql_error()) ;[!--colorc--][/span][!--/colorc--]
$row = mysql_fetch_array($query);
[/quote]

Did I help you? Feeling generous? Buy me lunch! 
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community :)

#5 west4me

west4me
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 16 June 2006 - 11:14 PM

This is what I

Can't find file: 'login.MYI' (errno: 2)





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users