does the page actually error or does it not do anything?
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Where's the error?
I have this script which SHOULD produce a linked webpage for soon-
you are missing the $ sign on your second mysql_query call
-Original Message-
From: Patrik Fomin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] silly problem
$sql = "UPDATE dagensfraga SET nej = '$nej' WHERE id = '$iid' AND
aktue
sorry, I am a backwards today...number_format()
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 9:01 AM
To: Chris Mach; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] commas
format_number() should do what you want
http://us3.php.net/manual/en
format_number() should do what you want
http://us3.php.net/manual/en/function.number-format.php
Eddie
-Original Message-
From: Chris Mach [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 8:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] commas
Is there a function that will strip o
md5() will always return the same for the same string, how else can you
verify that the user entered their password?
everytime they log in, you have to encrypt what they typed in
$pword=md5($pword);
select * from users where uname='$uname' and pword='$pword'
and see if it matches the password th
no. we added to old 'password' question to one of the sites I did for this
reason. When the client registered, they picked a question, ssn, mother's
maiden name, dog's name, etc and entered an answer. That way if they lost
their password, they could go to a 'lost password' area, enter their
usern
I think you are getting an error because you are using User as the table
name which I believe is a reserved keyword. If you change the name to users
it would probably work fine.
-Original Message-
From: Christopher McCourt [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 1:28 PM
To:
some of the other errors occurred ( such as the headers already sent)
because you probably have white space before your php code.
Eddie
-Original Message-
From: Tim Winters [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 10:21 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Session error
you need to look in your php.ini file to see where it is dumping the session
data, then make sure that directory exits...
-Original Message-
From: Tim Winters [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 10:21 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Session error?
Ok,
Tried
If it is a low traffic site, then the db writes should not be bad at all.
You can simply have the user log in then set their username or something in
a session variable, then you can use that to keep track of them in the db.
Eddie
-Original Message-
From: Tim Winters [mailto:[EMAIL PROTEC
I think you might find it a better option to upload the image to a folder on
the server and save the image path in the db...not the actual image.
Eddie
-Original Message-
From: Stéphane Pinel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 1:03 PM
To: 'PHP DB'
Subject: [PHP-DB]
s
why I'm posting to the newsgroup. The only working thing I have today is the
listing of the "main db"
It looks a bit whired since I copy past it from the file.
Could you post some of your code?
--------
--
Marc,
I did something sort of along these lines with an 'auction' site I worked
on. I displayed rows from a db. If the row had bid information in the db
(or your case submenu info) then a + sign icon was displayed next to it. IF
the plus sign was clicked, the page would reload and the bid or su
I apologize if you subscribe to the php general list also as this is a
re-posting from there..
I know I can connect to another db through an odbc connection in php. Can I
use php to create the connection initially? I will be uploading an access
db from the users and then moving the data over in
I was referred to this class and it works great. I had a page that
generated a leave form (based on the users info) and e-mailed the form as an
attachement to the users supervisor.
http://phpmailer.sourceforge.net/
Eddie
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROT
ginal Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 8:48 AM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] data move
Umm, if it's a one time deal, why not just have access output a CSV (comma seperated
version, or something
Ok, I know I have asked this question several times but it is time for me to
start coding so I am looking for some goog tutorials somewhere. I need to
use php to transfer data from an access file to mysql db. I assume I will
just use an odbc connection but I am unsure as to where to start. If an
Thanks!
select * from offtime where type='%' didn't work but when I change = to
'like' it works great!
Thanks,
Eddie
-Original Message-
From: Marco Tabini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 4:57 PM
To: Edward Peloke
Cc: [EMAIL PROTEC
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is there a wildcard in
mysql like there is in sqlserver that I can use to grab all the records?
such as select * from offtime where type='%' would grab all.
Thanks,
Eddie
--
PHP Database
I need to do roughly the same thing so I am interested to see if it is
possible. I am writing an air charter app so I want to allow the users to
select the airport codes from a popup and it will automatically fill the
box.
If I find anything I will pass it on.
Eddie
-Original Message-
Fr
Hello all,
I need to create a basic calendar page for my office where people can post
their days off. All the data will be stored in the mysql db. Does anyone
know of any good code I an use to get me started? I have seen a lot online
of calendar systems but I just want something to start with,
Ok,
I am lost now, I am just trying to read the documentation on odbc...here is
what I have so far. This seems to work...or at least not give any errors.
How do I know get to the result set in the select statement to move this
data somewhere else? I just want to get the entire result set so I can
Great, thanks! I will look up in the documentation on how to do this.
Thanks for the info!
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 2:28 PM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] extract
I posted this to the php general list also so forgive me if you are seeing
this twice. Can I use php to extract data from an access db? The php
script and access db will be local. I will then upload the file to my
server.
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To un
I know this isn't db related but...I finally go mysql and apache running on
my laptop now I am trying to get php working. I downloaded the
php-4.2.3-installer this morning. Ran the install and am now going through
the install instructions. I noticed it said to copy these lines into the
apache c
Thanks for all the help. I finally got it running by running winmysqladmin
Eddie
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 9:29 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
Forgive me if this is a dumb question but is that still the case if mysql is
on the same machine?
Thanks,
Eddie
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 9:01 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: SELPH,JA
can't seem to find that line in the install file but I probably don't know
what I am looking for
IS this the install doc you meant?
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#In
stalling
Thanks,
Eddie
-Original Message-
From: [EMAIL PROTECTED] [mailto:
how do you do this? I guess I could look it up in the help files. I don't
need the firewall as it is behind one at home.
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:45 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
I got a new laptop yesterday that has xp home loaded. I installed mysql
last night but get errors that I can't connect to 'localhost'. Any ideas?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I asked a question sort of alone these lines the other day so please forgive
me if it sounds familiar...
If I have a microsoft access file .mdb on my server, can I use a php page
to move the data from the file to a mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To
change this part so that $query is capitalized
if (mysql_db_query ($DBName, $query, $Link)){
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:23 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] A little advise please
Hello,
I have a b
I may be able to get my upload problem fixed by the vb app connecting to our
db and pumping over the data. Can I set up a php page or service in mysql
that once an hour, day, etc runs a clean up script?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
Many of the people who will be using my php site, will also be using an app
that runs an access db. I would like to create a page on my webpage that
allows the users to click a button, and data is moved from their access db
on their machines, to my mysql db. Is this possible? I will know where t
I know this is off the topic of dbs but I can't get the mail function to work, I get
this error. Does the script need to be in the apache root?
Thanks,
Eddie
Warning: Failed to Receive in c:\program files\apache
group\apache\htdocs\aircharter\working\verify_login.php on line 69
f in your php.ini file, which is preferable.
> In which case you'll have to use
>
> If($_REQUEST['variable'])
>
> Or
>
> If(isset($_REQUEST['variable']))
>
> Second possible is:
>
> I've never really used an image within a link to sub
r 09, 2002 10:09 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] passing variables
I think you want:
if (isset($variable)){}
<>< Ryan
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 8:33 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB
Hello all,
I have a login/register screen for my php/mysql db. When the page opens,
the user sees the log in screen but I have a button and reloads the same
page, hopefully with the register screen. I know I can simply check to see
if a variable is set with
if ($variable){} . This does not see
I know a lot of sites, such as car dealerships, where you can put in your
zip code and then you can search for cars within 50,100, etc miles of your
house. How is this done? I have a site that we want to implement a feature
like this. What is stored in the db? Can I simply write a function usin
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
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
I am currently creating a php/mysql site for a client. Many of the
customers who will be using this site also use a vb/access program to store
a lot of the same data. The client asked me last night if we could write an
app that would run on the customers machine that would routinely take data
fr
it is just a datetime field and the clients use a javascript calander to
pick the date, here is the exact date as it appears in the db.
2002-11-08 00:00:00
Eddie
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 2:05 PM
To: 'Edward P
When I use this, I get 12/31/69 as my date.
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 13, 2002 4:04 PM
To: 'Edward Peloke'; 'Php-Db'
Subject: RE: [PHP-DB] date()
$date = date("m:d:y", $myrow[datefield]);
I have a date field in my mysql db, when I output the data to the screen, I
don't want to see the minutes, just the mmddyy. I can format a date but
can't seem to get it to work passing in the value from
$myrow["datefield"]any ideas? I don't want to have to worry about just
pulling what I want
I am working on a php page where I need some airport codes data, I have seen
a few places online where you can buy this data so I was wondering if anyone
has used any of these databases and if anyone had a good source for a mysql
airport code db.
Thanks,
Eddie
--
PHP Database Mailing List (http
I agree with the others, don't try to store the picture in the db. What I
did was provide a place for users to log-in to my site, when they signed up,
I created a folder (using their username since that had to be unique). When
they uploaded their pictures, I put the pictures in their folder and t
I don't think you can reference the aliased column timea in the select
clause, I know sql server won't let you do it..try and
(labor_qty*parts_time+parts_setup)>labor_time
-Original Message-
From: Steve Dodkins [mailto:Steve.Dodkins@;ebm-ziehl.co.uk]
Sent: Tuesday, November 12, 2002 10:16
But I am not sure where my hosting companies mysql is so I do not know the
path
-Original Message-
From: Marco Tabini [mailto:marcot@;inicode.com]
Sent: Thursday, November 07, 2002 11:31 AM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] calling sql script
You can use
I need to use a php page to run an .sql script against a mysql db. How do I
simply call the script from php? I can take parts of it and execute the
statements but I would like to just call the entire script.
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
Thanks Jeff,
I will give that a shot.
I am developing on windows but the server that will host the site is linux.
Eddie
-Original Message-
From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com]
Sent: Tuesday, November 05, 2002 3:32 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject
I am playing with uploading files. The names will then be stored in the db.
I have a
simple form:
Send these files:
Which calls a php file that just contains this:
copy($_FILES['userfile']['tmp_name'], "\ufiles\");
This ufiles folder is under my htdocs folder in apache. I have look
: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mail()
did you restart apache?
epeloke@echoma
n.com (EdwardTo: <[EMAIL PROTECTED]>
Peloke) cc:
S
yep and I still get the same error...I modified the ini file in my windows
directory..I assume that is the right one.
Eddie
-Original Message-
From: Marco Tabini [mailto:marcot@;tabini.ca]
Sent: Thursday, October 31, 2002 2:24 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP
I know this is off topic to the db list but..
I am attempting to use the mail function. I have set the smtp in the
php.ini file to my smtp server but when I run the script, I get the error
Warning: Failed to Connect in c:\program files\apache
group\apache\htdocs\lg\nuser2.php on line 50 where li
I am attempting to create a page on my website which will allow users to
upload images. I will need to rename and resize the image and then grab the
location of the image and place it in the mysql db in a varchar field.
I have been told there are already some code for this online that can be
plug
thanks Jeff and Richard, I will give that a shot. Jeff, I see you aren't to
far from here if you work at Keane, I live in NH.
thanks again,
Eddie
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 2:59 PM
To: Edward Peloke
Cc: [
How can I allow the user to upload images to a php website and have the
image stored in the mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
nevermind, stupid me, I got it working...
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] space in query
forgive the basic question but how do I add a space in my query
$result
forgive the basic question but how do I add a space in my query
$result=mysql_query("SELECT * from ".$dbname.".grades WHERE user_id=".$uid.
" and subject=".$subject,$db);
I need to force a space between $uid and 'and' and I don't think simply
pressing the space bar does it.
Thanks,
Eddie
Sorry, Michael, I meant to send this to the list, not just to you. I
apologize.
Hello all,
I am a php newbie and am currently developing my first php page. My page
will allow several people to log in at the same time sharing access to the
mysql db. SO, I need to use sessions. Does anyone
What does everyone typically use to display the results of a query. For
example, I have a database that has a series of subjects and grades. If I
select * from the table, I want a nice way for the data to be displayed. In
cold fusion, I can simply use a grid that dynamically fills in. Can I do
Hello all,
I am very new to php, in fact, this is my first attempt at a script. I have
just been following a tutorial online. Currently, I have a page where the
user types in a username and password, I then pass those parameters to this
page. This page connects to a main db, looks up their us
63 matches
Mail list logo
