Linux, Apache, MySQL, PHP

Mohibur Rashid11-Aug-11 22:48

Mohibur Rashid

11-Aug-11 22:48

What type of request are you sending to server from your broswer?
is it ajax request ? normal request?

doitnow114711-Aug-11 23:18

11-Aug-11 23:18

its a normal request. i am just opening the page in localhost or server.

doitnow114711-Aug-11 23:28

11-Aug-11 23:28

It's VERY frustrating for me , i am facing this problem for past 2 month. but i am not able to find any soln. for it.

Peter_in_278011-Aug-11 23:39

Peter_in_2780

11-Aug-11 23:39

Have you done this[^] yet? It will take a lot less than 2 months.

Peter

Software rusts. Simon Stephenson, ca 1994.

doitnow114711-Aug-11 23:44

11-Aug-11 23:44

what is this? i don't understand. i have tested the code using basic insertion and using some complicated code. but i am not able to find any soln for it.using live http header . but did not find any soln.

Peter_in_278012-Aug-11 0:01

Peter_in_2780

12-Aug-11 0:01

If your SQL code is getting run twice for a particular browser but not others, you need to find out how many HTTP requests and responses are sent. LiveHTTPHeaders is a Firefox plugin, so can't see what happens on other browsers. Wireshark is independent of the browser, so it provides an impartial record of the HTTP traffic. If there is one request/response when it fails, then the problem is on the server side. If there are two, then you need to find out what is causing the second one. Javascript/JQuery in the browser, maybe?

Software rusts. Simon Stephenson, ca 1994.

doitnow114712-Aug-11 0:02

12-Aug-11 0:02

ok let me try this one. than i will reply.
thanks for suggestion.

Mohibur Rashid12-Aug-11 0:12

Mohibur Rashid

12-Aug-11 0:12

if you are running the server in Linux then execute the code
and see how its behave:
>php test.php

if you found two entry then something is not right about your php

you also try the same statement in mysql from command prompt

By the way, tell me this. did you installed phpmyadmin?

try to insert from phpmyadmin, if it insert more than one input php, try reinstall it. i am not sure is there any thing to do with your apache installaion and configuration

doitnow114712-Aug-11 0:20

12-Aug-11 0:20

problem is that when i echo my mysql query it show only one time but it execute the code two times. and i have also tested the sql directly into the phpmyadmin but there its working fine.

doitnow114712-Aug-11 2:09

12-Aug-11 2:09

i have found the soln.for the problem. when i have tested the code on other pc with firefox than it running perfectly fine so i have tested the header request and found out that it sending two url request. so i Google it and found out that its happening because of yslow add-on. when i disable it query running fine. thanks to you guys for your valuable suggestion.

doitnow114711-Aug-11 20:53

11-Aug-11 20:53

now i have tested simple php code . this one

PHP

mysql_query("insert into test('1','12345')");

just this code and i am facing the same problem.
it inserting the two times data into the test table.

Peter_in_278011-Aug-11 18:58

Peter_in_2780

11-Aug-11 18:58

The first step is to see what is happening twice. Fire up Wireshark and capture the HTTP requests and responses. Compare the results from the different browsers and find where the difference is. Then you will know where to look next.

Cheers,
Peter

Software rusts. Simon Stephenson, ca 1994.

doitnow114711-Aug-11 19:23

11-Aug-11 19:23

ok i will do that
thanks

doitnow114711-Aug-11 20:54

11-Aug-11 20:54

now i have tested simple php code . this one

PHP

mysql_query("insert into test('1','12345')");

just this code and i am facing the same problem.
it inserting the two times data into the test table.

Mohibur Rashid12-Aug-11 19:58

Mohibur Rashid

12-Aug-11 19:58

Here is another way of testing.

SQL

CREATE TABLE tbltest(id integer primary key auto_increment, testvalue varchar(20) not null);

PHP

<?php
$value=$_POST['TestValue'];

$qShowStatus = "SHOW TABLE STATUS LIKE 'tbltest'";
$qShowStatusResult = mysql_query($qShowStatus);
$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];

$Query="Insert into tbltest(testvalue) value('".$value."')";
$res=mysql_query($Query,$conn);

$id=mysql_insert_id($res);

echo "What was suppose to be :".$next_increment."<br>What you got: ".id;
?>
<FORM method=get>
<input name='TestValue'>
<input type=submit value=submit>

Try the code
hit the button once
and see what you receive.
And Before running the code
run this line in your mysql cmd clined:
SHOW TABLE STATUS LIKE 'tbltest'
I guess you will understand what are you making mistake

doitnow114712-Aug-11 20:10

12-Aug-11 20:10

OK I WILL TEST THIS CODE

doitnow114712-Aug-11 21:42

I need help in learning php

12-Aug-11 21:42

binngokute10-Aug-11 5:48

binngokute

10-Aug-11 5:48

I'm learning advanced php, so I need someone show me how to learn effective as well as some advanced exercises.
thank for your help!

Re: I need help in learning php

Dr.Walt Fair, PE10-Aug-11 8:28

Dr.Walt Fair, PE

10-Aug-11 8:28

I bought a book at Barnes & Noble, the store, not online, but you could start here: Learning advanced PHP[^].

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Is Windows Server Support File Uploads? [modified]

Arunkumar.Koloth3-Aug-11 21:37

Arunkumar.Koloth

3-Aug-11 21:37

Hi All

Now Iam In A Problem Is it possible to upload file to a windows server?

i used this code for uploading file i got this code from w3schools.com

HTML

<form action="upload_file.php" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>

PHP

if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      }
    }
  }
else
  {
  echo "Invalid file";
  }

This Script is Working Good On My Local wamp server and also working fine in my linux server

i checked phpinfo() of my windows server

fileupload is on
and max_upload size is 32 mb
Thease Are My Server informations

OS/Hosting Type: Windows / 4GH Web Hosting
Hosting Configuration:
.Net Runtime Version: ASP.Net 2.0/3.0/3.5
PHP Version: PHP 5.3
IIS Version: IIS 7.0

Please Help Me To Do This

Arunkumar.T
Cry | :((

modified on Thursday, August 4, 2011 7:02 AM

cjoki4-Aug-11 4:29

cjoki

4-Aug-11 4:29

use this to make sure the file is posting the data to the server.

<?php
echo "<pre>";
print_r($_POST);
print_r($_FILES);
echo "

";
?>

place that at the top of the script you are posting to (upload_file.php) and run it. If your post and files are getting to the server then look at your file permissions of the target directory and of the upload_file.php and make sure they are permitted to do what you want them to do.

Chris J
www.redash.org

Arunkumar.Koloth5-Aug-11 6:45

Arunkumar.Koloth

5-Aug-11 6:45

Thank you For Helping me cjoki

I Done What you Said Igot this message

i got message like this

PHP

Array
(
    [submit] => Submit
)
Array
(
    [file] => Array
        (
            [name] => Water lilies.jpg
            [type] => image/jpeg
            [tmp_name] => D:\Temp\php\php9B61.tmp
            [error] => 0
            [size] => 83794
        )
)

I Thing It Seems Ok But The File Uploading Is Failed
Can you Tell Me Why This Happen ?

Please Help Me?

Arunkumar.T
Cry | :((

cjoki5-Aug-11 8:38

cjoki

5-Aug-11 8:38

Your file upload did not fail...but looking at your echoed $_FILES data and your code snip the issue looks to be in this area...can you see it?

if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))

compare this to your last post.

Chris J
www.redash.org