Off subject but anyone know why php.net is down??
--
Chris Hall
sytems administrator
funnelbox mediaworks
[EMAIL PROTECTED]
--
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
sweet thnx man
:)
--
Chris Hall
sytems administrator
funnelbox mediaworks
[EMAIL PROTECTED]
""Chris Hall"" <[EMAIL PROTECTED]> wrote in message
9a1g2o$6mb$[EMAIL PROTECTED]">news:9a1g2o$6mb$[EMAIL PROTECTED]...
> Off subject but anyone know why php.net i
Hey guys, anyone built a plugin for macromedia dreamweaver 3 or 4, maybe
ultradev? what about firstpage 2000?? the ones at macromedia's site arent
that good IMHO, so if somone has built one and thinks it rocks send it to
me, i could use it. :)
thanks
--
Chris Hall
sytems administrator
funn
ke is an
educated guess. SQLite uses the filesystem for storage. If your queries
are needing to access the same file (maybe you're querying the same
table), SQLite is going to serialize those queries to help you avoid
threading problems. So, your queries are going to basically take turns.
Hope th
o
select their CSV file (No matter what size) and it will insert it automatically, and
as I said it does work on small files but not large :-(
Any help would really be appreciated.
Chris
27;yes';
} else {
$row = 1;
$handle = fopen ("$userfile","r");
while ($data = fgetcsv ($handle, 10, "|")) {
$num = count ($data);
$row++;
echo "$data[0];";
};
fclose ($handle);
}};
Chris
> I've never seen where the file size
e from a coding point of
view :-)
Again thank you everyone, I don't know what i'd do without you all.
Regards
Chris - Crazy, but slightly less so than this morning :-)
> You may have hit the browser time-out limit, which you can not control (at
> least for IE; don't kno
Hi there everyone,
I'm doing a search in my DB using LIKE '%$word%' which works great, but it's not case
sensitive, so if I search for bike it WON'T find BIKE, i'm using PHP and MySQL.
Probably something very obvious LOL it's just a basic select using LIKE.
Chris
MySQL Manual.
> Option 2 is to use UNIX_TIMESTAMP() in your query to retrieve the MySQL date
> formatted as a Unix timestamp. You can then pass this value to the PHP
> date() function and format it like you have above.
Or option 3: strtotime()
Chris
--
PHP Database Mailing List (http
x27;$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$date[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]')
");
};
echo $count;
fclose ($fp);
Thanks for any help
Regards
Chris
ch is $data[15]; if I remember correctly) it imports over 880
fields, but when that's in it only imports 92 - but I have no idea how to correct bad
characters they may have put in the file (I have no control over the characters they
use - sigh).
I really appreciate your help on this.
Rega
Hi there everyone,
Just a note to say i've fixed the CSV import problem, I had to excape the ' character
that was in the array and now it imports all 1081 rows properly.
Now I can relax and pass out LOL :-)
Thanks for all the help, very appreciated.
Chris
Hi there everyone,
Just a quick question which I can't for the life of me find the answer for on MySQL's
website (Probably as i'm looking for the wrong term?) I want to know how to empty a
table, is there an empty command or should I just tell it to delete everything?
Chris
not the sharpest knife in the draw :-)
Just thought i'd mention this, as it's helping me i'm sure it would help others too,
and this is what this group is for, helping everyone out :-)
Oh and no I DON'T work for them LOL, just found it useful.
Chris
$row++;
mysql_query ("INSERT INTO emaillist (EMail,name,date)
VALUES ('$data[0]','$data[1]','$date')
");
};
fclose ($handle);
$failed = "no";
};
return $failed;
};
Any help would be really appreciated, as i'm new to functions but enjoying it :-)
Chris
reciated, i'm trying to split email addresses from an input box
seperated by a ,
Thanks for any help.
Chris
that haven't come over from the previous
hour?
Thanks in advance
Chris
Y don't want to spend a few days
doing it manually.
Oh and Merry Christmas / Happy Holidays.
Chris
connecting tot he server, and with PHPMyADMIN I get the following
error:
cannot load MySQL extension
HELP I am so confused and I need my DB up as soon as possible :-(
Chris
the MySQL database, is this possible?
Any help would be really appreciated, as right now I have to collect all the failed
emails from the server, then go through them one at a time and remove them, not very
effecient :-(
BTW the server is Redhat.
Chris
as I need to get this mail system working with the DB by the
weekend, almost there but this bit has stumped me.
Thanks everyone, and Happy New Year.
Chris
You can always test if your SQL statement successfully completed or not to
determine errors. Using:
$myresult =mysql_query($queryX,$myconn);
if (! $myresult) {
echo mysql_error($myresult) ;
}
else {
// nothing or
echo "Query successful";
}
"Ryan Jameson" <[
>';
}
$str = "asdf asdf sadl jf lsakdjf a \r\n asdfierw aweiufasd asiuwr
\r\nasdhfauiweuhrahsd \r\n";
array_walk( explode( "\r\n", $str ), 'bulletElements' );
That should do the trick.
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> Thanks Chris... that worked great.
No worries.
> Guess I need to spend a _lot_ more time reading the manual.
It also helps alot just lurking on the list (this and/or PHP general).
I've been coding with PHP for almost 6 years and there're still new
things I learn all the time.
($fd);
Any help would be extremely appreciated.
Regards
Chris
confused how to do it.
I can do it if I specify the name of the form item coming in and going out, but since
I want to make it generic I don't want a zillion different possible form names in the
function :-)
Any help (If you can understand my rambling :-) would be greatly appreciated.
Regards
Chris
Hi there everyone,
I need to produce a system which uses databases but NOT on a webserver, I
heard something about a PHP distro that is being developed which acts like
an executable, does anyone know anything of this?
Any help would really be appreciated :-)
Chris Payne
00/XP that can
control and receive results from PHP.
If you have any tips I would be really appreciative :-) I just download
PHP-GTK.
Chris Payne
--
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, F
Try using $_SERVER["PHP_SELF"] instead of $PHP_SELF.
I believe $PHP_SELF is only set on servers with register variables turned
on.
ChrisPW
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 12:49 AM
Subject: [PHP-DB] PHP_SELF and par
Try using $_COOKIE['cookie_name']
- Original Message -
From: "Omelin Morelos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 12:55 AM
Subject: [PHP-DB] Cookies ?
> Friends
>
> Is there a way to read a cookie's with php , that were generated with
> javascr
l web server (on port 80) to refer to the
notes server, like in "http://my.notes.server:81/MyDatabase.nsf";
Hope this helps a little ...
Best regards,
Chris
On Wednesday 11 February 2004 09:51, [EMAIL PROTECTED] wrote:
> Sadly, no...
> I'm totaly new to Notes, and all I know is.
The mysql_escape_string() function escapes ' (single quote) and "
(double quote) characters. When php recieves information data through a
form, it automatically escapes these characters (tested with php 4.3.5).
Once mysql_escape_string() recieves it, ' and " have already been
escaped. In essence, i
Jason Wong wrote:
... and is in no way related to "metacharacters as defined by the w3c". If
you are having a particular problem please elaborate.
As pointed out by rain forest puppy
http://www.wiretrip.net/rfp/txt/phrack55.txt
All metacharacters as defined by the w3c should be escaped for
Jason Wong wrote:
But why do they say in the manual that only the backslash character, and the
string quote character needs to be escaped?
I've been able to inject sql queries into form fields that escape the
backslash character and quote characters.
http://www.securiteam.com/securityreview
> Is there any way to destroy the object in PHP?
http://us2.php.net/manual/en/function.unset.php
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
listens to and
gets the reply URL that is sent back to it with the new value (Which is
determined by the pid= value).
Thank you everyone.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.662 / Virus Database: 425 - Release
get much sleep last night so hard to
express what I mean.
Chris
Anyway first you have to translate your problem to us.
In plain english.
But I have spare time, so.. here is the solution for your problem, as I
understood it.
from php
http://myserver.com/index.asp?pid=";);
print_r($f);
?>
it failed OR a 24
character token (Value) but I seem to get a much larger value back than 24
so I'm doing something wrong. I'd tried doing it by checking the body,
which is where I get the token result but it's too large.
Oh well, back to the drawing board LOL Thanks anyway :-)
Ch
ead that out loud
to yourself. It should be clear that this statement is equivalent to:
if (true)
Hope that helps.
Chris
=
Chris Shiflett - http://shiflett.org/
PHP Security - O'Reilly
Coming Fall 2004
HTTP Developer's Handbook - Sams
http://httphandbook.org/
PHP
Go to PHP.net, books @ bookstore.
Seems like you are trying to insert data from an array into a MySQL table, I
would visit http://dev.mysql.com/doc/mysql/en/index.html site too.
Good luck.
===
"Ronald "The Newbie" Allen" <[EMAIL PROTECTED]> wrote in message
news:[EM
> Thanks Hans. I tried what your suggested and still no luck.
What does the actual HTML form look like?
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Quick work around: Dump the MySQL data into a comma delimited file and then
pick it up with MS Word Document Form to be merged. Then with the MS Task
Scheduler I would schedule to open the document to print automatically
and/or research with MS to email automatically.
CB.
===
"
An easy way to do it (work around) is to dump it as csv or html. If your
form can output an html table to the browser to show results then all you
need is to include a short instruction on the html form that has all results
in html table that would say something like "Save with your browser's 'sav
How about:
DELETE FROM users WHERE userid IN (SELECT u.userid FROM users AS u
LEFT JOIN roles AS r ON (u.roleid = r.roleid) WHERE r.roleid IS NULL
LIMIT 1);
On Mon, 14 Jun 2004 11:59:25 -0400, Brock Jimmy D Contr 74 MDSS/SGSI
<[EMAIL PROTECTED]> wrote:
>
> I've been able to figure how to use a d
not at my home/work computer ATM.
Chris
Hi there,
Just got back and tried it and it works perfectly, thank you so much for
your help, you've got me out of a bind here ;-)
Chris
You could loop through the weeks and put those 3 specifically in:
$days = array();
for($i = 0; $i < 365; $i +=7) {
$days[] = strtotime(
ts :-)
One thing he wanted which I didn't know how to do (Javascript I guess which
I don't know much about) was to preload a database of email address, and as
he started to type an email address it would do a sort of auto-complete, but
have no clue how to go about that so just told h
hat I need) but I don't want the page
to refresh everytime I select an option which it does if you just use PHP.
Any help would be EXTREMELY greatly received :-)
Regards
Chris
Hi there everyone,
I'm having a problem loading in a text file, each column is enclosed with a
" and separated by a , but when I try the below, it loads in the data BUT it
puts a " to the left of each character.
Any help would be really appreciated.
Thank you
Chris
SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near ') -
LENGTH(REPLACE(LOWER(),LOWER('as'),''))) /LENGTH('as'
Can anyone see what is wrong which is stopping it being compatible with
MySQL 4?
Any help would really be appreciated, as this system is very important.
Best Wishes
Chris
in my PHP search engine and
I need them to.
I know I have to edit ft_min_word_len to show 3 instead of 4, but what file
do I edit? (Sorry to sound dumb but I haven't reconfigured MySQL before).
Thanks everyone.
Chris
appreciated.
Thanks
Chris
sy to follow example?
Thanks, I really appreciate it.
Oh and so far, on the pages that I haven't had to use JOINS, I can honestly
say that MySQL is FAR faster than ACCESS from what I'm seeing in my
development here.
Chris
fooditems.CategoryNumber AND
fooditems.CategoryNumber = '$VendorID') WHERE
vendorprices.VendorNumber='$VendorID' AND
fooditems.CategoryNumber='$VendorID'";
Can anyone see where I'm going wrong? This is driving me nuts and I need to
figure it out urgently.
Thank you for your help.
Regards
Chris
me."\" <".$to_email.">\r\n";
$headers .= "Return-Path: <".$from_email.">\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$headers .= "Content-Transfer-Encoding: 8bit\r\n\r\n";
$headers .= $body_html."\r\n";
mail($to_email, $subject, '', $headers);
-
Regards
Chris
Hi there,
Thanks for the help, I've sorted it out now - stupid me :-) You know what
it's like sometimes, you work that hard on different things that something
which should be really simple just goes over your head - well, it does mine
anyway :-)
Very much appreciated.
Chris
rdernow,$vendor,$unitcost,$unitsell\015\012"
);
Thank you.
Chris
Hi there everyone,
I set an array using the following in PHP:
$ringb[$i]="$complex_area";
$i++;
It cycles through my DB and stores the info, my question is, how can I
convert it to a value that can be read in Javascript?
I'm stumped.
Chris
grab the info in the
first place? I've never had to write to 2 tables at once where data is
relative like this, infact it was my first time of using JOINS at all to
even display the data.
I'm using PHP with MySQL.
Thank you.
Chris
ed to import her old data
first.
Chris
find anything on the web concerning
this issue and I know there must be much higher traffic installations
that would have experienced this issue if it was widespread.
Any help would be greatly appreciated.
-Chris Back
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
Here's a piece of some code I wrote that does what you want. You'll need
to change the WhoIsMyParent() function to match your database
abstraction and schema.
$array = BreadCrumbs($id);
print_r($array);
exit;
function BreadCrumbs($parent) {
// construct an array of indexes that represents
interesting reading and requires a
slight restructuring of how the records are stored to pull off but with
the wonderful result in being much faster to retrieve.
Chris Gregors wrote:
> Here's a piece of some code I wrote that does what you want. You'll
need
> to change the WhoIsMyPare
The session information is bound to the users computer and the browser
they use.
option 1: user logs into app using a different computer (2 laptops)
option 2: user logs into app using a different browser (ie and firefox)
option 3: sessions have a lifetime of one screen (aka no session
persistance)
column easily when the numbers are auto-incremented so aren’t
necessarily one after the other?
I would really appreciate any help on this as it’s really bugging me.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783
a * and I don’t want that I need it to be the MAX() number as it isn’t an
auto-increment field.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004
dead simple, but can’t
remember the command.
Thank you.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 11/1/2004
and generate a new sessionid
without having to close the browser and go back again?
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.791 / Virus Database: 535 - Release Date: 11/8/2004
d I’ve looked online and can’t seem to find anything, so
thought I’d try here as usually you are all very helpful.
Thank you
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.795 / Virus Database: 539 - Release Date: 11/12/2004
Hi there everyone,
Just a quick question, I’m having to calculate some values from an existing
database, but on some of the results I get (For example)
0.5907
How can I limit the result to only 2 digits after the decimal point with
PHP?
Thanks
Chris
---
Outgoing mail
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004
.
Thanks everyone.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004
sing all rows?
is there a way to "create a table if it doesn't exist", or
"remove extra columns and add needed columns if it does exist."
* OR, is there a better way to do what i want to do, *altogether*???
thanks a lot!
--
Chris Wagner <[EMAIL PROTECTED]>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there everyone,
I’m having to send an email with looped results, but I’m having problems. I
can send an email no problem, and this code works OUTSIDE of the string, but
not inside, can anyone see what is going wrong?
’;
---
Outgoing mail is certified Virus Free.
Checked by AVG an
PLUS the table
data into a string? It has to be an HTML email and I'm stumped. I can send
an email no problem, but not with all the data, just the last row in the
data.
Chris
On Friday 17 December 2004 10:33, Chris Payne wrote:
> I’m having to send an email with looped results, but I’
?
Thank you.
Chris
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.816 / Virus Database: 554 - Release Date: 12/14/2004
present, but leave all other
AND statements in the string?
I would really appreciate any help on this. I can do a find and replace on
a string no problem, but just want it to be removed IF it is the FIRST word
in the string.
Oh and Happy New Year everyone.
Chris
--
No virus found in
solution that
works perfectly but I need this to work in order to do it.
I would appreciate any help on this, as it’s very important.
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.7 - Release Date: 12/30/2004
would appreciate any help on this, as it’s very important.
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.6.7 - Release Date: 12/30/2004
major security
concern?
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 1/16/2005
Personally, I would interpolate the $query and $user string like so:
$query = "SELECT credits FROM krypto WHERE user='".$user."' AND
pass='".$pass."'";
Always works for me...
rgd
chris r.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
from all 3 tables in
the same DB, what am I doing wrong? It works perfectly if I just use 1
table.
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005
Hi there,
Basically I just need to pull ALL the data from ALL the tables listed in the
same query. It doesn't matter in what order the data is displayed and there
is no relation between the tables.
Chris
What exactly are you trying to do? If you require data from each table and
that da
lost on this.
Any help would REALLY be appreciated.
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005
x27;t think multiple queries would work, hence why I'm trying to do it all
in a single query.
Chris
if you have kind of geo id number you could use that, failing to have that
info, you could re-arrange the data to have Akron - Central, Akron - SE (so
that all is in a standard format)
Bas
t it didn’t seem to work?
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.4 - Release Date: 2/1/2005
would be nice to have a
flexible DB structure rather than a static one.
Chris
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.4 - Release Date: 2/1/2005
estor too?
Thanks for your help everyone :-)
Chris
esize them by percentages?
Thanks for your help
Chris
www.planetoxygene.com
Hi there everyone,
I need to generate a random number between 1 and 15 for insertion into a DB, I can
easily do the DB side of it but what is the best method for quickly generating a
random number between 1 and 15 (including 1 and 15 in the equation)?
Thanks for all your help.
Regards
Chris
Hi there,
That is absolutely PERFECT, thank you so much for that you are a lifesaver
:-)
Regards
Chris Payne
www.planetoxygene.com
> On sön, 03 feb 2002, Chris Payne wrote:
>
> > Hi there everyone,
> >
> > I need to generate a random number between 1 and 15 for in
> You can use mysql_result_rows() to check whether any rows were returned;
> something like:
you mean:
mysql_num_rows();
?
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> how would I write it if I wanted to say this:
> if $variable == 2 through 4 ???
if(( $variable >= 2 ) && ( $variable <= 4 )) {
echo "Equals 2 through 4\n";
}
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
with Munich Hotels to appear first
before the rest, any ideas?
Thanks everyone.
Chris Payne
http://www.planetoxygene.com
lly need to know how to do a 0 or 1 I guess once the row has
been deleted or if the specified email address wasn't found.
Thanks for your help everyone.
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
'$country' AND type =
'$type') ORDER BY city ASC LIMIT $offset, $item_perpage";
and this brings up 1000 results, how can I then do another search based on THESE
search results only? That is, it only searches the results it currently has and
doesn't search the DB for other entries at the same time?
Thanks for your help
Chris
methods of doing
things so I would really appreciate your input :-)
Thanks for everything.
Chris
> You could select these results into a temporary table
> and then query that table. Look at the mysql.com docs
> and check out the CREATE TEMPORARY TABLE. You can
> select data right
save the unique results and so don't have to sort once i've
created the new table?
Thanks for your help everyone,
Chris
(For the first pulldown):
Make a Selection
the past
(And will probably ask in the future :-)
Chris
doesn't update, any ideas how I can fix this?
Thanks everyone.
Chris
701 - 800 of 1258 matches
Mail list logo