idea why I'm getting this error? (the same connect string works fine
on a differant web server running FreeBSD-5.2.1/php-4.3.6/mysql-3.23.49)
Thanks,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
]
if (empty($first) || !eregi("^[A-Za-z]+[- ]?[A-Za-z]?$", $first))
the regex is broken?
Regards,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks, I did use your code as is, and it works perfectly.
Regards,
Chip
"Bastien Koert" <[EMAIL PROTECTED]> wrote on 01/28/2005 09:56:35 AM:
> What you should do then is to compare some value to only write the image
> data if that value matchesin my code snippet,
ts the last row?
--
Chip
"Bastien Koert" <[EMAIL PROTECTED]> wrote on 01/28/2005 08:37:58 AM:
> it runs three times because there are three rows of data and you are
setting
> the same thing for each set of data.
>
> try this
>
> $sql="select * f
included in this message of course (and this file is itself included in
another file), the page can be seen at this address:
http://www.simradusa.com/index-test.php
If anyone can see any reason for the script to run 3 times please let me
know.
Thanks,
Chip
Thanks for all the tips guys. I'll keep the last couple for future
reference.
--
Chip
Gareth Heyes <[EMAIL PROTECTED]> wrote on 01/26/2005 05:30:45 AM:
> >> if(isset($_GET['id'])) {
> >> $id=$_GET['id'];
> >> $query = "select
the purposes and the site.
Here is the code I have used -
%s", $row["alt-text"],
$row["title-text"], $row["desc-text"]);
}
?>
I'm sure there are many ways to do this sort of thing, but this is quick
and easy, and works.
Thanks guys,
--
Chip
"Basti
FWIW, I have the image stored in the database in a blob
field, is that correct?
--
Chip
> >From: Chip Wiegand <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: [PHP-DB] storing images in database
> >Date: Tue, 25 Jan 2005 12:44:44 -0800
> >
> >
requested URL /id=$id was not found on this server. Any suggestions?
Thanks,
Chip
"Bastien Koert" <[EMAIL PROTECTED]> wrote on 01/25/2005 09:45:39 AM:
> the best way to do this is to move the image processing code to a
separate
> page and include it like this
>
> e
,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
little sleuthing
around in there I will probably figure out what the extra 10 rows are.
Thanks you very much.
Regards,
Chip
> What this says is take everything in Dealers, left join it against
> blackgate_users (left join says to take everything from the left side..
> And match against t
rows that are in the dealers table but not in the
blackgate_users table.
Thanks for any help,
Chip Wiegand
Computer Services
Simrad, Inc
425-778-8821
425-771-7211 (FAX)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ared. The database table has columns
titled qty as well as description and others.
Regards,
Chip
The newest version of the code is this -
Part Number
Description
Quantity
List Price
Special Price
Put on Hold
%s\n\n", $row["part_number"]);
printf("%s\n\n", $row
Justin Patrin <[EMAIL PROTECTED]> wrote on 08/12/2004 12:55:24 PM:
> On Thu, 12 Aug 2004 12:46:19 -0700, Chip Wiegand
> <[EMAIL PROTECTED]> wrote:
> > I have an existing database and web page showing the query results. I
have
> > added another field to allow a user
but that doesn't work. I have pasted in the main part of the code below...
Thanks for any help you can provide,
Chip Wiegand
Computer Services
Simrad, Inc
425-778-8821
425-771-7211 (FAX)
BTW, thanks for the replys to the first message, I was expecting
I just subscribed to the list yesterday and have yet to receive any
messages from the list. Any ideas?
--
Chip Wiegand
Computer Services
Simrad, Inc
425-778-8821
425-771-7211 (FAX)
that. In the meantime, this database is
pretty
low useage, very specialized information for a small market segment, so
for now
it will be okay. It'll never have hundreds or thousands of hits per day.
But I
will look into making the suggested changes.
Thanks,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
implied a need to have the messages saved to
the database, what they do
with the message is their game, not mine. I'm just cleaning up their
existing code a bit.
--
Chip
Miles Thompson <[EMAIL PROTECTED]> wrote on 06/04/2003
08:31:14 AM:
> Chip,
>
> Given that you have
the page and fills in the form
- today, tommorrow, next week, next month, whenever. The address info is
being written to the database each time they send the form. The message
body itself isn't saved to the database, only the name and address info.
--
Chip
> On Wednesday, June 4, 2003, at 03:13
orked
with cookies yet, so am not sure where to start with that part.
Thanks,
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
nd it happens. I get at least
one phone call a day from people asking why they can't log in, the
screen just reloads. I suggest to them to upgrade to Mozilla, Netscape
or Opera.
--
Chip
> Sr. UNIX Administrator
> Ingram Entertainment
> (615) 287-4876
> "Pay It
behavior appears to only effect IE, I saw it once on
either Netscape
or Mozilla (I don't recall which), and no one I've talked to on the phone
has had this
problem in any browser other than IE, and there have been many calls about
this. Any
idea what this might be caused by?
Thank
es are obeyed by the results page. This is quite strange.
Anyone
seen this behavior before?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of
id
= '11'
but of course that changed the file name for id 11 to %.zip. Is there a way
to change all the
entries from .pdf to .zip without writing an update statement for each
individual row?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There i
id
= '11'
but of course that changed the file name for id 11 to %.zip. Is there a way
to change all the
entries from .pdf to .zip without writing an update statement for each
individual row?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There i
looking at had so many include files referencing other include files that
getting
it all straight was near impossible.
--
Chip
> > Typically, the menu items are links
> > to html pages. I would like to have the link bring up a list of items
from
> > another table in the database,
&
statement?
Is this even possible?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(They why do I have 8
near 'lifts, char(25), not
null' at line 1
I don't see any reference to this in the php manual or in the two
php/mysql books that I have.
Anybody know how to do this?
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Forget it, It works, I was entering a field name with a space in it, and
that was causing the problem. Duh!
--
Chip
phpdbOn Tue, 2002-10-01 at 22:01, Chip Wiegand wrote:
> I would like to know how to add columns to an existing table. I've tried
> this -
>
> $qry = mysql_q
I've gotta get this fixed ASAP,
perminently, this is a business web
site. The code for the login screen and the main page are pasted below.
Regards,
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in the
t the user
being forced to go through the logon screen?
Thanks,
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Co
link, in the left column, and in the
right is the form for input/editing. The kids list is ordered by
kids_id, making it easy to know what id's already exist, or don't yet.
--
Chip
On Sat, 2002-09-21 at 01:39, Ignatius Reilly wrote:
> This is a query requiring two different levels
ame and
l_name.
I s'pose this is clear as mud.
Thanks for any help you all can provide,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
form field).
When I make any changes and press submit, the changes to fields other than
rma_status, those fields are updated or left
as is, but the rma_status textarea is wiped out.
Also, instead of updating the current item in the db, it is submitting
another row into the database, giving multiple ro
Have you looked at which configuration file you are using? That is also
shown in phpinfo. I have often edited the wrong php.ini file and gone
nuts when none of my changes took place. You might need to HUP httpd,
though I'm not positive on that one. Give it a try though.
Chip
On Thu, 2
corner, whereas
before
it was one tab furthor into the box, now I know why that happens also.
thanks,
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairma
;
}
I use the same type of checking on input type="text" boxes and it works
fine.
Any ideas why it doesn't work on a textarea field?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home
Got it figured out, and foreign address do work now -
if (empty($useremail) ||
!eregi("^([A-Za-z0-9\.\_-])+@([A-Za-z0-9\_-])+\.([A-Za-z])+\.([a-z])*$",
$useremail))
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
he
sections, and added the {2,3} because a web site tutorial shows that will
limit the preceding section to that many characters (2 or 3 only in this
case).
The script works fine without the {2,3}, and I may have to use it that way,
since another response mentioned foreign addresses, I hadn't
ve been testing this and
it allows as many letters as I put in there, but not 1 only.
What's wrong?
Also, when using eregi do I need to specify A-Za-z or just a-z, since it is
case-insensitive?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no
Thanks, that works great.
--
Chip
"Stuart McDonald" <[EMAIL PROTECTED]> wrote on 08/20/2002 05:55:40
PM:
> Are you setting the variables in the form?
> Something like this - note the value field in the username field:
>
>align="center" cellpadding=
d not have to re-enter
all the data. But how?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(They
> As well as the . before the third character set?
> -Steve
Got it fixed like this:
if (empty($useremail) || !eregi("^[A-Za-z0-9\.\_-]+@[A-Za-z0-9\_-]
+\.[A-Za-z0-9\_-]+$", $useremail))
--
Chip
> On Tuesday, August 20, 2002, at 11:11 AM, [EMAIL PROTECTED] wrote:
>
t do I need to do to fix this?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(They why
')";
if(!empty($date_am) && !empty($exercise_am) && !empty($reps_am)
mysql_query($sql_am) or die ("Error in this query >>$sql<< : "
.mysql_error());
Thanks to everyone for pointing me in the right direction.
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
,comments)
values ('$date_am','$exercise_am','$reps_am','$comments_am')";
if(!is_null($date_am))
mysql_query($sql_am) or die ("Error in this query >>$sql<< : "
.mysql_error());
And it still inserts the row no matter what, as lo
!isnull($exercise_am) && !isnull($reps_am))
>
> This should IMO work :)
>
> -Joni-
Here's the error that results from using that:
Fatal error: Call to undefined function: isnull() in
/usr/local/apache/htdocs/workout-abs.php on line 111
--
Chip
> --
> // Joni
>$sql<< : "
.mysql_error());
}
and this -
$sql_am = "insert into absmachine (today,exercise,reps,comments)
values ('$date_am','$exercise_am','$reps_am','$comments_am')";
if ($date_am || $exercise_am || $reps_am !
orkout-abs.php on line 111
I have 4 fields, 3 will always be filled, 1 is optional. I thought I
would try to test for any of the 3 being empty but it didn't work.
--
Chip
> On Sat, 2002-08-17 at 17:08, Chip Wiegand wrote:
> > I have a web page interface to a mysql database. In th
empty rows from being written to
the tables?
--
chip w
www.wiegand.org
[EMAIL PROTECTED]
(my web server died and the hard drive crashed hard, and is running from
an incomplete backup on another machine, what a drag) :-(
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
wsers cache
does not help.
Any ideas what's going on here?
http://www.simradusa.com/auth_dealers/dealers_page.php' );
}
?>
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
salamander <[EMAIL PROTECTED]> wrote on 08/09/2002 04:31:35 PM:
> Chip,
> I wonder if you set the ODBCINI environment variable with the putenv()?
Yep, they are there and I am getting this error when attempting to load the
web page -
Warning: SQL error: [iODBC][Driver Manager]Spec
ndler() in
/usr/local/apache/htdocs/odbctest.php
on line 10
I'm outa here, catch up with ya on monday,
--
Chip
salamander <[EMAIL PROTECTED]> wrote on 08/09/2002 04:10:00 PM:
> Chip,
> You are going to have to rebuild the dso with the options you specified
> before - tr
anged?
--
Chip W
Chip Atkinson <[EMAIL PROTECTED]> wrote on 08/09/2002 02:51:10 PM:
> It looks like you didn't build php with odbc support.
> Try putting in a call to
> phpinfo ();
> and see if it says that odbc support is compiled in.
> (Another) Chip
> On Fri, 9 Aug 20
It looks like you didn't build php with odbc support.
Try putting in a call to
phpinfo ();
and see if it says that odbc support is compiled in.
(Another) Chip
On Fri, 9 Aug 2002 [EMAIL PROTECTED] wrote:
> I am attempting for the first time, to connect from freebsd/mysql/php box
>
escription
\n";
}
echo "";
echo "";
?>
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipm
.1.53/workout-absflexor.php?exerciselist=%24listbox&exercise=80
&reps=12&comments=&submit=Send+Data
Notice that the $listbox variable is still not being sent. Just above
this is an echo statement which shows what's in that variable, and it
displays the expected result (see c
but it always responds that it cannot find the
table. The table does exist, the variable does contain the appropriate
table name, but is not being replaced by the name. What am I doing
wrong?
--
Chip W
www.wiegand.org
[EMAIL PROTECTED]
Below is the code for the first page --
";
ases order by 'month'";
elseif ($orderby == 'month_num2'):
$sql = "select * from releases order by 'month' desc";
The html select
Month:
None
Jan
Feb
etc
--
Chip Wiegand
Computer Services
Simrad
Greetings,
Has anyone gotten oracle 7.0 to work with the latest php? I'm having
trouble reliably getting anything back.
Thanks in advance,
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
e.
That works fine also. The table contains columns:
squats, squats_reps, legpress, legpress_reps, etc etc.
The first is the weight and the second is the number of reps. So after
each workout the appropriate numbers would be entered via the form page,
the graph would be generated with the update
art looking for, the 3 books I have either don't talk about this or I
just am missing it.
Could someone point me in the right direction?
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Sat, 2002-07-13 at 00:52, Jason Wong wrote:
> On Saturday 13 July 2002 14:49, Chip Wiegand wrote:
> > I just set up a pc with mysql-3.23.51/php-4.2.1/apache-1.3.26. I have
> > created a database and tables and a web interface to insert data into
> > it. I can insert data
roblem.
If anyone has a few minute to review my code below, hopefully someone
will find whatever it is I am missing. I have pasted in the html for the
web page, and below that a .csv copy/pasted of the database.
--
Thanks
Chip W
www.wiegand.org
[EMAIL PROTECTED]
Below is the web page -
connected to
I can't say for sure, but perhaps "desc" is a reserved word, short for
describe. What happens if you say something like "description"?
Chip
On Wed, 10 Jul 2002, Michael Zornek wrote:
> I was using phpMyAdmin to do an export from one machine to another an
ogram. The output is within the test program itself.
Thanks in advance for any help.
Chip
\n";
exit;
}
$cursor = Ora_Open ($connection);
if ($cursor == false){
echo Ora_ErrorCode($connection).":2 ".Ora_Error($connection)."\n";
exit;
Is there any application available that can take data from my mysql
database and draw graphs?
I am using mysql/php on FreeBSD.
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
column only) and blue2 (name column
only) like this-
title1 blue2
I am finding it difficult to write the proper select statement to get just
those items in
a web page using php/mysql.
Suggestions?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There
I am using
php/mysql.
If anyone has any idea what I am trying to do please attempt to help...
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simradusa.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and found
s accessing the
database.
Any suggestions?
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simrad.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home."
--Ken Olson, president, chairman and founder of Digital Equipment
Corporation, 1977
(They why d
nails
created by xv are in a format which is loosely derived from pbmplus image
formats.
So, I have found an app in the ports called jpgtn, it creates thumbnails from
a directory of jpg files, works quite well. I will use that to create the
thumbs, and all is well.
--
Chip
<+><+><
t
index.tk.txt
index.pickups.txt
Just enter those file names after the above url to view the source code.
(of course you all already know that).
--
Chip
<+><+><+><+><+><+><+><+>
Windows 95/NT - 32 bit extensions and a graphical shell for a 16 bit patc
On Friday 18 January 2002 08:09 pm, Steven Cayford banged out on the keys:
> Hello again.
>
> On 2002.01.18 18:48:36 -0600 chip wrote:
> > In my code I have the following line:
> >
> > printf("
> > \n", $row["name"], $row["name"]);
de below.
Any ideas what the cause might be?
--
Chip W
<+><+><+><+><+><+><+><+>
Windows 95/NT - 32 bit extensions and a graphical shell for a 16 bit patch
to an 8 bit operating system originally coded for
tch_array($result))
{
the rest of the code.
And it works great.
That takes care of the two questions I had to begin with. Thanks for the
help, I appreciate your kindness and patience, sometimes even the best books
and manuals fall a bit short of such common, si
something like that.
I tried this myself. Before setting that line, I changed the url as mentioned
and it resulted in a broken sql statement (not a valid result resource). Now
with that line added the current page reloads whatever it happened to be
displaying.
--
Chip
> In any case, thi
On Wednesday 16 January 2002 08:57 pm, Steven Cayford banged out on the keys:
> On 2002.01.16 19:59:37 -0600 chip wrote:
> > Let's tackle the first one first -
> OK.
> > On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the
> > keys:
> > > O
Let's tackle the first one first -
On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys:
> On 2002.01.15 23:30:25 -0600 chip wrote:
> > won't work)
> >
> > > $new_pic=$pic+12;
>
> Is $pic already set by the HTTP_GET_VARS here?
o "\n";
}
}
echo "\n\nHome \nNext\n\n\n";
?>
--
Chip W
www.wiegand.org
<+><+><+><+><+><+><+><+>
Windows 95/NT - 32 bit extensions and a graphical shell for a 16 bit patch
to an 8 bit operating system original
houldn't this fix the problem so now it
will
return the database list because the submit button is not pushed (on
returning
to the page)?
--
Chip
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 14, 2002 11:18 AM
> To:
ot;news_id"]."? "
.$row["bulletin_subject"]."\n\n";
}
?>
Back
--
Chip Wiegand
Computer Services
Simrad, Inc
www.simrad.com
[EMAIL PROTECTED]
"There is no reason anyone would want a computer in their home.&
d would be useful.
www.chami.com has HTML-Kit. A very good editor fully supporting PHP. Has many
plugins available also. I use it everyday at work on NT, and at home on
FreeBSD with a windows emulator.
Chip
--
<+><+><+><+><+><+><+><+>
Windows 95/NT - 32 bi
tinue from
there? I hope you know what I mean.
--
Chip
--
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 administrators, e-mail: [EMAIL PROTECTED]
83 matches
Mail list logo