取得Insert data 後的Mysql auto_increment 值

<？ mysql_query("INSERT INTO...."); echo mysql_insert_id(); ？>

or

<？ mysql_query("INSERT INTO...."); mysql_query("SELECT LAST_INSERT_ID()"); ？>

c# 判斷字串是否為空值IsNullOrEmpty

若有一個字串為空值，例如： string a=""; string b=null; string c=string.Empty; 所以要判斷a、b、c是否為空值,可以使用IsNullOrEmpty來判斷，所以上面三個字串，其結果皆為true。 string.IsNullOrEmpty(a) = true； string.IsNullOrEmpty(b) = true； string.IsNullOrEmpty(c) = true；

上一篇下一篇

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>



    


    

    

      

               
                
      上一篇：下一篇： 
    
    

.cs頁面

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
    CommonClass CC = new CommonClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string id = Request["id"].ToString();
            bindNext(Convert.ToInt32(id));
        }
    }
    private void bindNext(int id)
    {
        int lastid = id - 1;
        int nextid = id + 1;
        this.ViewState["NextDetails"] = nextid.ToString();
        this.ViewState["lastid"] = lastid.ToString();
        this.ViewState["nextid"] = nextid.ToString();
        if (lastid > 0)
        {
            string sql = "select * from news where id=" + lastid + "";
            DataSet ds = CC.GetDataSet(sql, "dttit");
            DataRow[] row = ds.Tables["dttit"].Select();
            foreach (DataRow rs in row)
            {
                this.lbName.Text = rs["title"].ToString();
                this.lkLast.Text = rs["title"].ToString();
                this.ViewState["lastDetails"] = rs["content"].ToString();
            }

        }
        else
        {
            this.lkLast.Text = "已經是第一篇";
        }
        string sql1 = "select * from news where id=" + nextid + "";
        DataSet ds1 = CC.GetDataSet(sql1, "dttit");
        DataRow[] row1 = ds1.Tables["dttit"].Select();
        foreach (DataRow rs1 in row1)
        {
            this.lbName.Text = rs1["title"].ToString();
            this.lkNext.Text = rs1["title"].ToString();
            this.ViewState["nextDetails"] = rs1["content"].ToString();
        }

    }
    protected void lkLast_Click(object sender, EventArgs e)
    {
        this.LbDetails.Text = this.ViewState["lastDetails"].ToString();
        int id = Convert.ToInt32(this.ViewState["lastid"].ToString());
        bindNext(id);
    }
    protected void lkNext_Click(object sender, EventArgs e)
    {
        this.LbDetails.Text = this.ViewState["nextDetails"].ToString();
        int id = Convert.ToInt32(this.ViewState["nextid"].ToString());
        bindNext(id);
    }
}

自動連線網路磁碟

net use t: \\user-PC\share /user:share 12345678

不允許使用多於一個使用者名稱的相同使用者有多個連線到一個伺服器或公用資源.......

不允許使用多於一個使用者名稱的相同使用者有多個連線到一個伺服器或公用資源.......
依序使用下列方法解看看：
1. 先查看一下我的電腦, 看是否有 \\192.168.0.10\e$ 的 網路磁碟機連線.
2. 刪除連線磁碟 net use \\172.17.16.17\e$ /delete
3. 如果還是不行呢！ 假設您是用\\IP\資料夾連線或是設定連線磁碟機，嘗試改用\\主機名稱\資料夾，不同就反之。

backup_tables

< ?php 
backup_tables('localhost','root','xxxxxxx','dbname');

/* backup the db OR just a table 
$hostname 主機名稱
$username 帳號
$password 密碼
$dbname   資料庫名稱
*/

function backup_tables($hostname,$username,$password,$dbname,$tables = '*')
{
 
 $link = mysql_connect($hostname,$username,$password);
 mysql_select_db($dbname,$link);
 
 //get all of the tables
 if($tables == '*')
 {
  $tables = array();
  $result = mysql_query('SHOW TABLES');
  while($row = mysql_fetch_row($result))
  {
   $tables[] = $row[0];
  }
 }
 else
 {
  $tables = is_array($tables) ? $tables : explode(',',$tables);
 }
 
 //cycle through
 foreach($tables as $table)
 {
  $result = mysql_query('SELECT * FROM '.$table);
  $num_fields = mysql_num_fields($result);
  
  $return.= 'DROP TABLE '.$table.';';
  $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
  $return.= "\n\n".$row2[1].";\n\n";
  
  for ($i = 0; $i < $num_fields; $i++) 
  {
   while($row = mysql_fetch_row($result))
   {
    $return.= 'INSERT INTO '.$table.' VALUES(';
    for($j=0; $j<$num_fields; $j++) 
    {
     $row[$j] = addslashes($row[$j]);
     $row[$j] = ereg_replace("\n","\\n",$row[$j]);
     if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
     if ($j<($num_fields-1)) { $return.= ','; }
    }
    $return.= ");\n";
   }
  }
  $return.="\n\n\n";
 }
 
 //save file
 $handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');
 fwrite($handle,$return);
 fclose($handle);
}
? >

php 連接 mssql

我的程式

<？php
//mssql.secure_connection = On
// Need to upload ntwdblib.dll from net

$myServer = ".\SQLEXPRESS"; // host/instance_name
$myUser = "sa"; // username
$myPass = "xxxxxxxx"; // paasword
$myDB = "mydb"; // database name

// connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn’t connect to SQL Server on $myServer");

// select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn’t open database $myDB");

echo "You are connected to the " . $myDB . " database on the " . $myServer . ".";

$query = "SELECT top 10 * FROM Account"; // your database query
$result = mssql_query($query);
while($row = mssql_fetch_assoc($result))
{
print_r($row);
}
// close the connection
mssql_close($dbhandle);

？>

在連接 mssql 時出現這個問題
“Warning mssql_connect()[function.mssql-connect]: Unable to connect to server:”

解決方法
1.修改 php.ini 打開php.ini
找到 ;extension=php_mssql.dll
打extension=php_mssql.dll 前面的 “;” 刪除便可以了

2.下載 ntwdblib.dll
之後把他複製/取代 你電腦上的
Apache/bin/ntwdblib.dll 和 php/ntwdblib.dll

3. Apache Restart

再測就OK了