    <div class="row">
        <div class="col-12">
			<pre class="with-hljs"><code class="lang-php">&lt;?php include(&quot;auth.php&quot;);
session_start();
require(&quot;conn.php&quot;);
$action = &quot;Add&quot;;
$id = null;

if ($_SERVER[&#039;REQUEST_METHOD&#039;] === &#039;POST&#039; &amp;&amp; isset($_POST[&#039;id&#039;], $_POST[&#039;status&#039;])) {
    $id = (int)$_POST[&#039;id&#039;];
    $status = $_POST[&#039;status&#039;];

    $sql = &quot;UPDATE tbl_wallet_withdraw SET status=? WHERE id=?&quot;;
    $stmt = $conn-&gt;prepare($sql);
    if (!$stmt) {
        die(&quot;Prepare failed: &quot; . $conn-&gt;error);
    }
    $stmt-&gt;bind_param(&quot;si&quot;, $status, $id);

    if ($stmt-&gt;execute()) {
        // 🔁 Reload SAME page (keeps any query string too)
        header(&quot;Location: &quot; . $_SERVER[&#039;REQUEST_URI&#039;]);
        exit;
    } else {
        die(&quot;Error updating status: &quot; . $stmt-&gt;error);
    }
}

?&gt;

&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;

&lt;head&gt;
    &lt;meta charset=&quot;utf-8&quot;&gt;
    &lt;meta content=&quot;width=device-width, initial-scale=1.0&quot; name=&quot;viewport&quot;&gt;

    &lt;title&gt;Reward &lt;/title&gt;
    &lt;meta content=&quot;&quot; name=&quot;description&quot;&gt;
    &lt;meta content=&quot;&quot; name=&quot;keywords&quot;&gt;
    &lt;link href=&quot;assets/img/favicon.png&quot; rel=&quot;icon&quot;&gt;
    &lt;link href=&quot;assets/img/apple-touch-icon.png&quot; rel=&quot;apple-touch-icon&quot;&gt;
    &lt;?php include(&quot;templates/inc.php&quot;); ?&gt;

    &lt;script src=&quot;scripts/ManagePin.js&quot; type=&quot;text/javascript&quot; language=&quot;javascript&quot;&gt;&lt;/script&gt;


&lt;/head&gt;

&lt;body&gt;

    &lt;!-- ======= Header ======= --&gt;
    &lt;?php
    include(&quot;templates/header.php&quot;);
    ?&gt;

    &lt;!-- End Header --&gt;

    &lt;!-- ======= Sidebar ======= --&gt;
    &lt;?php
    include(&quot;templates/sidebar.php&quot;);

    ?&gt;
    &lt;!-- End Sidebar--&gt;

    &lt;main id=&quot;main&quot; class=&quot;main&quot;&gt;

        &lt;div class=&quot;pagetitle&quot;&gt;
            &lt;h1&gt;Withdrowal List&lt;/h1&gt;
            &lt;nav&gt;
                &lt;ol class=&quot;breadcrumb&quot;&gt;
                    &lt;li class=&quot;breadcrumb-item&quot;&gt;&lt;a href=&quot;dashboard.php&quot;&gt;Dashboard&lt;/a&gt;&lt;/li&gt;
                    &lt;li class=&quot;breadcrumb-item&quot;&gt;Reward&lt;/li&gt;

                &lt;/ol&gt;
            &lt;/nav&gt;
            &lt;hr&gt;
            
        &lt;/div&gt;&lt;!-- End Page Title --&gt;



      &lt;section class=&quot;section&quot;&gt;
        &lt;div class=&quot;row&quot;&gt;
          &lt;div class=&quot;col-lg-12&quot;&gt;

            &lt;div class=&quot;card&quot; style=&quot;overflow:scroll;&quot;&gt;
              &lt;div class=&quot;card-body&quot; id=&quot;records&quot;&gt;
              &lt;h5 class=&quot;card-title&quot;&gt;Withdrowal List&lt;/h5&gt;
                &lt;table class=&quot;table datatable&quot;&gt;
                  &lt;thead&gt;
                                        &lt;tr&gt;
										    &lt;th&gt;SL NO&lt;/th&gt;
											&lt;th&gt;UID&lt;/th&gt;
											&lt;th&gt;DATE&lt;/th&gt;
											 &lt;th&gt;AMOUNT&lt;/th&gt;
											  &lt;th&gt;BANK&lt;/th&gt;	
												&lt;th&gt;ACC.HO&lt;/th&gt;
												&lt;th&gt;ACC.NO&lt;/th&gt;
												 &lt;th&gt;IFSC&lt;/th&gt;
												  &lt;th&gt;STATUS&lt;/th&gt;
												
                                        &lt;/tr&gt;
                                    &lt;/thead&gt;
                                    &lt;tbody&gt;
                                        
                                    &lt;?php
									require &quot;./conn.php&quot;;
									 $sl=1;

									$cid=$_SESSION[&#039;v_code&#039;];
									$sql=&quot;select * from   tbl_wallet_withdraw order by trans_date desc&quot;;
									  $rs=mysqli_query($conn,$sql);
									  while($row=mysqli_fetch_assoc($rs))
									  { echo &#039;&lt;tr&gt;&#039;; 
											echo&#039;&lt;td&gt;&#039;.$sl.&#039;&lt;/td&gt;&#039;;
											echo&#039;&lt;td&gt;&#039;.$row[&#039;cid&#039;].&#039;&lt;/td&gt;&#039;;
										  echo&#039;&lt;td&gt;&#039;.$row[&#039;trans_date&#039;].&#039;&lt;/td&gt;&#039;;
											echo&#039;&lt;td&gt;&#039;.$row[&#039;amount&#039;].&#039;&lt;/td&gt;&#039;;
										
											echo&#039;&lt;td&gt;&#039;.$row[&#039;bank_name&#039;].&#039;&lt;/td&gt;&#039;;
											echo&#039;&lt;td&gt;&#039;.$row[&#039;account_holder_name&#039;].&#039;&lt;/td&gt;&#039;;
											echo&#039;&lt;td&gt;&#039;.$row[&#039;account_no&#039;].&#039;&lt;/td&gt;&#039;;
											echo&#039;&lt;td&gt;&#039;.$row[&#039;ifsc_code&#039;].&#039;&lt;/td&gt;&#039;;
										
											$status = $row[&#039;status&#039;];
                      $color = &quot;&quot;;
                      if ($status === &quot;Under Process&quot;) {
                          $color = &quot;background-color: yellow; color:black;&quot;;
                      } elseif ($status === &quot;Transfered&quot;) {
                          $color = &quot;background-color: green; color:white;&quot;;
                      } 

                      echo &quot;&lt;td&gt;
                              &lt;form method=&#039;post&#039; action=&#039;&#039; style=&#039;margin:0;&#039;&gt;
                                &lt;input type=&#039;hidden&#039; name=&#039;id&#039; value=&#039;&quot;.htmlspecialchars($row[&#039;id&#039;]).&quot;&#039;&gt;
                                &lt;select name=&#039;status&#039; class=&#039;status-select&#039; style=&#039;{$color}&#039; onchange=&#039;this.form.submit()&#039;&gt;
                                  &lt;option value=&#039;Under Process&#039; &quot;.($status===&quot;Under Process&quot;?&quot;selected&quot;:&quot;&quot;).&quot;&gt;Under Process&lt;/option&gt;
                                  &lt;option value=&#039;Transfered&#039; &quot;.($status===&quot;Transfered&quot;?&quot;selected&quot;:&quot;&quot;).&quot;&gt;Transfered&lt;/option&gt;
                                  
                                &lt;/select&gt;
                              &lt;/form&gt;
                            &lt;/td&gt;&quot;;
                      echo&quot;&lt;/tr&gt;&quot;;
										$sl++;
									  }
									  ?&gt;
                                        &lt;/tbody&gt;
                &lt;/table&gt;
              &lt;/div&gt;
            &lt;/div&gt;
          &lt;/div&gt;
        &lt;/div&gt;
        
      &lt;/section&gt;









    &lt;/main&gt;&lt;!-- End #main --&gt;

    &lt;!-- ======= Footer ======= --&gt;
    &lt;?php
    include(&quot;templates/footer.php&quot;);
    ?&gt;
    &lt;!-- End Footer --&gt;


    &lt;?php include(&quot;templates/vendors.php&quot;); ?&gt;

&lt;/body&gt;

&lt;/html&gt;</code></pre>        </div>
    </div>