PHP is not execute the query from mysql in Linux


 
Thread Tools Search this Thread
Operating Systems Linux PHP is not execute the query from mysql in Linux
# 1  
Old 09-02-2011
Question PHP is not execute the query from mysql in Linux

Hi ,

I have ran the php script from Linux box. It is running, But I can able to see any html content. There is no mysql data on that page. I have checked .

1) Mysql and data bases are connected successfully.

Please help and guild me If I missed any think during the configuration.

Thanks,
Mani
# 2  
Old 09-02-2011
without seeing your code, we cannot tell anything Smilie

Refer here for the basic example of mysql with php

PHP/MySQL Tutorial - Part 4
# 3  
Old 09-02-2011
The same code is working properly in Solaris server.
# 4  
Old 09-02-2011
just execute the below code and check whether you can able to connet to the db properly or not

Code:
 
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

repalce localhost,username and password
# 5  
Old 09-02-2011
Yes, I can able to connect . I got the message the same connected successfully.

---------- Post updated at 01:01 AM ---------- Previous update was at 12:57 AM ----------

Hi, I have checked like this also

<?php
$link = mysql_connect('localhost', 'tst', 'start123');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully ';
echo ' fine fine';
#mysql_close($link);
$db = "tst";
mysql_select_db('tst', $link) or die('Could not select database.');
return $link;
?>

Please help me
# 6  
Old 09-02-2011
Then check your select statement and try to process the resultset one by one. And make sure it retrieves the rows for the given query
# 7  
Old 09-02-2011
Could you please give me that code for that select statement. Because i am a new to php.
If possible help me .
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to write MySQL query in text file and run in Linux?

I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database. I am able to call the .sql file by running .sh file in linux, but the sql query is not working. Below is my syntax. The select statement is throwing below error. ./sample.sql: line... (1 Reply)
Discussion started by: qytan
1 Replies

2. Programming

Need help in mysql query

Hi All, i have a table in mysql with the following data Table name Test Assettype Serial_No Status location Mouse 123456 In Stock chennai Mouse 98765 Allocated chennai Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies

3. Programming

mysql query help

Hello i have created mysql query to compare to values and get difference in percentage as following: SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies

4. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

5. Web Development

about php.ini and mysql linux

I can't use mysql .How should i config the file of php.ini . the message: Fatal error: Call to undefined function mysql_errno() in /var/www/html/inc/dv_clssql.php on line 129 how should i do? please help me (2 Replies)
Discussion started by: fang_xiaoan
2 Replies

6. Virtualization and Cloud Computing

Problems with PHP query to MySQL database

Hello all, I completed a website (it was code by php) and putted it to AWS, I install fedora instance in EC2 with the base is php and mysql. I putted all files of my website to folder /home/webuser/helloworld/htddocs and my database (mysql) to folder /var/lib/mysql/test ("test" is my... (2 Replies)
Discussion started by: hero132
2 Replies

7. Programming

How to query one to many mysql

Hi there, I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks! YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies

8. UNIX for Dummies Questions & Answers

Linux/Unix/PHP/MySQL & servers?

Hello everyone! First I would like to say that I am very glad that I found this forum, and by some of the posts I have viewed, I see that I can learn a lot from you all! Secondly, I know next to nothing about Linux/Unix (gotta learn sometime right?) and need some assistance. I am a... (5 Replies)
Discussion started by: kolton
5 Replies
Login or Register to Ask a Question