Hola,
tengo una función en PHP que me lee de un fichero una configuración de
unas tablas de BBDD, quiero que el nombre de las tablas así como los
datos de conexión, me queden residentes en unas variables de sesión.
Cuando registro las variables dentro de la función, al acceder desde
cualquier
english please!!!
___
Mark Snijders, Developer
Atos Origin
Groenewoudeseweg 1, Room VN-515
5621 BA Eindhoven, The Netherlands
* : [EMAIL PROTECTED]
*:+31 (0)40 - 2785992 (tel)
* : +31 (0)40 - 2788729 (fax)
The information in this mail is intended
Hi Francisco José Saiz netPerceptions,
would you be so kind and repeat your mail in english.
Regards,
Ruprecht
--
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax.: +49[0]7621 16 99 16
Homepage: http://www.rheyn.de
email: [EMAIL
through the magic of babelfish!
I have a function in PHP that reads of a file a configuration to me of BBDD
tables, I want that the name of the tables as well as the data of
connection, I have left residents in session variables. When registry the
variables within the function, when acceding from
Hi,
I have made a PHP function that reads a tablename from a file. I want to
keep the tablename value into a session var. I register the session vars
and assign the value. But when I try to access outside the function the
variable is empty.
I do this:
session_start();
function OneFunction
{
probably b/c of grants/rights
did you run a -- grant all on *.* to user@localhost ? or something of the
sort. or set up root to have access
can you connect via command line?
HTH
Jeff
how do you do this? I guess I could look it up in the help files. I don't
need the firewall as it is behind one at home.
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:45 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
that didn't cause me any issues on my install. why do you have to turn
that off. i'm not doubting you, just curious?
Jeff
SELPH,JASON
can't seem to find that line in the install file but I probably don't know
what I am looking for
IS this the install doc you meant?
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#In
stalling
Thanks,
Eddie
-Original Message-
From: [EMAIL PROTECTED]
by default on a new xp install the firewall is enabled. stops everything on
your network from getting thru. if port 3306 is blocked then accessing
mysql thru ip would be denied.
To disable internet connection firewall...
I have not installed mysql on xp, but the same thing happens with irc,
I honestly can't give you an answer on that as I haven't installed mysql on
XP. On linux there are 2 ways to connect to your server, socket or tcp. I
am not sure on the windows version. I just know that trying to access
anything on a firewalled machine, even from itself, via tcp with XP didn't
The problem is that you're printing $size, but size is the result
code for the mysql_query() function.
--
$size = mysql_query($query,$db) or die(query: . mysql_error());
--
You need to fetch the values as you did in the first query.
--- Max Clark [EMAIL PROTECTED] wrote:
Help-
When I run
Try mysql_connect instead. Doesn't sound as if you are at the stage at
which you would realize any gains from a persistent connection. I've
just seen a lot of comments regarding strange happenings with pconnect
- which I have no doubt will be addressed later.
Don Briggs wrote:
While
Hi all,
I want to grab the resul from a db query and store it in an array so that I
can selectively grab the data later.
This is what I'm doing:
$dbRowCount = mysql_num_rows( $result );
for ($i = 1; $i = $dbRowCount; ++$i) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
Hi,
first leave out the loop with for ($i...).
then use the loop with while and make sure that you create arrays. you're
currently filling the same variables with different results each time. the last
one always overwrites the ones bevor.
so add those brackets: []:
$dbRow['ev_id'][]=
Bastian,
That's great - it does the trick perfectly. Many thanks.
George
-Original Message-
From: Bastian Vogt [mailto:[EMAIL PROTECTED]]
Sent: 13 December 2002 3:18 pm
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Dumping MySQL rows into a 2D array
Hi,
first leave out the
Thanks for all the help. I finally got it running by running winmysqladmin
Eddie
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 9:29 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
We are currently running two report generation applications where PHP is
running on Linux machines and queries data from Windows NT servers
running MSSQL 7.0
We have reports that deal with millions of records, and whether they run
for 4 minutes or 20, I have only seen robust results from the
I know this isn't db related but...I finally go mysql and apache running on
my laptop now I am trying to get php working. I downloaded the
php-4.2.3-installer this morning. Ran the install and am now going through
the install instructions. I noticed it said to copy these lines into the
apache
Thanks, I'll try it now.
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 1:49 PM
To: Francisco José Saiz :: netPerceptions
Subject: Re: [PHP-DB] Variables de SESSION dentro de funciones PHP
You're mixing register_globals off session
I was playing around with this, and created a DOS batch file that
should be equivalent. Note it was about 15 minutes of work including
debugging, so I can't guarantee success. It's nothing compliated, but
if oyu need to get mysql data into excel often, this might help.
--query.bat--
rem Show the
I have a few hundred rows of data to import into a mysql db. Its currently
tab separated.
What's the most straight forward way (ie i dont want to enter it line by
line) of doing a bulk import?
I have full admin rights to my dev server. Is there a method or software app
that people can recommend
use mysqlimport, its a program that comes with MySQL. go to www.mysql.com
and click on documentation to learn more about it.
Adam
On Fri, 13 Dec 2002, mikek wrote:
I have a few hundred rows of data to import into a mysql db. Its currently
tab separated.
What's the
I am using PHP and MySQL and in one section I am trying to SELECT for a
table where unit_id = $variable. In that column I have several blank items.
When I select a particular variable I get that plus all the blanks. I
presume there is some way of getting just those which meet my criteria.
--
I have a few hundred rows of data to import into a mysql db. Its currently
tab separated.
What's the most straight forward way (ie i dont want to enter it line by
line) of doing a bulk import?
I have full admin rights to my dev server. Is there a method or software
app
that people can
Try:
SELECT some_column FROM some_table WHERE column_value IS NOT NULL AND
unit_ID=$variable
If that's kind of what you're looking for, there's good info in the MySQL
manual about the WHERE condition and other sorting and selecting options.
HTH
-Original Message-
From: Alex Francis
SELECT jouw_id
FROM A AS A1, A AS A2
WHERE A1.merkid=1
AND A2.merk_id=2
AND A1.jouw_id=A2.jouw_id
this is a self join!
thanks to vincent @ www.yapf.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
If you want MySQL to work in XP, make sure that you have the proper version
(XP/2000/NT) and in the advanced settings of your firewall, make sure to
allow TCP port 3306 to have full internet access from inside as well as out.
Good luck,
Tyler
- Original Message -
From: SELPH,JASON
28 matches
Mail list logo