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';
how to configure ADS in ABAP instance
Hi All,
Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so I don't quite understand what they're talking about or what the code means.Here's the situation: I
PHP - HTTP Digest Authentication - Understanding Code Help
Hi Everyone,This is my first time on your website and please excuse if I am asking silly question.I have a question about PHP HTTP DIGEST AUTHENTICATION - published in PHP Manual - php.netTheir
Gantt Chart Tool
Does anyone know of a good free gantt chart creator toolThanks
Empty text file when there is over XXXX lines of text.
define("RANDOM_FILE","/public_html/random.txt"); $randomEntry = "This goes in text file.\n"; { $randomFile = fopen(RANDOM_FILE,"a"); }
How to file_get_contents when login required?
Hello!I am trying to read data from a page that you have to be logged into to view, I am trying to use file_get_contents to do this, I have read that I need to use cURL, Is that true?Also, as Another
A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.rank ...set @rank := 0;select @rank:=@rank+1 'rank', users.username, users.points from users order by
problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mine, i grabbed it from here http://www.phpfreaks.com/tutorial/basic-paginationNow onto the
Got A Free Server :(
So I was given a free server http://shopping.yahoo.com/p:Compaq%20ProLiant%201500%20Server:1990708735It is a Compaq Proliant 1500 :|And I cannot seem to get it to install any OS from the CD drive
Problem with creating FI documents
Hi, Experts!