Hi all,
I am having a problem that I have not seen in the past and thought to
post it here. I am running mysql-3.23.54, php-4.3.0 and apache 1.3.27.
Everything seems to install and work correctly...ie stuff like ?php
phpinfo() ? works just fine. Now what is broken is mysql_connect(). I
get
At 12:27 AM 1/8/03 -0800, Shantu Roy wrote:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2
Could not connect: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
It is not a
oops forgot to forward
---BeginMessage---
Rick Widmer wrote:
At 12:27 AM 1/8/03 -0800, Shantu Roy wrote:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on
line 2
Could not connect: Can't connect to
hi there,
any hint on resetting a $res from mysql_fetch_row()?
my sample code is something like this:
$res = mysql_query( . ) or die (Query failed);
while ( list ( $gid, $pSubSetName) = mysql_fetch_row($res) )
{ print $gid - $pSubSetName }
:
while ( list ( $gid, $pSubSetName) =
any hint on resetting a $res from mysql_fetch_row()?
www.php.net/mysql_data_seek
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi Everybody
Does anyone have a sample code that read each page of data from Oracle like
OLEDB in windows?
I don't want to read the whole table into my webpage, each time i only want
to read 20 rows. And list all of the remaining pages for choosing
How can I do that.
If someone has done it or
it's very useful to store images in the db then
in the other page show the image by selecting it then
print it out to the page with Content-type: image (jpeg/gif/etc) header;
But, i didn't find how to show pdf binary file so that the browser
can directly call acrobat reader to show it,
i tried
Do you have php_mssql.dll extension loaded?
Check better with phpinfo();
Radovan
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
Hope someone can help me with this.
I need to connect to a MS SQL database but my attemps fail once and
i know this is a bit down the chain, but i'm trying to keep the message
strings in tact
but can't you set up your directory just like you set up your mysql Grants.
I have a directory that the web user owns, who is in its own group. so i
set the permisssions once, and its done. Also i don't
I have the following code in my page as a header.
?
if ($mainarea==Language)
{
header(Location:add_5-14_material.php?mainarea=$mainarea);
}
else
{
}
?
When I echo $mainarea I get \'Language\'. I think it is something to do
with my quotation marks but need some help.
How do I get rid of the '
On Wed, 2003-01-08 at 06:50, [EMAIL PROTECTED] wrote:
i know this is a bit down the chain, but i'm trying to keep the message
strings in tact
but can't you set up your directory just like you set up your mysql Grants.
I have a directory that the web user owns, who is in its own group.
Maybe you want to use urlencode()?!
hth,
Bastian
Alex Francis schrieb:
I have the following code in my page as a header.
?
if ($mainarea==Language)
{
header(Location:add_5-14_material.php?mainarea=$mainarea);
}
else
{
}
?
When I echo $mainarea I get \'Language\'. I think it is
mysql_query returns an array, not simply a string ... my recommendation is
do your error checking near your mysql_query statement (i.e.
if(!mysql_query(whatever) die();) then do an else to loop through the
results.
loop using mysql_fetch_row(RESULT), where result is your RESOURCE ID,
echoing
OK, this isn't really a DB question, but it is definitely a PHP
question. I am working on customizing a calendar application for my group's
use and noticed that there is a function that has to do with a mouseover
effect. The problem is that this mouseover does not appear to do anything.
OK, this isn't really a DB question, but it is definitely a PHP
question. I am working on customizing a calendar application for my
group's
use and noticed that there is a function that has to do with a
mouseover
effect. The problem is that this mouseover does not appear to do
Well, I figured it out. New files in the dlls directory and not in the path. The error
message sent me on a wild goose chase.
:-\ Sorry...
-Original Message-
From: Ryan Jameson (USA)
Sent: Tuesday, January 07, 2003 6:02 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] PHP 4.3 problem
You are correct. I have found the JS that the dLink references.
Here it is if there are any JS experts out there who want to take a gander.
//
// expandItems() calls a javascript that replaces one string of //
// text with
Hello list,
I am able to get the query to work by itself but it will not work using
the if (isset ($submit)) and NO errors are outputting...nothing.
Any suggestions would be greatly appreciated. I havnt even gotten to
the form variables yet...and yes, my globals are turned on (at least for
I am able to get the query to work by itself but it will not work using
the if (isset ($submit)) and NO errors are outputting...nothing.
That's because $submit is not set
Any suggestions would be greatly appreciated. I havnt even gotten to
the form variables yet...and yes, my globals
Hello everybody,
I am PHP-beginner, and I have to code the multiple result pages
management - just like search engines display something like that:
First Previous 1 2 3 4 Next Last
io each page allowing users to link to a dozen neighboring pages directly.
Could you give me some tips of how
Thank you! - you know (darn it!) I had that submit name in the input
type on previous test pages - must have forgot it on this one. I'm
stressin'...
Thanks again
On Wed, 2003-01-08 at 13:41, 1LT John W. Holmes wrote:
I am able to get the query to work by itself but it will not work using
Hello,
Look at this usefull PEAR package :
http://pear.php.net/package-info.php?pacid=31
A tutorial is available at:
http://www.pearfr.org/docs/dbpager.php?lang=en
hth
pierre
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Uh - excuse me, Me Again...
When I post to my next page in the survey in the form action, instead of
this page, the data doesnt go into the database.
Does anyone know a way around this other than rewriting all the pages
into one page?
Many thx
Mignon
On Wed, 2003-01-08 at 13:50, Mignon
When I post to my next page in the survey in the form action, instead of
this page, the data doesnt go into the database.
Does anyone know a way around this other than rewriting all the pages
into one page?
Use sessions or hidden form fields to transfer the data between pages.
---John
Actually, I dont need these variables in the rest of the form, I just
need to go to the next page...Like a hyperlink on the submit button
maybe ???
Seems like I've seen that...
Mignon
On Wed, 2003-01-08 at 14:12, 1LT John W. Holmes wrote:
When I post to my next page in the survey in the form
Or a redirect after submitting:
Header(Location: pagetogoto.php);
___
Ryan Marrs
Web Developer
Sandler Travis Trade Advisory Services, Inc.
248.474.7200 x 183
248.474.8500 (fax)
www.strtrade.com
-Original Message-
From: Mignon Hunter [mailto:[EMAIL
Well change/set the ACTION attribute of your form, then, if that's where you
really want to go. The second page should check for
if(isset($submit))
and process the data. Or do it in one page and redirect with header()
(before _any_ output) after the processing is complete.
---John Holmes...
Ok - thanks. I've just read up on headers, but, where would you put this
in the code? After the submit input type ?? I get an error.
On Wed, 2003-01-08 at 14:34, Ryan Marrs wrote:
Or a redirect after submitting:
Header(Location: pagetogoto.php);
___
The simplest way is to use the LIMIT keyword in your SQL statement. Set, or
allow the user to set, the number of items to show at one time, then keep
this number as a hidden field and use it to determine what record to go to
when they click the page number or the next button. So a sample would
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is there a wildcard in
mysql like there is in sqlserver that I can use to grab all the records?
such as select * from offtime where type='%' would grab all.
Thanks,
Eddie
--
PHP
If you want all records, remove the where clause.
select * from mytable
Jim
---Original Message---
From: Edward Peloke
Date: Wednesday, January 08, 2003 02:03:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql wildcard
I have an query:
select * from offtime where
Well, if that is your only condition, why not use:
'select * from offtime' as your query?
I believe the % as a wildcard is standard SQL, so I would *think* it should
work in mysql, have you tried it?
-Brad
Edward Peloke wrote:
I have an query:
select * from offtime where type='$type'
then
You probably want something like:
select * from offtime where type like '{$type}%'
As a side note, are you making sure that $type does not contain any
malicious code?
Cheers,
Marco
--
php|architect - The Monthly Magazine for PHP Professionals
Come check us out on the web at
In a message dated 1/8/03 2:48:15 PM Pacific Standard
Time, [EMAIL PROTECTED] writes:
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is
there a wildcard in mysql like there is in sqlserver
that I can use to grab all the records? such
This is not a mouseover. This builds the links for the popup window that
appears when you click on the event in the calendar. Go to the
common.php file and find the dLink() function.
-Micah
On Wed, 2003-01-08 at 09:45, NIPP, SCOTT V (SBCSI) wrote:
OK, this isn't really a DB question,
I'm hoping someone can give a little advise.
We have a customer that provides his software via a www address. We've
setup .htaccess on this folder with a single username/password. So he
supplies this user/pass to people that pay to get his software.
He now wants to have control over the
The links in the calendar are made up of the titles of you events. The
displayed length is restricted until you mouse over them, then they
expand to show their entire length. This is the code that does that.
-Micah
On Wed, 2003-01-08 at 10:08, NIPP, SCOTT V (SBCSI) wrote:
You are
I wrote a similar script a long time ago to achieve this. [Anti-Leech
solution]
You store the software in a folder that is outside of the web directory tree
and use PHP to 'fopen' the file being downloaded by the 'authenticated' user
and send it back to the broser using location() with the
On Thursday 09 January 2003 08:36, David Chamberlin wrote:
I was reading the mysql docs and noticed a section on searching on
multiple keys (stupid question - keys=columns?). It says doing an OR on
multiple keys is inefficient, and you should use a temp table. Here's
their example:
CREATE
Hi,
php_mssql.dll is for win32 only. This seams to be a *nix installation. In
order to use the MSSQL functions yoy will need to compile PHP using
--with-mssql (or if your PHP version is 4.3.0 --with-sybase). In both
cases you also need to download, compile and install FreeTDS
(www.freetds.org).
Hello
everybody!!! I'm writing to you to ask if somebody knows how can I do to emulate
the examine button to retrivea file'spath to save that string in the
database. Specifically, it's a photo, that've got to search in the directory's
window. Thanks in advance!
Sabina
Alejandra
41 matches
Mail list logo