Hello community!
I am successfully using mysql connections and operations in more than one
php file.
But when I want to use this in an included (required("header.inc.php")) php
file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?
with kind regards
Wolfgang L. 8 2830
Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L.
I'm not sure I understand the syntax you're using. It should be something like
this (note there is no "d" on the end of include or require):
include ("header.inc.php");
or
require ("header.inc.php");
If that's what you have, are you sure you have the path right? The syntax above
should be used if the include file is in the same directory as the script you're
including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php")
Is the file actually being included? If you're not sure, type:
echo "<BR><BR>!!!FOO!!!<BR><BR>";
or similar on a line in the include file.
If that's prints out okay, maybe you should describe the mysql error you're
getting.
Regards,
Shawn
--
Shawn Wilson sh***@glassgiant.com http://www.glassgiant.com
"Shawn Wilson" <sh***@glassgiant.com> wrote in message
news:3F***************@glassgiant.com... Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than
one php file. But when I want to use this in an included (required("header.inc.php"))
php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L. I'm not sure I understand the syntax you're using. It should be something
like this (note there is no "d" on the end of include or require):
include ("header.inc.php"); or require ("header.inc.php");
If that's what you have, are you sure you have the path right? The syntax
above should be used if the include file is in the same directory as the script
you're including it in. Otherwise, you have to include path info. (i.e. "../../header.inc.php" or "/home/yourdirectory/header.inc.php")
Is the file actually being included? If you're not sure, type:
echo "<BR><BR>!!!FOO!!!<BR><BR>";
or similar on a line in the include file.
If that's prints out okay, maybe you should describe the mysql error
you're getting.
Regards, Shawn
the syntax is ok. the file is also included, because i get use of functions
in that specific file in other php
files.
On my local machine i get:
"2003 Can't connect to MySQL server on 'localhost' (10061)"
An on the sourceforge server i get:
"2002 Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)"
you can see it on http://fsth.sourceforge.net
"Wolfgang Lang" <la***********@aon.at> wrote in message
news:3f***********************@newsreader01.highwa y.telekom.at... "Shawn Wilson" <sh***@glassgiant.com> wrote in message news:3F***************@glassgiant.com... Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included
(required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L. I'm not sure I understand the syntax you're using. It should be
something like this (note there is no "d" on the end of include or require):
include ("header.inc.php"); or require ("header.inc.php");
If that's what you have, are you sure you have the path right? The
syntax above should be used if the include file is in the same directory as the
script you're including it in. Otherwise, you have to include path info. (i.e. "../../header.inc.php" or "/home/yourdirectory/header.inc.php")
Is the file actually being included? If you're not sure, type:
echo "<BR><BR>!!!FOO!!!<BR><BR>";
or similar on a line in the include file.
If that's prints out okay, maybe you should describe the mysql error you're getting.
Regards, Shawn
the syntax is ok. the file is also included, because i get use of
functions in that specific file in other php files.
On my local machine i get: "2003 Can't connect to MySQL server on 'localhost' (10061)"
An on the sourceforge server i get: "2002 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
you can see it on http://fsth.sourceforge.net
sorry, did not use the right parameters.
the actual error message is:"1044 Access denied for user:
'f***@sc8-pr-web4-b.sourceforge.net' to database 'news'"
but witz guestbook and news i can connect.
Wolfgang Lang wrote: "Shawn Wilson" <sh***@glassgiant.com> wrote in message news:3F***************@glassgiant.com... Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L.
I'm not sure I understand the syntax you're using. It should be something like this (note there is no "d" on the end of include or require):
include ("header.inc.php"); or require ("header.inc.php");
If that's what you have, are you sure you have the path right? The syntax above should be used if the include file is in the same directory as the script you're including it in. Otherwise, you have to include path info. (i.e. "../../header.inc.php" or "/home/yourdirectory/header.inc.php")
Is the file actually being included? If you're not sure, type:
echo "<BR><BR>!!!FOO!!!<BR><BR>";
or similar on a line in the include file.
If that's prints out okay, maybe you should describe the mysql error you're getting.
Regards, Shawn
the syntax is ok. the file is also included, because i get use of functions in that specific file in other php files.
On my local machine i get: "2003 Can't connect to MySQL server on 'localhost' (10061)"
An on the sourceforge server i get: "2002 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
you can see it on http://fsth.sourceforge.net
The error I see is:
1044 Access denied for user: 'f***@sc8-pr-web1-b.sourceforge.net' to database
'news'
Have you set up that user with the appropriate permissions?
Are you able to connect to mysql on your local machine with other scripts?
Regards,
Shawn
--
Shawn Wilson sh***@glassgiant.com http://www.glassgiant.com
"Shawn Wilson" <sh***@glassgiant.com> wrote in message
news:3F***************@glassgiant.com... Wolfgang Lang wrote: "Shawn Wilson" <sh***@glassgiant.com> wrote in message news:3F***************@glassgiant.com... Wolfgang Lang wrote: > > Hello community! > > I am successfully using mysql connections and operations in more
than one > php file. > But when I want to use this in an included
(required("header.inc.php")) php > file but nothing happens except an error on > mysql_select. > Has mysql problems from included files or what could be the problem? > > with kind regards > Wolfgang L.
I'm not sure I understand the syntax you're using. It should be
something like this (note there is no "d" on the end of include or require):
include ("header.inc.php"); or require ("header.inc.php");
If that's what you have, are you sure you have the path right? The
syntax above should be used if the include file is in the same directory as the
script you're including it in. Otherwise, you have to include path info. (i.e. "../../header.inc.php" or "/home/yourdirectory/header.inc.php")
Is the file actually being included? If you're not sure, type:
echo "<BR><BR>!!!FOO!!!<BR><BR>";
or similar on a line in the include file.
If that's prints out okay, maybe you should describe the mysql error you're getting.
Regards, Shawn
the syntax is ok. the file is also included, because i get use of
functions in that specific file in other php files.
On my local machine i get: "2003 Can't connect to MySQL server on 'localhost' (10061)"
An on the sourceforge server i get: "2002 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
you can see it on http://fsth.sourceforge.net
The error I see is: 1044 Access denied for user: 'f***@sc8-pr-web1-b.sourceforge.net' to
database 'news'
Have you set up that user with the appropriate permissions?
Are you able to connect to mysql on your local machine with other scripts?
Regards, Shawn
yes, i connect to the same database and table on news.php with the same
user/pass settings
Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L.
For connections inside of an included file, make sure you do something like
$MySQL_Link = mysql_connect(....);
and then in the other files, you do
mysql_query(...., $MySQL_Link);
if you leave off the handle for the database connections, you could have
problems.
"Agelmar" <if**********@comcast.net> wrote in message
news:bs***********@ID-30799.news.uni-berlin.de... Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L. For connections inside of an included file, make sure you do something
like $MySQL_Link = mysql_connect(....);
and then in the other files, you do mysql_query(...., $MySQL_Link);
if you leave off the handle for the database connections, you could have problems.
but in the php files and the included file i use separate mysql
connection/handles.
i always connect, make my select,... and then close the connection.
could this be a problem? should i use one connection for all queries?
Wolfgang Lang wrote: "Agelmar" <if**********@comcast.net> wrote in message news:bs***********@ID-30799.news.uni-berlin.de... Wolfgang Lang wrote: Hello community!
I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing happens except an error on mysql_select. Has mysql problems from included files or what could be the problem?
with kind regards Wolfgang L.
For connections inside of an included file, make sure you do something like $MySQL_Link = mysql_connect(....);
and then in the other files, you do mysql_query(...., $MySQL_Link);
if you leave off the handle for the database connections, you could have problems. but in the php files and the included file i use separate mysql connection/handles. i always connect, make my select,... and then close the connection. could this be a problem? should i use one connection for all queries?
It's certainly easier to just use one connection for all queries. Less work
on both servers, and less prone to errors (forgetting to re-open one,
mis-typing something somewhere etc.) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: francescomoi |
last post by:
Hi.
I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2:
----------------------------------
# export PATH=$PATH:/usr/local/mysql/bin/
# export mysqlclient=mysqlclient_r
# python setup.py...
|
by: mikey |
last post by:
Hi all,
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.
There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I...
|
by: Yun Guan |
last post by:
Hello mysql gurus,
I am trying to run perl on mysql database on Red Hat box. I want to install
DBI and DBD:mysql using CPAN:
perl -MCPAN -e shell
cpan>install DBI
The above succeeded, but...
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest...
|
by: Saqib Ali |
last post by:
I installed mySQL and have it running.... but I think I made a
mistake somewhere along the line...... I believe I did follow the
instructions that were provided with the distribution at:...
|
by: Alex Hunsley |
last post by:
I am trying to install the DBD::mysql perl module. However, it claims I
need mysql.h:
cpan> install DBD::mysql
CPAN: Storable loaded ok
Going to read /home/alex/.cpan/Metadata
Database was...
|
by: ./Rob & |
last post by:
Hi gang:
I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0
to 4.1.10 and now when I login as root it doesn't show all the databases I
should have access to, nor it...
|
by: trihanhcie |
last post by:
I m currently working on a Unix server with a fedora 3 as an os
My current version of mysql is 3.23.58. I'd like to upgrade the version
to 5.0.18.
After downloading from MYSQL.COM the package on...
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
...
|
by: menzies |
last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |