with br's and then use substr_count to count how many
br's you have in the string.
Good luck,
Jeffrey Baumgartner
Ng Hwee Hwee wrote:
hi!
thanx for your reply. i cannot count the number of \n because sometimes
the inputted text is very long without any \n, but because it is inside a
cell that has
I'm working on a web application and one of the things I am doing is
creating an archiving function that would move older data to archive
tables in order to minimise the amount of data in the active tables.
This so that the data that is being used more frequently can be accessed
faster by the
, so if I could do it in a singel query it would be so much more
elegant.
Thanks!
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
server, etc, would you also encrypt on the DB?
Thanks,
Jeffrey
Micah Stevens wrote:
Oh! Also, there's built in mysql functions for encryption, I forgot about
that, so you can still search, like this:
insert into table set name_field = AES_ENCRYPT('Some name', 'secret key');
select * from table
);
@mysql_select_db($database) or die( Unable to select database);
$query=SELECT alias FROM tablename WHERE alias LIKE '$alias%' LIMIT 1;
$result=(mysql_query($query))
if (mysql_num_rows($result)==1)
{
echo Alias already in use;
} else {
echo Unique alias;
mysql_close();
}
Good luck,
Jeffrey
Try www.squirrelmail.org - I believe there was a typo in the original post.
JeRRy wrote:
sqirrelmail.org
can't display page
You sure that is the url?
Brent Baisley [EMAIL PROTECTED] wrote:
SqirrelMail is as customizable as you want, it's written in PHP and
you get the source code. By
://php.belnet.be/manual/en/function.strtotime.php
Good luck,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
JeRRy wrote:
Date:Sun, 16 Oct 2005 02:40:44 -0400From:Alain Rivest [EMAIL
PROTECTED]To:php-db@lists.php.net php-db@lists.php.netSubject:Re: [PHP-DB]
µç×Ó´«µ¥,×îÁ®¼ÛµÄÐû´«·½Ê½
KOKOµç×Ó´«µ¥ a ¨¦crit
.
For the last question, get the date info from your drop down menus, then
in php...
$date_for_db=$year.-.$month.-.$day;
...and insert $date_for_db into your table.
Good luck,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- it is not enough to hide menu options. Users
could simply type the URL in.
I hope that's clear.
Good luck,
Jeffrey
Jeff Broomall wrote:
Good morning everyone.
I'm building a very simple content management site that tracks tasks.
The options available are:
1. Add Task
2. Edit Task
3. View Task
4
Ron Piggott (PHP) wrote:
Is there a way to re-name a table once you have created it? Ron
ALTER TABLE `old_name` RENAME `new_name`
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the managers
How can I get the text field to show the entire string?
Many thanks,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
...
Fix the managers
How can I get the text field to show the entire string?
Many thanks,
Jeffrey
htmlentities($some_text, ENT_QUOTES) is more robust than htmlspecialchars
();
David
Thanks, David. That did the trick. And thanks to everyone else who
quickly responded with intelligent
with Chinese and Japanese characters are not even posts.
They are pure spam. As such, the senders should be removed from the list
completely.
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in the
archiving/delete page. That way there would be a snapshot of the
pre-action db, making it easy to put things right.
Can you help with my query - or by suggesting an alternative solution?
Thanks,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
Thanks all for the help!
exec() seems the best option.
Jeffrey
Miguel Guirao wrote:
You could use exec() within PHP!
-Original Message-
From: Adrian Bruce [mailto:[EMAIL PROTECTED]
Sent: Jueves, 29 de Junio de 2006 06:31 a.m.
To: Jeffrey
Cc: PHP DB
Subject: Re: [PHP-DB] mysqldump
methods - presumably using something clientside -
that could check the server and only do a refresh if new data/new page
or somesuch is available.
I hope this is clear.
Thanks,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
security), reliability and customer service as sensitive
corporate data would be saved on the application(s) hosted by them.
Feel free to e-mail me off-list.
Many thanks,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
,
Jeffrey
Ron Piggott (PHP) wrote:
What I haven't figured out is how to crawl my site. If I knew how to
crawl my site I could write a basic search engine and develop it over
time. This is the crucial issue I need help with.
I have a really basic search engine I wrote last year. I told my web
of tutorials. Google PHP Tutorials
and look around.
Good luck,
Jeffrey
[EMAIL PROTECTED] wrote:
I've got a website using PHP and MySQL. I would like to make a news
preview on the webpage's frontpage with a link to the full story.
Is it possible to use one (1) .PHP file to generate full
.
Good luck,
Jeffrey
Chris Carter wrote:
my code:
html
body
?
$username=chris;
$password=carter;
$database=chris_phpb1;
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( Unable to select database);
$query=SELECT * FROM phpbb_banlist;
$result=mysql_query($query
and, if not, generate a
new random number.
Good luck,
Jeffrey
Desmond Coughlan wrote:
X-No-Archive: true
Hello,
I'm learning PhP and trying to write a library catalogue system, that uses a PostgreSQL back-end. My db looks like this ...
http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql
specific data from a table, then use the format...
a href=somepage.php?variable_1=xvariable_2=yvariable_3=zLink/a
Good luck,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
you expect them to have?
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Here's a question of efficiency.
I have an application in PHP using MySQL.
Users select items on a form and each selected item represents a change
in a table row. It is possible that 100s of changes might be chosen from
a single form.
Which is likely to be faster/more efficient?
multiple
We have a moderately complex PHP web app collecting data from a MySQL
database. We've been offered a rather attractive proposition to build an
Ingres version (ie. same app, but collects data from an Ingres database).
Questions for experts like you:
1) Is this a reasonably straightforward
solution I haven't seen.
Many thanks!
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
That's been going on for a VERY long time. And instead of waiting, DUMP
Ultradev and take a look at Code Charge (www.codecharge.com). It fills the
niche in PHP (and a bunch of other languages as well!) that Ultradev tries
to fill in ASP.
--
Jeff (FurBall)
WebOverdrive Newbie Tech Board
path points to the newer version of
mysql then, and not an old outdated one. Make sure you've removed all
binary (for that matter all source) files for Mysql-3.22 if you've
upgraded to 3.23.
If in doubt, type which mysql and see if that's where you think it
lives.
Jeffrey
--
PHP Database Mailing
* Julio Cuz, Jr. ([EMAIL PROTECTED]) wrote:
Ron,
Thanks for your help, but my problem still there even when I made the
following changes:
$sql = "SELECT * FROM \"Remodel\" WHERE Email=\"".$find."\"";
You don't have to quote the table name either. You can probably get
away with
* Romeo Manzur ([EMAIL PROTECTED]) wrote:
how could I configure diferent user password to each database on my
server???
You can probably achieve this with grant statements.
Grant SELECT on test.* to myuser@localhost identified by 'pass1';
Grant SELECT on other.* to myuser@localhost
anyone enlighten me or have any ideas?
Thanks in Advance,
Jeffrey Cleary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
and Linux Administration, along with prior PHP
application success.
Only replies with their resume and hourly rate will be considered.
Please post to another list if this is the wrong one.
Thanks,
Jeffrey Cleary
JeffreyCo, Inc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
']}nbspnbspnbsp{$row['position']}/b br;
}
?
Jeffrey Norsworthy MCP, CCNA
Network Administrator
Community Health Services
[EMAIL PROTECTED]
Thanks for the tip. Unfortunately it didn't fix the issue. I am sorry about the way
the address message is displayed. There unfortunately isn't anything I can do about it.
Jeffrey Norsworthy MCP, CCNA
Network Administrator
Community Health Services
[EMAIL PROTECTED]
Bogdan Stancescu [EMAIL
). They must be willing to host adult content (soft-core
erotica and adult humour). Any recommendations (on or off-list will be much
appreciated).
A million thanks,
Jeffrey Baumgartner
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
and add the sender's e-mail address to the
database (MySQL).
Doable?
Thanks,
Jeffrey Baumgartner
eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
function in PHP
to get a row count (which is dead easy). It SEEMS to me the former would be
more efficient. Am I correct?
Many thanks!
Jeffrey Baumgartner
eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00
--
PHP Database Mailing List (http://www.php.net
pages with links to content
pages. All links will be visible, but links for paid members will be clearly
indicated. The purpose of this is to show freeloaders what they are missing!
I hope this is clear. More experienced members of this list may well find
flaws with my method.
Good luck,
Jeffrey
of the permissions the site 2 web host has
granted me? And if so, why can I do things with phpmyadmin but not via my
own scripts?
Many thanks,
Jeffrey Baumgartner
?php
$dbcnx = mysql_connect(localhost, USER, PASSWORD);
$db = mysql_select_db(TABLENAME, $dbcnx) or die(Couldn't get DB);
If (isset
seconds.
But perhaps you have a more elegant solution?
Thanks,
Jeffrey Baumgartner
eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
1-Since he's posting to a PHP-DB list, I think we can assume he plans
to implement it in PHP using a database to capture and store the
comments/ideas.
Correct, thank you.
Jeff - Do you have a plan in place for your DB schema or the backend
processing that might take place?
No,
I am making a section on a web site which requires that visitors log-in.
Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP
4.2.2 with global variables turned off. Until now, I have worked with a
different host in which global variables were switched on.
The way it works
and
session_register($_SESSION['okbabe']);
on index.php.
Your enlightenment will be highly appreciated.
Jeffrey Baumgartner
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
wrong).
I expect the solution must be dead easy, but I can't find it or figure it
out.
Many thanks,
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
There is eClipse, it can be found at http://sourceforge.net. It is a
modular IDE, and there is a plugin for php. It is Java based, so it
works on any platform.
phpEdit is also free: http://www.phpedit.com
Those are the best two editors I've found.
--
PHP Database Mailing List
JM Primary keys aren't any faster than normal keys. They're simply for
JM identification. (correct me if I'm wrong, that is my understanding)
JM If you don't already have an index on created, I'd do that.
I do - here's a question though, what is the best way to have an
index? To combine
Is Sybase support in PHP5 working?
I get:
/bin/sh /usr/portage/tmp/php-5.0.0b3/libtool --silent --preserve-dup-deps
--mode=compile gcc -Iext/sybase/ -I/usr/portage/tmp/php-5.0.0b3/ext/sybase/
-DPHP_ATOM_INC -I/usr/portage/tmp/php-5.0.0b3/include
-I/usr/portage/tmp/php-5.0.0b3/main
It is possible to md5 encrypt a password before you send it off to the
server using javascript onSubmit function. Check this code out:
http://pajhome.org.uk/crypt/md5/
-Jeff Moss
- Original Message -
From: matthew perry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 05,
I think someone else asked about a problem where they had text running off
the side of the page, heres everything I've ever learned about PS/PDF.
GNU ghostscript is all you really need for editing pdf's. Usually the text
appears as plain text once you convert the PDF to a PS with pdf2ps, and you
I would start by seeing if the files are there after you create/load the
table. It should by default create a file for each table you create. Sounds
to me like a problem reading the disk.
If you don't find any answers on your own, post your system specs to the
MySQL lists. You could also try
Read up on MySQL full text search.
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
-Jeff
- Original Message -
From: redhat [EMAIL PROTECTED]
To: phplist [EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 10:12 AM
Subject: [PHP-DB] search engines
Anyone out there know of a good
Steve,
You must turn the file to postscript before you can read anything out of it,
and even then, a lot of the time words are broken up into different show
statements.
use pdf2ps (part of GNU GhostScript) to convert to PS and then search for
patterns like this:
(text) show
that is the most
Well, like will do a full table scan if it starts with a wildcard, so you
dont want to do it that way.
I'd do full text search.
http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
-Jeff
- Original Message -
From: Monty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 22,
Well, you should come up with a definitions table.
Create an array out of the definitions table (I'd recommend keeping
everything in one array, for recursive efficiency). Then go over THIS array,
and check for the existence of variables in the form array. That way you can
output all the
Gotta recompile php with the --with-mysql option (or something like that).
Try running configure --help
You can see what options you compiled with by grepping for CONFIGURE in your
Makefile. Here's what I got:
[EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile
CONFIGURE_COMMAND =
://www.macromedia.com/devnet/mx/dreamweaver/articles/php_iis.html)
-Jeff
- Original Message -
From: Jeffrey Moss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 12:08 PM
Subject: Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined
function mysql_connect()...
Gotta
Matter of preference really. Do you put all your files in one directory? I
do for the most part, but when it comes to security you can divy out access
to different databases rather than each table and it makes things simpler,
so I use different databases for different projects. Also, I think
Or, you could use XmlHttpRequest, which is what google suggest uses.
http://www.google.com/webhp?complete=1
You can use this to dynamically populate a section of the page. I wouldn't
delve into it unless you have some xml/javascript experience also though.
Try this page for more info:
resource. This really puzzles me because it works one
time around, but not after that.
$ic, incidentally, is a string originally generated from the timestamp
(ie. getdate[0]) - could this be causing a problem?
Many thanks!
Jeffrey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
That was indeed the problem and of course I should have seen it myself!
Thanks very much, Jochem.
Jeffrey
Jochem Maas wrote:
Steve McGill wrote:
Jeffrey Baumgartner [EMAIL PROTECTED] schreef in bericht
news:[EMAIL PROTECTED]
I've made a little programme that deletes expired records from database
I am trying to connect to a DB on a difrent server but mysql keeps connecting to the local server via the socket. What is going on?
-- code snippet--
$connection = mysql_connect(mysql.meanspc.com:3306, Removed, Removed);
--
Jeffrey D. Means [EMAIL PROTECTED]
Owner / CIO for MeansPC http
)
and zg_longitude = ('result here'+2)
order by zg_city asc
Can anyone help me with this or point me in a better direction?
Thanks
-Rich
--
Jeffrey D. Means [EMAIL PROTECTED]
Owner / CIO for MeansPC http://www.meanspc.com/
Custom Web Development For Your Needs. (970)308-1298
My Public PGP Key ID
63 matches
Mail list logo
