PHP :: UPDATE Command Is Not Working On MySQL, Windows 2000 Server

Mail() Php Function Not Working In Windows Server 2003
I tried the mail() php function and it ends up with error message. I tried different tests with port configuration and Smtp server, though it ended up in error.

Error: Code: Original - Code Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in c:program fileseasyphp1-7wwwmailerman.php on line 19 Warning: mail(): Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in c:program fileseasyphp1-7wwwmailerman.php on line 19.

View Replies !

MySQL UPDATE Command
I use this to add a new row of data to a table:

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>$query = "insert into $parent values('$id','$author','$website','$fname','$width','$place','$title')";
$result = mysql_query($query) or die("crap");[/code]

The $id is an auto incrementing field so every row can be referenced with a unique number. Suppose I have the $id of the row I want to modify, and I have new values for $author, $website, $fname, $width, $place, and $title. What code do I use to modify the row (keeping the same $id)?

View Replies !

System(); Command Not Working On Remote System. Windows.
My server is a windows machine, on the same domain as python(also a windows machine). Apache is running as a service as an administrator. This is a test only environment to whom it may concern(I hate people telling me how insecure my system is) I'm just trying to run:

$last_line = exec('dir pythonc$', $retval, $g);
print_r($retval);
echo '<br>'.$g.'<br>';
echo '$last_line= '.$last_line.'<br>';
Which outputs:

Array ( )
1
$last_line=

The command from the command line works fine. And apache can access directories that only administrators can access on the local machine.

View Replies !

Using PHP For Mysql Command (update Partial)
I have a table with a structure column of "product_attributes" that I want to do a mass update to with certain criteria. Basically if within product_attributes there are some rows with the following: Code:

color_blue,color_pink,color_purple,color_black
color_blue,color_pink,color_purple,color_white
color_green,color_pink,color_purple,color_black
color_blue,color_pink,color_purple,color_yellow

Now I want to change all instances of color_purple to color_violet. So that it should now read: Code:

color_blue,color_pink,color_violet,color_black
color_blue,color_pink,color_violet,color_white
color_green,color_pink,color_violet,color_black
color_blue,color_pink,color_violet,color_yellow

How would I do this without disturbing any of the other information within that table? Only the one word in all rows with "color_purple" in it?

View Replies !

Mysql Table Update Command
I have a MySql DB called "CONTACTS" and it has two tables, they are:

Table Name = CUSTOMER [There are many customers in this table]
Field 1 = Customer_Name [Data available]
Field 2 = Customer_Country_Code [Data Available]
Field 3 = Customer_Country_Name [To be updated from COUNTRY table]

Table Name = COUNTRY [There is one record for every country in the world]
Field 1 = Country_Code
Field 2 = Country_Name

How can I run a SQL command or write a PHP script that will fill the CUSTOMER->Customer_Country_Name with the Country Name by checking the CUSTOMER->Customer_Country_Name with COUNTRY->Country_Code

View Replies !

If/else Not Working With MySQL Command?
I'm trying to set up a basic email list, starting with the following:

if($_POST['gf_email_signup']=='Yes') {
$sql = "SELECT email from e_mailing_list where e_mailing_list.email = '$_POST[gf_email_signup]'";
$result = mysql_query($sql, $conn) or die(mysql_error());
if(mysql_num_rows($result) != 0) {
$email_signup_notice = '(Your email address was already on our mailing list)'
} else {
$sql = "INSERT INTO e_mailing_list values ('','$date','$_POST[gf_name_first]','$_POST[gf_name_last]','$_POST[gf_email]')";
$result = mysql_query($sql, $conn) or die(mysql_error());
$email_signup_notice = '(Your email address was successfully added to our mailing list)'
}}

The problem is, after an email address is added, if that address is attempted to be added again (i.e. test@email.com is already in the list but someone tries to add it again), the if/else clause does not work.

It skips to the else section and then returns as mySQL error because the email field is set as unique. Am I missing something as to why the if/else is not working to detect a duplicate address? Am I going about this the wrong way?

My apologies if this belongs in the mySQL forum; I am new to mySQL but this seemed to me to be a php problem... but again, I'm new to mySQL so I could be wrong, and maybe the solution is quite obvious to a more seasoned coder.

View Replies !

Windows 2000 Problems
when I open IE and enter in "http://localhost" I get:

"The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings."

blah blah blah....

Then, when I click the Personal Web Manager icon in the Admin tools, I get this error:

"Error connecting to servernamehere: Unexpected error 0x80074002 occurred. Do you wish to continue to attempt to connect to it in the future?"

View Replies !

Installing Php On Windows 2000
I've just installed php on windows 2000 with a pws. How can I test it to see if it's installed correctly.

View Replies !

Installing On Windows 2000 Iis 5
for some odd reason the installer program doesn't set the file extension
..php to be associated with anything, my guess is that it should be
php-win.exe (i've tried all 3 .exe files, and the php.exe produces the
correct results in a command window)... when running a .php in IE I can see
it execute in task manager but the IE screen will not change to display the
correct info.. anyone have any idea about this? IE settings wrong or
something?

View Replies !

Use Gettext In Windows 2000
How can i use gettext in windows 2000. problem in compile .po file. how can i make the .po file. tell me in detail step by step. also unable to find msgfmt.exe, libiconv.dll, libintl.dll to compile .po file in windows.

View Replies !

V4.0.2 And Exec() In Windows 2000 / IIS
Are there any tricks to getting the exec() function to work under
Windows 2000 with IIS? PHP v4.0.2 is installed on the server.

View Replies !

Problems With MS-SQL, Apace, PHP On Windows 2000
I want to use PHP for a project at work. This project requires Windows 2000 running Apache and accessing MS-SQL Server 2000. I am using the mssql php extension to access the db and have all the required files to access the db. If the environment was not correct, it shouldn't connect and successfully query int data types.

Everything works fine as long as I query for numeric datatypes such as int. However, every single time I try to query a text, char, var or datetime field, Apache crashes and I get a Windows error dialog saying that an error is being logged. Unfortunately, there is no error logged to either the Windows 2000 Event Log or the Apache log.

I love PHP and would really like to be able to use it for this project rather than JSP or ASP on IIS.

If anyone knows why this is crashing the server, I'd greatly appreciate any advice or help.

By the way, this is an enterprise-wide database so switching to MySQL is not an option.

View Replies !

How Can Windows 2000 Be Shut Down/ Restarted Via PHP?
How can windows 2000 be shut down/ restarted via PHP?

View Replies !

EGroupWare - With Windows 2000 Install
using Apache, PHP and MySQL on my own PC - been using
it for a while on ISP hosted servers and plesk to create oline forums using
things like Invision and PHPBB but decided to give running eGroupWare a go
on my own PC.

I have windows 2000 Pro and followed some online tutorial to the letter
(excpet downloaded the very latest version of MySQl, PHP, etc) to install
Apache, PHP and MySQL and all worked fine.

Now downloaded eGroupWare and put it in the c:web folder and ran the setup
file

but when I go to my browser and tpye:
http://localhost/egroupware/login.php

I get the following below can anyone point me in the direction of what it
all means??

Warning: main(C:/php/phpgwapi/setup/setup.inc.php): failed to open stream:
No such file or directory in c:webegroupwareheader.inc.php on line 102

Warning: main(): Failed opening 'C:/php/phpgwapi/setup/setup.inc.php' for
inclusion (include_path='.;c:php4pear') in
c:webegroupwareheader.inc.php on line 102

Warning: main(C:/php/phpgwapi/inc/functions.inc.php): failed to open stream:
No such file or directory in c:webegroupwareheader.inc.php on line 110

Warning: main(): Failed opening 'C:/php/phpgwapi/inc/functions.inc.php' for
inclusion (include_path='.;c:php4pear') in
c:webegroupwareheader.inc.php on line 110

Warning: main(C:/php/phpgwapi/inc/xml_functions.inc.php): failed to open
stream: No such file or directory in c:webegroupwareheader.inc.php on
line 111

Warning: main(): Failed opening 'C:/php/phpgwapi/inc/xml_functions.inc.php'
for inclusion (include_path='.;c:php4pear') in
c:webegroupwareheader.inc.php on line 111

Warning: main(C:/php/phpgwapi/inc/soap_functions.inc.php): failed to open
stream: No such file or directory in c:webegroupwareheader.inc.php on
line 112

Warning: main(): Failed opening 'C:/php/phpgwapi/inc/soap_functions.inc.php'
for inclusion (include_path='.;c:php4pear') in
c:webegroupwareheader.inc.php on line 112

Fatal error: Call to undefined function: createobject() in
c:webegroupwarelogin.php on line 26

View Replies !

Exec() Function Under Windows 2000 With IIS?
Are there any tricks to getting the exec() function to work under
Windows 2000 with IIS? PHP v4.0.2 is installed on the server.

View Replies !

Why I Cant Setup Apache In Windows 2000
i can install apache in windows 2000 professional
but when i was to install it in a LAN it cant run correctly
when i type http://localhost/ in browser i recieve The page can not find
why?

View Replies !

Installing Php4 On Windows 2000 Webserver
Is this possible? If so, how do I do it exactly? All I can find is tutorials on how to install it on Apache. If anyone knows the answer can you please help me? I'm desparate. Thanks in advance.

View Replies !

Include PEAR DB Framework Using PHP 5.0.4 On Windows 2000
Get the following errors when trying to include PEAR DB framework using
PHP 5.0.4 on Windows 2000 with Apache 2.

Warning: main(PEAR-1.3.3/DB/DB.php) [function.main]: failed to open
stream: No such file or directory in E:Program FilesApache
GroupApache2htdocsservusincludesinclude.php on line 19

Fatal error: main() [function.require]: Failed opening required
'PEAR-1.3.3/DB/DB.php' (include_path='.includes;.') in E:Program
FilesApache GroupApache2htdocsservusincludesinclude.php on line 19

The include_path config variable looks like this:
include_path = ".includes;."

PHP is installed in
e:php-5.0.4
and the PEAR Class defs are in
e:php-5.0.4includesPEAR-1.3.3DBDB.php

The includes that fail are:
include_once("PEAR-1.3.3/DB/DB.php");

These worked with 4.4.0, but fail with 5.0.4 ...

View Replies !

MySQL 'update' Not Working..
I'm setting up a website on which you have to pay for membership. I allow the user to register with an 'elec' field in the database as '0'. The 'elec' field is '0' when they haven't paid and '1' when they have.

I've tested it and the login/register scripts work fine but i cant get it to change 'elec' to '1'. I use a separate script to buy elec, as shown below. Code:

View Replies !

Mysql Update Not Always Working?
My code works most the time but occasionaly it does not update a users count, this is a weird issue but very important to get resolved, any ideas what would cause this PHP Code:

$sql2= "update friend_user_photo set comments=comments + 1 WHERE auto_id='$photoid'";
executequery($sql);

View Replies !

Update To The Mysql Database Is Not Working?
Any ideas why this update to the mysql database is not working? PHP Code:

$email=$_POST['email'];
        $temp=$_POST['temp'];
        $pass=$_POST['pass'];

        $sql="update config set Passwd='".$pass."', Template='".$temp."', Email='".$email."'";
        $result=mysql_query($sql, $conn);

        if(!$result){

            echo "there is a problem";
            echo "<script>setTimeout("window.location='index.php?action=config'",1400);   </script>";

        }else{
........................

View Replies !

Mysql Update Query Not Working In Code
I would like to ask how to update a database using the php script. Below is the code that I used for updating but for some reasons it does not seem to work. Code:

View Replies !

MS-SQL Server 2000
i have a huge database that is mantained and updated on a daily basis. It is on a MS-SQL 2000 server. I need that data to be exported, preferably by a php script using a cron job every morning, to a MySQL database if anything has changed. I can write the code to do the SQL stuff and maipulate the data, but i'm confused as hell as how to connect to a MS-SQL server using either windows or linux (preferably linux) in order to GET the data!
php's documentation of MS-SQL functions is very "lacking".

View Replies !

MySQL On Windows 2003 Server
I have installed PHP verr 4.x and MySQL 4.1 on a Windows 2003 Standard Server running IIS. I am trying to install phpadsnew an adserving program.

However when I specify the username, password and table during installation it says Could not connect to database. Whereas the same thing installed without any error on a Windows XP Pro machine. Do I need to install MyODBC drivers or something similar.

View Replies !

5 / SQL Server 2000 Problem
I just setup my server with IIS6, PHP5, and all that's working great. Now I'm trying to install SQL Server 2000, and I'm running into one particular problem.

When I add the extension in php.ini for php_mssql.dll, then try to connect to to the database i created for it... all it does is sit there looping forever "waiting for "servername"".....

I installed client network unitlity, created alias with IIS virtual directory..

View Replies !

PHP/MySQL On Windows 2003 Server 64bit
We're looking at getting a hosted dedicated web server to host our
PHP4/MySQL4 websites. It needs to be a MS Windows server as we use .NET Web
Services for a lot of background communications.

We've found what appears to be a fantastic hosting package but it is on
Windows 2003 Server **64 bit edition**.

Are there any problems with PHP4/MySQL4 on 64 bit servers?
Are these problems easy to overcome?

View Replies !

PHP With ADO Stored Procedures In SQL Server 2000
here is the problem..

When this procedure runs I am supposed to get 2 output parameters.
When an insert statement is going to generate duplicate names I get 1
for @checker and 3 for @insertid. When the Insert statement runs
properly I am supposed to get 2 for @checker and an actual identity
for @insertid.

When using the code below, the part where the insert statement is
unsuccessful works just as desired, however the part where it inserts
the record returns zeros for both parameters.

When the stored procedure is run using query analyzer it performs
correctly in both instances.

Here is my PHP code

$cmd = new COM("ADODB.Command", NULL, CP_UTF8);
$cmd->CommandText = "STP_insertartist";
$cmd->CommandType = 4;
$cmd->ActiveConnection = $conn;
$par=$cmd->Parameters;
$par->Append($cmd->CreateParameter("@firstname",200,1,50,$_POST["txtfname"]));
$par->Append($cmd->CreateParameter("@lastname",200,1,50,$_POST["txtlname"]));
$par->Append($cmd->CreateParameter("@livedate1",3,1,9,$begdate));
$par->Append($cmd->CreateParameter("@livedate2",3,1,9,$enddate));
$par->Append($cmd->CreateParameter("@style",200,1,300,$_POST["txtstyle"]));
$par->Append($cmd->CreateParameter("@datedescription",200,1,75,$datetext));
$par->Append($cmd->CreateParameter("@insertid",3,2,4));
$par->Append($cmd->CreateParameter("@checker",3,2,4));
$rec=$cmd->Execute;
$invid=$cmd->Parameters["@insertid"]->Value;
$check=$cmd->Parameters["@checker"]->Value;
echo("Check: ".$check." Invid: ".$invid);.........

View Replies !

Problem Running PHP Script On 2000 Server
I am a web designer, and to process a form I placed a PHP script in it. The script sends input to an e-mail and writes it to a comma-delimited file as well.
Well, I tested it on a Linux server and it works fine. However, when the IT guys placed it on a Windows 2000 server, the form does not process. I got this message from IT:

"I tried installing Apache Webserver for windows and it displays the script on the screen when submitted but does not run the form. Rick, Is there anyway you can convert PHP -> ASP?" Code:

View Replies !

Copy Command Available In Windows?
Is the copy command available for use on a windows system. I have tried to run a script using it (taken directly out of a PHP manual) and am receiving a "parse error".

View Replies !

Update Command
For some reason, I am not able to update the database when I run this command. (of course the data is coming from an HTML form). Code:

View Replies !

UPDATE Command In Php
I'm currently using the update command with myphp admin, but I need an alternative that I can use within a php page.

UPDATE table SET field1 = (field2 + field3)

Can anyone show me what the php code would be.

View Replies !

[windows] PHP.GTK And Popuped Command Line
i compile php.gtk file with roadsend php compiler. Is here possiblity to
have windows program without starting command line window?

View Replies !

Windows Program Command Exists
I can do this so easily in Unix: PHP Code:

$msg = exec('whatis convert 2>&1');
echo $msg;

However, in Windows using MS-DOS, I'm utterly lost. I am having to find out if ImageMagick is installed on a system for a function to operate (ImageMagick is required), and since this is a portable web application, you simply can't install ImageMagick everywhere you go.

Therefore I need to know if the system home has ImageMagick or not, and in Unix, I simply do a "whatis convert" and I can tell, but since MS-DOS has no equivalent to "whatis" I can't figure it out, and just running the "convert" command within a recursive function onto thousands of images is just not a good idea.

View Replies !

Update Command Problems
I been trying to create a form to update the database for me, but everything i hit submit the command does not update. Here is the Code:

<?php require_once 'conn.php'
$update = "UPDATE images
SET
type = '".$_GET['type']."',
title = '".$_GET['title']."',
comment ='".$_GET['comment']."'
WEHRE
id = '".$_GET['id']."' ";
$result = mysql_query( $update );
?>

View Replies !

Running PHP Scripts From The Command Line Under Windows
I was wondering if anyone has ever tried running PHP scripts from the DOS command prompt. Any insight would be appreciated.

View Replies !

Running A Windows Command Line From A Web Page
I have a web page on an intranet, i need to run a command in the local windows run from the webpage. for example when you press a button button on a webpage it has the same effect as running cmd from the run prompt on the local machine. Anyone know how to do this?

View Replies !

MySql Permission Problems (Win 2000)
I screwed up the permissions on my database. Basically I revoked all
the permissions of the root account on the mysql table.

To try to fix this, I went through all of the instructions here:

http://dev.mysql.com/doc/refman/5.0...ermissions.html

running:
mysqld-nt.exe --defaults-file="C:Program FilesMySQLMySQL Server
5.0my.ini" --init-file=C:mysql-init.txt

except in the mysql-init.txt file I put this:

GRANT ALL ON mysql.* TO root

View Replies !

MYSQL Select Using BETWEEN '1/1/2000' And '1/1/2004'
What is the syntax for a mysql select statement to select values between a range of dates. I am trying to use:

SELECT * from net5 WHERE Transaction_Date between '6/7/2004' and '11/3/2004'

My dates are stored as date_time in the database.

View Replies !

Virtual Command Not Working
I'm really an ASP coder but have been asked to fix someones php site. I've had a look at their pages and none of the php pages that are using the "virtual()" command are working.

When I replace the command with the include() command they seem to work again.

Can anyone tell me why the virtual may have stopped working (it was working before) and another fix apart from replacing all instances of virtual with include? I'm not really sure what the difference is between them..

View Replies !

Include Command Stopped Working
It's just making the time in a hectic schedule for one more unexpected project that I'm hoping to delay. Anyway, it involves php so I'm hoping someone here might be able to give me a work around. Code:

View Replies !

Automatically Update Database On Server Usign Php.e.g Mysql Database
I want to automatically update database on server usign php.e.g mysql database on web server and oracle is on local pc one php take data from the oracle and check on web server using the php and if some data is difference between oracle and mysql than that php page upload data on web server.

View Replies !

Working With Different Windows
I have a user in window A pressing a button that makes window B come up, the user enters some data in window B and once done presses a submit button that processes the input. When all is OK, I want to close window B and refresh window A.

View Replies !

Passing A Value (eg Id) From A Apache Server To A Windows Server
I am trying to pass an Id from one server to another. The case is like this I have two scripts one in php and the other in asp. I am trying to combine the both together by passing an Id from php script to an asp script. The problems come on the client side because the information is on two different servers. Is there a way around this? Can this be accomplished?

View Replies !

E-mail From Linux Server But Not Windows Server
The following one-liner sends mail from a Linux server but not from their Windows server.

mail ("admin@mydomain.com", "Subject", "body");

What do I need to check / change, please?

View Replies !

Ssh2_exec On Windows Not Working
i can't seem to get the "ssh2_exec" function working on Windows XP. the
example in the manual (which is obviously linux biased) says:

ssh2_exec($connection, '/usr/local/bin/php -i');

i have tried the windows equivalent:

ssh2_exec($connection, 'c:phpphp.exe c:some_file.php');

.... along with many other variations, but nothing seems to be working.
does anyone know what i could be doing wrong?

View Replies !

Ticks Not Working Under Windows
The code at bottom crashes apache when run on a windows. I have tried
both PHP/4.3.9 with Apache/1.3.27 and PHP/5.0.3 with Apache/2.0.49, same
thing happens.

Same code runs fine under Linux (PHP/4.3.4 with Apache/2.0.48)

On http://bugs.php.net/ there is a couple of bug reports on the same,
but 1 is closed and the others has status "bogus".

Does anybody know what that is all about?

/Bent

<?php
header('Content-Type: text/plain');

function tick_function() {
echo "..tick..
";
}

register_tick_function('tick_function');
declare(ticks=1);

echo "line 1
";
echo "line 2
";
echo "line 3
";
?>

View Replies !