one on a different
server all together.
What do you think?
Thanks,
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Also check out .codecharge.com - it's a bit more matured.
I couldn't get codejay to work on my machine - can't even remember
the errors. I just removed it after 2 hours of frustration.
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
I think that the following code looks fine, but I get an error (Warning:
Supplied argument is not a valid MySQL result resource) where it says "while
($Row = mysql_fetch_array ($Result)) {" any ideas?
$category returned the following
results:";
} else { if ($title) {
$Query = "SELECT * from $
t a good way but a possible way is
$varString = $array[index] . " " . $array[nextindex] ...
ofcouse it would be better with an foreach but still arrays > string imho
--
Tim Nilimaa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I want to save and load images as binaries with a MySQL database, but I'm
not sure how to do it. I'm sure this is a very dumb question, but forgive
me for being a newbie =)
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
suggestions on how to secure the database password would be greatly
appreciated.
Thanks in advance!
Tim Haak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
#x27;ve tried setting the
"session.gc_maxlifetime" in the php.ini to a lower number, but had no luck.
I suppose a last resort is a script that runs in cron to delete the old
files.
Our environment is: Solaris 7, PHP 4.1.2, Apache 1.3.22.
Thanks in advance for any advice you may have.
and allow Apache to return the data to php/mysql.
Thanks In Advance,
Tim Legg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on a different
machine.
(A really crappy setup...)
/Tim K
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
with
configuration information in this regard.
Thanks in advance,
Tim Nields
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the password stored
in the DB. In addition to the "PASSWORD()" function, I also tried "MD5()" and
"ENCRYPT()" but they also failed. Can someone please help me accomplish this or point
me to some resources that might help?
Thanks!
Tim Haak
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ing longer than 15). The stored string's end was
concatenated. I found that in my example it made the string 4 times as long.
Thanks!
Tim Haak
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 7:17 PM
To: Tim Haak; [EMAIL PROTECTED]
Su
I've written a script that works perfectly for almost ten times, and then
stops being able to connect to the MSSQL server. I imagine this has
something to do with me not properly closing my connection, and the server
having a maximum # of connections.
I'm calling both mssql_free_result() and mssq
What is the best method to move data from access tables to postgreSQL?
Are there are php functions that are available?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administr
RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...Agreed.
Personally, I refuse to keep date values in fields that are not DATE fields
of some kind. Too much trouble.
TIM
-How do "Do Not Walk On Grass" signs get there?
-Original Message-
From: Robinson, Mike [mailto:[EMAIL
you want to do is bid a fixed cost for the project and
then have "scope creep" break you. You can try to keep scope creep under control by
getting the client to commit (in writing) to your proposal (and revised proposals),
but my
experience is that there's always scope creep and/or
your 'webmaster' making $65 per hour".
I think a light came on for him. (but he likes his webmaster, so I didn't get the job
;)
C'est la vie!
TIM
-Some people manage by the book, even though they don't know who
wrote the book or even what book.
--
PHP Database Ma
business needs. If the characteristics
are
few and don't change often, it seems to me that you'd want a 3rd table to keep them.
That
way, the spelling is similar, etc, and therefore you can do (accurate) queries based on
the characteristics (if the need ever came up)
TIM
-Whenever you
Use sql keyword LIKE, unless you have access to the design of the database,
in which case design it properly (i.e. something approaching normal form).
Tim
--
From: Peter Brown [SMTP:[EMAIL PROTECTED]]
Sent: 12 November 2001 05:28
To: [EMAIL PROTECTED
tead. I wanted to make sure I wasn't missing some cool
feature of PHP. ..and the feedback I'm getting indicates that my general
understanding of
dates in ASP is not too different with PHP.
TIM
-Things are more like they are today than they ever have been before.
--
PHP Database Mail
le space considerations and (IMHO) reduce the amount of programming/debugging
to
more than justify the overhead.
FWIW, M$ likes to store their dates as two integers: one to hold the date portion, the
other to hold the hours:minutes:seconds portion.
If there's something about PHP/MySQL that ma
se you could be painting yourself into a corner if you had to move to another
platform.
TIM
-What if the Hokey-Pokey really is what it's all about?
> -Original Message-
> From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> I actually have an easy way to do INSERTs like this.
Interesting.
A bit tiedious, I suppose. Seems like it'd be a bit more overhead than I'd care to
have,
but an interesting technique nonetheless.
TIM
-I date this girl for two years and then the nagging starts: "I
wanna know your name." - Mike Binder
> -Original Messa
? The idea being that if you put it in an
array and suddenly decided that you needed more than 2 colors, you just add
your colors to the array and change the modulus number.
Thoughts?
TIM
_ l i n e a r c o n c e p t s
http:/
and change
the
modulus number from 2 to however many colors you want.
I'm still fairly new to all things *nix, so my handling of regular expressions is
simply
not what it should be. When I look at the ereg() you've got... I'm scratching my head.
(but I *think* I know what you'r
e value of $manufacturername will be
a comma-delimited list of all the values they selected. If your query
will be based on this selection, then it must read:
SELECT ... WHERE Manufacturer IN ('$manufacturername')
3. You can use 'size="n"' to control the hei
You wouldn't happen to have a spare ELH diagram (or two) lying around
that one could take a look at, would you?
Thanks.
TIM
-When you save for a long time to buy something, then you find
that you can't afford it --- that's inflation.
> -Original Message-
>
Server Enterprise
> Manager. It should show the calling server, the PHP version, and that
> the connections are sleeping.
>
>
> Tim Evans wrote:
>
> >I've written a script that works perfectly for almost ten times, and then
> >stops being able to connect to the MSS
I have a database: web_feedback, and it has 5 columns:
Firstname varchar(40) not null
Lastname varchar(40) not null
Email varchar(40) PRIMARY KEY not null
ServList varchar(40) not null
Timestamp not null
I run a query in a PHP script to retrieve the email address the line of code
looks like this:
Hello,
I'm interested in setting up a system whereby I can track a users
movements through a site.
I particularly I am interested in recording both that the user actually
hit the page but also the time he spent on that page.
Is this possible using PHP and if so how?
Thx
Tim Wi
Thanks Mike,
You make some good points.
>From a volume point of view I don't think making the writes to the DB
will have much effect as it's a low traffic site.
I guess I'm going to have to do some reading on SESSION()
Thanks!!
Tim Winters
Creative Development Manager
Sam
Interesting Pierre,
Is this something you have ever used?
Thanks for the reply
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
www.samplingtechnologies.com
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Office: 902
ine 6
Warning: Unknown(): open(/tmp\sess_bf0c0a0a020087aa573e357a2553f828,
O_RDWR) failed: No such file or directory (2) in Unknown on line 0
Warning: Unknown(): Failed to write session data (files). Please verify
that the current setting of session.save_path is correct (/tmp) in
Unknown on line 0
Thanks John,
So is that address relative to the physical machine or is it relative to
the directory where the php files are contained.
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
Thanks Mike!!
Ok, been doing dome more reading on sessions. Is there any sort of
consensus on whether to use cookies or not for sessions?
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
"myPHPpage.php and include the following...
Don't put ANYTHING else in this PHP page. No space, no html markup,
nothing.
That should do it. I haven't tested the code, it just sort of flew out
of my fingers but it should would.
Doing a google search on Flash and PHP turns up tons of re
Anyone know how you set a lock in a MySQL table using PHP?
I tried:
$select = ³LOCK TABLES t1 WRITE;²;
$select .= ³select * from t1;²;
$select .= ³UNLOCK tables;¹;
When I run mysql_db_query(³db²,$select,$conn); it always returns nothing.
Any insights would be appreciated!
Thanks,
/T
ge and reading the suggestions of others,
I think I've covered all of my bases. What else do I need to look at
that could be causing this problem? I've had a person who is used to
configuring servers to use PHP and MySQL look at this and he also thinks
I've got it setup corre
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket
Please include the list in replies.
Sorry, I meant to, but hit the wrong button.
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web
Stut wrote:
Tim McGeary wrote:
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to
another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect
Stut wrote:
Tim McGeary wrote:
Oh, duh! Ok. I wrote this:
mysql_connect($hostname, $username, $password) or
die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT * FROM Requestor_type") or
die(m
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or are you saying that
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or are you saying that
Chris wrote:
Tim McGeary wrote:
Stut wrote:
Ok, so I did the recommended process of:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
This allows the CLI
check properly?
Thanks,
Tim
$query = "SELECT $select_value FROM $table WHERE $field =
'{$search_value}'";
$result = mysql_query("SELECT $select_value FROM $table WHERE
$field='{$search_value}'") or die(mysql_error());
echo "$result".&qu
Thanks!
Tim
Miguel Guirao wrote:
The mysql_query function executes a query againts a DBM and just that, it
delivers the query to the DBM, if the DBM can execute the query, it returns
a positive integer, if the DBM can not execute the query, it returns 0 or
false, can't remember exactly
bout which MySQL statement in the page is the problem? "line
4" certainly doesn't help.
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If you I missed anything or you have more specific questions, feel free
to email me on or off list.
Cheers,
Tim
Tim McGeary '99, '06G
Senior Systems Specialist
Lehigh University
610-758-4998
[EMAIL PROTECTED]
Jason Pruim wrote:
I sent this to the MySQL list but didn't rece
I designed the site and did all coding, and uploaded from OS X. But
the mac stops there, our work server is Windows, and the server
hosting our sites is I think Windows.
On 11/12/2007, at 3:34 AM, Dee Ayy wrote:
Normally I'd say, "If it's been working fine for 3 months; then just
stopped
Asalamalikum Asim, Happy new year from Australia.
Tim
On 11/01/2008, at 12:31 AM, Asim wrote:
AOA
HAPPY NEW MUSLIMYEAR
Asim Jamil
PRAY FOR WHOLE MUSLIM UMMAH AND ASK HELP FROM ALLAH AND HAZRAT
MUHAMMAD (SAW)
ALLAH HAFIZ
Hi,
This is my first time using php in my site navigation, I have the code
for all the pages in one file and I am using the switch statement to
change between them.
This is working great but I am now trying to change the css id of the
current page's navbar link. How do I get my script to
If you are looking at future expansion then the separate DB per blog
is defiantly the way to go.
Some notes:
1) Avoid joins like the plague, in fact most operations on a blog
application would consist of getting primary record and then
decorating it with secondary data, for example getti
Until TUDBC is available under an accredited FOSS license, nobody in
their right mind is going to use it in any project that
may need to be ipr encumbrement free at a future date.
Posting solutions that pertain to a proprietary technology on a list
predominately dedicated to technologies tha
FC is an internal link which makes finding things in the RFC rather easier.
The following list of RFCs is the set I consulted when writing my own email
client:
a) RFC 5034 POP3
b) RFC 2821 SMTP
c) RFC 5322 Internet Message Format
d) RFC 2045, 2046, 2047, 2048, 2049, (MIME), and 2183
--
o
small in database-connection.php on line 33
I tried adding:
[OpenSSL]
dh_param = /etc/ssl/dh-2048.pem
to php.ini per the PHP documentation related to the OpenSSL library,
but that did not seem to help. Is there some way to specify a dhparam
file to be used by php56-mysqli?
--
Tim Gustafson
t...@uc
ulatie differences between timestamps etc...
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
start again.
update 'rows you would update anyway' and 'oca=oca+1' where 'regular stuff'
and 'oca=$ocaFromHiddenField'
If you don't update the 'rows you would update anyway' and 'oca=oca+1'
at the same time you run again into con
s
you to have 1-n relationships between clients-sales and products-sales.
Apart from the links to the client_id and the product_id, you also may
want to have a sales_id, quantity, date of order, ...
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
system will accept it. So can you pls suggest me what to do to solve the problem
> ?
In this case you only want to allow characters in the interval 0-9. I
think \d is a shortcut for that. And to limit it to only 10 occurences,
i believe you can use {0,10} so you end up with \d{0,10} if i'm no
is already written (and cut the irrelevant
things out) , things stay clear for everybody.
As i mentionned before, use your regular expressions manual.
There you will find what \s and \w mean.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.
> {
>
> Statements;
> }
>
> But here still system not supporting for space.
If you don't bother to read my advices, i don't bother to answer
anymore.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
and Peterson etc... Every website on
computer algorithms will know how they work...
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ssion with the ones in the database.
This way:
Every user that tries to login with a valid uid/pwd gets access.
Every session with the same uid but older timestamp expires.
Don't applaud, just throw money :D
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List
all zeroes for this
> output.
> I can't even get this function to work in a SQL query window.
> Please help!!! I would attach code to this, but I am not sure what to
> attach.
Try "SELECT LAST_INSERT_ID() AS id";
--
Tim Van Wassenhove <http://home.mysth.be/~timv
dvantage of using a regex is that you can perform some form of
> validation on the address.
And in the end compare your regular expression with the one at:
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Dat
567';
Probably you'll want to make the name the primary key or at least
unique. This way you save yourself from adding duplicate entries with
the same name.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
aining (ip - timestamp) pairs,
the other containing (username - timestamp) pairs.
Every time someone tries to authenticate, you count the number of
failures in both queues. The larger the number, the longer the sleep
will take. (removing old entries once in a while might speed up things)
--
Tim Va
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
age you should use
http://www.php.net/htmlentities.
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
eys are field names instead of
> the key fields themselves? IE:
What's wrong with:
$db->setFetchMode(ADODB_FETCH_ASSOC);
$rs = $db->Execute('...');
$rows = $rs->getRows();
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
--
PHP D
d the password
mysql -u user -pyourpassword -h somehost db < /tmp/mydb
--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
72 matches
Mail list logo
