Connect To Database

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Connect To Database as PDF for free.

More details

  • Words: 505
  • Pages: 4
Connect to database : trang này đã được đọc

lần

COPYRIGHT BY MRRO WINDAK UPGRADE


align="center"> CONNECT TO DATABASE

align="center">Upgraded by Windak

align="center">Version 2.0

align="center">



method=post>
Server
Username
Password
Database
Table

where =

set =

where =

SQL Command:

{ $query="Update $table set $column1='$value1' where $column2='$value2'"; } else die("PLEASE CORRECT YOUR INPUT"); } //Chay mysql_select_db($database); $res=mysql_query($query); echo " " ; echo ""; $ncols = mysql_num_fields($res); while($i<$ncols) { $meta = mysql_fetch_field ($res); echo "" ; $i++; } echo ""; while($data=mysql_fetch_array($res)) { echo(""); for($i=0; $i<$ncols; $i++) { echo ""; } echo(""); } mysql_free_result($res); } //Click ListDB else if (isset($HTTP_POST_VARS['ListDB'])) { $conn = mysql_connect("$server","$username","$password"); $db_list = mysql_list_dbs($conn); if (!$db_list) { echo mysql_error(); exit; } while ($row = mysql_fetch_object($db_list)) { $rdata = $row->Database ; $tb_list = mysql_list_tables($rdata); if (!$tb_list) { echo "$rdata "; } else echo "$rdata "; }

} else if (isset($HTTP_GET_VARS['db'])) { //Get info $database=$HTTP_GET_VARS['db']; $username=$HTTP_GET_VARS['user']; $password=$HTTP_GET_VARS['pass']; $server=$HTTP_GET_VARS['server']; //Test permission if (!mysql_connect("$server","$username","$password")) { echo mysql_error(); exit; } $tb_list = mysql_list_tables($database); // Okie List while ($row = mysql_fetch_row($tb_list)) { echo "$row[0] "; } mysql_free_result($tb_list); } ?>
". $meta->name ."
". $data[$i] ."

Related Documents

Connect To Database
May 2020 6
Connect
June 2020 17
Connect
October 2019 26
Connect Fluids To Particles
November 2019 15