yeah, i know this, but i'm just trying to get this to work before i add some
security in there - passing sessions through etc to ensure they're logged in
as admin etc.
it doesn't really have to be that secure for what i want anyway, but
probably a good job you pointed that out ;)
-Original
No! don't get them started again! my inbox won#039;t take it
any more.
-Original Message-
From: Boaz Yahav [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2002 08:07
To: Bogdan Stancescu; Jonathan Hilgeman
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Fixed Quote Marks in Inputs
Hi
I have a database that has lyrics in it. I can get them to list but they are not
aligned the same as whats in the database. How can I get the results aligned as whats
in the database ?
Hi,
We have developed a PHP security extension, it was originally developed to make
it possibly to store you database password securly!!! So I thought I'd post a
copy of the email I posted to the dev list to this list as well.
Here it is
==
Maybe one or two of you may have read a post a
without code it's hard to know, but i'd have thought a simple html pre tag
around the entry should work.
ie...
printf pre%s/pre,$myrow[Lyrics];
-Original Message-
From: Barry Rumsey [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 12:20
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Formated
Try printing pre before and /pre after them
Regards,
Andrey Hristov
- Original Message -
From: Barry Rumsey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 2:19 PM
Subject: [PHP-DB] Formated Results
Hi
I have a database that has lyrics in it. I can get them to
Yes thank you that was the answer.
While I'm asking questions , I've got one good one :
Whats the best book to buy on php mysql ?
- Original Message -
From: Andrey Hristov [EMAIL PROTECTED]
To: Barry Rumsey [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 08, 2002 1:27 AM
well, i'm sure there are lots out there, but i am very happy with...
PHP and MySQL Web Development By Luke Welling and Laura Thomson, published
by SAMS
First printed in March 2001, so it's still not out of date.
there are probably lots of other good books out there too though.
-Original
On Monday 07 January 2002 14:32, you wrote:
Yes thank you that was the answer.
While I'm asking questions , I've got one good one :
Whats the best book to buy on php mysql ?
I can recommend PHP Blackbook by Peter Moulding
(Coriolis, ISBN 1-58880-053-9), 845 pages.
It concentrates mostly
One last question for tonight as I have been given alot of help from this group to
keep me going for awhile.
I would like to set up one of those A B C D E F page listings. How do i query the
database to grab the first letter from each entrey.
Hi all,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT and will be moving this to
Linux before the end of January.
Filemaker is able to perform
At 01:48 AM 1/8/02 +1300, Barry Rumsey wrote:
I would like to set up one of those A B C D E F page listings. How do
i query the database to grab the first letter from each entrey.
Barry try something such as
select info from mytab
where name like $ltr%;
Marty
Website Creation Made
Set the username and password for your database to whatever you want. It
doesn't have to be nobody/nobody.
Pass the username and password from an include file.
Miles Thompson
At 09:31 PM 1/6/2002 -0800, patrick gibson wrote:
I'm new to PHP, and I have a question regarding the storage of
George,
Suggestions interspersed below
Miles
At 12:53 PM 1/7/2002 +, George Pitcher wrote:
Hi all,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT
Hi there,
I have a user table which contains province and country.
Another table named provinces contains this fields to and also the name of
the province.
Now I am trying to find out the provinces user are registered coming from a
special country. Unfortunatelly this statement underneath:
On Monday 07 January 2002 04:48 am, Barry Rumsey wrote:
One last question for tonight as I have been given alot of help from this
group to keep me going for awhile.
I would like to set up one of those A B C D E F page listings. How do i
query the database to grab the first letter from each
That's why I skipped the regular expression and irregular expression and
grep stuff and used explode :-) All it takes is the string and the
delimiter and it feeds you back an array. I've been using it to pass
parameters in the $QUERY_STRING when I don't use $HTTP_POST_VARS. You can
even have
Miles,
Thanks for the response.
My description of the Filemaker solution was very simple. In fact it is 13
databases with some containing up to 18000 records. At the centre is a
Transaction database containing 15000 'book' records. Each transaction
record contains a pack ID field and this is
I am looking for compiled libraries for PHP 4.1.1 and SuSE 7.2 for use with
M$ SQL 7+
Does anyone know where I can find this library?
Thanks,
Shane Peery
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Is there anyway to rewrite the $server_name variable with php? This is kind
of an ambitious post for I think I already know the answer.
My company has just changed our corporate identity and we want our old url
to point to the new one, http://www.worktiviti.com. This isn't a problem,
we've
Hi,
I'm attempting to pull about 300 rows from a mysql database, (all rows in
the table).
I can pull the first 10, the first 20, the first 30, no problem. (using
LIMIT (start), (10|20|30)... in the SQL statement)
But if I attempt to pull all of them (no LIMIT clause), or even the first
(x)
Assuming that c.province is the province name, and c.province_id is the
province code, and U.province_id is the province code from the User table,
I don't see where in your statement you have filtered the search down to
just the province_id for the CURRENT USER.
I think you need something
Barry,
Since you're posting to an HTML page, you need BR and/or P to produce
formatting.
I'm guessing that if you look at the SOURCE for the web page you've
produced, you'll see all the formatting.
So, you can either fetch the lyrics and replace all line-ends with BR, or
else use the tags
Hi,
Completely new at this, so don't be too harsh.
I'm trying to create a help file system for a programme (much like the help
files that you get with macromedia flash).
All the help files will be in HTML format and will be in an access database.
I need to search through the database with a
I would like to set up one of those A B C D E F page listings. How do
i query the database to grab the first letter from each entrey.
Barry try something such as
select info from mytab
where name like $ltr%;
Barry,
What you have asked for (from each entrey [sic]) is:
SELECT LEFT(
I am having problems connecting and pulling data from a local SQL server. I
have set up a user and, as far as I can tell, all the settings for the user
are correct. However, when I try to pull data using the user, I get empty
result sets--almost as if I don't have SELECT permissions. When I
George,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT and will be moving this to
Linux before the end of January.
=As a general comment, it is
Although my case was targeted specifically at forms and inputs, your
question depends on how your application would write to the text file.
When an HTML entity is retrieved from the database and put into the VALUE of
an INPUT box or put inbetween TEXTAREA tags, the HTML entity is left encoded
If all of your pages share an include file, then add to the include file
something like this:
?php
if(strstr($HTTP_HOST, oldhostname.tld)){
header(Location: http://www.newhostname.tld.$PHP_SELF);
}
?
That way all requests to the old url will be redirected to the new url. You
can
Store the connection strings in an include file preferably outside the
wed root. You can include files with a fully resolved path, or using the
php include_path variable if you have access to the configuration.
Alternately, if you don't have access to directories outside the
webroot, put the
Is your table indexed on the field your query is based on? That will
greatly speed up the query.
Miles Thompson
At 11:32 AM 1/7/2002 -0500, Peter Westergaard wrote:
Hi,
I'm attempting to pull about 300 rows from a mysql database, (all rows in
the table).
I can pull the first 10, the first
If this is targetted at the Windows platform, why not use Windows own help
engine ... htmlhelp, or something like that?
If it's headed for the web, apologies.
Miles Thompson
At 04:17 PM 1/7/2002 +, Keith Hughes wrote:
Hi,
Completely new at this, so don't be too harsh.
I'm trying to create
Store the connection strings in an include file preferably outside the
wed root. You can include files with a fully resolved path, or using the
php include_path variable if you have access to the configuration.
Alternately, if you don't have access to directories outside the
webroot, put the
Given that the data are on a shared server, then your info is available to
anybody else with root access to the database directories. A previous
web-site I had allowed me open access to other users mysql databases. I
could have blown those databases away.
Thankfully, I happen to be that
I wanted to make it look nicer than the windows help engine.
The idea was to have a framed HTML page with the search engine part in the
left and the help file that has been selected in the right.
If you've used flash or dreamweaver before then that's the type of look I'm
going for. It just looks
Hi
In these web portals they have these things called blocks, is there a tutorial on how
to do these anywhere
Start playing around with some basic php tutorials and
you'll catch on fast and see how to change things to
do what you want. If you have a basic grasp of SQl
you'll be able to think out the thing.
Here's an article on building a search engine.
http://www.phpbuilder.com/columns/clay19990421.php3
$query = SELECT * FROM xp_sings,xp_artist,xp_songs WHERE xp_artist.artist_id =
xp_sings.artist_id AND xp_sings.song_id = xp_songs.song_id AND song_name LIKE 'b%'
DESC LIMIT 5;
$req = mysql_query($query);
$res = mysql_num_rows($req);
if ($res == 0)
{ echo centerbSorry there is no
Barry,
Try ORDER BY song_name DESC
and then add a LIMIT.
Simply saying DESC is ambiguous as you are selecting all fields.
Miles
On Monday 07 January 2002 07:55 pm, Barry Rumsey wrote:
$query = SELECT * FROM xp_sings,xp_artist,xp_songs WHERE
xp_artist.artist_id = xp_sings.artist_id AND
DL Neil,
Thanks for your response.
=As a general comment, it is always dangerous to replicate when shifting
platforms, better to reverse engineer
and then implement anew and taking advantages of the strengths of the new
tools. This particularly when moving
into the relational field...
to use a desc, you need an order by
Barry Rumsey [EMAIL PROTECTED] wrote in message
001001c197d6$ceb70160$0100a8c0@weizmain">news:001001c197d6$ceb70160$0100a8c0@weizmain...
$query = SELECT * FROM xp_sings,xp_artist,xp_songs WHERE
xp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id =
41 matches
Mail list logo
