• 24-11-2013, 19:09:10
    #1
    config.php
    <? 
    $dbhost = "127.0.0.1"; 
    $dbuser = "sa"; 
    $dbpasswd = "pass"; 
    $host = "127.0.0.1"; 
    
    //=============== Connect to DB ==================== 
    $db = 'MuOnline'; 
    $msconnect=mssql_connect("$host","$dbuser","$dbpasswd"); 
    $msdb=mssql_select_db("$db",$msconnect); 
    ?>
    register.php
    <?php 
    include("config.php"); 
    $error[0] = "<font color='red' size='2'>Enter Account!</font>"; 
    $error[1] = "<font color='red' size='2'>Enter E-Mail!</font>"; 
    $error[2] = "<font color='red' size='2'>Enter password!</font>"; 
    $error[3] = "<font color='red' size='2'>Enter repeat password!</font>"; 
    $error[4] = "<font color='green' size='2'>Register SUCESSFULLY!</font>"; 
    if ($_POST[send]){ 
    $Acc = $_POST[Acc]; 
    $mail = $_POST[mail]; 
    $pass = $_POST[pass]; 
    $pass2 = $_POST[pass2]; 
    if (strlen($Acc) > 4 ){ 
    $Acc = stripslashes($Acc); 
    
    } 
    else { 
    $Acc = NULL; 
    $msg[0] = $error[0]; 
    
    
    } 
    
    if (strlen($mail) > 4 ){ 
    $mail = stripslashes($mail); 
    
    
    } 
    else { 
    $mail = NULL; 
    $msg[1] = $error[1]; 
    
    
    } 
    if (strlen($pass) > 4 ){ 
    $pass = stripslashes($pass); 
    
    
    } 
    else { 
    
    $pass = NULL; 
    $msg[2] = $error[2]; 
    } 
    if ($pass != $pass2){ 
    $msg[3] = $error[3]; 
    
    } 
    if ($Acc && $mail && $pass == $pass2){ 
    $id = 1111111111111; 
    $dotaz = "INSERT INTO [MEMB_INFO] (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$Acc','$pass','Hocico','$id','$mail','01/01/2006','01/01/2006','01/01/2006','01/01/2006','1','0','0','','')"; 
    mssql_query ($dotaz); 
    $msg[4] = $error[4]; 
    } 
    
    mssql_close(); 
    } 
    echo ' 
    <form method="post" action=""> 
    <font size="2"><label for="acc" style="float: left;color:orange; width: 80px;">Account</label></font> <input style="margin-bottom: 2px;" class="textbox" type="text" name="Acc" id="Acc"><br> 
    <span style="color:red">'.$msg[0].'</span><br> 
    <font size="2"><label for="email" style="float: left;color:orange; width: 80px;">Email</label></font> <input style="margin-bottom: 2px;" class="textbox" type="text" name="mail" id="mail"><br> 
    <span style="color:red">'.$msg[1].'</span><br> 
    <font size="2"><label for="password" style="float: left;color:orange; width: 80px;">Password</label></font> <input style="margin-bottom: 2px;" class="textbox" type="password" name="pass" id="pass"><br> 
    <span style="color:red">'.$msg[2].'</span><br> 
    <font size="2"><label for="password2" style="float: left;color:orange; width: 80px;">Repeat Password</label></font> <input style="margin-bottom: 2px;" class="textbox" type="password" name="pass2" id="pass2"><br> 
    <span style="color:red">'.$msg[3].'</span><br> 
    <input type="submit" name="send" class="button" value="Register!">                                  <input type="reset" name="Reset" class="button" value="Reset" > 
    </form>'.$msg[4]; 
    
    ?>

    MSSql ile baglanmış bunu nasıl odbcye çevireiblirm mssql artık desteklenmiyor o yüzden
  • 24-11-2013, 23:55:29
    #2
    Kimlik doğrulama veya yönetimden onay bekliyor.
    @trhero;

    Altta bulunan betiği deneme fırsatım olmadı fakat çalışacağını düşünüyorum. Bi' deneyip sonucunu yazabilir misin?

    config.php;
    <?php
    	
    	$cfg = (object) array(
    		"dsn" => "Driver={SQL Server Native Client 10.0};Server=%s;Database=%s;"
    		"dbhost" => "127.0.0.1",
    		"dbuser" => "sa",
    		"dbpass" => "pass",
    		"dbname" => "MuOnline"
    	);
    	
    	$link = odbc_connect(
    		sprintf($cfg->dsn, $cfg->dbhost, $cfg->dbname),
    		$cfg->dbuser,
    		$cfg->dbpass
    	);
    register.php;
    <?php
    	
    	require("config.php");
    	
    	$errors = array(
    		"<font color=\"red\" size=\"2\">Enter Account!</font>",
    		"<font color=\"red\" size=\"2\">Enter E-Mail!</font>",
    		"<font color=\"red\" size=\"2\">Enter Password!</font>",
    		"<font color=\"red\" size=\"2\">Enter Repeat Password!</font>",
    		"<font color=\"green\" size=\"2\">Register Successfully!</font>",
    	);
    	
    	$messages = array();
    	
    	if(array_key_exists("send", $_POST)) {
    		$acc = $_POST["Acc"];
    		$mail = $_POST["mail"];
    		$pass = $_POST["pass"];
    		$pass2 = $_POST["pass2"];
    		
    		if(strlen($acc) > 4)
    			$acc = stripslashes($acc);
    		else {
    			$acc = null;
    			$messages[0] = $errors[0];
    		}
    		
    		if(strlen($mail) > 4)
    			$mail = stripslashes($mail);
    		else {
    			$mail = null;
    			$messages[1] = $errors[1];
    		}
    		
    		if(strlen($pass) > 4)
    			$pass = stripslashes($pass);
    		else {
    			$pass = null;
    			$messages[2] = $errors[2];
    		}
    		
    		if($pass != $pass2)
    			$messages[3] = $errors[3];
    		
    		if($acc && $mail && $pass && ($pass == $pass2)) {
    			$id = 1111111111111; 
    			$query = "INSERT INTO [MEMB_INFO] (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$Acc','$pass','Hocico','$id','$mail','01/01/2006','01/01/2006','01/01/2006','01/01/2006','1','0','0','','')";
    			odbc_query($query);
    			
    			$messages[4] = $errors[4];
    		}
    		
    		odbc_close();
    	}
    	
    	echo '<form method="post"><font size="2"><label for="acc" style="float: left;color:orange; width: 80px;">Account</label></font><input style="margin-bottom: 2px;" class="textbox" type="text" name="Acc" id="Acc"><br><span style="color:red">'.$messages[0].'</span><br><font size="2"><label for="email" style="float: left;color:orange; width: 80px;">Email</label></font><input style="margin-bottom: 2px;" class="textbox" type="text" name="mail" id="mail"><br><span style="color:red">'.$messages[1].'</span><br><font size="2"><label for="password" style="float: left;color:orange; width: 80px;">Password</label></font><input style="margin-bottom: 2px;" class="textbox" type="password" name="pass" id="pass"><br> <span style="color:red">'.$messages[2].'</span><br><font size="2"><label for="password2" style="float: left;color:orange; width: 80px;">Repeat Password</label></font><input style="margin-bottom: 2px;" class="textbox" type="password" name="pass2" id="pass2"><br><span style="color:red">'.$messages[3].'</span><br><input type="submit" name="send" class="button" value="Register!"><input type="reset" name="Reset" class="button" value="Reset" ></form>'.$messages[4];
  • 25-11-2013, 00:09:14
    #3
    saintx adlı üyeden alıntı: mesajı görüntüle
    @trhero;

    Altta bulunan betiği deneme fırsatım olmadı fakat çalışacağını düşünüyorum. Bi' deneyip sonucunu yazabilir misin?

    config.php;
    <?php
    	
    	$cfg = (object) array(
    		"dsn" => "Driver={SQL Server Native Client 10.0};Server=%s;Database=%s;"
    		"dbhost" => "127.0.0.1",
    		"dbuser" => "sa",
    		"dbpass" => "pass",
    		"dbname" => "MuOnline"
    	);
    	
    	$link = odbc_connect(
    		sprintf($cfg->dsn, $cfg->dbhost, $cfg->dbname),
    		$cfg->dbuser,
    		$cfg->dbpass
    	);
    register.php;
    <?php
    	
    	require("config.php");
    	
    	$errors = array(
    		"<font color=\"red\" size=\"2\">Enter Account!</font>",
    		"<font color=\"red\" size=\"2\">Enter E-Mail!</font>",
    		"<font color=\"red\" size=\"2\">Enter Password!</font>",
    		"<font color=\"red\" size=\"2\">Enter Repeat Password!</font>",
    		"<font color=\"green\" size=\"2\">Register Successfully!</font>",
    	);
    	
    	$messages = array();
    	
    	if(array_key_exists("send", $_POST)) {
    		$acc = $_POST["Acc"];
    		$mail = $_POST["mail"];
    		$pass = $_POST["pass"];
    		$pass2 = $_POST["pass2"];
    		
    		if(strlen($acc) > 4)
    			$acc = stripslashes($acc);
    		else {
    			$acc = null;
    			$messages[0] = $errors[0];
    		}
    		
    		if(strlen($mail) > 4)
    			$mail = stripslashes($mail);
    		else {
    			$mail = null;
    			$messages[1] = $errors[1];
    		}
    		
    		if(strlen($pass) > 4)
    			$pass = stripslashes($pass);
    		else {
    			$pass = null;
    			$messages[2] = $errors[2];
    		}
    		
    		if($pass != $pass2)
    			$messages[3] = $errors[3];
    		
    		if($acc && $mail && $pass && ($pass == $pass2)) {
    			$id = 1111111111111; 
    			$query = "INSERT INTO [MEMB_INFO] (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$Acc','$pass','Hocico','$id','$mail','01/01/2006','01/01/2006','01/01/2006','01/01/2006','1','0','0','','')";
    			odbc_query($query);
    			
    			$messages[4] = $errors[4];
    		}
    		
    		odbc_close();
    	}
    	
    	echo '<form method="post"><font size="2"><label for="acc" style="float: left;color:orange; width: 80px;">Account</label></font><input style="margin-bottom: 2px;" class="textbox" type="text" name="Acc" id="Acc"><br><span style="color:red">'.$messages[0].'</span><br><font size="2"><label for="email" style="float: left;color:orange; width: 80px;">Email</label></font><input style="margin-bottom: 2px;" class="textbox" type="text" name="mail" id="mail"><br><span style="color:red">'.$messages[1].'</span><br><font size="2"><label for="password" style="float: left;color:orange; width: 80px;">Password</label></font><input style="margin-bottom: 2px;" class="textbox" type="password" name="pass" id="pass"><br> <span style="color:red">'.$messages[2].'</span><br><font size="2"><label for="password2" style="float: left;color:orange; width: 80px;">Repeat Password</label></font><input style="margin-bottom: 2px;" class="textbox" type="password" name="pass2" id="pass2"><br><span style="color:red">'.$messages[3].'</span><br><input type="submit" name="send" class="button" value="Register!"><input type="reset" name="Reset" class="button" value="Reset" ></form>'.$messages[4];
    Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in C:\xampp\htdocs\sitem\config.php on line 5
    hatası aldım bakıyorum ama hata bulamadım
  • 25-11-2013, 00:36:30
    #4
    @trhero;

    config.php'yi şu şekilde tekrardan düzenleyin.
     <?php
        
        $cfg = (object) array(
            "dsn" => "Driver={SQL Server Native Client 10.0};Server=%s;Database=%s;",
            "dbhost" => "127.0.0.1",
            "dbuser" => "sa",
            "dbpass" => "pass",
            "dbname" => "MuOnline"
        );
        
        $link = odbc_connect(
            sprintf($cfg->dsn, $cfg->dbhost, $cfg->dbname),
            $cfg->dbuser,
            $cfg->dbpass
        );
  • 25-11-2013, 01:09:30
    #5
    saintx adlı üyeden alıntı: mesajı görüntüle
    @trhero;

    config.php'yi şu şekilde tekrardan düzenleyin.
     <?php
        
        $cfg = (object) array(
            "dsn" => "Driver={SQL Server Native Client 10.0};Server=%s;Database=%s;",
            "dbhost" => "127.0.0.1",
            "dbuser" => "sa",
            "dbpass" => "pass",
            "dbname" => "MuOnline"
        );
        
        $link = odbc_connect(
            sprintf($cfg->dsn, $cfg->dbhost, $cfg->dbname),
            $cfg->dbuser,
            $cfg->dbpass
        );
    buseferde ODBC baglanamadı nedense
    http://176.9.131.174/sitem/
  • 25-11-2013, 02:02:45
    #6
    ODBC ayarlarını yaptınız mı?

    GT-I8160 cihazımdan Tapatalk 2 ile gönderildi
  • 25-11-2013, 02:51:10
    #7
    saintx adlı üyeden alıntı: mesajı görüntüle
    ODBC ayarlarını yaptınız mı?

    GT-I8160 cihazımdan Tapatalk 2 ile gönderildi
    Evet yaptım ama girmedi .


    bu arada sorunumu başka şekilde çözdüm
    http://176.9.131.174/ adresindeki baglantı ile
    teşşekkürler