manipulate data of mdb access file with php

$dbConn = new COM("ADODB.Connection");

$dbConn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='C://InsertAccessFileNameHere.mdb';");

$rs = $dbConn->execute("SELECT TOP 3 * FROM TableNameHere");

while ( ! $rs->EOF ) {

  for ( $i = 0; $i < $rs->Fields->Count(); $i++ ) {
    echo $rs->Fields( $i )->value, ' ';
  }
  echo '<br>'; $rs->MoveNext();
}

$rs->Close(); $dbConn->Close();
Advertisements

Alterar DNS no DOS

1 – Abra o prompt de comando DOS como Administrador

2 – Veja o nome das interfaces de rede

netsh interface show interface

3 – Defina o DNS primário e secundário(opcional)

netsh interface ip add dns name="interface-name-here" addr=8.8.8.8 index=1
netsh interface ip add dns name="interface-name-here" addr=8.8.4.4 index=2

4 – Atualize as configurações de DNS das interfaces de rede

ipconfig /flushdns