RE: [PHP-DB] password input type
the onlooker From: matthew perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] password input type Date: Mon, 05 Apr 2004 13:14:17 -0500 Does using a pasword input type input name=password type=password make the transfer more secure from someone sniffing my connection or does it only shield an onlooker from seeing what the user enters? - Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSN Toolbar provides one-click access to Hotmail from any Web page FREE download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PDFLib
http://www.fpdf.org I swear by it as well. Neil Morgan -Original Message- From: Peter Beckman [mailto:[EMAIL PROTECTED] Sent: 06 April 2004 03:39 To: PHP-DB Mailing List Subject: Re: [PHP-DB] PDFLib I LOVE FPDF. I don't know where I found it, but I can insert images, it wraps text -- it's pretty fantastic. Get it. Beckman On Mon, 5 Apr 2004, Nathan Mealey wrote: Has anyone had any experience extracting text from a fulltext field/column in a MySQL DB and, using the PDFLib library, converting it to a PDF on-the-fly? I can create the PDF, but it is taking all of the text (about 6300 characters) and putting it on just one line - which goes off of the viewable page (as you can imagine). If anyone has any ideas or experience with this, that'd be super. -- Nathan Mealey Director of Operations Cycle-Smart, Inc. P.O. Box 1482 Northampton, MA 01061-1482 [EMAIL PROTECTED] (413) 587-3133 (413) 210-7984 Mobile (512) 681-7043 Fax -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Peter Beckman Internet Guy [EMAIL PROTECTED] http://www.purplecow.com/ --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] HELP: mySQL table name
I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table test_table. How can I do it? Thanks Adrian D. [EMAIL PROTECTED]
Re: [PHP-DB] HELP: mySQL table name
From: Adrian Donoiu [EMAIL PROTECTED] I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table test_table. How can I do it? You can't. If you alias the table as t, then that's the table name. Either don't use an alias or write a function that'll parse the query to retrieve the table name. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Graphing - bar charts
Hi there: I am looking for an open source and simple PHP script that will graph (bar) a few MySQL fields. Does anyone have any recommendations? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Graphing - bar charts
Hi there: Hello, I am looking for an open source and simple PHP script that will graph (bar) a few MySQL fields. Does anyone have any recommendations? I'd suggest the jpgraph OO lib. Very easy to get simple graphs up and running. so long as you have gd/jpeg available to your php. With some, not alot, more work you can start utilizing many of its features for more complex graphs. HTH jeff __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Graphing - bar charts
From: Craig Hoffman [EMAIL PROTECTED] I am looking for an open source and simple PHP script that will graph (bar) a few MySQL fields. Does anyone have any recommendations? The easiest way is to just have an image that you dynamically vary with width of img src=dot.jpg height=10 width=$width Or take a look at JPGraph, which offers a lot of features. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Graphing - bar charts
jpgraph is great http://www.aditus.nu/jpgraph/ open source, very reasonably priced Ignatius _ - Original Message - From: Craig Hoffman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 4:55 PM Subject: [PHP-DB] Graphing - bar charts Hi there: I am looking for an open source and simple PHP script that will graph (bar) a few MySQL fields. Does anyone have any recommendations? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] help desk software
Anybody out there familiar with some helpdesk software? I found some called teacup that runs as a cgi and used Postgres but I wanted to see if I could find something that was PHP/MySQL based. Any ideas out there? thanks, DF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] help desk software
Go to http://hotscripts.com -Original Message- From: redhat [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:21 PM To: phplist; fedoralist Subject: [PHP-DB] help desk software Anybody out there familiar with some helpdesk software? I found some called teacup that runs as a cgi and used Postgres but I wanted to see if I could find something that was PHP/MySQL based. Any ideas out there? thanks, DF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How to troubleshoot MySQL Error 1040: Too many processes
I need a little direction for troubleshooting a problem I'm having with PHP and MySQL. Twice recently my little homebrew PHP/MySQL content management system has essentially crashed when MySQL starts returning a 1040 error: Too many connections. Restarting MySQL fixes things ... for a little while at least. Currently I am trying to manage the situation by monitoring the process count and restarting mysqld whenever the count gets high, but I need to get a better handle on what is going on. I'm running Apache 1.3.27, PHP 4.1.2, and MySQL 3.23.41. Most of my connections are made with PHP's mysql_pconnect. My understanding is that each Apache/PHP process will reuse a connection made with mysql_pconnect. If so -- and assuming one db connection per http response -- I would expect there to be a correspondance between the number of Apache processes and mysqld processes. This isn't the case. One day after restarting MySQL and httpd, Apache has 21 processes running and mysqld has 62 processes. Is this an indication of a problem or am I barking up the wrong tree? Any other suggestions for troubleshooting? Thanks in advance, --John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Graphing - bar charts
Bar graphs are very easy to use with PHP. It's just a table columns of
varying height.
I wrote this a long time ago. To be honest it isn't very good code and
I think I got the ideas from someone else.
Regardless it should give you an idea.
You basically pass in an array of dollar amounts and it outputs a bar graph.
You can also manually adjust the scale of the graph by varying the
values $minval and $maxval.
The function bar makes a single bar of the graph.
Use it at your own risk though. It is pretty poor PHP but it did the
trick for me!
//graph looks best when values are between 50 and 250
function bargraph ($bararray, $xminval, $xmaxval){
function bar($height,$val, $minval, $maxval){
$n_bars=count($bararray);
$newmargin = $maxval - $minval;
$newdifference = $height - $minval;
$newchange = $newdifference / $newmargin;
$newheight = 200 * $newchange + 25;
echo (td valign=bottom .
table bgcolor=#aa height= . $newheight .
cellpadding=0 cellspacing=0);
echo(trtd align=center valign=bottom);
echo (font color=#0 size=-1 );
echo ($);
printf(%.2f, $val);
echo (/font);
echo (/td/tr/table/td);
}
$n_bars=count($bararray);
$border=0;
echo(table bgcolor=#a0a0a0 height=200 width= .
$n_bars*$width . border= . $border . );
if (!$xminval) $minval= min ($bararray);
else $minval = $xminval;
if (!$xmaxval)$maxval= max ($bararray);
else $maxval = $xmaxval;
for ($x = 0; $xcount($bararray); $x++){
bar($bararray[$x], $bararray[$x], $minval, $maxval);
}
echo(/table);
}
--
- Matt
John W. Holmes wrote:
From: Craig Hoffman [EMAIL PROTECTED]
I am looking for an open source and simple PHP script that will graph
(bar) a few MySQL fields. Does anyone have any recommendations?
The easiest way is to just have an image that you dynamically vary with
width of
img src=dot.jpg height=10 width=$width
Or take a look at JPGraph, which offers a lot of features.
---John Holmes...
Re: [PHP-DB] How to troubleshoot MySQL Error 1040: Too many processes
From: John Hicks [EMAIL PROTECTED] Twice recently my little homebrew PHP/MySQL content management system has essentially crashed when MySQL starts returning a 1040 error: Too many connections. Restarting MySQL fixes things ... for a little while at least. [snip] Most of my connections are made with PHP's mysql_pconnect. I wouldn't use mysql_pconnect for this vary reason. Read through some of the user comments on the manual page and it's explained in detail. Try with mysql_connect(), first. You can raise the number of connections (default is 100) using a my.cnf file (explained in MySQL manual), but if you're not getting the actual traffic to produce 100 simultaneous users, then that's not the issue. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] include function
Someone tell me why this isn't working? I keep getting a parser error on line 36 (the last include). I'm running PHP 4.3.5 if that helps. include (include/dbadmin.php); include (jpgraph/src/jpgraph.php); include (jpgraph/src/jpgraph_bar.php); Parse error: parse error, unexpected T_INCLUDE in /Users/choffman/Sites/www/cyclistsedge/top_performace.php on line 36 __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] include function
did you make sure the previous line had a ; at the end? Check that first. - Original message - From: Craig Hoffman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Tue, 6 Apr 2004 22:24:27 -0500 Subject: [PHP-DB] include function Someone tell me why this isn't working? I keep getting a parser error on line 36 (the last include). I'm running PHP 4.3.5 if that helps. include (include/dbadmin.php); include (jpgraph/src/jpgraph.php); include (jpgraph/src/jpgraph_bar.php); Parse error: parse error, unexpected T_INCLUDE in /Users/choffman/Sites/www/cyclistsedge/top_performace.php on line 36 __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Marcjon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
