> Hello,
>
> i am writing a login script with php and mysql:
>
> while($dbbenutzer = mysql_fetch_row($sqlbenutzername))
> while($dbpasswort = mysql_fetch_row($sqlpasswort)){
>
>
>echo $dbbenutzer[$i];
>echo $dbpasswort[$j];
>if($benutzername == $dbbenutz
Quoting PK :
I am new to PHP and as well as with MySQL,
I have installed PHP 5.28, on win XP (with Apache 2.09)...
any guess what i am doing wrong, i am sure that it is some
configuration error.
A absolute easy install solution can be at...
web.walters-way.com
Directions on installing:
*doooh*
I forgot you use Apache instead of IIS ... if php is set up to log errors to
the windows log (entry "error_log" with value "syslog" in php.ini), then you'll
find errors and warnings in your event log, otherwise have a look at your
apache logs (as mentioned by Antonio). And if you check
Hi
Also make sure that the php.ini file listed as being used in phpinfo()
is the one that you are making the changes in.
--
Niel Archer
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ngs are. If the dlls are in the wrong place, move them and
restart apache
-Original Message-
From: Antonio CS [mailto:antoni...@gmail.com]
Sent: 17 June 2009 16:51
To: Will Fitch
Cc: kprateek...@gmail.com; php-windows@lists.php.net
Subject: Re: [PHP-WIN] MySQL Configuration on Windows Box
Hi Prateek,
Prateek wrote:
> Now I want to use MySQL with PHP, but seems that *MySqli* is not
> installed properly. as when I write a following script in a php page I
> get a error ...
>
> *
> any guess what i am doing wrong, i am sure that it is some configuration
> error.
>
> Prateek
>
> --
>
Don't know if this was sent correctly but here it goes again!!
See if the extension dir ini entry is set correctly.
Look for:
extension_dir = "./"
This is normally not set correctly in windows.
Also check Apache's error log files, they should say something about not
being able to load the driv
It's a long shot, but have you restarted Apache?
--
Thanks,
Will Fitch
Zend Certified Engineer
Cell: 931.205.8242
Fax: 931.914.1206
-Original Message-
From: PK [mailto:kprateek...@gmail.com]
Sent: Wednesday, June 17, 2009 9:44 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] MySQL Co
See if the extension dir ini entry is set correctly.
Look for:
extension_dir = "./"
This is normally not set correctly in windows.
Also check Apache's error log files, they should say something about not
being able to load the drivers etc
Good Luck
On Wed, Jun 17, 2009 at 4:38 PM, PK wrote:
<<<
You may be try also the phpinidir directive in apache so that you does't have
to copy php.ini to windows folder.
as PHPIniDir "c:/webroot/php"
It works for me
>>>
Well the problem has been really with libmysql.dll. I'm not sure wht is the lib
for. But read somwhere about it. Some notice.
--Original Message-
From: Eric Lee [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2008 7:42 AM
To: php-windows@lists.php.net
Subject: Re: [PHP-WIN] MySQL on Windows
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: "Eric Lee" <[EMAIL PROTECTED]>
To:
Sent: Monday, June 23, 2008 7:18 AM
Subject: Re: [PHP-WIN]
@lists.php.net
Subject: Re: [PHP-WIN] MySQL on Windows
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: "S. Buffn" <[EMAIL PROTECTED]>
To: "Eric Lee" <[EMAIL PROTEC
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: "S. Buffn" <[EMAIL PROTECTED]>
To: "Eric Lee" <[EMAIL PROTECTED]>;
Sent: Monday, June 23, 2008 6:30 AM
p and included in
the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but WITHOUT ANY
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: "S. Buffn" <[EMAIL PROTECTED]>
To:
Sent: Sunday, June 22, 2008 10:01 PM
Subject: [PHP-WIN] MySQL on Windows
: Hello,
:
: I have encounte
S. Buffn wrote:
> Hello,
>
> I have encountered the problem with running MySQL Server 5.0 with PHP 5 and
> Apache2 on Windows XP.
...
> PHP is running
> Fatal error: Call to undefined function mysql_connect() in C:\Program
> Files\Apache Group\Apache2\htdocs\index.php on line 6
> As for the php.in
S. Buffn wrote:
Hello,
I have encountered the problem with running MySQL Server 5.0 with PHP 5 and
Apache2 on Windows XP.
Everrything seems to be ok, so Apacheh is running, also together with php.
If I run php -m it shows the library for MySQL is included. Even if I run
php.exe -f index.php
it
You need a registry entry in HKLM\Software\PHP called IniFilePath set
to where your ini file is. This will get it to load the correct ini
file, so then the extensions should be loaded. Put the following into a
.reg file and run it and it will create the entry required.
Windows Registry Editor V
exta-feira, 18 de Janeiro de 2008 16:12
To: Bruce Cowin
Cc: Jacob Kruger; Subject: Re: [PHP-WIN] mysql not working but very odd
bruce,
I just upgraded php to make sure all is good and i see this problem,
my php.ini is in c:\php but it's reading it from c:\windows
i copied it over but same pro
ROTECTED]>
To: "Jacob Kruger" <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2008 6:01 PM
Subject: Re: [PHP-WIN] mysql not working but very odd
Not really, I don't want to run apache at all.
On 1/18/08, Jacob Kruger <[EMAIL PROTECTED]> wrote:
I had similar problems
bruce,
I just upgraded php to make sure all is good and i see this problem,
my php.ini is in c:\php but it's reading it from c:\windows
i copied it over but same problem, any ideas?
On 1/17/08, Bruce Cowin <[EMAIL PROTECTED]> wrote:
> And if it's not pointing to the php.ini file you may need the r
And if it's not pointing to the php.ini file you may need the registry
entry as per my previous email.
Regards,
Bruce
>>> "Jacob Kruger" <[EMAIL PROTECTED]> 18/01/2008 8:50:44 a.m. >>>
Not sure if this is relevant, but if you run phpinfo(), it should tell
you
which php.ini is being implemented
Not sure if this is relevant, but if you run phpinfo(), it should tell you
which php.ini is being implemented, and in that, maybe just double-check
that the correct paths for the ext's is being implemented to actually load
those extensions.
HTH
Jacob Kruger
Blind Biker
Skype: BlindZA
'...Fate ha
Not to mention that read would most likely be a tinyint(1), and thus
shouldn't be fed a character.
Stut wrote:
Please include the list when replying.
James Blandford wrote:
It seems i have fixed it >_< thanks for your time thou. It turns out
that I couldn't have "read" as a field name due to
<[EMAIL PROTECTED]>
Cc:
Sent: Saturday, June 30, 2007 10:55 PM
Subject: Re: [PHP-WIN] MySQL query error
James Blandford wrote:
Hello,
I am making a private messaging system for my website, and if you
click on the pm, it --should-- set it as "read" rather than "unread"
James Blandford wrote:
Hello,
I am making a private messaging system for my website, and if you click
on the pm, it --should-- set it as "read" rather than "unread". I am
using the query:
UPDATE pms SET read=1 WHERE id='{$assoc['id']}'
but it is giving me this error:
You have an error in your
From: "Birt.Ecplipse" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 23, 2007 5:03 PM
Subject: Re: [PHP-WIN] Mysql and Textarea (Please help me figure out this
problem. I' m stuck. Please help me!!! )
> Looks like a problem in the definition of the TEXTAREA NAME.
> The echo state
Looks like a problem in the definition of the TEXTAREA NAME.
The echo statement is started and ended with a '
While in the $row['ID'] also a quote is used. So the echo string looks not
correct.
Try:echo ' wrote in message
news:[EMAIL PROTECTED]
> use $_POST[your var] in this script..
> not
use $_POST[your var] in this script..
not simple but worked..
other option
$_HTTP_POST_VARS[your var]
- Original Message -
From: "sam rumaizan" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 23, 2007 4:13 AM
Subject: [PHP-WIN] Mysql and Textarea (Please help me figure out this
problem. I
Is it just me or are you missing a tag?
That'd explain the form not posting...
Mike
sam rumaizan skrev:
I'm just a php beginner.
So please be patient with my stupid questions.
What am I missing in this code that causing the function can’t update the textarea?
Update button eras
Hi!
Ok... Thanx!
Best regards
/Gustav Wiberg
-Original Message-
From: Mikael Grön [mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 1:41 PM
To: ''php windows' (php-windows@lists.php.net)'
Subject: Re: [PHP-WIN] MySQL Dump
Oh yeah, of course. :)
Mike
Gusta
s@lists.php.net)'
Subject: Re: [PHP-WIN] MySQL Dump
mysqldump -uusername -p -A > output.file
Enter password: [password]
Done
Gustav Wiberg skrev:
Hi there!
Thanx! Does this mean that I can't use option -ALL databases when using
usernames and passwords?
(I want to create a
Hi there!
Username and password for root (for all databases then) you mean?
/Gustav
-Original Message-
From: Mikael Grön [mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 1:32 PM
To: ''php windows' (php-windows@lists.php.net)'
Subject: Re: [PHP-WIN] M
Best regards
/Gustav Wiberg
-Original Message-
From: Mikael Grön [mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 11:49 AM
To: 'php windows' (php-windows@lists.php.net)
Subject: Re: [PHP-WIN] MySQL Dump
mysqldump -uusername -ppassword database > output.file
or
my
ECTED]
Sent: Monday, May 14, 2007 11:49 AM
To: 'php windows' (php-windows@lists.php.net)
Subject: Re: [PHP-WIN] MySQL Dump
mysqldump -uusername -ppassword database > output.file
or
mysqldump -uusername -p database > output.file
which lets you specify the password cloaked right a
Hi there!
Thanx. Does this mean that I have to this on each database if I want to create
ba
-Original Message-
From: Mikael Grön [mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 11:49 AM
To: 'php windows' (php-windows@lists.php.net)
Subject: Re: [PHP-WIN] MySQL Dump
mysqldump -uusername -ppassword database > output.file
or
mysqldump -uusername -p database > output.file
which lets you specify the password cloaked right after you've hit enter.
Remember, no spaces between -u and the username or -p and the password.
Mike
Gustav Wiberg skrev:
Hi!
Trying to
Try dropping the libmysql.dll file in your windows/system32 directory.
Or add the PHP directory to your PATH environment variable. Cheers.
Armando
Mikey wrote:
Vincent Kruger wrote:
My php 5.0.5 doesn't want to load the mysql module and the libmysql
file is
in the root directory of php I jus
Vincent Kruger wrote:
My php 5.0.5 doesn't want to load the mysql module and the libmysql file is
in the root directory of php I just can't seem to get it working. I've also
upgraded to mysql 4.1.12 but that’s working fine.
Please help.
Have you enabled it in the extensions section of the
you may also consider using
$mysql = @mysql_connect(...);
to get rid of the warning if it is on.
On 8/17/05, Paul Menard <[EMAIL PROTECTED]> wrote:
> Well you can start with the mysql_connect() call. If you are unable to
> connection check the error
> code. Then take action if needed.
>
Well you can start with the mysql_connect() call. If you are unable to
connection check the error
code. Then take action if needed.
--- Jon <[EMAIL PROTECTED]> wrote:
> Is there some way to have PHP test if MySQL is running and if not make the
> system call to start it?
>
> This is just an ME
What version of PHP and MySQL. For a long time PHP comes with MySQL support
compiled in
(especially on Windows).
P
--- "Brian D. McGrew" <[EMAIL PROTECTED]> wrote:
> I installed a pretty general manual installation of PHP and it's
> working, I do a phpinfo() and life is good. I can't seem to g
This has been solved. The problem was 'pilot error'.
This is indeed the right syntax to change a table
name.
--- Patrick Roane <[EMAIL PROTECTED]> wrote:
> I am trying to rename my table, but I get a syntax
> error.
>
> ALTER TABLE myblobs RENAME myBlobs;
>
>
> Can anyone tell me where the p
> My problem is i cant figure out how to install the new
> "MYSQL_REAL_CONNECT" - feature
> i am looking a whole f*$%%%ing day now and there is no germen help for
> it.
mysql_real_connect is part of the mysqli extension, not the standard mysql
extension. If you have the right version of mySQL &
Armando wrote:
If you upgraded to 4.1.x from 4.0.x then it's likely you need updated
libraries (DLL files).
Armando
Joseph L. Mueller wrote:
Just upgraded to MSQL 4.1.8 and PHP 4.3.10 and am running apache
2.0.43 on Win XP. When trying to connnect to Mysql I get the following
error:
"Warning:
If you upgraded to 4.1.x from 4.0.x then it's likely you need updated
libraries (DLL files).
Armando
Joseph L. Mueller wrote:
Just upgraded to MSQL 4.1.8 and PHP 4.3.10 and am running apache 2.0.43
on Win XP. When trying to connnect to Mysql I get the following error:
"Warning: mysql_connect():
@lists.php.net
Subject: Re: [PHP-WIN] MySQL 4.1 Server
Importance: High
> Does anyone know where I can download the latest MySQL PHP API to connect
> to MySQL 4.1?
Best API out there...
http://adodb.sourceforge.net/
walter
--
PHP Windows Mailing List (http://www.php.net/)
To unsub
> Does anyone know where I can download the latest MySQL PHP API to connect
> to MySQL 4.1?
Best API out there...
http://adodb.sourceforge.net/
walter
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Nothing wrong, besides missing a character.
I tried your instructions with the full word CREATE and it worked fine...
Luis
Patrick Roane wrote:
I am learning the mysql basics and was wondering what
I'm doing wrong. I'm using the MySQL.exe console to
create a simple table, but I keep getting these s
i think you need to add "extension=php_mysqli.dll" rather and put
php_mysqli.dll in your extension directory. That DLL is included in the
PECL package available on php.net. This works fine for me, am also
running PHP4 and 5 on a winbox, but with my MySQL server running on a
linux machine.
nie
Bogdan Ribic wrote:
Hello everyone
I have a strange problem with freshly installed php5, 5.0 final. I
did some web searching and found out how to get php_mysql.dll loaded
into php - I needed to copy libmysql do windows\system32 and uncomment
extension=php_mysql.dll
i think you need to add "extens
I think that you need php_mysql.dll and not libmysql.dll. Probably there are
two dll's. Search for php_mysql.dll in your php directory. If you do not
have I think you should create it compiling the code. It should be located
in c:\php\ext\mysql or something like this. If you have it put in c:\php\e
This is a function I use. Modify as you wish.
function Price($amount) {
return ($amount) ? '$'.number_format($amount, 2, '.', ',') : '-';
}
At 04:04 AM 28/06/2004, you wrote:
I have created a database for a local real estate company, and I am having
issues trying to display home prices with com
I have created a database for a local real estate company, and I am
having
issues trying to display home prices with commas. when you get into
the
hundreds of thousands of dollars, it is quite difficult to look at home
prices without commas. I am using mySQL and PhpMyAdmin. Is there a
mySQL
f
Could u just give me what should be the statement to rollback a database for eg "abc"
[EMAIL PROTECTED] wrote:what verion of mysql do you have? Early version of MySQL
didn't include the rollback functionality. Do you not have any mysql_dumps of the
databases and/or tables? (Its vital that you ba
How did you lose them?
I don't know about mySQL, but in general DELETE, INSERT
and UPDATE are logged while DROP and TRUNCATE are not.
If you do /not/ use auto commit /and/ did /not/ do commit,
then you can use rollback to undo a delete/insert/update.
Else you need to restore the database from t
Check out my thread on a similar issue...
http://www.sitepoint.com/forums/showthread.php?t=158703
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
rch 22, 2004 11:58 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] MySQL query to generate Array
Are you trying to create a breadcrumb trial?
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing Lis
Are you trying to create a breadcrumb trial?
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try something like this (UNTESTED)
// array1 is temporary array
// array2 is the one to fill with query results
$array1= array("URL"=>"nul","URLN"=>"nul");
$array2= array(
1=>array("URL"=>"","URLN" => "")
);
// $n is counter of registers
// begin mysql query
// foreach element
// $row[0] i
If you read in the same article you will find this:
"MySQL AB has not released a separate patch for this bug, but it is fixed in
the latest MySQL database releases 4.0.15 (the current production release)
and 3.23.58 (an older production release)."
-Original Message-
From: Roderick Martin
Reference for what?
-Original Message-
From: Ryan Vesely
To: Svensson, B.A.T. (HKG); ''[EMAIL PROTECTED] ' '
Sent: 10/3/2003 7:07 PM
Subject: RE: [PHP-WIN] Mysql Purge script
just one way to create record created. not really relevant
to the delete statement, othe
hibited and may be unlawful.
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 9:57 AM
To: ''[EMAIL PROTECTED] ' '
Subject: RE: [PHP-WIN] Mysql Purge script
As well as it assumes that a delete trigger takes care of
y have received this message in error or if you are not
the
named recipient, please notify Pinnacor at once at the sender's email
address, or call 212.691.7900. Unauthorized use, dissemination,
distribution
or reproduction of this message is strictly prohibited and may be
unlawful.
-----Original M
or if you are not the
named recipient, please notify Pinnacor at once at the sender's email
address, or call 212.691.7900. Unauthorized use, dissemination, distribution
or reproduction of this message is strictly prohibited and may be unlawful.
-Original Message-----
From: Svensson, B.A.T. (HKG)
DELETE FROM
WHERE >
-Original Message-
From: Php2tor
To: [EMAIL PROTECTED]
Sent: 3-10-2003 18:15
Subject: [PHP-WIN] Mysql Purge script
Does anyone have a script that will purge a MySQL DB that
has entries over 30 days old?
--
PHP Windows Mailing List (http://www.php.net/)
To unsubsc
$num_items = amount user wants;
$td2 = floor($num_items/2);
$td1 = $num_items-$td2;
print("");
for($i = 0; $i < $td1; $i++) {
print();
}
print("");
print("");
for($i = $td1; $i < $td2; $i++) {
print();
}
print("");
.bobo
- Original Message -
From: "Dean Hayes" <[EMAIL
One possible reason why it does not work is that the DAY() function does not
exist.
Use DATE_FORMAT() instead.
Ignatius
_
- Original Message -
From: "Disko_kex" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 22, 2003 10:47 AM
Subject: [PHP-WIN]
$SQL = "SELECT 'password' FROM 'table' WHERE 'username' = '".$user."';";
$result = mysql_query($db,$SQL,$cid);
With the above you then do a:
$pass = mysql_fetch_object($result);
$pass->passord //is the password then...
.bobo
- Original Message -
From: "Exiang" <[EMAIL PROTECTED]>
To: <
$SQL = "SELECT 'password' FROM 'table' WHERE 'username' = '".$user."';";
$result = mysql_query($db,$SQL,$cid);
With the above you then do a:
$pass = mysql_fetch_object($result);
$pass->passord //is the password then...
.bobo
- Original Message -
From: "Exiang" <[EMAIL PROTECTED]>
To: <
This is message (not generated by or associated with PHP at all) that is telling you
that your users (probably supposed to be root) doesn't have the right to perform the
action you're trying to do. If you're trying to administer MySQL from the console try
typing this:
mysql --user=root mysql
T
> Anyone any idea how to check whether a table is locked? In
> particular I use
> FLUSH TABLES WITH READ LOCK before backup starts and want to know whether
> this has happened.
>
> Thanks in advance,
>
> . : Fran Thomas
Fran
I don't believe there is any method to show the lock status of a table -
> I must run some kind of script but I don't know what.
> Tried:
> \.data.sql
> I had to put the also the source, but when I pressed Enter key, an error
> apears "ERROR 1046: No database selected"
>
> What's wrong?
You haven't RTFM.
--
PHP Windows Mailing List (http://www.php.net/)
To unsu
quot;);
- are all the above true or false?
- Original Message -
From: "Rui" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 10:08 AM
Subject: Re: [PHP-WIN] MySQL: some script I must do
> I already have the database made.
>
I already have the database made.
I want to put the database on the server.
They told me that I must do a Dump and then run some kind of script that I
dont quite get it.
The problem is that I don't know how to run/make the script.
Thanks
"Cam Dunstan" <[EMAIL PROTECTED]> escreveu na mensagem
0055
Not sure if I fully understand your problem Rui but I would think your ISP
means an SQL statement type dump - that is, the data you have is put in the
form of a giant SQL statement - a collection of INSERT statements, one for
each record you want to insert. Perhaps this might need to be preceeded
I would propose you to post this question in the MySQL list.
You would probably get better and more accurate answers on
question about MySQL there.
Also, reading the documentation that comes with MySQL
wille xplain for you how to dump data; however it wont
explain from which tables you need to dum
bobo
I doubt that the table will be too big myself given the limitations which
you will find in the mysql manual (far above your requirements). Spend a
bit of time and calculate the actual size of the table - while it sounds
huge you might be pleasantly surprised. A database of properties in a lo
A quicky:
echo "$query_rsRegisteredClasses"
To make sure the query is exactly what you are expecting. Copy the exact SQL
statement and run in MySQLAdmin sql window.
PHP to PHP, SQL statement to sql statement.
--
Scott Carr
Documentation Maintainer
http://documentation.openoffice.org
OpenOff
I think you need to do a while() loop there instead of trying to grab the
results in one shot:
$row_rsRegisteredClasses = array();
while ($row = mysql_fetch_assoc($rsRegisteredClasses)) {
$row_rsRegisteredClasses[] = $row; //populate this array with the $row array
}
That may or may not work,
http://www.dbtools.com.br
-Original Message-
From: toby z [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 18 January 2003 4:33 PM
To: php hlp list
Subject: [PHP-WIN] mysql tools lost ...
hi guys im stuck bad as usual .
mysql.com and datanamic.com r both down .. god alone knoz y
hi
first u ll have to lookup gd and enable it in ur php.ini n u ll have
to get tiff and libjpeg on ur machine
n here r a few links to graph creation with php
http://php.resourceindex.com/Complete_Scripts/Images_and_Graphs/Graph_Creation/
http://www.szewo.com/php/graph/eng.phtml
http://www.adit
What error do you get with PHP?
-Original Message-
From: Gareth Thomas [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2002 02:17
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] mysql command problem
Hi,
I have a Mysql command that when run in PHP does not work and yet when
executed directly in M
Gareth,
PHP has a default 30 second timeout. This can be changed in php.ini (not
reccomended) or by set_time_limit
(http://www.php.net/manual/en/function.set-time-limit.php). Set it to "0"
to disable the timout script.
-Dash
"I think the sky is blue because it's a shift from black through purple
B.A.T. Svensson was right. But... I thing the answer is
mysql.exe -h myhost -u root -p mymass dbname < c:\my_file.txt
--
Best regards,
George Nicolae
IT Manager
___
PaginiWeb.com - Professional Web Design
www.PaginiWeb.com
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
I believe this is the Win32 PHP mailing list. But I may be wrong.
> -Original Message-
> From: Frank Tudor [mailto:frank_tudor@;yahoo.com]
> Sent: Monday, November 11, 2002 6:33 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] mysql running sql from txt file
>
>
> How do I run a sql state
s" <[EMAIL PROTECTED]>
To: "Ignatius Reilly" <[EMAIL PROTECTED]>; "PHP Helplist Windows"
<[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 2:30 PM
Subject: RE: [PHP-WIN] MySQL Query
> Ok, solved that problem, can anyone help me on my last query, i need to
ssage-
From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr]
Sent: Fri 25/10/2002 12:57
To: James Meers; PHP Helplist Windows
Cc:
Subject: Re: [PHP-WIN] MySQL Query
arrays are not a datatype for MySQL.
arrays are not a datatype for MySQL.
You have to serialize your array into a string. You must choose a suitable
delimitor that will not conflict with your data. Taking as an example ",":
$to_feed = implode( "," , my_array ) ;
$query = " update user_table set categories in '({$to_feed})' where
us
mysql is running, i can connect to the mysql server with another pc in lan,
but is the web server that cannot connect to mysql server. i need help!!!
i'm goin crazy
grazie della dritta, mi aggiorno subito al 4.2
"Nicola Delbono" <[EMAIL PROTECTED]> ha scritto nel messaggio
[EMAIL PROTECTED]">ne
>Php 4.1.2
>Abyss Web Server (Freeware) www.apelium.com
>
>mysql_connect("127.0.0.1","root","admin") or die(mysql_error());
>print("connected!!!");
>
>?>
Is mysql server running?
did you flush privileges when you changed password to "admin"?
Can you connect via console? (dos prompt)
NB: Php 4.1.2
I don't believe so. I've gone to using adoDB ( http://php.weblogs.com/ADODB
) for everything. Perhaps it has a solution for you? I know it has a
get_insert type of statement, but I've never used it.
-
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.l
well I'm not sure how you would acomplish the first two tasks, but you can
at least get an accurate feel for how long a page (or section of code) takes
to execute.
There are several timer classes available, the one I use is called
Deathead's Timer, wich you can download from:
http://www.phpclasse
> Is there a way to get the cost in cpu cycles or the milliseconds it
> takes to process a query and output that statistic in PHP? Or maybe the
> processing time of the whole page?
The most naive approach is the brute force test: Run the query and
count the time it toke to execute it. However thi
att Babineau
> Cc: 'Php-Win (E-mail)'
> Subject: RE: [PHP-WIN] MySQL / PHP - possible to run many sql
> statements
> in the same execution?
>
>
> > What I would need to do here is either lump all the
> queryioes into one
> > SQL execution or lock the
> What I would need to do here is either lump all the queryioes into one
> SQL execution or lock the PHP code so it is single threaded like this:
I understand this as that you are trying to deal with the (in)famous
readers&writer problem here? There is a basic technique to deal with
this, and it
g
>too.
>
>Matt Babineau
>Freelance Internet Developer
>e: [EMAIL PROTECTED]
>p: 603.943.4237
>w: http://www.illuminatistudios.com
>
>
>
>-Original Message-
>From: Scott Hurring [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, April 25, 2002 4:49 PM
>To:
Freelance Internet Developer
e: [EMAIL PROTECTED]
p: 603.943.4237
w: http://www.illuminatistudios.com
-Original Message-
From: Scott Hurring [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:49 PM
To: Php-Win (E-mail)
Subject: RE: [PHP-WIN] MySQL / PHP - possible to run many
Sorry for seeming a bit dense, but what's the problem
with using "LOCL TABLES" for all SQL stmnts?
It's my understanding that it will lock tables
and prevent other procs from reading/writing to
that table while you've got a lock on it.
Is that not the case?
---
Scott Hurring
Systems Programmer
1 - 100 of 161 matches
Mail list logo
