como faço para ver as tabelas de um banco de dados em MSSQL ?
tentei "SHOW TABLES" mais não rolo
to usando assim?
$query = mssql("SHOW TABLES");
alguem pode me ajudar?
obrigado!
There have been 31 items by _tHeFlAsH_ (Search limited from 10/05/2023)
Posted by _tHeFlAsH_ on 28/01/2007, 19:43 in Microsoft SQL Server
$query = mssql("SHOW TABLES");
Posted by _tHeFlAsH_ on 25/10/2006, 13:58 in PHP
Posted by _tHeFlAsH_ on 16/06/2006, 00:43 in Artigos, Dicas e Tutoriais de PHP
Posted by _tHeFlAsH_ on 16/06/2006, 00:54 in PHP
Posted by _tHeFlAsH_ on 19/10/2006, 14:18 in PHP
Posted by _tHeFlAsH_ on 18/06/2006, 18:16 in BrainStorm Design
Posted by _tHeFlAsH_ on 18/06/2006, 15:21 in PHP
Posted by _tHeFlAsH_ on 16/06/2006, 01:05 in PHP
<?php if(isset($_GET['page'])) { include ("".$_GET['page'].".php"); } else { include ("principal.php"); } ?>
Posted by _tHeFlAsH_ on 18/06/2006, 18:05 in BrainStorm Design
Posted by _tHeFlAsH_ on 13/06/2006, 20:34 in PHP
Posted by _tHeFlAsH_ on 13/06/2006, 14:40 in PHP
class Gerenciador { var $Caminho = "/home/index/public_html/sit/gerenciador/"; var $Login; var $NomeArquivo; function CriaTabela_PaginaDados($login_cliente) { $this -> NomeArquivo = $_POST['nome_arquivo']; $sql = mysql_db_query($bancodedados, " CREATE TABLE `".$login_cliente."_".$_POST['nome_arquivo']."` ( `uid` INT( 5 ) NOT NULL AUTO_INCREMENT, `nome_arquivo` VARCHAR( 250 ) NOT NULL , `titulo` VARCHAR( 250 ) NOT NULL , `imagem_titulo` VARCHAR( 250 ) NOT NULL , `texto` TEXT NOT NULL , PRIMARY KEY ( `uid` ) ); "); $executa = mysql_db_query($bancodedados, "INSERT INTO ".$login_cliente."_".$_POST['nome_arquivo']." (nome_arquivo, titulo, imagem_titulo, texto) VALUES ('".$_POST['nome_arquivo']."','".$_POST['titulo']."','".$arquivo_titulo_name."','".$_POST['mensagem']."')"); } }
Posted by _tHeFlAsH_ on 27/06/2006, 21:22 in Javascript / DOM / AJAX / ECMAScript
function troca(nome_camada, imagem_atualiza) { document[nome_camada].src = document[imagem_atualiza]; }
Posted by _tHeFlAsH_ on 27/06/2006, 22:13 in Javascript / DOM / AJAX / ECMAScript
Posted by _tHeFlAsH_ on 19/06/2006, 14:30 in BrainStorm Design
Posted by _tHeFlAsH_ on 15/09/2006, 15:30 in PHP
<?php if (!($connect = @ldap_connect("localhost"))) { die("Não foi possível se conectar com o servidor de AD<br>"); } else { echo "Conectado com sucesso !!!<br>"; } if (!($bind = @ldap_bind($connect, "uid=postmaster,ou=Usuarios,dc=cs,dc=intranet", "secret"))) { //se não validar echo "Usuário ou senha incorretos !!!<br>"; } else { //se validar echo "Usuário autenticado !!!<br>"; } ?>
<?php if (!($connect = @ldap_connect("192.168.200.1", 389))) { die("Não foi possível se conectar com o servidor de AD<br>"); } else { echo "Conectado com sucesso !!!<br>"; } if (!($bind = @ldap_bind($connect, "cn=postmaster,dc=cs,dc=intranet", "secret"))) { //se não validar echo "Usuário ou senha incorretos !!!<br>"; } else { //se validar echo "Usuário autenticado !!!<br>"; } ?>
Posted by _tHeFlAsH_ on 23/02/2007, 10:40 in ASP
Posted by _tHeFlAsH_ on 22/02/2007, 15:56 in ASP
Posted by _tHeFlAsH_ on 18/06/2006, 15:16 in PHP
mysql_query("INSERT INTO orcamento ( 'codigo' , 'nome' , 'descricao' , 'valor' , 'data' ) VALUES ('', '$nome', 'teste', '$preco', '$tempo');");
mysql_query("INSERT INTO orcamento (codigo, nome, descricao, valor, data) VALUES ('', '$nome', 'teste', '$preco', '$tempo')");
$sql = "INSERT INTO orcamento (codigo, nome, descricao, valor, data) VALUES ('', '$nome', 'teste', '$preco', '$tempo')"; $exe = mysql_db_query($database, $sql);
Posted by _tHeFlAsH_ on 05/10/2006, 21:53 in Teoria de Programação
Posted by _tHeFlAsH_ on 10/10/2006, 09:08 in Teoria de Programação
Posted by _tHeFlAsH_ on 18/06/2006, 16:14 in PHP
Posted by _tHeFlAsH_ on 19/06/2006, 10:50 in PHP
Posted by _tHeFlAsH_ on 18/06/2006, 10:39 in PHP
function unzip($dir,$file) { $zip = zip_open($dir.$file.".zip"); if ($zip) { mkdir($dir.$file); while ($zip_entry = zip_read($zip)) { if (zip_entry_open($zip,$zip_entry,"r")) { $buf = zip_entry_read($zip_entry, zip_entry_filesize($zip_entry)); $hostDir = dirname(zip_entry_name($zip_entry)); /* for root "." directory nothing to be done coase root directory was created before the while-loop statement */ if ($hostDir != ".") { $absPathToHostDir = $dir.$file."\\"; /* Convrerts path string upon to FMS & OS-WIN configuration */ foreach ( explode("/",$hostDir) as $k) $absPathToHostDir = $absPathToHostDir . $k . "\\"; $absPathToHostDir = substr($absPathToHostDir,0,-1); if (is_file($absPathToHostDir)) unlink($absPathToHostDir); if (!is_dir($absPathToHostDir)) mkdir($absPathToHostDir); /* Stores Archive entries BOTH as file: Directories & Files; for this porpose we need these 2 hereabove [IF] checks */ $fp=fopen($dir.$file."\\".zip_entry_name($zip_entry),"w"); fwrite($fp,$buf); fclose($fp); zip_entry_close($zip_entry); } } else { echo "unable open - "; return false; } } // while-loop end zip_close($zip); } else return false; return true; }
Posted by _tHeFlAsH_ on 23/08/2006, 09:34 in PHP
Posted by _tHeFlAsH_ on 22/08/2006, 17:53 in PHP
// Cria arquivo named.conf $nome_named = fopen("/etc/named.conf" , "w+"); $escreve_named = fwrite($nome_named, $named);
Community Forum Software by IP.Board
Licensed to: Webmasters Online