Cannot Connect to Database


Posted on 16th Feb 2014 07:03 pm by admin

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>&nbsp;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>&nbsp;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';

No comments posted yet

Your Answer:

Login to answer
72 Like 11 Dislike
Previous forums Next forums
Other forums

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:

Code: [Select]$query

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

need help in php variable
i have a php variable on one page
Code: [Select]$lastId = mysql_insert_id($db);
echo $lastId;<

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash