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> 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';
No comments posted yet
Your Answer:
Login to answer
72 
11 
Other forums
update the selected existing records of database
Hi frndz,
I am new to php and get stuck....
Edit.php > Update.php > Updatea
simplexml_load_file and rss problem
Hi,
I have a problem parsing an rss feed using simplexml_load_file - this is strange as i hav
Java API in PHP?
I have an application that we use internally here at the office.
The software company provide
rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam
Remove values in array2 from array1
I have two arrays.
Array 1 is where the array key holds various different numbers. For exampl
insert/update functions for mysql, what do you think?
I am working on two really simple functions that automatically generate (and execute) insert and upd
Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi
square instead of number
Hello
I do not know why but this code seems to work fine only in my xampp local insallation but n
Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag
session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of
