Is it possible to place the mysql_connect and mysql_select_db functions in an include
file and to open the connection and use the database in a PHP file using include(); ?
All that happens when I attempt it is that the text of the include file is dumped, the
connection to the mysql server is no
- Original Message -
From: CC Zona <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 12:30 PM
Subject: Re: [PHP-DB] Using include() to specify mysql_connection??
>
> To be parsed as PHP code, the contents of the included file also
need to be
> in PHP mode .
This is simple but I cannot see where I am going wrong
I have a table members with one of the fields
status, varchar(10)
The values may be active or retired or deceased or null
If I run the select
SELECT * FROM members WHERE status = 'deceased';
I getMySQL said: You have an error in your
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:02 AM
Subject: [PHP-DB] Select where
> This is simple but I cannot see where I am going wrong
>
> I have a table members with one of the fields
- Original Message -
From: Darryl Friesen <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 1:22 AM
Subject: Re: [PHP-DB] Select where
> > Thanks, I only gave the mySQL but the php scripting is
> &g
The database has a table of equipments with date fields for
date_online and date_offline.
The requirement is to find which equipments were available on a date
specified by the user, this being a variable created by the user.
My attempts at scripting for the condition where the date_online <=
'
___Morris___
The database has a table of equipments with date fields for
date_online and date_offline.
The requirement is to find which equipments were available on a date
specified by the user, this being a variable created by the user.
My attempts at scripting for the condition where the dat
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 10:45 PM
Subject: Re: [PHP-DB] Select where date is in period
>
> ___Morris___
>
> The database has a table of equipments with date fields for
> d
- Original Message -
From: Steve Brett <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:04 PM
Subject: RE: [PHP-DB] Select where date is in period
> i think i also used >= to indicate 'equal o
"boclair" <[EMAIL PROTECTED]> wrote in message
005101c0b2d2$4e6b3920$[EMAIL PROTECTED]">news:005101c0b2d2$4e6b3920$[EMAIL PROTECTED]...
|
| - Original Message -
| From: boclair <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, March 22,
Yes please
Tim Morris
- Original Message -
From: olinux <[EMAIL PROTECTED]>
To: PHP-DB <[EMAIL PROTECTED]>
Sent: Sunday, March 25, 2001 11:21 AM
Subject: Re: [PHP-DB] uploading files.
> mmmK,
>
> i have figured it out,
> anyone want it?
> lemme know
>
> olinux
>
>
> - Original Mess
I realise that CC Zona answered this question earlier but I haven't
understood.
I have attempted to use the date_format in generating the query
variable and applying the result with a while loop to display the date
data in an html table as dd-mmm-
Generating the query variable
include ("inp
"boclair" <[EMAIL PROTECTED]> wrote in message
000e01c0b5d0$720921c0$[EMAIL PROTECTED]">news:000e01c0b5d0$720921c0$[EMAIL PROTECTED]...
| I realise that CC Zona answered this question earlier but I haven't
| understood.
|
| I have attempted to use the date_f
It has been pointed out to me that there is an error. I had failed to
include the two date fields in the select. The actual scripting is.
The query
include ("inputs/connect.php");
|$plantavail = mysql_query("SELECT * date_format(online,'%d-%b-%Y') AS
logon,
date_format(offline,'%d-%b-%Y') )
"Matt Braynard" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| When I asked the question, what I meant was should I use the
includes to
| hold page style details or a CSS file. And someone who understood
that this
| was not an apples and oranges situation but
"olinux" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| here is the working script on my local windows machine. note that
you will
| need to change $the_path
| Everything is pretty self explanatory. You can read the article that
I took
| this from at http://ph
- Original Message -
From: "Hull, Douglas D" <[EMAIL PROTECTED]>
For example, say I have a variable $mytext = 'what up doc'. Now I want to
add the text 'not much' to the end of this variable. But I want to place a
return or linefeed after the original text so when I echo $mytext it look
Would somebody be kind enough to explain why this query produces a false result
$latest=mysql_query("SELECT MAX(fee_recd) FROM members",$connectup)or die
("Query failed:$latestError: " . mysql_error());
but this one doesn't
$latest=mysql_query("SELECT fee_recd FROM members ORDER BY fee_recd DESC
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [EMAIL PROTECTED] wrote:
> > Would somebody be kind enough to explain why this query produces a false
result
> >
> > $latest=mysql_query("SELECT MAX(fee_recd) FROM members",$connectup)or
die
> > ("Query failed:$latestEr
PHP 4.3.10
MySql 4.0.20
How do I find and then display on a web page the time that additional
data added to, or, existing data amended in an ISAM table?
My latest futile attempt , with connection made and the database already
selected,
Last logged:
With no errors reported, the display is "no
Typo. Sorry. Should read of course
SHOW TABLE STATUS UPDATE_TIME
Louise
boclair wrote:
PHP 4.3.10
MySql 4.0.20
How do I find and then display on a web page the time that additional
data added to, or, existing data amended in an ISAM table?
My latest futile attempt , with connection made and
http://www.mysql.com/doc/en/Tutorial.html is a good place to start with the
mysql functions in the php manual.
http://www.devshed.com/Server_Side/ has a number of on line tutes amongst
others.
phpbuilder also is useful. The normalisation article is a good first step; it
is at
http://www.phpbui
- Original Message -
From: Blue Tiger <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 10:13 AM
Subject: RE: [PHP-DB] Changing colors in table?
: The blank table column comes from a blank MySQL database field...(I was
: initially going to blob images from ther
I have a problem with a user input in a form required to be an
integer, creating a variable for a mysql query.
I have instances where integer, 0, is being typed as letter,o.
The last discussion of validating the input was
http://marc.theaimsgroup.com/?l=php-db&m=97207172003983&w=2
There it was
lidation was being with a javascript and
the creation of the variable was OK.
Further advise appreciated.
Tim
- Original Message -
From: Steve Farmer <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 3:23 PM
Subj
- Original Message -
From: John Starkey <[EMAIL PROTECTED]>
To: B. van Ouwerkerk <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 4:04 PM
Subject: Re: [PHP-DB] OT - Domain Registrars
> I'd have to definately agree. Avoid NS at all costs. If you want to
be able
"boclair" <[EMAIL PROTECTED]> wrote in message
002101c0bd8e$30742e60$[EMAIL PROTECTED]">news:002101c0bd8e$30742e60$[EMAIL PROTECTED]...
| I have a problem with a user input in a form required to be an
| integer, creating a variable for a mysql query.
|
| I have instan
- Original Message -
From: Matt Williams <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 9:03 PM
Subject: RE: [PHP-DB] Forms : Validating user input is integer
>
> > To gain the full benefit of your suggestion I find that I c
"boclair" <[EMAIL PROTECTED]> wrote in message
004801c0bdc7$13afbe00$[EMAIL PROTECTED]">news:004801c0bdc7$13afbe00$[EMAIL PROTECTED]...
|
| - Original Message -
| From: Matt Williams <[EMAIL PROTECTED]>
| To: boclair <[EMAIL PROTECTED]>
| Sent: Thursd
"Matt Williams" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
|
| > or even just
| > elseif (!eregi("[^a-zA-Z]"),$num)) { }
|
| But that would not stop other characters.
|
| M@
Whoops! Careless of me. The line should read, and as I tested it,
elseif (ereg
- Original Message -
From: Matt Williams <[EMAIL PROTECTED]>
To: Boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2001 11:28 PM
Subject: RE: [PHP-DB] Forms : Validating user input is integer
The line should read, and as I tested it,
> &g
"boclair" <[EMAIL PROTECTED]> wrote in message
002101c0bd8e$30742e60$[EMAIL PROTECTED]">news:002101c0bd8e$30742e60$[EMAIL PROTECTED]...
| I have a problem with a user input in a form required to be an
| integer, creating a variable for a mysql query.
|
| I have instan
Ben Udall <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| boclair wrote:
| > I have a problem with a user input in a form required to be an
| > integer, creating a variable for a mysql query.
| >
| > I have instances where integer, 0
Manuel,
Manuel Lemos <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| Hello boclair,
|
| On 05-Apr-01 01:58:24, you wrote:
|
| >I have a problem with a user input in a form required to be an
| >integer, creating a variable for a mysq
Manuel,
Manuel Lemos <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
| Hello boclair,
|
| On 05-Apr-01 01:58:24, you wrote:
|
| >I have a problem with a user input in a form required to be an
| >integer, creating a variable for a mysq
- Original Message -
From: Rankin, Randy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 10:56 PM
Subject: [PHP-DB] No MySQL-Link resource supplied
> Is anyone familiar with this error and what causes it (or better,
how to fix
> it).
> Warning: No MySQL-Link res
> Here is sample code:
> $connection = @mysql_connect("localhost", "jeff", "*")
> or die("Couldn't connect.");
> if ($connection) {
> $msg = "success!";
> }
> ?>
>
> This is on my machine only used by me. I also tried connecting to
> IP address and 127.0.0.1 and it still won't work. Thanks.
- Original Message -
From: Jeff Oien <[EMAIL PROTECTED]>
To: PHP-DB <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 11:07 AM
Subject: [PHP-DB] Date_Format Question
> I have a date like this in date format in MySQL
> 2001-08-29
>
> and I want it to say
> August 29, 2001
>
> I tried t
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; PHP-DB <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 1:09 PM
Subject: Re: [PHP-DB] Date_Format Question
>
> - Original Message -
> From: Jeff Oien <[EMAIL PR
- Original Message -
From: Martin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 04, 2001 8:29 AM
Subject: [PHP-DB] Nothing returned
: Why am I not getting anything returned from this function?
: I have code doing a if user exists and b if user doesn't exist. I'm no
When a php statement is "part" of a markup snippet in a mysql database
table field, what must be done to have the php parse in the html
A simple demo demonstrating my problem is at
http://www.boclair.com/test/blobvars.php
Louise
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, vis
Content-Type: multipart/alternative;
boundary="070700030402040702060708"
X-Authentication-Info: Submitted using SMTP AUTH PLAIN at
omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at Thu, 1 Sep
2005 11:49:59 +
This is a multi-part message in M
Miles Thompson wrote:
At 08:50 AM 9/1/2005, boclair wrote:
Content-Type: multipart/alternative;
boundary="070700030402040702060708"
X-Authentication-Info: Submitted using SMTP AUTH PLAIN at
omta05ps.mx.bigpond.com from [138.130.220.111] using ID boclair at
Frank Flynn wrote:
But if you could be more specific - send the schema and precisely what
you were looking to do I could give you an example of how to make it work.
I am still having difficulties with my workup and more help would be
appreciated .
I have two tables
CREATE TABLE `cl
I need help to track down the cause of the error,"Could not run query"
A typical query is
$laterrecords = mysql_query("SELECT * FROM messages WHERE `logged` >
$timebegin ORDER BY `logged` DESC" ) or die ("Cannot
select:$queryError: " . mysql_error());
Louise
--
PHP Database Mailing List (ht
Ron Piggott wrote:
How would I put a space after each letter:
echo str_shuffle(stripslashes(mysql_result($word_result,0,"word"));
Ron
CSS best handles styling
E.G.
OR
$word_result";
?>
Increase the em value to customize the spacing
Louise
--
PHP Database Mailing List (http://w
46 matches
Mail list logo
