LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-17-2015, 05:24 PM   #1
naneus
LQ Newbie
 
Registered: May 2012
Posts: 5

Rep: Reputation: Disabled
mysql is not working in php on centos


I have installed httpd, mysql, php on a centos machine. Php executes in the browser of my machines website, mysql can be ran from the command line, but mysql within php in a browser will not work.
I know my code is syntactically correct since it will run on another Centos Lamp machine and NetBeans says it is.
My code
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="refresh" content="300">
<title> Freeze Warn Points table Query"</title>
</head>
<body>
<?php
include("config.php");
echo $dbhost;
echo "<br />\n";
echo $dbuser;
echo "<br />\n";
echo $dbpasswd;
echo "<br />\n";
mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Unable to connect to database");
echo 'Connected Successfully';
mysql_select_db($dbname);

echo "zone"."&nbsp;&nbsp;&nbsp;&nbsp;";
echo "currentLow"."&nbsp;&nbsp;&nbsp;"."dateLastRep"."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "priority"."&nbsp;&nbsp;&nbsp;"."siteId"."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp"."siteName";
echo "<br />\n";

$result = $sql = 'SELECT zone, currentLow, dateLastRep, pri, siteId, siteName from points order by zone, pri';
$numRows = mysql_num_rows($result);
echo "Matches: ".mysql_num_rows($result);
for($a=0; $a<$numRows; $a++)
{ $rowArray = mysql_fetch_row($result);
echo $rowArray[0]." ".$rowArray[1]." ".$rowArray[2]." ".$rowArray[3]." ".$rowArray[4]."&nbsp;&nbsp;&nbsp".$rowArray[5]."<br />";
}
mysql_close();
?>
</body>
</html>


When executed on the CENTOS lamp machine in question out puts this

"; $result=mysql_query("SELECT rpad(zone,6,'-'), rpad(currentLow,13,'-'), rpad(dateLastRep,13,'-'), rpad(pri,8,'-'), rpad(siteId,6,'-'), siteName from points order by zone, pri"); $numRows = mysql_num_rows($result); for($a=0; $a<$numRows; $a++) { $rowArray = mysql_fetch_row($result); echo $rowArray[0]." ".$rowArray[1]." ".$rowArray[2]." ".$rowArray[3]." ".$rowArray[4]." ".$rowArray[5]."
"; } mysql_close(); ?>


When I put the same code in the other machine, (it does not have the mysql database so it will not connect) displays this

204.227.112.31
apache
password
Unable to connect to database

httpd is running of course
mysqld is running
I have
mysql-server-5.1.73-3.el6_5.x86_64
php-mysql-5.3.3-40.el6_6.x86_64
mysql-devel-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-5.1.73-3.el6_5.x86_64
php-mbstring-5.3.3-40.el6_6.x86_64
php-odbc-5.3.3-40.el6_6.x86_64
php-imap-5.3.3-40.el6_6.x86_64
php-mysql-5.3.3-40.el6_6.x86_64
php-xml-5.3.3-40.el6_6.x86_64
phpmyadmin-2.11.11.3-2.el6.rf.noarch
php-cli-5.3.3-40.el6_6.x86_64
php-xmlrpc-5.3.3-40.el6_6.x86_64
php-gd-5.3.3-40.el6_6.x86_64
php-5.3.3-40.el6_6.x86_64
php-pdo-5.3.3-40.el6_6.x86_64
php-common-5.3.3-40.el6_6.x86_64
php-ldap-5.3.3-40.el6_6.x86_64
php-pear-1.9.4-4.el6.noarch

Installed.

I checked the php.ini files and the httpd.conf files with the LAMP machine it works on and have been unable to find any discrepancies.
Unless I missed something.

Selinux is disabled.

I know it is not my code, but some type of setting somewhere on my machine, I have not been able to find.
I have been unable to find any thing like this issue.

Thanks,
Nancy

Last edited by naneus; 03-17-2015 at 05:27 PM.
 
Old 03-17-2015, 05:43 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 14,932

Rep: Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520Reputation: 1520
Quote:
$result = $sql = 'SELECT zone, currentLow, dateLastRep, pri, siteId, siteName from points order by zone, pri';
Might be a typo with the posted code but the query was never sent. Using code tags improves readability.

$sql = 'SELECT zone, currentLow, dateLastRep, pri, siteId, siteName from points order by zone, pri';
$result= mysql_query($sql);

Check the apache log for errors.

Last edited by michaelk; 03-17-2015 at 05:45 PM.
 
Old 03-26-2015, 12:01 PM   #3
naneus
LQ Newbie
 
Registered: May 2012
Posts: 5

Original Poster
Rep: Reputation: Disabled
My syntax is correct. It runs on another centos machine. I am thinking it may have something to do with Drupal. It is a Drupal site, so I need to research how php/mysql works with Drupal. If anyone has any ideas how to get this to work or with Drupal or if there might be a setting in mysql or php please let me know.
Thanks,
 
Old 04-08-2015, 01:55 PM   #4
naneus
LQ Newbie
 
Registered: May 2012
Posts: 5

Original Poster
Rep: Reputation: Disabled
Solved my problem. Actually PHP was not working when executed in the /data/www/html/sites/default/files directory but would execute from the /data/www/html/ (my webserver home address) and the /data/www/html/sites/ and default directories. I found that it was due to a .htaccess file in the /data/www/html/sites/default/files directory. I got rid of this file and now my php and the MySQL in the php all work beautifully.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP - Problem with mysql integration Centos 5.5 x64 dutchw Linux - Server 4 02-26-2011 04:44 AM
CentOS setting up php / mysql keleas Linux - Server 2 10-28-2010 05:56 AM
mysql/ php5.2.8 /apache 2.1.1 on centos. PHP not being pased!!! ratchie Linux - Newbie 2 12-28-2008 07:55 AM
Centos 5, Apache, php, mysql Anauj0101 Linux - Server 5 02-26-2008 11:39 PM
PHP with MySQL Support not working : mysql.sock DID[DL] Linux - Software 3 11-04-2006 02:26 PM


All times are GMT -5. The time now is 12:56 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration