I am writing an application to do annual reviews. I cannot get my script to work. Whenever it runs I get the following error:
Code: $username='far'; $password='c00lfarus3r@'; $database='far';
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/FARv2/scripts/insertsection1.php on line 18
Unable to select database.
This does not make sense to me. It has the username and password variables and does not seem to be using them. Who is user www-data? I am pretty new to php so I don't know where to start.
Here are all of the files:
Input Page - section1.php:
Code: <?php include('./includes/doc_top.php');?>
<div class="container">
<form action="scripts/insertsection1.php" method="POST">
<h1>Teaching/Advising</h1>
<div class="entry_box">
<h4>1.A. Courses taught including the summer term.</h4>
<textarea name="_1a"></textarea>
</div>
<strong>Note:</strong> The information provided below is automatically generated:
<table>
<tr>
<td>Course</td><td>Title</td><td>Term</td>
</tr>
</table>
<div class="entry_box">
<h4>1.B. Independent Study Supervision</h4>
<textarea name="_1b"></textarea>
</div>
<h3>1.C. Other Academic Assignments</h3>
<div class="entry_box">
<h4>1. Undergraduate Advising</h4>
<textarea name="_1c1"></textarea>
</div>
<div class="entry_box">
<h4>2. Senior Design Committee</h4>
<textarea name="_1c2"></textarea>
</div>
<div class="entry_box">
<h4>1.D. Teaching Awards and Recognition</h4>
<textarea name="_1d"></textarea>
</div>
<div class="entry_box">
<h4>1.E. Course-Faculty Survey Results</h4>
<textarea name="_1e"></textarea>
</div>
<strong>Note:</strong> The information provided below is automatically generated:
<table>
<tr>
<td>Course</td><td>Term</td><td>Course Rating</td><td>Faculty Rating</td><td># of Student Responses</td>
</tr>
</table>
<div class="entry_box">
<h4>1.F. Course/Lab Development and Major Revision Activity</h4>
<textarea name="_1f"></textarea>
</div>
<h3>1.G. Student Design Projects</h3>
<div class="entry_box">
<h4>1.G.1. Freshman Design Supervision</h4>
<textarea name="_1g1"></textarea>
</div>
<div class="entry_box">
<h4>1.G.2. Senior Design Supervision</h4>
<textarea name="_1g2"></textarea>
</div>
<div class="entry_box">
<h4>1.H. Examples of Innovation in Teaching</h4>
<textarea name="_1h"></textarea>
</div>
<div class="entry_box">
<h4>1.I. E-Learning and Distance Learning</h4>
<textarea name="_1i"></textarea>
</div>
<div class="entry_box">
<h4>1.J. Other Teaching Related Activities (UNIV 101, Honors Seminar)</h4>
<textarea name="_1j"></textarea>
</div>
<input type="submit" value="Submit Secion 1">
</form>
</div>
</body>
</html>
Input Script - insertsection1.php
Code: <?php
include('./../includes/db_connect.php');
$_1a=$_POST['_1a'];
$_1b=$_POST['_1b'];
$_1c1=$_POST['_1c1'];
$_1c2=$_POST['_1c2'];
$_1d=$_POST['_1d'];
$_1e=$_POST['_1e'];
$_1f=$_POST['_1f'];
$_1g1=$_POST['_1g1'];
$_1g2=$_POST['_1g2'];
$_1h=$_POST['_1h'];
$_1i=$_POST['_1i'];
$_1j=$_POST['_1j'];
mysql_connect(localhost,$database,$password);
@mysql_select_db(far) or die ("Unable to select database.");
$query = "INSERT INTO far VALUES ('$_1a','$_1b','$_1c1','$_1c2','$_1d','$_1e','$_1f','$_1g1','$_1g2','$_1h','$_1i','$_1j')";
mysql_query($query);
mysql_close();
?>
Output Page - output.php
Code: <?php
include('./../includes/db_connect.php');
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die("Unable to select database");
$query="SELECT * FROM section1";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b>";
$i=0;
while($i < $num) {
$_1a=mysql_result($result,$i,"_1a");
$_1b=mysql_result($result,$i,"_1b");
$_1c1=mysql_result($result,$i,"_1c1");
$_1c2=mysql_result($result,$i,"_1c2");
$_1d=mysql_result($result,$i,"_1d");
$_1e=mysql_result($result,$i,"_1e");
$_1f=mysql_result($result,$i,"_1f");
$_1g1=mysql_result($result,$i,"_1g1");
$_1g2=mysql_result($result,$i,"_1g2");
$_1g=mysql_result($result,$i,"_1h");
$_1i=mysql_result($result,$i,"_1i");
$_1j=mysql_result($result,$i,"_1j");
}
?>
<h2>1.A. Courses taught including the Summer Term</h2>
<div class="output">
<?php echo $_1a;?>
</div>
<h2>1.B. Independent Study Supervision
<div class="output">
<?php echo $_1b;?>
</div>
<h2>1.C. Other Academic Assignments</h2>
<h3>1. Undergraduate Advising</h3>
<div class="output">
<?php echo $_1c1;?>
</div>
<h3>2. Senior Design Committee</h3>
<div class="output">
<?php echo $_1c2;?>
</div>
<h2>1.D Teaching Awards and Recognition</h2>
<div class="output">
<?php echo $_1d;?>
</div>
<h2>1.E. Course-Faculty Survey Results
<div class="output">
<?php echo $_1e;?>
</div>
<h2>1.F. Course/Lab Development and Major Revision Activity</h2>
<div class="output">
<?php echo $_1f;?>
</div>
<h2>1.G. Student Design Projects</h2>
<h3>1. Freshman Design Supervision</h3>
<div class="output">
<?php echo $_1g1;?>
</div>
<h3>2. Senior Design Supervision</h3>
<div class="output">
<?php echo $_1g2;?>
</div>
<h2>1.H. Examples of Innovation in teaching
<div class="output">
<?php echo $_1h;?>
</div>
<h2>1.I. E-Learning and Distance Learning
<div class="output">
<?php echo $_1i;?>
</div>
<h2>1.J. Other Teaching Related Activities (UNIV 101, Honors Seminar)</h2>
<div class="output">
<?php echo $_1j;?>
</div>
Usernames and Passwords - db_connect.php:
Code: $username='far';
$password='c00lfarus3r@';
$database='far';
Database 'Validation'
Hi everyone,I'm trying to validate the password entered by the user with the password in the database. I've worked out that it checks the username fine (if the username doesn't exist it displays an
Preserving user-entered linebreaks
Hi, I'm building a web 2.0 thingy from scratch and I wanna display text which users input. It's all good so far, except that all the linebreaks are destroyed, so no matter how carefully they insert
Remove directories not empty
hi,i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.I must to delete only the folders in array, i use this code:Code: $all_folders = array();while ($row =
PHP - HTML
Could anyone give me some GOOD sample links for php - html email tutorial.Thanks!
timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)in my mysql db using the time()and when i show the time on webpages i use the date('ymd/h:i:s', $time) kind of thing.now
i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understand simple arrays, associative arrays, and multidimensional arrays also. The book I am reading
cURL proxy
Okay here is the thing... i know how to add proxysCode: curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);curl_setopt($ch, CURLOPT_PROXY,"[i][b]PROXYHERE[/b][/i]");Here are my questions..
Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.In a nutshell, the first page is entirely html and calls a php script to process an uploaded file and some form fields using POST. After validating the
Checking if field is empty AND using !is_numeric
Hi lads,Need to be able to display an error message (using isset?) that says "Cant leave field blank" when someone clicks on submit after leaving the field blank. The problem is that I'm