Hello - My problem is as follows (I am trying to migrate from a mssql
server to a mysql server)

    <?
        ## I have already made pconnect statements to both the mssql and
mysql servers.
        ## I have summarized what I am trying to achieve below (actual,
full code available below):
        $data = mssql_result(mssql_query("SELECT field1 FROM table1
WHERE ID='1'"),0,0);
        echo $data;
        mysql_query("INSERT INTO table2 VALUES('$data')");
    ?>
 
The data in the MSSQL table is: 
 
IF I call this PHP code from my browser (IE6) it results in the
following output:  and it also places into the MySQL database the
value: 
 
However, if I call this PHP code from the command line, using "php.exe
test.php" it also results in the following output:  but it places into
the MySQL database: 
 
Does anyone have any idea why this is happening?

I am sure it is a character set issue, but for the life of me I cannot
work out why the command-line does not run the exact same script in the
same way as a browser would?
 
Regards,
Emile Axelrad,  <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED]




-- Reposted in response to: -
Ouch. 

First, you're mixing and matching mssql and mysql functions.  Second,
there is no function named mysql_insert().  Third, mssql_result()
requires three arguments, you only provided two.  Fourth, if you mean to
be calling mysql_result(), I've never seen folks call it with a
mysql_query()  
function in it, people usually call the query function separately first
and put the resource identifier into a variable.  Fifth, all of this
could be thrown off by your retyping the example rather than
copying/pasting or 
importing the acutal script that's giving you the error.  Sixth, you 
posted the same question twice.

--Dan

--



<html><head><style>
                BODY,td {font:9pt Verdana, Arial, sans-serif;color:red}
                .black {color:black}
                </style></head>
                <body>

<?
set_time_limit(3530);
#mssql_pconnect("SQL-1", "xxx", "xxx");
mssql_pconnect("SQL-1", "xxx", "xxx");
mssql_select_db ("xxx");
mysql_pconnect("localhost", "xxx", "xxx");

function AddToErrorDisplay ($text) {
        global $errordisplay;
        echo $text;
        $errordisplay .= $text;
        return true;
}

function CreateTable($tablename) {

        $_temp = mssql_query("exec sp_columns @table_name =
'$tablename'");
        
        while ($row = mssql_fetch_assoc($_temp)) {
                $tablestructure[] = $row;
        }

        ##
        ## Build fieldlist and create table structure
        ##
        
        $createquery = "CREATE TABLE `acclinetest`.`" .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import`
(\r\n";

        foreach ($tablestructure as $rowid=>$row) {
                if ($rowid > 0) $fieldlist .= ",";

                if ($row["TYPE_NAME"] == "ntext") {
                        $fieldlist .= "SUBSTRING([" .
$row["COLUMN_NAME"] . "],1,DATALENGTH([" . $row["COLUMN_NAME"] . "])) As
[" . $row["COLUMN_NAME"] . ']';
                } else {
                        $fieldlist .= '[' . $row["COLUMN_NAME"] . ']';
                }
                
                switch ($row["COLUMN_NAME"]) {
                        #case 'group':
                        case 'option':
                                $createquery .=  "`" .
$row["COLUMN_NAME"] . "column` ";
                        break;
                        default:
                                $createquery .=  "`" .
$row["COLUMN_NAME"] . "` ";
                        break;
                }

                switch ($row["TYPE_NAME"]) {

                        case 'nvarchar':
                         if (($row["LENGTH"]/2) > 255) {
                                $createquery .= 'MEDIUMTEXT';
                         } else {
                                $createquery .= 'VARCHAR(' .
($row["LENGTH"]/2) . ')';
                         }
                        
                        break;
                        case 'varchar':
                         if ($row["LENGTH"] > 255) {
                                $createquery .= 'MEDIUMTEXT';
                         } else {
                                $createquery .= 'VARCHAR(' .
$row["LENGTH"] . ')';
                         }
                        break;
                        case 'nchar':
                        case 'char':
                         $createquery .= 'VARCHAR(' . $row["LENGTH"] .
')';
                        break;
                        case 'text':
                        case 'ntext':
                         $createquery .= 'MEDIUMTEXT';
                        break;
                        case 'varbinary':
                         $createquery .= 'BLOB';
                        break;
                        case 'image':
                         $createquery .= 'MEDIUMBLOB';
                        break;
                        case 'smallint':
                         $createquery .= 'SMALLINT(' .
($row["PRECISION"]+1) . ')';
                        break;
                        case 'tinyint':
                         $createquery .= 'TINYINT(' .
($row["PRECISION"]) . ')';
                        break;
                        case 'int':
                         $createquery .= 'INT(' . ($row["PRECISION"]+1)
. ')';
                        break;
                        case 'float':
                         $createquery .= 'FLOAT(8)';
                        break;
                        case 'int identity': # AUTO_INCREMENT field
                         $createquery .= 'INT(' . ($row["PRECISION"]+1)
. ')';
                        break;
                        case 'bit':
                         $createquery .= 'TINYINT(4)';
                        break;
                        case 'real':
                         $createquery .= 'FLOAT(4)';
                        break;
                        case 'money':
                         $createquery .= 'DECIMAL(19,4)';
                        break;
                        case 'smalldatetime':
                        case 'datetime':
                         $createquery .= 'VARCHAR(40)';                 
                        break;
                        
                        default:
                         AddToErrorDisplay("<br><b>UKNOWN FIELD TYPE: "
. $tablename . ' --> ' . $row["COLUMN_NAME"]  . ' --> ' .
$row["TYPE_NAME"] . "</b>");
                         AddToErrorDisplay("<br><span
style='display:none'>" . print_r($row) . "</span>");
                        break;

                }

                $createquery .= ' ' . ($row["NULLABLE"] ? "NULL" : "NOT
NULL");

                if ($rowid+1 < sizeof($tablestructure)) $createquery .=
",";
                $createquery .= "\r\n";

                # print_r($row);

        }

        $createquery .= "\r\n)";

        #echo $fieldlist;
        #echo $createquery;
        mysql_query($createquery);
        AddToErrorDisplay(" \r\n:: <span class=black><b>[" .
date("H:i:s") . "] " . $tablename . "</b></span><u>" . mysql_error() .
"</u>");
        flush();
        
return $fieldlist;
}




function InsertData($tablename,$fieldlist) {
        
        ##
        ## Retrieve data and build/run reinsert queries
        ##

        $_temp = mssql_query("SELECT $fieldlist FROM [$tablename]");
        while ($row = mssql_fetch_row($_temp)) {

                #print_r($row); 
                $i=0;
                                
                $insertquery = " (";

                foreach ($row as $fieldvalue) {

                        $insertquery .= "'" . addslashes($fieldvalue) .
"'";
                        if (++$i < sizeof($row)) $insertquery .= ",";

                }
                $insertquery .= ")";

                
                ## Every x rows insert data using SQL query...
                $dataquery .= ($j % 75 > 0 ? ',' : '') . $insertquery;
                if (++$j % 75 == 0) {
                        if ($dataquery) {
                                mysql_query("INSERT INTO " .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import
VALUES" . $dataquery);
                                AddToErrorDisplay(mysql_error());
                                # AddToErrorDisplay("<br>INSERT INTO " .
strtolower($tablename) . "_import" . $dataquery);
                                unset($dataquery);
                        }               
                }       
                

                # echo $insertquery . "<br>\r\n";

        }

# Finish off any remaining queries before ending.

if ($dataquery) {
        mysql_query("INSERT INTO " .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import
VALUES" . $dataquery);
        AddToErrorDisplay(mysql_error());
}


AddToErrorDisplay("<span class=black> (inserted $j rows)</span>");

}





#mysql_query("DROP DATABASE acclinetest");
#mysql_query("CREATE DATABASE acclinetest");

mysql_select_db("acclinetest");



$_temp = mssql_query("exec sp_tables");
        
while ($row = mssql_fetch_assoc($_temp)) {
        if ($row["TABLE_TYPE"] == "TABLE") $tables[] = $row;
}

foreach ($tables as $tabledata) {
        mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import");
        $fieldlist = CreateTable($tabledata["TABLE_NAME"]);
        InsertData($tabledata["TABLE_NAME"],$fieldlist);
        
}

foreach ($tables as $tabledata) {
        mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])));
        mysql_query("ALTER TABLE " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import RENAME AS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])));
        mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import");
}

?>

</body></html>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to