Hi all,
How do you make a 'processing page' like the one's on some php forum search
pages? Would it be something like as follows:
Processing
Processing, please wait...
';
?>
Or is there some other much simpler way to ac
I have a database which allows people to upload info and foto's. There's a
unique ID field, but some people tend to upload their info more than once
(its a contest site). What I'm able to do is to see how may duplicates there
are using the following statement:
$query="SELECT COUNT(*) as cnt, voorn
Hi,
there's an elegant way to stop people from uploading the infos more than one
time.
And it's easy to do. You just have to figure out which fields are not allowed to
have the same values and put those fields into an unique key.
ALTER TABLE projekt ADD UNIQUE(voornaam, achternaam, email)
would ju
I do not understand your first question.
Your query in effect shows duplicates.
To prevent future duplicates, you can do it in two ways:
1. with MySQL:
create a unique index on what should be unique, most likely the email (it
looks like your business logic implies one entry per email)
in fact you
Ok I see, and how would you catch the error people get, when they send it
again ?
"Bastian Vogt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> there's an elegant way to stop people from uploading the infos more than
one
> time.
> And it's easy to do. Y
Marco Alting schrieb:
> Ok I see, and how would you catch the error people get, when they send it
> again ?
>
Well, there will be no error-message... if you use mysql (do you?) ;-)
If you want a message you will have to select all rows from your table where the
values the user wants to insert a
What I ment was that when using the GROUP by, you will see one of the
duplicates, and if you output the 'cnt' value you would see how many times
it has a duplicate. But I want to see all duplicate records in a table, so I
can add a delete button to the row.
If I have the email address as a PRIMARY
Well, seeing n rows or only one does not make you any happier, because you
can not issue a DELETE statement that will delete only (n-1) entries.
If your table is small enough, you may try to delete duplicates manually
with a graphical interface such as Access or DBTools. But test first, as it
may
Hi,
My website requires subscribed users to login with their email and password,
the email is guaranteed to be unique, so this is one key, the other is the
AUTO_INCREMENT ID assigned at registration time.
In the cookie that I drop at logon time is the email/password combination
(security isn't re
Hi to all,
I'm working in a system where users can post projects. Other users will
verify those projects. What I'm trying to do is once a user verify a project
he/she cannot view it anymore, but I want to keep it available for the other
users that haven't verified it.
I have two tables project and
the id is definitely better. although creating an index on the email and
potentially the password would help. I had a table that was indexed off of
a random unique string and when i got to about 5+ rows updates were
taking about 4 seconds.
you can authenticate with the email and password, b
Ideally, you would have 3 tables like so...
Projects(with one record per project)
-
projectID |ProjectName| etc...
1 my project
2 another project
Users(with one record per user)
---
userID| userName| etc...
123 Joe Blow
124
Always, always, always use a value that has no other significance other
than being a unique ID. Email addresses change and so do passwords, so
those are poor choices for linking data. They are fine and good choices
for login, but that's about the only thing they should be used for.
I've seen sy
Okay, it was suggested that I may not have my "register_globals" flagged to
"on" but I do. I still can't seem to make any remote connect to the server.
Again, there are no errors, it just flat don't work.
Chase
"Chase" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTE
do you have the persmissions set either for [EMAIL PROTECTED](which
would only work from remotehost.com) or username@'%' (which would work for
that username from any host)
hth
jeff
Are you able to connect to the MySQL server from the command line using
a non-php client?
--Dave
On Wed, 2002-12-04 at 09:04, [EMAIL PROTECTED] wrote:
>
> do you have the persmissions set either for [EMAIL PROTECTED](which
> would only work from remotehost.com) or username@'%' (which would work
Yes I am.
I was just asked to create a simple web page that would display the visitors
IP address using:
and when I call this up over the intranet or internet it works just fine.
However, I was also asked to create a page that would just display the PHP
Info screen and that will only show up on
On Thursday 05 December 2002 00:44, Chase wrote:
> Yes I am.
>
> I was just asked to create a simple web page that would display the
> visitors IP address using:
>
>
So you're saying that the above works ...
> and when I call this up over the intranet or internet it works just fine.
> However, I
The phpinfo() call works great on the server itself, but I cannot get the
information to display to anyone that connects to the server.
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Thursday 05 December 2002 00:44, Chase wrote:
> > Yes I am.
>
Ok, I know this isn't really a db specific question so forgive me. In my
php/mysql page, I have a button that loops back to the same page only when
it opens the page again, I want it to go to a certain spot on the page with
certain parameters.
For Example
auction.php#map takes me to the map sec
Try auction.php?clientid=1#map
On Wed, 4 Dec 2002, Edward Peloke wrote:
> Ok, I know this isn't really a db specific question so forgive me. In my
> php/mysql page, I have a button that loops back to the same page only when
> it opens the page again, I want it to go to a certain spot on the page
thanks Peter! Thanks I appreciate it!
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 2:21 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] anchors
Try auction.php?clientid=1#map
On Wed, 4 Dec 2002, Edward Peloke wrote
I am trying to implement an approval system that sends an e-mail to
a user for approval linking them back to a special URL that matches database
entries for a verification string. The verification string sent via the
e-mail does not match that in the database and I am looking for help in
f
The %7 and similar are used in URL encoding to represent illegal characters
such as spaces and others - these are translated when the user clicks to
open the URL, giving the string you get back. I think
Peter
---
Excellence in internet and open
Hi
PS
I would use
$verify_string = md5(uniqid(rand()));
to generate a random identifier of the sort you are looking for
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
w
> Always, always, always use a value that has no other significance other
> than being a unique ID. Email addresses change and so do passwords, so
> those are poor choices for linking data. They are fine and good choices
> for login, but that's about the only thing they should be used for.
I under
hey, there's a full featured, open-source db, made available from SAP.
since sap has software running on this database base that powers the ERP
systems of the world's largest companies, it has a lot of powerful,
advanced,
reliable features. you can get free cd's of the database from there web site
isn't it funny how all projects are simple till you do them!
well, that is, unless they really are simple. i guess i never take those.
"Aaron Lagadyn" <[EMAIL PROTECTED]> wrote in message
003c01c298b6$7a235180$[EMAIL PROTECTED]">news:003c01c298b6$7a235180$[EMAIL PROTECTED]...
> Hi:
>
> I'm l
Hi!
I am knew around here, and a newcomer to PHP, but I know enough. I have =
this idea, and I have gone through all the ways that I know off to work =
it, but they dont work. I am a paintball player and I get fustrated =
because there are too many web sites out there that sell paintball =
marker,
echo the actual sql statement from runtime and post it.
"Natividad Castro" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi to all,
> I'm working in a system where users can post projects. Other users will
> verify those projects. What I'm trying to do is onc
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 11:48 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: PHP/MySQL not available remotely...
On Thursday 05 December 2002 00:44, Chase wrote:
> Yes I am.
>
> I was just asked to create a sim
Hi,
I'm using some form fields on a page to pick up existing data from a MySQL
database, make any changes, and update the database when i hit "submit".
I've picked up the data ok, now i want to process the update...
How do i call a function(?) on the same page rather than use another page
through
long story short - you can't
you can only call a function in javascript or some other client-side
scripting language like that, and you would use the onSubmit="" attribute of
the tag.
by the sounds of what you want to do - i would say you would do something
like;
1. load values from db and disp
Well, we can only offer very general guidelines at this stage.
What you can do is write a script that:
- call all the URLs showing paintball prices (btw what is a paintball?)
- extract the product name and price. this will require a specific REGEX for
each URL called, and regular testing vs change
Simply append a parameter to the URL:
action="same_page.php?selector=1"
your script will take various actions based on a switch:
switch $_POST['selector'] {
case 1 : etc.
Ignatius
___
- Original Message -
From: "Gavin Amm" <[EMAIL PROTECTED]>
To:
35 matches
Mail list logo