Re: [PHP] upload file size limit
On Mon, 31 Jan 2005 03:15:00 -0800, Badlya Badlu wrote: the path is /etc/php.ini also upload_max_filesize 50M 50M Waiting for reply. it also depends on your webserver. I guess you are running apache2? thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: HTML Frames and PHP Sessions
On Tue, 21 Sep 2004 04:02:47 -0400, Nick Patsaros wrote: Are PHP sessions compatible with frames in HTML? I'm trying to pass a user name through a session and my individual frames aren't receiving the variable. It worked prior to migrating to frames so I don't think it's my PHP that is the problem. Is there a target function somehow or some way to pass it down from the _top frame to an individual frame or frames? Any help is appreciated and I offer thanks in advance. probably you are loading the other frames *before* the given frame sets the username. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: problems with different results on count() and select
On Thu, 16 Sep 2004 10:43:46 +0200, Merlin wrote: Theoreticly the result number of the first select statement should be identical with the count statement, but it is not. Has anybody an idea how to fix that? It can't be the same number as you are using a where clause in the second statement so you are missing some rows there. also your code for ordering in the first part might just be wrong, but you didn't show this code. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: php does not get variable values in POST method
On Thu, 02 Sep 2004 09:03:34 -0700, Leticia Campos wrote: I developed an html/php form in a Php version 4.0.6, working fine, but when a moved the files to another web server with Php 4.3.2 the file procesaadmision.php called in the Post method does not get any of the input html variables defined in the calling form. form ACTION=procesaadmision.php METHOD=POST you probably have register globals disabled there: http://de3.php.net/manual/en/ini.sect.data-handling.php#ini.register-globals thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: oop too slow
On Thu, 19 Aug 2004 11:21:16 +0200, Krzysztof Gorzelak wrote: Each object gets data from mysql by itself. The generation time of 1 category [30 products, 10 keys, 5 values ~= 300 mysql queries] takes as I said more than a 1s (on quite fast machine). How can this model be improved? Why are you doing 300(!!!) mysql queries? I guess you can retrieve the same data with much less queries. 300 queries are slow ... not OOP. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: building php to have mysqli support...
On Sat, 17 Jul 2004 13:11:41 -0700, Bruce wrote: has anybody managed to get php to work so you can actually use both mysql/mysqli??? pointers/criticisms/assistance is greatly appreciated! searching through google/php.net/etc.. hasn't turned up information on where i've gone wrong. thanks.. -bruce the docs say its for mysql-4.1.x and higher (you probably have mysql-4.0.x) http://de.php.net/mysqli also I think its php5 only. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: unset empty elements in an array
On Mon, 12 Jul 2004 15:33:53 +1000, Justin French wrote:
Hi,
Looking for a one-liner to delete all empty elements in an array. I
know I can do it with a foreach loop, but I'm hoping that I've missed
an existing function in the manual which may already do this, or a
simple one-liner to replace the foreach.
?php
foreach($in as $k = $v) {
if(empty($v)) {
unset($in[$k]);
}
}
?
Sure, a one-liner:
foreach ($in as $k = $v ) { if(empty($v)) unset($in[$k]); }
;).
Really what do you need an internal function for something simple like
that?
thomas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: installing 4.3.x and 5.x
On Sun, 11 Jul 2004 23:17:04 -0400, Alex Duggan wrote: Hello, Is it possible to build php-4.3.x and php-5.0.0RC3 both as static modules into apache-1.3? If so, can the two version of php be installed in the same prefix? or should they be installed in /usr/local/php4 and /usr/local/php5? AFAIK it can only be done with one of these as module, the other as CGI. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP Include not Working Correctly
Harlequin wrote: ?php include Header.inc; ? Brings in the correct file but not an images referenced in the CSS file, just the background and formatting. Has anyone come across this before...? Huh? The include-statement just includes code/html, it doesn't correct any links or such. probably the link in your css-file is wrong from the place where you include. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql_escape_string vs. mysqli_escape_string....
Scott Fletcher wrote: What the hell??? When I enter the mysql_escape_string in the search for textbox at www.php.net, I get a mysqli_escape_string result. So, the question here is, is the website mistaken or is someone made a typo when posting to this php newsgroup??? Scott F. I get mysql_escape_string if I search for it. These are two different mysql-modules so use the one for the module you use (probably just mysql_escape_string). thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySql Close problem
you should tell WHAT problem you have.
does it throw an error?
doesn't it work as expected ... ?
whats the matter?
thomas
On Sun, 20 Jun 2004 13:47:03 -0700 [EMAIL PROTECTED] (Erik Gjertsen) wrote:
I have problem with mysql_close
I dont understand why.
Are ther someone that have any proposal?
Thank for any help
Erik Gjertsen
Here is the code
$query = SELECT usrid FROM users WHERE username;
$result = @mysql_query ($query); //Run the query
if (mysql_num_rows($result) == 0) { // Make the query
$query = INSERT INTO users (username, name, email, password, registration_date)
VALUES
('$username', '$name', '$email', '$password', NOW() );
$result = @mysql_query ($query);
if ($result) { // IF it ran OK
// Send an email, if desired
echo 'pbYou have been registered!/b/P';
include(./footer.inc);
exit();
} else { // If it did not ron OK.
$message = 'pYou cout not be registered due to a system error. We apologize
for any inconvenience/p';
}
} else {
$message = 'pThat username is alredy taken./p';
}
mysql_close();
} else {
$message = 'pPlease try again./p';
}
} // End of the main submit conditional.
// Print the error message if ther is one
if (isset($message)) {
echo 'font color=red', $message, '/font';
)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: jdmonthname Function problem
On Tue, 15 Jun 2004 21:32:32 +1000 [EMAIL PROTECTED] (Alan McDonald) wrote: Fatal error: Call to undefined function: jdmonthname() in hmmm what have I done with my build that I have left something like this out? Anyone have a cloe as to what option should have been set to get this function working? It works fine on my 4.3.4 on Windows but 4.3.7 in Linux throws this complaint at me Alan http://de.php.net/manual/en/ref.calendar.php --- Installation To get these functions to work, you have to compile PHP with --enable-calendar. The windows version of PHP has built in support for this extension. You do not need to load any additional extension in order to use these functions. --- thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [OT?] Apache/PHP error/warning(s)
Php Lists wrote: Hi list I can understand the difference between 'world writable' and 'writable by the webserver' in concept, but how would I go about manipulating these variables? Specifically, theses are error reports generated when setting up eGroupware (sourceforge.net) Thanks in advance. Stuart 'man chmod' should help you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] generating graphs
On Sat, 5 Jun 2004 19:31:34 +0530 [EMAIL PROTECTED] (Nitin) wrote: thanks for the help, but my PHP ver is 4.0.6... Any other suggestions?? hmm, upgrade? :) really, its worth it! thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: shedule a php script
I would recommend the cronjob too but if you want to just keep the script running, do
a while-loop around your code, i.e.
while(1) {
... your code
sleep(120); // sleep 120 seconds
}
---
the require should be outside of the loop IMHO ;).
thomas
On Sat, 5 Jun 2004 21:46:20 +0600 [EMAIL PROTECTED] (Curlybraces Technologies \ Ltd)
wrote:
hi friends ,
when running this php script we can make a log file with relavent to the mysql data
base. but i need to execute this script after every 2 min time. that is mean there
must be a 2 min sleep time . can somebody help me do this function plz .?
?php
require ('connectMySql.php');
$select= select ServiceNo, ServiceName, Status, DateTime from ServiceStatus ;
$add_member = $db_object-query($select);
$result=mysql_query($select);
while($row=mysql_fetch_array ($result))
{
$output1 =$row['ServiceNo'];
$output2 =$row['ServiceName'];
$output3 =$row['Status'];
$output4 =$row['DateTime'];
$your_data .= $output1.\t $output2 - $output3 - $output4 \n;
$output = $your_data \n;
}
// Open the file and erase the contents if any
$fp = fopen(vas_status.log, a);
// Write the data to the file
fwrite($fp, $output);
// Close the file
fclose($fp);
if (DB::isError($add_member)) {
die($add_member-getMessage());
}
$db_object-disconnect();
?
thanx in advance
curlys
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: multiple checkbox help
On Mon, 31 May 2004 10:50:52 -0400 [EMAIL PROTECTED] (Bob Lockie) wrote:
I tried this HTML:
input name=deleteID value=1 type=checkbox
input name=deleteID value=2 type=checkbox
$_REQUEST['deleteID'] === the last box checked.
so I did a google search and changed my HTML to:
input name=deleteID[] value=1 type=checkbox
input name=deleteID[] value=2 type=checkbox
Now the code:
for ($i = 0; $i count($_REQUEST['deleteID']); $i++){
echo deleting ' . $value . ';
}
has the right count but how do I get the values out?
echo deleting ' . $_REQUEST['deleteID'][$i] . ';
regards,
thomas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] cookies malfunctioning moving from windows to linux
Ryan Schefke wrote: I don't think that is it. I believe session.save_path is only for sessions, not cookies. I'm only using cookies in the application. Can someone please help? Thanks, Ryan Yeah, tell HOW you set the cookies. There is really no difference in linux/windows-php in this cases. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Windows to Linux -- Issues with mkdir()function and picture uploading
Ryan Schefke wrote: The above behavior is on the Linux machine. Now, I run the same script on my windows box and it works perfectly. windows has (afaik in its default settings) no good file-permissions. the php-scripts usually run as the user the webserver runs as ... so the webserver-user has to have write-permissions on the directory it needs to write to. so either chown (change the owner) or chmod (change the permissions to be writable for the group or even other if needed) the directory. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Windows to Linux -- Getting errors still...
This is line 29: imagejpeg($base_image, 'temp.jpg'); //convert and save it to temp.jpg Hi, you should give it a path, i.e. ./temp.jpg or a full absolute path. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Session variables not recognized?
On Tue, 25 May 2004 08:36:37 -0700 [EMAIL PROTECTED] (Brian Dunning) wrote: The first line of my file is session_start(); but whenever I try to set or reference $_SESSION['anything'] I get: Undefined variable: _SESSION What's up with that??? what php-version do you use? thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: php accelerator for php5rc1 ?
Hi David, I'm not quite sure if its worth the trouble to officially support a php-version which is not yet stable. I remember that, at least, turck-mmcache has unofficial support for php5. thomas David Herring ([EMAIL PROTECTED]) schrieb: Hi Thomas, Thanks for the correction. My current undertanding is that zend-acelerator, phpa, turck-mmache and apc do not support PHP5.0rc1 ? Is there any accelerator that does ? Thx dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: php accelerator for php5rc1 ?
On Sat, 17 Apr 2004 19:01:21 +0100 [EMAIL PROTECTED] (David Herring) wrote: The latest Zend optimiser - 3.60 does not support php 5 - is there any alternative accelerators which do ? uhm, afaik the optimiser is not an accelerator, more kind of a loader for encrypted files. You would have to use the zend-accelerator, phpa, turck-mmcache, apc or similar products. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP 4.3.5 Released
Hi folks, thanks for another great php-release. Are there any important changes since the last RC? TIA, thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Generating Numbers from Strings
On Sat, 1 Nov 2003 00:37:32 - [EMAIL PROTECTED] (John Ryan) wrote: I've a bit of a problem, I want a random keyword pulled from my database. But I dont want it random all the time. I just want it random to each page. So I have the filename variable of the page. How do I somehow generate a 'constant' random number from this string that is constant to each file??? TIA md5(__FILE__) ? Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: (ANNOUNCE) codeSECURE 1.0 released - - Protecting PHP code
I think he just answered the other guy's question with your answer to another one ;-). btw. http://www.securecents.com/secureCode_features.php only returns a 404. thomas On Wed, 22 Oct 2003 23:20:13 +0200 [EMAIL PROTECTED] (John Black) wrote: Hi Jason, Did I say something wrong? A bit puzzled as you just copied what I wrote to the other guy and reposted Cheers, -JB On Wednesday 22 October 2003 21:38, Bas wrote: Is it free? For details, check us out at http://www.secureCents.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* The fundamental principle of science, the definition almost, is this: the sole test of the validity of any idea is experiment. -- Richard P. Feynman */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] (native) linux-php-editor with some advanced features?
Hey folks, I know this topic comes up again and again but I couldn't find any usefull php-editor for linux which is NOT written in java AND has some advanced features like a file navigation (listing all functions in a file with direct jump to them) or tooltips with the function definition or similar. I liked the features of the Zend IDE but its just to aching slow on linux (don't know why, but its much faster on windows), while other native editors are not made for php or just contain its syntax-highlightning without any further special features. Did I miss one of the available editors which provides these features? Thanks, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: javascript php
On Mon, 28 Jul 2003 12:48:04 +0200 [EMAIL PROTECTED] (Roman Duriancik) wrote: I have problem with variables in javascript and php. I have code in php and in this code I insert some values from javascript.: $color = script!-- document.write(screen.colorDepth) //-- /script; when I write command echo $color - result is correct. but when i need insert or select some values from database with this value ($color) result is not correct You are doing it just wrong. The PHP-code is executed and returns the html-page (with the JS-code if you use the print/echo command) to the user Afterwards the JavaScript-Code is executed ON THE CLIENT and shows the color in the page. So the color never reaches the php-script. Get a good book on how JavaScript works at all. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: convert mysql datetime to unix timestamp
SELECT UNIX_TIMESTAMP(datetime-field) ... thomas On Mon, 28 Jul 2003 18:06:32 +0200 [EMAIL PROTECTED] (Chris Hayes) wrote: hi, i have to move data from a table with a datetime (2003-05-14 13:36:04) to a unix timestamp (e.g. 2147483647) . Any ideas? Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Recompiling the PHP Binary with PCNTL
On Sun, 27 Jul 2003 20:13:22 +0100 [EMAIL PROTECTED] (David Goodchild) wrote: My exact problem is this: I do not know how to recompile an already installed PHP binary with the option --with-pcntl ... You can't recompile a binary, you compile a new version with the compile-options of your old binary. thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PECL v. PEAR
On Wed, 23 Jul 2003 14:22:40 + [EMAIL PROTECTED] (Curt Zirzow) wrote: * Thus wrote Chris Boget ([EMAIL PROTECTED]): Could someone point me to a good website that discuss the above? I can't find reference to PECL on either the PHP or Zend site and PHPBuilder isn't pulling much up, either. I don't want to clutter the list up with something that would seem to have been addressed before (possibly many times) so if someone can just point me in the right direction? whats PECL? its funny though I do a google search on PECL and PEAR comes up... i'm assuming PECL is some library type thing like PEAR. The PEAR mailing list might be able to give you some documentation (biased as it may be) PECL is a part of PEAR, or at least they are stringed together. as far as I understand, PECL is the thing for C/C++-extensions to PHP, PEAR are extensions/classes written in PHP. Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: script not stopping
try that
if (!isset($_POST[imgList]) || empty($_POST[imgList])){
for the comparison.
Thomas
On Mon, 7 Jul 2003 16:02:21 -0600 [EMAIL PROTECTED] (Micah Montoy) wrote:
How do I specify it that I just want to check to see if the form field was
blank and if so, inform the user? I know I could do this with JavaScript
but I need to be able to do correct conditions.
thanks
Paul Chvostek [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, Jul 07, 2003 at 03:28:27PM -0600, Micah Montoy wrote:
if ($_POST[imgList] = ){
You're *assigning* a variable in this condition.
--
Paul Chvostek [EMAIL PROTECTED]
it.canadahttp://www.it.ca/
Free PHP web hosting!http://www.it.ca/web/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP/Content Management
Safari is the new Mac-Browser by Apple. Its using the KHTML-component from Konqueror (Linux). Thomas On Mon, 07 Jul 2003 18:06:29 -0400 [EMAIL PROTECTED] (Robert Samuel White) wrote: Hello, I was just alerted of the issue by another fellow with a way excellent website at saturn5.com :-) I wish I could help you! But I have never heard of the Safari browser and without using it or getting more information about what is causing your problem, I cannot do anything! It is known to work with IE 4-6+ on Windows, most Netscapes, Mozilla, Lynx, etc.., but may have some problems with the Mac and now the Safari browser... Is it possible the problem could be Safari does not recognize the Header () command in PHP??? Thanks! = Do you realize that link does not work with the Safari browser? it just shows up blank :( Rick When one door closes, another opens; but we often look so long and so regretfully upon the closed door that we do not see the one which has opened for us. - Alexander Graham Bell From: Robert Samuel White [EMAIL PROTECTED] Reply-To: Robert Samuel White [EMAIL PROTECTED] Date: Mon, 07 Jul 2003 16:54:11 -0400 To: [EMAIL PROTECTED] Subject: [PHP] PHP/Content Management Just a quick message to let everyone know that after ten months I have finally released the first official open source version of eNetwizard Matrix Server, my sophisticated content management system and application server. All it needs is PHP, MySQL, and Apache. Full instructions are included on the website. More information about it is below... http://matrix.enetwizard.net/default.rsw About eNetwizard Matrix Server eNetwizard Matrix Server takes content management and web application serving to levels undreamt, infusing your web environment with sheer power and possibility. Cutting Edge Technology - Never before has a content management system been designed around the concept of a universal point of contact for all requests. This server knows all, and delivers all. - Never before has a content management system been designed to render and manage the content of an unlimited number of domains and websites for an unlimited number of businesses and organizations. Expect nothing less from our server. Core Features - Production Environment Ready. The server before you has had no corners cut in its design. It is stable and ready for production environments, with only a few minor limitations or idiocyncracies. And it's free and open source. - Infinitely Expansive Design. The server was designed to manage an infinite number of domains, websites, components, organizations, groups, and users, all from a single running copy of its distribution. - Complete Content Management. The server manages the content of all mime types and can deliver the content to the requesting client based on customizable settings of the server for each mime type. - Seemless Integration with Other Server Software. The server was designed to complement the job of the web server and server side scripting languages, and does not replace nor interfere with their purposes. In fact, you can utilize all of them from within the system in a myriad of useful ways. - Language Independent. The server, objects, and wizards were all designed to contain its strings in an XML localization file, allowing it to run in any language it has been translated into. In a near future release, it will also be possible to render content into the language appropriate for the visitor. - Cascading Templates. Web page design and layout are controlled by templates, allowing for quick and cost-effective website redesigns. Templates can be modified in real time, changing the layout, colors, and other style properties instantaneously. Templates are cascading through the matrix folder, meaning templates can be defined for a single page or an entire domain or website. - Workflow Ready. This version of the server includes everything needed to manage an infinite number of organizations, groups, and users, all with unique roles, policy permissions, and access rights throughout the matrix. It lacks only a few things when it comes to workflow, and these added features will be included in a near future release. - Inclusive Session Management. The server does not rely upon cookies at all to manage the individual sessions of each user accessing the server. Instead, it automatically and uniquely propagates this information into each request and embeds the information into every link managed by the server. - Search Engine Aware. The server automatically disables sessions for known search engines, preventing them from including session information in their indexes. This is also useful if you wish to create a page for the search engine that does not
[PHP] Re: Failed to Receive in E:\...\mailscript.php on line 25
are you sure that the smtp-settings in php.ini are correct on your host's server?
Thomas
On Sat, 5 Jul 2003 20:15:14 +0200 [EMAIL PROTECTED] (Håkon strandenes) wrote:
Hi,
I am making a small PHP script for managing a simple mailing list. The
PHP script is added in the bottom of this message.
This PHP script works great on IIS 5.1 with PHP 4.3.0, witch I have
installed locally on my system to test my scripts. But when I transfer
the script over to my host server (With IIS and PHP 4.2.1), I get an
error message when I'm trying to use it. The error message is like this:
Warning: Failed to Receive in
E:\inetpub\wwwroot\grimstad.seilforening\Mailinglister\mailscript.php on
line 25 Kommandoen er nå sendt. Merk at det kan ta opp til 5 minutter
før den trer i kraft.PHP Warning: Failed to Receive in
E:\inetpub\wwwroot\grimstad.seilforening\Mailinglister\mailscript.php on
line 25
Is there any compatibility problems between 4.2.1 and 4.3.0 for the
codes I have used in my script?
Regards,
Håkon Strandenes
Here is the script (It get its inputs from this form:
http://grimstad.seilforening.no/Mailinglister/Styreskjema.html):
?php
@extract($_POST);
$Liste = stripslashes($Liste);
$Navn = stripslashes($Navn);
$Email = stripslashes($Email);
$Kommando = stripslashes($Kommando);
if (!$Email)
{
echo (Du må fylle inn din e-mail adresse.);
}
else
{
if (!$Navn)
{
echo (Du må fylle inn navnet ditt.);
}
else
{
$Message = Automatisk generert styringsmail;
$Headers = From: $Navn $Email;
mail( $Liste, $Kommando, $Message, $Headers );
echo (Kommandoen er nå sendt. Merk at det kan ta opp til 5 minutter før
den trer i kraft.);
}
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Passing Variables
If you don't want them seen anywhere, then you've got to use sessions. Thomas On Sat, 21 Jun 2003 08:53:12 -0500 [EMAIL PROTECTED] (Jay Fitzgerald) wrote: I have been searching for an answer to this for a couple of hours now and cant find anything. I believe that there is a secure way of doing this but I think my brain is having a momentary lapse... I have these variables: $eventid = 1; $age = 15; Is there a way to pass these variables to the next page so I can continue using them without doing something like this: A HREF=test.php?eventid=1age=15 I would rather not have the variables be seen or known to the end user for security reasons because they could change them in the URL. I know it has something to do with $_GET and $_POST because I do have register_globals set to OFF in my php file and I do not want to turn them on TIA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: correct session format?
yeah its the right way. though I don't know what you'r trying to do with echo P $_SESSION; Thomas On Sat, 21 Jun 2003 09:22:39 -0500 [EMAIL PROTECTED] (Jay Fitzgerald) wrote: is this the correct way to register variables via a session? [code] session_start (); $_SESSION['eventid'] = 'arma2'; print_r ($_SESSION); echo P $_SESSION; [/code] [result] Array ( [eventid] = arma2 ) Array [/result] I apologize for the numerous questions, but I am trying to learn...If anyone would like to help off-list, my ICQ is 38823829 Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Passing Variables
you can transfer the session-id (which is unique) through the url too. but then its only the session-id and not the actual data and the session-id can't be guessed that simple to reach another user's data. Thomas On Sat, 21 Jun 2003 15:31:56 +0100 [EMAIL PROTECTED] (George Pitcher) wrote: Jay, I've never ventured into 'sessions' (not ones without drinks) but I've a feeling that if the user has turned cookies off then sessions are out as well as they require a cookie being stored on the user's machine. Someone will surely correct me if I am wrong. I went to the PHP conference in Frankfurt about 18 months ago and Rasmus was talking about 'clean' URLs (ithout the 'query' string. I never did find out how though? Cheers George -Original Message- From: Jay Fitzgerald [mailto:[EMAIL PROTECTED] Sent: 21 June 2003 3:19 pm To: George Pitcher; nabil; [EMAIL PROTECTED] Subject: RE: [PHP] Re: Passing Variables That was my thought too, George. But if the user does not have cookies enabled, then I believe, as Thomas pointed out, that a SESSION is the only way to handle the variables. I have never done a correct session so I am trying to learn how to do them without having a userid and password for each user. I have played with sessions but I don't know if I am doing them correctly or how to do sessions without authentication. Jay At 03:14 PM 6/21/2003 +0100, George Pitcher wrote: Nabil, That is one way but it means that Jay would have to use a form and not a link. You could set a cookie. That would work, but it relies on the user allowing cookies. George -Original Message- From: nabil [mailto:[EMAIL PROTECTED] Sent: 21 June 2003 2:58 pm To: [EMAIL PROTECTED] Subject: [PHP] Re: Passing Variables use hidden field (pure html) and then u have it as $yourhiddenfield on the next page even u have the register global off.. Nabil Jay Fitzgerald [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have been searching for an answer to this for a couple of hours now and cant find anything. I believe that there is a secure way of doing this but I think my brain is having a momentary lapse... I have these variables: $eventid = 1; $age = 15; Is there a way to pass these variables to the next page so I can continue using them without doing something like this: A HREF=test.php?eventid=1age=15 I would rather not have the variables be seen or known to the end user for security reasons because they could change them in the URL. I know it has something to do with $_GET and $_POST because I do have register_globals set to OFF in my php file and I do not want to turn them on TIA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Difference between $_POST[foo] and $_POST['foo']?
the first will generate a warning if warnings are enabled. it could mean a constant or a string, if a constant with that name is not available php will use it as a string and show a warning. the second is right as a string. Thomas On Tue, 17 Jun 2003 11:09:14 +0300 [EMAIL PROTECTED] (Jarmo Järvenpää) wrote: Hi A quickie, how does the $_POST[foo] and $_POST['foo'] differ? Both do work. BR, Jarmo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] more information about the php-/zend-api
Hi folks, I'm currently trying to work my way through an extension. Using the tutorials on the php.net/zend.com ... and other sites it works so far to do some work, return values and getting parameters. But how can I get access to the variables defined in php or add other variables without the need to return them and so on. There must be anywhere more information about such matters or am I just blind? Thanks in advance, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Please help.
That doesn't tell much. The way you'r using should work. What happens if it doesn't work? Thomas On Sun, 15 Jun 2003 21:46:54 +1000 [EMAIL PROTECTED] (Ben Houlton) wrote: How do I get a DB table open easily? So far, I've been using a metod that sometimes works and some times doesn't, I just want to know the easy way to do it. My code of what I'm doing now is below: $db = mysql_connect(localhost,root); mysql_select_db(misc,$db); $result = mysql_query(SELECT * FROM replace); $row = mysql_fetch_array($result); Thank you for your time. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: need help on coding
you need to quote in your code. Thomas On Sun, 15 Jun 2003 17:01:03 + [EMAIL PROTECTED] (Shien Hang Low) wrote: From: Gabor Hojtsy [EMAIL PROTECTED] To: Shien Hang Low [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: need help on coding Date: Sun, 15 Jun 2003 12:26:53 +0200 Please ask support questions at [EMAIL PROTECTED] Goba Shien Hang Low : hi there, i am very sorry, previously i have send you an email but it is the email wich code is wrong, so this is the correct one. thank you i am a php code user and i have below questions and problems wish you could help me out and i think it is very easy for you. thank you . problem : code : ? $data= message; echo $data; ? output : message --- if i want the output to be : message i try to used the below code but fail: ? $data = message; echo $data; ? so i wonder if i want to get the output that with the 'quatation' mark how can i do it, your help means alot to me thank you for your time and patient . best regards, shienhang _ Are you in love? Find a date on MSN Personals http://match.msn.com.my/ _ Download ringtones, logos and picture messages from MSN Malaysia http://www.msn.com.my/mobile/ringtones/default.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: if ($xxxxx) { function not working?
do you even have register_globals enabled?
otherwise $submit, $id and so on will not be set.
Thomas
On Tue, 10 Jun 2003 19:11:21 +1000 [EMAIL PROTECTED] (Ben Houlton) wrote:
HTML
BODY
?php
$db = mysql_connect(localhost,root);
mysql_select_db(main,$db);
if ($submit) {
if ($id) {
$sql = UPDATE edit SET
sub='$sub',msg='$msg',name='$name',email='$email',newday='$newday' WHERE id=$id;
} else {
$sql = INSERT INTO edit (sub,msg,name,email,date,time,newday) VALUES
('$sub','$msg','$name','$email','$date','$time','$newday');
}
$result = mysql_query($sql);
echo Record updated/edited!pReturn to A
href=\index2.php?page=edit\$sub/a.;
} elseif ($delete==areyousure) {
$sql = SELECT * FROM edit WHERE id=$id;
$result = mysql_query($sql);
echo Are you sure you want to delete $sub?pa
href=$PHP_SELF?page=editid=$iddelete=trueYes/a | a
href=$PHP_SELF?page=editNo/a;
} elseif ($delete==true) {
$sql = DELETE FROM edit WHERE id=$id;
$result = mysql_query($sql);
echo $sub Record deleted!pa href=index2.php?page=editReturn/a;
} else {
if (!$id !$edit) {
$result = mysql_query(SELECT * FROM edit ORDER BY time ASC,$db);
while ($myrow = mysql_fetch_array($result)) {
$newday = false ;
$newday = $myrow['newday'] ;
if ($newday) {
printf(TABLE border=0 cellpadding=0 cellspacing=2 width=%sTRTD
align=right class=newsdate width=%sP style=text-align:
rightb%s/b/TD/TD/TABLE, $myrow[width], $myrow[width],
$myrow[date]);
}
printf(font class=newstitleba
href=\%s?page=editedit=yesid=%s\%s/a/b/fontfont class=newsnfo - a
href=mailto:%s%s/A @ %s AEST/fontbr, $PHP_SELF, $myrow[id], $myrow[sub],
$myrow[email], $myrow[name], $myrow[time]);
printf(%sbrbr, $myrow[msg]);
printf(a
href=\index2.php?page=editid=%sdelete=areyousure\(DELETE)/abr,
$myrow[id]);
}
echo Pa href=index2.php?page=editedit=yesADD A RECORD/aP;
}
}
?
?php
if ($edit) {
?
form method=post action=index2.php?page=edit
?php
if ($page $id) {
$sql = SELECT * FROM edit WHERE id=$id;
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow[id];
$name = $myrow[name];
$email = $myrow[email];
$sub = $myrow[sub];
$msg = $myrow[msg];
$newday = $myrow[newday];
$width = $myrow[width];
?
input type=hidden name=id value=?php echo $id ?
?php
}
?
input type=hidden name=date value=?php echo date(l, F, jS Y); ?
input type=hidden name=time value=?php echo date(H:i:s); ?
input type=hidden name=width value=100%
Name:input type=Text name=name value=?php echo $name ?br
E-Mail:input type=Text name=email value=?php echo $email ?br
Subject:input type=Text name=sub width=50 value=?php echo $sub ?New
Day?input type=radio name=newday value=1Yesinput type=radio name=newday
value=0Nobr
Message:textarea name=msg rows=7 cols=80 wrap=virtual?php echo $msg
?/TEXTAREAbr
input type=Submit name=submit value=Enter information
/form
?php
}
?
/BODY
/HTML
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Warning: mysql_fetch_row(): supplied argument is not avalid MySQL result resource in f:\.....\none.php on line 286
On Mon, 9 Jun 2003 07:35:16 -0300 [EMAIL PROTECTED] (Marcelo Luiz De Laia) wrote:
I use phpnuke and it have a sql_layer.php. You are correct, for mysql is
mysql_query. But this dont is the problem, I change it and the problem
continue!
Any tip??
I think you are mixing the layer and native functions.
You should use ONE of these, either the layer from phpnuke OR
the native functions.
I don't know how the layer handles the results but from the layout you had it looks
just wrong.
The standard-way using native mysql_*-functions for a select (with some basic error
checking) is as follows:
[... connection and so on ...]
$result = mysql_query(select * from ...);
if(!mysql_error()) {
echo mysql_error();
}
while($row=mysql_fetch_row($result)) {
[... output ...]
}
You are either not transferring the result-identifier correctly or your query returns
an error.
Thomas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Warning: mysql_fetch_row(): supplied argument is not avalid MySQL result resource in f:\.....\none.php on line 286
why are you using sql_query through your code? its mysql_query for mysql! and the result, needed for mysql_fetch_row is returned from that function. read the docs again. Thomas On Sun, 8 Jun 2003 16:37:59 -0300 [EMAIL PROTECTED] (Marcelo Luiz De Laia) wrote: $result = SELECT categoria, nombre, datafim FROM .$prefix._anuncios ORDER BY datafim LIMIT 0,30; sql_query($result, $dbi); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Compile 4.3.2 Errors.
the same is given for 4.3.2, just compiled it today :). Thomas On Sat, 31 May 2003 12:50:38 -0700 [EMAIL PROTECTED] (Evan Nemerson) wrote: Don't know about 4.3.2, but at the end of 5.0-dev make, the following message is output: Build complete. (It is safe to ignore warnings about tempnam and tmpnam). On Saturday 31 May 2003 06:29 am, Volker Augustin wrote: hi, this sounds like a warning not like an error, your php is successfully compiled...(most software i know an compile got this message.) can you post a little bit more debug information? volker - Original Message - From: Alberto Ferrer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 3:16 PM Subject: [PHP] Compile 4.3.2 Errors. Im compiling the last vercion of PHP 4.3.2 and says this after finish of compile. The system is a Redhat 7.3, Apache 1.3.27. ext/mysql/libmysql/my_tempnam.lo: In function `my_tempnam': /root/php-4.3.2/ext/mysql/libmysql/my_tempnam.c:115: the use of `tempnam' is dangerous, better use `mkstemp' -- -- Alberto Ferrer [EMAIL PROTECTED] http://www.barrahome.org -- Syntax Error in KITCHEN.H: COFFEE not found. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Know me? Know me??? What the hell does that mean, know me, you want to know me? Well you don't know me, and you'll never know me. Nobody knows me, or you, or eachother. Nobody in this world knows anybody else. You'll never know me. Ever. -Rules of Attraction -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Long screen display cut short.
what is the online-version? I mean which webserver-software in which version? Thomas On Fri, 30 May 2003 20:45:08 -0400 [EMAIL PROTECTED] (Floyd Baker) wrote: Hello... I have a routine that works fine on local win98 but when it runs on linux online, the screen output is cut short. I have lengthened the 30 second script time max to 45 but that made no difference at all. Depending on the particulars, the routine stops at a certain spot. If it is rerun, it stops at the very same spot again. Putting in other particulars cause it to stop at a different point, further down. It seems that changes which affect the number of mysql calculations, make some difference in the length of the screen display, but it's only a minor amount. It cuts off somewhere around 4 pages. Any ideas please. Floyd -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: database selection
On Sun, 16 Feb 2003 12:51:58 +0100 [EMAIL PROTECTED] (Hans Prins) wrote:
Hello,
Im trying to select only one row in a mysql database (in this case a poll
with the smallest pollID)...
Each row has a field called pollID which is the primary key and is auto
incremented when a new row is inserted.
I could possible do the following but I think its a bit extensive:
$query = SELECT * FROM polls ORDER BY pollID ASC;
$result = mysql_query($query);
for ($count = 0; $count 1 $count++) {
$data = mysql_fetch_array($result);
$pollID = $data['pollID'];
}
$query = SELECT * FROM polls WHERE pollID = $pollID;
Does anyone now a solution for this that requires less code?
Thx
$query = SELECT * FROM polls ORDER BY pollID ASC LIMIT 1;
Thats the only row.
Regards,
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Username and Passwords
phpMyAdmin has an option to reload mysql too.
It won't work until that is done.
Where did you get the idea, that the username worked?
It just tells, that access has been denied ... the same message
would be sent if the user didn't exist at all!
Thomas
On Sun, 9 Feb 2003 12:40:12 -0500 [EMAIL PROTECTED] (Stephen Craton) wrote:
I'm not sure how except through shell which isn't enabled. Even if I didn't
reload it, why would the username work but the password not?
- Original Message -
From: John Nichel [EMAIL PROTECTED]
To: Stephen Craton [EMAIL PROTECTED]
Cc: PHP List [EMAIL PROTECTED]
Sent: Sunday, February 09, 2003 12:29 PM
Subject: Re: [PHP] MySQL Username and Passwords
Did you reload MySQL after you added the new user?
Stephen Craton wrote:
It's me again, trying to get some more help.
My boss is hosting sites now for games and I need some help with setting
up
phpMyAdmin privelages for certain MySQL users and such. Right now, my
problem is setting up a new MySQL username and password.
I add a new user in phpMyAdmin, I type in the details, everything is
fine.
When I go to test the connection with those connection details, I get
this
error: (I copied and pasted the username and password so they are the
same
for both the script and when I entered them into phpMyAdmin.)
Access denied for user: 'd2sector@localhost' (Using password: YES)
My code is as follows:
?php
if(@mysql_connect('localhost', 'd2sector', '**Edited Out**')) {
header(Location: index.php);
} else {
echo 'font color=redUnable to connect to database. Error as
follows:/fontbr'.mysql_error();
}
?
Does anyone have a clue as to why this happens and how to fix it? I'll
need
to know how to fix this for future users as well. Thanks in advanced.
Thanks,
Stephen Craton
http://www.melchior.us
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL/PHP Associative Array Insert
On Sat, 01 Feb 2003 10:26:10 -0600 [EMAIL PROTECTED] (Cditty) wrote:
A co-worker is teaching me to move to the next level in php. I have
started using associative arrays for my scripts, but I am having a problem
using them to do an insert into MySQL. Can someone give me an example of
how to do an insert to the database using these arrays? My array is
this...$item['itemID']
try something like that:
other-code ... i.e. connecting and so on
mysql_query(INSERT INTO items SET itemcolumn='.$item['itemID'].');
or just
mysql_query(INSERT INTO items (itemcolumn) VALUES('.$item['itemID'].'));
Regards,
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Possible PHP/MySQL Bug?
On Sat, 1 Feb 2003 13:28:00 -0800 [EMAIL PROTECTED] (Tim Lan) wrote: The following code is supposed to migrate data from an old database to a new one, but produces the error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\...\convertdb.php on line 17 The code: [...] Any idea? Yeah, read out mysql_error() after sending the query and before doing fetch... to see what mysql thinks is wrong. Regards, -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Possible PHP/MySQL Bug?
On Sat, 1 Feb 2003 13:28:00 -0800 [EMAIL PROTECTED] (Tim Lan) wrote:
The following code is supposed to migrate data from an old database to a new
one, but produces the error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in C:\...\convertdb.php on line 17
The code:
?php
/* connect to database */
if(!($srcDB = mysql_pconnect('localhost', 'root')) ||
!mysql_select_db('temp', $srcDB)) {
echo 'Unable to connect to source database';
exit;
}
if(!($desDB = mysql_pconnect('localhost', 'root')) ||
!mysql_select_db('cgu', $desDB)) {
echo 'Unable to connect to destination database';
exit;
}
ah yes and another thing.
you can't work on two databases with the same connection parameters (host,
username,password)
to have different connection-ids.
PHP only keeps one connection and not two with the same parameters.
They are the same connection for php which is expected behaviour there (although I
don't like it too).
Regards,
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Loading CSV data into MySQL
On 01 Feb 2003 16:47:23 -0500 [EMAIL PROTECTED] (Brian V Bonini) wrote: Sorry for the OT question: I'm loading a .csv file into MySQL, done it a million times but for some reason it is scrambling the row order. All the fields are making it in correctly but the order of the rows seems to end up totally random. I've done this a million times and never saw this.. Any thoughts... where do you take a row-order from? and HOW are you uploading it into mysql? if you don't use a order by-clause in a select you won't have a really ordered result (only by accident). Regards, -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Loading CSV data into MySQL
On 01 Feb 2003 18:06:01 -0500 [EMAIL PROTECTED] (Brian V Bonini) wrote: On Sat, 2003-02-01 at 16:47, Thomas Seifert wrote: I'm loading a .csv file into MySQL, done it a million times but for some reason it is scrambling the row order. All the fields are making it in correctly but the order of the rows seems to end up totally random. I've done this a million times and never saw this.. Any thoughts... where do you take a row-order from? and HOW are you uploading it into mysql? if you don't use a order by-clause in a select you won't have a really ordered result (only by accident). LOAD DATA INFILE 'file.cvs' INTO TABLE table1 FIELDS TERMINATED BY ';'; the contnts of file .csv look like: 1;2002-02-01;New Dominion Pictures;Prosecutors - The Gosch Murder Case;Beau Parcells;Dave Stevenson (victim's husband), Lead;yes;yes;yes 2;2002-02-01;Coastal;Prospecting;Zoe Whitaker;Corporate Representative;yes;yes; 3;2002-02-01;Metro Video;Right Spirit Campaign (Binge Drinking PSA), - Richmond, VA;Tom Downs;Jim (Sailor)/Principal;yes;yes; 4;2002-02-01;Metro Video;Right Spirit Campaign (Binge Drinking PSA), - Richmond, VA;Amie Hill;Spokesperson;;; 5;2002-02-01;Metro Video;Unit of Action (U.S. Army);Tim Smith;Col. Mike Daniels (Principal);;yes; 6;2002-02-01;Metro Video;Colonial Williamsburg;Molly Larkin;Mother/Wife;;yes; 7;2002-02-01;Commercial;Barton Ford;Dave Hobbs;Car Salesman;yes;yes; 8;2002-02-01;Commercial;Barton Ford;Jackie Jackson;Customer's Wife;;; 9;2002-02-01;Regent Films;First Lunch;Molly Larkin;Principal;yes;yes; 10;2002-02-01;Skillet Productions (televisio;Welcome Home;Molly Larkin;Principal;yes;yes; etc You'd think they would load into the db just like that right? But they do not. They just end up in some random order. this doesn't have anything to do with php afaik. as I said, try: select * from table1 order by field1 ASC replace the field1 with the field you have the number in (the first field in your csv). -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] HELP please quickly
file already returns an array so this would be best for that :). Thomas On Wed, 22 Jan 2003 14:00:09 + [EMAIL PROTECTED] (Didier McGillis) wrote: Cool I'll report back what I have found. Question. I have tried fopen and file and was wondering for opening the file and loading it into an array which one is better? From: Timothy Hitchens \(HiTCHO\) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Didier McGillis' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: [PHP] HELP please quickly Date: Wed, 22 Jan 2003 23:26:10 +1000 You first file just requires loading into an array and you can use unique array functions to remove duplicates etc.. The other files simply load into an array and use preg to strip out what you want and follow the same checking and removal of duplicates. Checkout: preg_match and array functions in the www.php.net manual. Timothy Hitchens (HiTCHO) Open Source Consulting e-mail: [EMAIL PROTECTED] -Original Message- From: Didier McGillis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 11:22 PM To: [EMAIL PROTECTED] Subject: [PHP] HELP please quickly Here is a brief description of what I want to do. I want to use PHP to grab a list of numbers in one file. Check it against a bigger file and strip the ones that match out of the bigger file, into a holding file. so here is what it might look like. file1.txt 456789 456790 456791 456792 456793 456794 . file2.log some time stamp code=001;number=456784;name=blahblah;date=012403; some time stamp code=001;number=456785;name=blahblah;date=012403; some time stamp code=001;number=456786;name=blahblah;date=012303; some time stamp code=001;number=456789;name=blahblah;date=012503; some time stamp code=001;number=456789;name=blahblah;date=012503; some time stamp code=001;number=456789;name=blahblah;date=012503; some time stamp code=001;number=456789;name=blahblah;date=012503; some time stamp code=001;number=456789;name=blahblah;date=012503; some time stamp code=001;number=456790;name=blahblah;date=012603; some time stamp code=001;number=456791;name=blahblah;date=012703; notice there might be more then one of the same number, I only need one so I need to ignore the rest, rip out the time stamp, which is a seperate line. file3.txt code=001;number=456789;name=blahblah;date=012503; code=001;number=456790;name=blahblah;date=012603; code=001;number=456791;name=blahblah;date=012703; can anyone help, any suggestions? _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] $header = Location:........ being ignored!
give some output in the if-construct to see if it even matches.
I believe there is some problem with the variables used in there,
the location should work though.
On Tue, 21 Jan 2003 06:09:01 -0600 [EMAIL PROTECTED] (Rick Emery) wrote:
if ( $_POST['passwd'] != $db['password'] )
{header(Location: loginfailed.html); exit;
}
- Original Message -
From: Shams [EMAIL PROTECTED]
To:
Sent: Tuesday, January 21, 2003 3:48 AM
Subject: [PHP] $header = Location: being ignored!
Hi Group,
I basically have some simple code such as:
==
if ( $_POST['passwd'] != $db['password']
{header(Location: loginfailed.html);
}
//else
$header = Location: success.html;
==
however, when I run this code, using a FORM to submit password, username,
etc.. if the passwords do not match, the page is forwarded to
success.html !
Is there anything obvious that I am doing wrong?
Thanks,
Shams
p.s. I don't want to use else{} because I have lots of if() checks!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP Variable Declare
try:
if (isset($_POST['frmAction']) $_POST['frmAction'] == formmail)
instead of your line.
Thomas
On Wed, 22 Jan 2003 09:47:46 -0500 [EMAIL PROTECTED] (Stephen Goehler) wrote:
Hey guys,
Thanks in advance for your help.
I'm working on emailing the contents of a form using php. It worked fine,
until I turned global_variables off in an attempt to secure the form (I
still have yet to write the data validation part).
Anyway, I have an IF statement that fires depending on a hidden variable in
the form. If the
variable is empty, it loads the form. If the variable contains the hidden
value I give it during form creation, then it emails the contents on the
form and displays a thank you msg instead of displaying the form.
The problem I have run into, involves the hidden value for the form. I
didn't have to declare it before when I had global_variables turned on, but
now I have to. I searched the manual and tried statements like global
$variablename but the code wouldn't run properly. I've searched through
the newsgroups as well, but I'm new to PHP so it was tough to figure out
what to search for. I'm sure all I'm missing is one line of code. I
included my code below. The problem exists in this line:
if ($_POST['frmAction'] == formmail)
which is before where the form is created so the $frmAction variable isn't
declared yet. I'm
getting a variable not declared error, which I know, but if I declare the
variable earlier in the document, then it resets the value that I give it
before I submit the form. How do I make this work?
Thanks so very much!!
Steve
html
head
/head
body
**HTML stuff here**
?php
// error handler
function e($type, $msg, $file, $line)
{
$errorLog = error.log;
**Error Handler code here**
}
error_reporting(E_ERROR | E_WARNING);
set_error_handler(e);
$TO = [EMAIL PROTECTED];
$MP = mail.mailserver.com;
?
?php
if ($_POST['frmAction'] == formmail)
{
$fd = popen($MP,w);
fputs($fd, To: $TO\n);
fputs($fd, From: $_POST['name'] $_POST['email']\n);
fputs($fd, Subject: $_POST['inforequest']\n);
fputs($fd, X-Mailer: PHP3\n);
fputs($fd, Name: $_POST['name']\n);
fputs($fd, Business: $_POST['business']\n);
fputs($fd, Phone: $_POST['phone']\n);
fputs($fd, Email: $_POST['email']\n);
fputs($fd, Details: $_POST['details']);
pclose($fd);
?
**HTML thank you msg here**
?php
exit;
} else {
?
table
form action=test.php method=POST
select name=inforequest
optionSelect Info Source/option
option value=Option 1Option 1/option
option value=Option 2Option 2/option
option value=Option 3Option 3/option
option value=Option 4Option 4/option
/select
/td
/tr
tr
input type=text name=name
/td
/tr
tr
input type=text name=business
/td
/tr
tr
input type=text name=phone
/td
/tr
tr
input type=text name=email
/td
/tr
tr
textarea name=details wrap=PHYSICAL cols=35
rows=8/textarea
/td
/tr
tr
td
input type=hidden name=frmAction value=formmail
input type=submit name=Submit value=Submit
input type=reset name=Reset value=Reset
/td
/tr
/form
/table
?php
}
?
**last bit of HTML here**
/body
/html
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP Variable Declare
it won't work the way you are doing this.
Try something like that line (changed from yours):
fputs($fd, From: .$_POST['name']. .$_POST['email'].\n);
Don't ask arrays directly in a string.
Thomas
On Wed, 22 Jan 2003 11:15:35 -0500 [EMAIL PROTECTED] (Stephen Goehler) wrote:
Now it gets more confusing.I added:
print 'pre';
print_r($_POST);
print '/pre';
to my form and the variables are displayed properly, but only generate
errors when I try to add it to fputs().any ideas?
Stephen Goehler [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Thanks!! That worked perfectly. Neat little function there to check if a
variable exists. Also I am set to E_ERROR ~E_NOTICE already.
The form loads correctly and then when you click submit goes to the thank
you screen. The only problem now is that it says that my variables don't
exist that I pass using the form and as a result, won't email them. When
it
gets to the code to email the results the variables like $_POST['name']
won't exist. What puzzles me is that the frmAction is passed, but none of
the textbox...etc. variables are. Do I need to add in the form name
somewhere to show where the variables are coming from?
Thomas Seifert [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
try:
if (isset($_POST['frmAction']) $_POST['frmAction'] == formmail)
instead of your line.
Thomas
On Wed, 22 Jan 2003 09:47:46 -0500 [EMAIL PROTECTED] (Stephen Goehler)
wrote:
Hey guys,
Thanks in advance for your help.
I'm working on emailing the contents of a form using php. It worked
fine,
until I turned global_variables off in an attempt to secure the form
(I
still have yet to write the data validation part).
Anyway, I have an IF statement that fires depending on a hidden
variable
in
the form. If the
variable is empty, it loads the form. If the variable contains the
hidden
value I give it during form creation, then it emails the contents on
the
form and displays a thank you msg instead of displaying the form.
The problem I have run into, involves the hidden value for the form.
I
didn't have to declare it before when I had global_variables turned
on,
but
now I have to. I searched the manual and tried statements like
global
$variablename but the code wouldn't run properly. I've searched
through
the newsgroups as well, but I'm new to PHP so it was tough to figure
out
what to search for. I'm sure all I'm missing is one line of code. I
included my code below. The problem exists in this line:
if ($_POST['frmAction'] == formmail)
which is before where the form is created so the $frmAction variable
isn't
declared yet. I'm
getting a variable not declared error, which I know, but if I declare
the
variable earlier in the document, then it resets the value that I give
it
before I submit the form. How do I make this work?
Thanks so very much!!
Steve
html
head
/head
body
**HTML stuff here**
?php
// error handler
function e($type, $msg, $file, $line)
{
$errorLog = error.log;
**Error Handler code here**
}
error_reporting(E_ERROR | E_WARNING);
set_error_handler(e);
$TO = [EMAIL PROTECTED];
$MP = mail.mailserver.com;
?
?php
if ($_POST['frmAction'] == formmail)
{
$fd = popen($MP,w);
fputs($fd, To: $TO\n);
fputs($fd, From: $_POST['name'] $_POST['email']\n);
fputs($fd, Subject: $_POST['inforequest']\n);
fputs($fd, X-Mailer: PHP3\n);
fputs($fd, Name: $_POST['name']\n);
fputs($fd, Business: $_POST['business']\n);
fputs($fd, Phone: $_POST['phone']\n);
fputs($fd, Email: $_POST['email']\n);
fputs($fd, Details: $_POST['details']);
pclose($fd);
?
**HTML thank you msg here**
?php
exit;
} else {
?
table
form action=test.php method=POST
select name=inforequest
optionSelect Info Source/option
option value=Option 1Option 1/option
option value=Option 2Option 2/option
option value=Option 3Option 3/option
option value=Option 4Option 4/option
/select
/td
/tr
tr
input type=text name=name
/td
/tr
tr
input type=text name=business
/td
/tr
tr
input type=text name=phone
/td
/tr
[PHP] Re: MySQL 4.0 + PHP 4
I'm running it in production since MySQL-4.0.2 and without any problems. Thomas On Wed, 22 Jan 2003 11:21:40 -0800 [EMAIL PROTECTED] (Joe Stump) wrote: Anyone out there have anything to share as to using PHP4+MySQL4. I've been hearing good things on the MySQL list about v4.0 and I'm thinking of upgrading, since I run a rather small server. Thanks! --Joe ps. PHP list responders please respond directly. I'm not currently subscribed. -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: 4.3.0 cpu load raise
Hmm, I didn't see this effect but I only tried on a development machine. I benchmarked a app there with both php-versions and it was nearly 20% faster with php-4.3.0. But that may depend on the application. Thomas On Mon, 20 Jan 2003 18:30:05 +0100 [EMAIL PROTECTED] (Philipp) wrote: Hello ! i upgraded PHP last week. I used 4.2.3 and now i am using 4.3.0. The System is Linux running a 2.4.20 kernel and Apache 1.3.27 with PHP statically compiled in. I recognized a significant load-raise. it seems that the new version needs more CPU power to complete its tasks. i will evaluate my atsar logs to verify my assumption, but i like to know if others experienced similar behavior on their webservers. Thank you very much, Philipp -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] SQL+php
it doesn't change it in the database, just in the output. Thomas On Sun, 19 Jan 2003 03:17:04 +0200 (EET) [EMAIL PROTECTED] (Paul Marinas) wrote: something like that only i don't whant to alter the database, the fields in the database must remains unchanged, only, on page i whant to display diferent data. On Sun, 19 Jan 2003, Sean Malloy wrote: If you want to do it within the query itself, take a look at the mysql replace command REPLACE(str,from_str,to_str) SELECT REPLACE(field,from,to) FROM table or you can do it using PHP once the query has executed, on a record by record basis, within a while/for loop or whatever. -Original Message- From: Paul Marinas [mailto:[EMAIL PROTECTED]] Sent: Sunday, 19 January 2003 11:07 AM Cc: [EMAIL PROTECTED] Subject: [PHP] SQL+php Dose anyone know how to search and replace a string in a mysql_query output. Thanks, Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Thomas Seifert mailto:[EMAIL PROTECTED] http://www.MyPhorum.de -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mail () error
The mail-server has to respond that it received the mail. Maybe you've set the firewall only one-way open? Thomas On Fri, 17 Jan 2003 15:29:32 -0500 [EMAIL PROTECTED] (Stephen Goehler) wrote: Thanks, the server was relaying, but it turned out to be the firewall that was rejecting the request. Now I have a new problem thought, my mail () command will send the mail (and I receive it) but it will just hang there and eventually return this: Fatal error: Maximum execution time of 30 seconds exceeded The email goes through, but it won't process any of the code after it. Is it waiting for a response from the mail server? Can I disable that? Steve John W. Holmes [EMAIL PROTECTED] wrote in message 004901c2be5a$a384f910$7c02a8c0@coconut">news:004901c2be5a$a384f910$7c02a8c0@coconut... Anyone know what causes this error? Warning: mail ()[function.mail]: Failed to receive Can it not find the mail server? When I got this error it was because the server was rejecting the email, saying it wouldn't relay the message. Maybe check your relay setting in your SMTP server? ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Using $vars from include()d functions in the main programm andother functions
They should show up but still think of the order in which they are loaded. You can access vars which are not yet loaded. Also you can't access variables which are initialized in a function (if they are not global). Including adds the contents of the files as if it was directly in main.php4, they are not new namespaces Thomas On Sat, 11 Jan 2003 12:49:15 +0100 [EMAIL PROTECTED] (Ben9000) wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello List, a simple problem turned out to be not so simple as I thought. Here the situation: main.php4 | +-include() mainhtml.php4 | +-include() functions.php4 | +a function does include() languagevars.php4 I can see the included $vars from languagevars.php4 in functions.php4 but not in main.php4. Using global $var just seems to work top-down but I'm not able to bring the $vars up to the main.php4 or to the mainhtml.php4. This time, I just wanted to write not one scary large PHP4-Page with around ~100kb in size. But I'm really stuck - all the books, pdfs and web information just want to bring the $vars down. Or is there just a failure in thinking?! Any hint is highly appreciated. Ben :) -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+IATAROwluvOuI4ARApiOAJ9EyDo2ER3YROGZ120CgllOkjM8tgCfUIeD pxtKmzi71xC3n8Tpb0FSQ7w= =BZcc -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Change Date
http://de.php.net/manual/en/function.mktime.php The most important part is mktime() is useful for doing date arithmetic and validation, as it will automatically calculate the correct value for out-of-range input. Thomas On Sun, 11 Jan 2004 16:12:01 +0330 [EMAIL PROTECTED] (Sadeq Naqashzade) wrote: Hi, How can I find time stamp for example 125 next days. or 03:30 hours next? Regards, S. Naqashzade PS: Sorry for my bad english :-( -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Change Date
i.e. // getting the current time in an array $timeval=localtime(); // we want the time 3 hours in the future $timeval[2] = $timeval[2]+3; // calc the new timestamp $timestamp=mktime ($timeval[2], $timeval[1], $timeval[0], $timeval[4], $timeval[3], i$timeval[5]); An even better solution, you are talking about a unix-timestamp, right? just add or subtract the the seconds from the current timestamp, i.e. // get the current timestamp $timestamp=time(); // 1 minute = 60 seconds, 1 hour = 60 minutes, therefore 1 hour = 60*60 = 3600 seconds // so we add 3600*3 to have the time in 3 hours $timestamp = $timestamp + (3600*3); // you can convert this time back to a readable format using strftime Regards, Thomas On Sun, 11 Jan 2004 16:22:08 +0330 [EMAIL PROTECTED] (Sadeq Naqashzade) wrote: So Thanks, but can you get me some example code? Regards, Sadeq Thomas Seifert [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... http://de.php.net/manual/en/function.mktime.php The most important part is mktime() is useful for doing date arithmetic and validation, as it will automatically calculate the correct value for out-of-range input. Thomas On Sun, 11 Jan 2004 16:12:01 +0330 [EMAIL PROTECTED] (Sadeq Naqashzade) wrote: Hi, How can I find time stamp for example 125 next days. or 03:30 hours next? Regards, S. Naqashzade PS: Sorry for my bad english :-( -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Make thumbnail online
how about just reading the docs which are available online? http://de.php.net/manual/en/ref.image.php and especially http://de.php.net/manual/en/function.imagecopyresized.php will help. Thomas On Sun, 11 Jan 2004 16:32:36 +0330 [EMAIL PROTECTED] (Sadeq Naqashzade) wrote: Hi every one, I want to create thumbnail of a photo stored in MySQL table online. Best Wishes, S. Naqashzade -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ftp_put: permission denied
it may be, that destiny is wrong.
the error-message tells that you don't have access to where you are trying to upload
the file to.
Thomas
On Wed, 08 Jan 2003 20:59:02 +0100 [EMAIL PROTECTED] (Oliver Witt) wrote:
I uploaded that script with a common ftp program on my server in the
internet.
FOr the host, user and pw, I use the same data as I use to log in with
my ftp program. So the mistake can't be there.
This is how that script basically works:
?php
if(isset($destiny)){
$ftp_server = host;
$benutzername = user;
$passwort = pw;
$connection_id = ftp_connect($ftp_server);
$login_result = ftp_login($connection_id, $benutzername, $passwort);
$upload = ftp_put($connection_id, $destiny, $local_file, FTP_ASCII);
if (!$upload) {
echo pIt didn't work/p;}
else {
echo pIt did work/p;}
ftp_quit($connection_id);}
?
html
head
title/title
/head
body bgcolor=#FF text=#00
form action=upload.php enctype=multipart/form-data method=POST
input name=local_file type=file size=50
br
input type=text name=destiny
br
input type=submit value=Submit
/form
/body
/html
Timothy Hitchens ) schrieb:
Using ftp_login() ??
Timothy Hitchens (HiTCHO)
Open Platform Consulting
e-mail: [EMAIL PROTECTED]
-Original Message-
From: Oliver Witt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 9 January 2003 5:30 AM
To: [EMAIL PROTECTED]; Timothy Hitchens )
Subject: Re: [PHP] ftp_put: permission denied
Timothy Hitchens ) schrieb:
I am assuming you have testing from a desktop client.
Are you sure that the PHP script has been logged in??
Can you see via a log file of the successful authentication??
I logged in using the same information as I used to upload
that script.
if ((!$conn_id) || (!$login_result)) {
echo Not logged in;
die;
} else {
echo Logged in;
}
That script returned Logged in.
Olli
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How To Delete Multiple Items Of Multiple Tables Using PHPand MySQL
there is no need to close and open the connection for every query.
just run the mysql_query again and again and again on the open connection.
Still Stephen's quote is true, you can't run more than one query by one call to
mysql_query.
Thomas
On Tue, 31 Dec 2002 16:30:38 -0600 [EMAIL PROTECTED] (@ Nilaab) wrote:
I was hoping for better news. Thanks for the suggestion, but it will put a
very big strain on my application since every DELETE query will open and
close the mysql connection everytime. Think about deleting 100s of records
one at a time. Surely someone has thought of a better way to do this with
MySQL 3.23. Also, I don't want to run persistent connections, as I only have
a limited number of simultaneous connections to the database currently. Is
there a better way to do all this? Anyone?
-Original Message-
From: Stephen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 1:10 PM
To: @ Nilaab
Cc: PHP List
Subject: Re: [PHP] How To Delete Multiple Items Of Multiple Tables Using
PHP and MySQL
From experience, I don't think you can run more then one SQL statement at
once in a single time. Try assigning each variable with delete, then query
them all seperately. I also don't think you need the ; in the SQL
statement...
- Original Message -
From: @ Nilaab [EMAIL PROTECTED]
To: Php-General [EMAIL PROTECTED]
Sent: Tuesday, December 31, 2002 1:36 PM
Subject: [PHP] How To Delete Multiple Items Of Multiple Tables
Using PHP and
MySQL
: Hello Everyone,
:
: I want to DELETE multiple items of multiple TABLES in a MySQL
database. My
: version of MySQL is 3.23, which means this version doesn't support the
: DELETE functionality on multiple tables. The following is my PHP code,
where
: $item_id is a multi-dimensional array containing the ids of the items I
want
: to delete from the table.
:
:# DELETE records
:for ($i = 0; $i count($item_id); $i++) {
: $query_item2 .= DELETE QUICK FROM item_dimension WHERE item_id =
: '.$item_id[$i][0].'; ;
: $query_item2 .= DELETE QUICK FROM item_popup WHERE item_id =
: '.$item_id[$i][0].'; ;
:}
:
: When I run this through the database using PHP, it returns a
syntax error
in
: the SQL. So what I did was echo out $query_item2, then copied and pasted
the
: SQL into the MySQL application manually, and ran it through. Well the
exact
: same SQL statement that I used in PHP worked when I entered it
manually in
: MySQL. In other words it didn't work doing it through PHP, but it worked
in
: MySQL directly. What gives? Is there a better way to delete
multiple items
: from multiple tables with one SQL string? I don't want to
separate the two
: DELETE functions and run them through two separate times because of
overhead
: concerns. I tried looking on the MySQL and PHP website for
better ways of
: using DELETE syntax on multiple tables, but I had no luck
finding anything
: useful with my version of MySQL. Any help would be greatly appreciated.
:
:
: --
: PHP General Mailing List (http://www.php.net/)
: To unsubscribe, visit: http://www.php.net/unsub.php
:
:
:
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Repeats of values
On Tue, 31 Dec 2002 10:47:57 -0600 [EMAIL PROTECTED] (Anthony Ritter)
wrote:
while($line = mysql_fetch_array($result)){
print \ttrtd bgcolor=\#FF\Font Face=\arial\ size =2\n;
while(list (,$value) = each ($line)) {
Thats just wrong, mysql_fetch_array returns an array with all the fields accessible per
field-id and field-name so you have each field twice.
You can try this
print_r($line);
to see that.
either access the rows by using mysql_fetch_row (only an enumerated array is returned
so each value only once)
or better access the values in the array directly:
while($line = mysql_fetch_array($result)){
print \ttrtd bgcolor=\#FF\Font Face=\arial\ size =2\n;
print td bgcolor=\FF\Font Face =\arial\
size=2.$line['level']./td\n;
print td bgcolor=\FF\Font Face =\arial\ size=2.$line['pm']./td\n;
print td bgcolor=\FF\Font Face =\arial\ size=2.$line['date']./td\n;
print \t/tr\n;
}
Regards,
Thomas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Writing byte 0A to a file (LF / CR related)
from the manual: Note: On systems which differentiate between binary and text files (i.e. Windows) the file must be opened with 'b' included in fopen() mode parameter. Thomas On Wed, 25 Dec 2002 11:43:13 +0100 [EMAIL PROTECTED] (Bbun) wrote: Hey, I am trying to write some binary data (image) to a file, but using fputs, every 0A byte will be written as 0D 0A. This is because of the windows representation of a new line (\r\n), but I'm not writing a text file! I'm writing binary data! Does anyone know how I can make this work correctly? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] function/class for updating multiple-tables automatically?
Hi folks, I'm looking for a function or class which is able to automatically update multiple tables. The hard thing on this is, I only want to give it some predefined arrays which define the table-structures (and maybe aliases for some fields) and on execution it only gets some field-names and their corresponding values. It should compute then the required tables to update based on the involved fields and update them with the values given. I know I could do it on my own with some work but I'm hoping someone has already developed something like that. Thanks, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: function/class for updating multiple-tables automatically?
oh, some addendum, I would need it for MySQL if its dependend. Thomas On Mon, 16 Dec 2002 21:46:34 +0100 [EMAIL PROTECTED] (Thomas Seifert) wrote: Hi folks, I'm looking for a function or class which is able to automatically update multiple tables. The hard thing on this is, I only want to give it some predefined arrays which define the table-structures (and maybe aliases for some fields) and on execution it only gets some field-names and their corresponding values. It should compute then the required tables to update based on the involved fields and update them with the values given. I know I could do it on my own with some work but I'm hoping someone has already developed something like that. Thanks, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Just Curious
Mail/News-Client Sylpheed On Sat, 7 Dec 2002 23:31:57 -0500 [EMAIL PROTECTED] (Conbud) wrote: I was just curious, but what program or website do you all use to view and reply to the newsgroups with ? Lee -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Server
mysql-database contains all the system tables and users. Users are only inserted there and defined for which database they are made. As Jason suggested, look at mysql.com they have a fine manual with tutorials and long descriptions which lead to easy solutions to create users. i.e. search for the grant-statement. Thomas On Tue, 3 Dec 2002 16:56:40 -0700 [EMAIL PROTECTED] (Chase) wrote: Thanks for the info... As it turns out, I am just a blithering idiot... I didn't know that I had to create a separate user... As I said, that shows my newbieness... However, this has lead me to another question... The default database, mysql, comes with a users file already... How do I create that in a new database?? Or can I just copy the existing to a new database? Chase Jason Wong [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Tuesday 03 December 2002 23:09, Chase wrote: I am the first to admit that this question belongs on a MySQL newsgroup instead of here, but I can't seem to find a newsgroup that will answer me... www.mysql.com Here is a newbie question. I am running a Win2K Advanced Server with IIS 5?, PHP4, and MySQLmax 3.23.53. I am by no means experienced in setting up any of these items, but my simple question is, how do I determine the name of the MySQL server so I can get PHP to connect to it? If they're all on the same server use 'localhost'. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* My father was a God-fearing man, but he never missed a copy of the New York Times, either. -- E.B. White */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: print to file
$fp=fopen(filename,a); fputs($fp,text to the file); fclose($fp); Regards, Thomas On Mon, 2 Dec 2002 15:52:23 -0800 (PST) [EMAIL PROTECTED] (Bryan Koschmann - Gkt) wrote: Okay, this is probably stupid, but how do you print to a file? Thanks, Bryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Guestbook
Hi, you give less information. How do you compute the entry number and how do you save the entries and so on. Normally you will have to live with the gaps but sure, you can touch every entry and change its number ;-). Thomas On Sun, 1 Dec 2002 10:33:45 - [EMAIL PROTECTED] (Vicky) wrote: Hiya ^_^ I have a guestbook I coded myself using PHP. In the corner it keeps record of the entry number, but when I delete and entry the entries posted after it don't go back to catch up. So the entry numbers skip from 22 to 24, for example. Is there anyway to stop this happening, so if i delete an entry the next one will follow on instead of being the number it would have been if i hadn't deleted the entry? Thanks ^_^ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP Trouble-Ticket-Systems?
Hi folks, I already searched through the web but couldn't find any which provide the features I want. What I would want to see in such a system: - adding TroubleTickets through webinterface or sending an email to an support email-address - adding answers to troubletickets to their parent - nice admininterface to answer support-requests and add comments (not sent to visitors) - open/close/stalled/bogus ... and so on tags for the system - ... So the question is, does anyone know any good troubleticket/helpdesk-systems written in PHP? Thanks, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PHP Trouble-Ticket-Systems?
Sounds interesting. I used RT at work but it was a nightmare to install and since my machine is a pure PHP-Apache I don't want to install mod_perl-support as well. Let me know if you need help on some parts. Thomas On Sun, 1 Dec 2002 14:33:02 -0500 [EMAIL PROTECTED] (Jonathan Chum) wrote: I actually spent all day last Wednesday for looking for such a tool to integrate into a web hosting control panel we've built, but there really isn't a good one out there. PerlDesk is a free one that is template based, yet it's lacking a few features. At work, we use Response Tracker v2 (RT) which is also Perl based, but the template engine is nightmare to give it a new look. It has everything you mention below, but the interface and installation is the drawbacks. So, I spent my Thanksgiving weekend working on PHP port of RT2 which at the moment is able to authenticate technicians, create a new ticket, reply/comment to tickets, activity logging, queue stats, and a few other things. I haven't done the client side yet, but shouldn't be too hard since the DB schema is complete and I can safely reuse templates in the technician screen for the client area with a small bit of changing out the WHERE clauses in the SQL querying. The DB layer is ADODB so it can be ported over to PostGreSQL later on. Smarty is the template class I'm using with custom error pages on all errors, warning, or notices. Until the web interface is hardened, then I'll work on email parser to pipe it into database and parse MIME attachments. . . I'd like to see it evolve into something like cyracle.com where there is a knowledge base in which the visitor can rummage through before submitting in a ticket. Thomas Seifert [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi folks, I already searched through the web but couldn't find any which provide the features I want. What I would want to see in such a system: - adding TroubleTickets through webinterface or sending an email to an support email-address - adding answers to troubletickets to their parent - nice admininterface to answer support-requests and add comments (not sent to visitors) - open/close/stalled/bogus ... and so on tags for the system - ... So the question is, does anyone know any good troubleticket/helpdesk-systems written in PHP? Thanks, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: imap
On Mon, 25 Nov 2002 14:14:54 -0500 [EMAIL PROTECTED] (Greg) wrote: Can I user php to create IMAP mailboxes? I'm using Cyrus and php and apache are running on the same computer as Cyrus. Thanks! -Greg Maybe something like that would fit your needs: http://www.delouw.ch/linux/web-cyradm/ Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Performance through the 4.x-series
Hi there, did anyone do any Performance measurement through the php4.x-series? I've heard that the performance decreased from 4.0.x to 4.1.x to 4.2.x ... ? Are there any numbers or benchmarks for this? Thanks in advance, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Performance through the 4.x-series
Sorry, yeah I've heard and I cannot prove it, therefore I ask. I didn't want to troll or similar, just curious about it. Are there any benchmarks through the different versions with a common-app or similar available? Regards, Thomas On Sun, 10 Nov 2002 08:08:04 -0800 (PST) Rasmus Lerdorf [EMAIL PROTECTED] wrote: You have heard? There have been a number of performance improvements in many different areas of php actually. -Rasmus On Sun, 10 Nov 2002, Thomas Seifert wrote: Hi there, did anyone do any Performance measurement through the php4.x-series? I've heard that the performance decreased from 4.0.x to 4.1.x to 4.2.x ... ? Are there any numbers or benchmarks for this? Thanks in advance, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] regexp help wanted
Hi folks, I just got nuts by trying to find a regexp for use with preg_replace to achive the following: remove all br / which are in the text between a pre and a /pre Tag. So, I want no br between these tags. Any ideas or quick help? thanks in advance, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql error
also try to: echo mysql_error(); after the select-query, it will tell you what went wrong. Thomas On Fri, 17 May 2002 18:45:07 +0100 [EMAIL PROTECTED] (Randum Ian) wrote: Hi all, I have got this code but I can get it to work, it doesnt make sense! snip ?php $host=localhost; $username=user; $password=pass; $database=admin; $mysqlconnect = mysql_connect($host, $username, $password) or die (Cannot connect to mySQL server, check it is running); mysql_select_db($database, $mysqlconnect) or die (Cannot connect to the database, check it is set right); $result = mysql_query(SELECT * FROM user); $count = mysql_num_rows($result); $counted = number_format($count); echo $counted; ? snip but I am getting this error - Warning: Supplied argument is not a valid MySQL result resource in /usr/home/e/a/eagadmin/public_html/main.php on line 14 but I dont understand why! Can anyone help? Regards, Ian. --- Randum Ian DJ / Reviewer / Webmaster, DancePortal (UK) Limited [EMAIL PROTECTED] http://www.danceportal.co.uk DancePortal.co.uk - Global dance music media -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Send html email
On Sun, 12 May 2002 00:07:57 -0500 (CDT) [EMAIL PROTECTED] (Miguel Cruz) wrote: On Sat, 11 May 2002, Alex Shi wrote: Thanks for all of you who answered my question. But another of my stupid question is: what is RTFM? RTFM == Read The Flurking Manual Or Read the fine manual (or replace fine with every word which begins with f ;-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] compiling extensions from HEAD for 4.1.1?
Hi folks, I would like to use a extension from the php4-cvs for my current php4.1.1-production-system. Is it possible to use such an extension? if so, how? using phpize produces error messages about the m4-macros. thanks a lot, Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: cursor focus
yeah, but what you want to do can only be accomplished with JavaScript. PHP is a serverside language and you need a clientside-lang like JS. Thomas Ralph Jarvis wrote: I am not running Javascript, just PHP/HTML... THe particular script I am having problems with has several decision points and includes which I think is confusing the placement of the cursor Gaylen Fraley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]; This is not a php question. It is a JavaScript issue. You need to add this code to the bottom of your page: script document.forms[0].text_box_name.focus(); /script -- Gaylen PHP KISGB v4.0.1 Guest Book http://www.gaylenandmargie.com/phpwebsite/ Ralph Jarvis [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]; This is really a newbie question, but here goes. I am running PHP4 with Apache on Redhat 6.2. I am sure I read this somewheres, but can't find it again. When I open a webpage in a small password application that I wrote, the cursor is not on the first text box I need to fill in, I need to click on the text box to begin typing. How do I get the cursor to focus on this text box? Many thanks in advance Ralph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysql_db_query and the future?
Hi folks, just wondering, why the mysql_db_query is being abandoned and called deprecated ? With the current implementation of the mysql_connect I have a problem with using 2 databases with the same username/password. PHP will use the same connection and so only use one of the two databases :-(. Is there any other way than always calling mysql_select_db before making a query? I was used using an abstraction layer with a class for each connection which used also mysql_db_query for the query so that I could use each class on a different database (but with the same connection parameters). Is there a speed penalty in using the combination of mysql_select_db();mysql_query ... compared against mysql_db_query? Thanks a lot for already reading this ;-) Thomas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
