php到asp.net转换 [英] php to asp.net convertion
问题描述
任何人请将此PHP代码转换为Asp.net vb代码或C＃代码
------
< br $> b $ b
<？php
define（''DBPATH''，''localhost''）;
define（''DBUSER''，''root''）;
define（''DBPASS''，''password''）;
define（''DBNAME''，''chat''）;
session_start（）;
global $ dbh;
$ dbh = mysql_connect（DBPATH，DBUSER，DBPASS）;
mysql_selectdb（DBNAME，$ dbh）;
if（$ _GET [''action''] ==chatheartbeat）{chatHeartbeat（）; }
if（$ _GET [''action''] ==sendchat）{sendChat（）; }
if（$ _GET [''action''] ==closechat）{closeChat（）; }
if（$ _GET [''action''] ==startchatsession）{startChatSession（）; }
if（！isset（$ _ SESSION [''chatHistory'']））{
$ _SESSION [''chatHistory'' ] = array（）;
}
if（！isset（$ _ SESSION [''openChatBoxes'']））{
$ _SESSION [''openChatBoxes''] = array（）;
}
函数chatHeartbeat（）{
$ sql = select * from chat where（chat.to =''。mysys_real_escape_string（$ _ SESSION [''username'']）。''AND recd = 0）order by id ASC;
$ query = mysql_query（$ sql）;
$ items ='''';
$ chatBoxes = array（）;
while（$ chat = mysql_fetch_array（$ query））{
if（！isset（$ _ SESSION [' 'openChatBoxes''] [$ chat [''from'']]）&& isset（$ _ SESSION [''chatHistory''] [$ chat [''from'']]））{
$ items = $ _SESSION [''chatHistory''] [$ chat [''from'']];
}
$ chat [''message''] = sanitize（$ chat [''message'']）;
$ items。=<< < EOD
{
s：0，
f：{$ chat [''from'' }}，
m：{$ chat [''message'']}
}，
EOD;
if（！isset（$ _ SESSION [''chatHistory''] [$ chat [' 'from'']]））{
$ _SESSION [''chatHistory''] [$ chat [''from'']] ='''';
}
$ _SESSION [''chatHistory''] [$ chat [''from'']]。=<<< EOD
{
s：0，
f：{$ chat [''from'']}，
m：{$ chat [''message'']}
}，
EOD;
未设置（$ _ SESSION [''tsChatBoxes''] [$ chat [''from'']]）;
$ _SESSION [''openChatBoxes''] [$ chat [''from'']] = $ chat [''sent''];
}
if（！空（$ _ SESSION [''openChatBoxes'']））{
foreach（$ _SESSION [''openChatBoxes''] as $ chatbox => （时间）{
if（！isset（$ _ SESSION [''tsChatBoxes''] [$ chatbox]））{
$ now = time（） - strtotime（ $ time）;
$ time = date（''g：iA M dS''，strtotime（$ time））;
$ message =以$ time发送;
if（$ now> 180）{
$ items。=<<<< EOD
{
s：2，
f：$ chatbox，
m： {$ message}
}，
EOD;
if（！isset（$ _ SESSION [ ''chatHistory''] [$ chatbox]））{
$ _SESSION [''chatHistory''] [$ chatbox] ='''';
} < br $>
$ _SESSION [''chatHistory''] [$ chatbox]。=<<< EOD
{
s：2，
f：$ chatbox，
m：{$ message}
}，
EOD;
$ _SESSION [''tsChatBoxes''] [$ chatbox] = 1;
}
}
}
}
$ sql =更新聊天集recd = 1其中chat.to =''。mysql_real_escape_string（$ _ SESSION [''username'']）。''和recd = 0;
$ query = mysql_query（$ sql） ;
if（$ items！=''''）{
$ items = substr（$ items，0，-1） ;
}
header（''Content-type：application / json''）;
？>
{
items：[
<？php echo $ items;？>
]
}
<？php
退出（0）;
}
/ *
功能chatBoxSession（$ chatbox）{
$ items ='''';
if（isset（$ _ SESSION [''chatHistory''] [$ chatbox]））{
$ items = $ _SESSION [''chatHistory''] [$ chatbox];
}
返回$ items;
} * /
函数startChatSession（）{
$ items ='''';
if（！empty（$ _ SESSION ['' openChatBoxes' ]））{
的foreach（$ _SESSION [ openChatBoxes’]为$客舱=> $ void）{
$ items。= chatBoxSession（$ chatbox）;
}
}
if（$ items！=''''）{
$ items = substr（$ items，0，-1）;
}
header（''Content-type：application / json''）;
？>
{
用户名：<？php echo $ _SESSION [''username''];？>，
项目：[
<？php echo $ items;？>
]
}
<？php
退出（0）;
} < br $>
函数sendChat（）{
$ from = $ _SESSION [''username''];
$ to = $ _POST [''to''];
$ message = $ _POST [''message''];
$ _SESSION [''openChatBoxes''] [$ _ POST [''to'']] = date（''Ymd H：i：s''，time（））;
$ messagesan = sanitize（$ message）;
if（！isset（$） _SESSION [''chatHistory''] [$ _ POST [''to'']]））{
$ _SESSION [''chatHistory''] [$ _ POST [''to'']] ='''';
}
$ _SESSION [''chatHistory''] [$ _ POST [''to''] ]。=<<<< EOD
{
s：1，
f：{$ to}，
m：{$ messagesan}
}，
EOD;
未设置（$ _ SESSION [''tsChatBoxes''] [$ _ POST [''to'']]）;
$ sql =插入聊天（chat.from，chat.to，message，sent）值（''。mysql_real_escape_string（$ from）。''，''。mysql_real_escape_string（$ to ）。'''，''。mysql_real_escape_string（$ message）。''，NOW（））;
$ query = mysql_query（$ sql）;
echo1;
退出（0）;
}
函数closeChat（）{< br $>
未设置（$ _ SESSION [''openChatBoxes''] [$ _ POST [''chatbox'']]）;
echo1;
退出（0）;
}
函数清理（$ text）{
$ text = htmlspecialchars（$ text，ENT_QUOTES）;
$ text = str_replace（\ nn \\ \\ r，\ n，$ text）;
$ text = str_replace（\\\\ n，\ n，$ text）;
$ text = str_replace（\ n，< br>，$ text）;
返回$ text;
}
提前致谢
Any one please convert this php code into Asp.net vb code or C# code
------
<?php
define (''DBPATH'',''localhost'');
define (''DBUSER'',''root'');
define (''DBPASS'',''password'');
define (''DBNAME'',''chat'');
session_start();
global $dbh;
$dbh = mysql_connect(DBPATH,DBUSER,DBPASS);
mysql_selectdb(DBNAME,$dbh);
if ($_GET[''action''] == "chatheartbeat") { chatHeartbeat(); }
if ($_GET[''action''] == "sendchat") { sendChat(); }
if ($_GET[''action''] == "closechat") { closeChat(); }
if ($_GET[''action''] == "startchatsession") { startChatSession(); }
if (!isset($_SESSION[''chatHistory''])) {
$_SESSION[''chatHistory''] = array();
}
if (!isset($_SESSION[''openChatBoxes''])) {
$_SESSION[''openChatBoxes''] = array();
}
function chatHeartbeat() {
$sql = "select * from chat where (chat.to = ''".mysql_real_escape_string($_SESSION[''username''])."'' AND recd = 0) order by id ASC";
$query = mysql_query($sql);
$items = '''';
$chatBoxes = array();
while ($chat = mysql_fetch_array($query)) {
if (!isset($_SESSION[''openChatBoxes''][$chat[''from'']]) && isset($_SESSION[''chatHistory''][$chat[''from'']])) {
$items = $_SESSION[''chatHistory''][$chat[''from'']];
}
$chat[''message''] = sanitize($chat[''message'']);
$items .= <<<EOD
{
"s": "0",
"f": "{$chat[''from'']}",
"m": "{$chat[''message'']}"
},
EOD;
if (!isset($_SESSION[''chatHistory''][$chat[''from'']])) {
$_SESSION[''chatHistory''][$chat[''from'']] = '''';
}
$_SESSION[''chatHistory''][$chat[''from'']] .= <<<EOD
{
"s": "0",
"f": "{$chat[''from'']}",
"m": "{$chat[''message'']}"
},
EOD;
unset($_SESSION[''tsChatBoxes''][$chat[''from'']]);
$_SESSION[''openChatBoxes''][$chat[''from'']] = $chat[''sent''];
}
if (!empty($_SESSION[''openChatBoxes''])) {
foreach ($_SESSION[''openChatBoxes''] as $chatbox => $time) {
if (!isset($_SESSION[''tsChatBoxes''][$chatbox])) {
$now = time()-strtotime($time);
$time = date(''g:iA M dS'', strtotime($time));
$message = "Sent at $time";
if ($now > 180) {
$items .= <<<EOD
{
"s": "2",
"f": "$chatbox",
"m": "{$message}"
},
EOD;
if (!isset($_SESSION[''chatHistory''][$chatbox])) {
$_SESSION[''chatHistory''][$chatbox] = '''';
}
$_SESSION[''chatHistory''][$chatbox] .= <<<EOD
{
"s": "2",
"f": "$chatbox",
"m": "{$message}"
},
EOD;
$_SESSION[''tsChatBoxes''][$chatbox] = 1;
}
}
}
}
$sql = "update chat set recd = 1 where chat.to = ''".mysql_real_escape_string($_SESSION[''username''])."'' and recd = 0";
$query = mysql_query($sql);
if ($items != '''') {
$items = substr($items, 0, -1);
}
header(''Content-type: application/json'');
?>
{
"items": [
<?php echo $items;?>
]
}
<?php
exit(0);
}
/*
function chatBoxSession($chatbox) {
$items = '''';
if (isset($_SESSION[''chatHistory''][$chatbox])) {
$items = $_SESSION[''chatHistory''][$chatbox];
}
return $items;
}*/
function startChatSession() {
$items = '''';
if (!empty($_SESSION[''openChatBoxes''])) {
foreach ($_SESSION[''openChatBoxes''] as $chatbox => $void) {
$items .= chatBoxSession($chatbox);
}
}
if ($items != '''') {
$items = substr($items, 0, -1);
}
header(''Content-type: application/json'');
?>
{
"username": "<?php echo $_SESSION[''username''];?>",
"items": [
<?php echo $items;?>
]
}
<?php
exit(0);
}
function sendChat() {
$from = $_SESSION[''username''];
$to = $_POST[''to''];
$message = $_POST[''message''];
$_SESSION[''openChatBoxes''][$_POST[''to'']] = date(''Y-m-d H:i:s'', time());
$messagesan = sanitize($message);
if (!isset($_SESSION[''chatHistory''][$_POST[''to'']])) {
$_SESSION[''chatHistory''][$_POST[''to'']] = '''';
}
$_SESSION[''chatHistory''][$_POST[''to'']] .= <<<EOD
{
"s": "1",
"f": "{$to}",
"m": "{$messagesan}"
},
EOD;
unset($_SESSION[''tsChatBoxes''][$_POST[''to'']]);
$sql = "insert into chat (chat.from,chat.to,message,sent) values (''".mysql_real_escape_string($from)."'', ''".mysql_real_escape_string($to)."'',''".mysql_real_escape_string($message)."'',NOW())";
$query = mysql_query($sql);
echo "1";
exit(0);
}
function closeChat() {
unset($_SESSION[''openChatBoxes''][$_POST[''chatbox'']]);
echo "1";
exit(0);
}
function sanitize($text) {
$text = htmlspecialchars($text, ENT_QUOTES);
$text = str_replace("\n\r","\n",$text);
$text = str_replace("\r\n","\n",$text);
$text = str_replace("\n","<br>",$text);
return $text;
}
Thanks in advance
推荐答案
dbh;
dbh;
dbh = mysql_connect（DBPATH，DBUSER，DBPASS）;
mysql_selectdb（DBNAME，
dbh = mysql_connect(DBPATH,DBUSER,DBPASS);
mysql_selectdb(DBNAME,
dbh）;
if（
dbh);
if (
这篇关于php到asp.net转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
