[Golith]

Hi all,

not strong with JS so i hope there is someone out there who can help

here is the code

PHP Code:

function DumpSQL( $result ){

     if($result == 0) 

    { 

        echo "<b>Error ".mysql_errno().": ".mysql_error()."</b>"; 

    } 

    elseif (@mysql_num_rows($result) == 0) 

    { 

        echo("<b>Query completed. No results returned.</b><br>"); 

    } 

    else 

    { 

        echo "<table border='1'> 

            <thead> 

            <tr><th>[Item]</th>"; 

        for($i = 0;$i < mysql_num_fields($result);$i++) 

        { 

            echo "<th>" . mysql_field_name($result, $i) . "</th>"; 

        }

        echo"<th> Active </th>";

        echo "<th> Update </th>";

        echo "<th> Delete </th>"; 

        echo "  </tr> 

            </thead> 

            <tbody>"; 

        for ($i = 0; $i < mysql_num_rows($result); $i++) 

        { 

            echo "<tr><td>[$i]</td>"; 

            $row = mysql_fetch_row($result); 

            for($j = 0;$j < mysql_num_fields($result);$j++)  

            {

            if (stristr($row[$j],"http")){

                 echo("<td> <a href=" . $row[$j] . "> " . $row[$j] . "</a></td>");

                }

                else{

                    echo("<td>" . $row[$j] . "</td>"); 

                }

            } 

            // check if active or not then place right icon

            echo "<td align=center>" ?> <img src="images/green_tick.png" width="30" height="30"><img src="images/red_cross.jpg" width="30" height="30"> <?php "</td>";            

            echo "<td>" ?> <form><input type = "submit" name = "update" value = "update"></form> <?php "</td>";

            echo "<td>" ?> <form><input type = "submit" name = "del_file" value = "del_file" ></form> <?php "</td>";

                        echo "<td>" ?> <form><input type = "submit" name = "del_row" value = "del_row" ></form> <?php "</td>";

            echo "</tr>"; 

        } 

        echo "</tbody> 

        </table>"; 

    }  //end else

I am trying to make the last 3 buttons with name update and del_* do stuff.
Update needs to update a file pulling xml of the web.
Del_file need to delere a file from my server.
Del_row needs to delete the entry from the database .

I can do these things manually but want to wire the buttons to do the job

PHP Code:

function copyxml($file1,$file2){ 

          $contentx =@file_get_contents($file1); 

          $openedfile = fopen($file2, "w"); 

          fwrite($openedfile, $contentx); 

          fclose($openedfile); 

              if ($contentx === FALSE) { 

                $status=false; 

            }

            else $status=true; 

                    

           if (!copyxml($file1, $file2)){

    echo "failed to copy $file1...\n";

}

else{

echo " copied $file1 successfully!!!...\n";

} 

for example this function copies stuff from the web
Anyone got a suggestion ??

[jsNewbie]

Hi Golith,

Do you need to accomplish this without a page reload? If not, why not just use php to execute like below?

I have edited only the form part of your code below:
// check if active or not then place right icon
echo " <form name=form method=post action=[filename].php>\n";
echo "<td align=center>" ?> <img src="http://www.hotscripts.com/forums/images/green_tick.png" width="30" height="30"><img src="http://www.hotscripts.com/forums/images/red_cross.jpg" width="30" height="30"> <?php "</td>";
echo "<td><input type = submit name = update value = update></td>";
echo "<td> <form><input type = submit name = del_file value = del_file ></td>";
echo "<td><input type = submit name = del_row value = del_row ></td>";
echo "</tr>";
echo "</form>\n";

Then, above the opening html tag:

if(!empty($_POST[update])) {
//perform relevant update
}

if(!empty($_POST[del_file])) {
//delete file from server
}

if(!empty($_POST[del_row])) {
//delete the row from the database
}

Good luck!

[Golith]

thanx will give it a go ..