[Çözüldü] Günlercedir Uğraştıran Script

[Empat]

Neden database'e bağlanmıyor ve login.php'yi import etmiyor?

Kodlara bakabilir misiniz?

login.php dosyasını çekip içeriğini göstermesi lazım.

Günlercedir uğraşıyorum.

Sunucu IP'sinde, veritabanı adında, MySQL kullanıcı adında ve parolasında bir sorun yok.

Kodlar:
https://paste.ubuntu.com/p/kby2pQvSTj/

Alternatif:

Kod Seç Genişlet


<?php

session_start(); ob_start();

ini_set("max_execution_time", 86400);

date_default_timezone_set("Europe/Istanbul");

$_SESSION["admin"]=1;

header("Content-Type:text/html; charset=UTF-8");

$databaseHostAddress    = "77.83.200.116";
$databaseName           = "eMailMarketing";
$databaseUsername       = "root";
$databasePassword       = "g5lGvX2OaInYw6";

define("DOMAIN", "mahmutonurozden.com");
define("ROOT_DIRECTORY", "/home/mahmutonurozden.com/public_html");
define("DIRECTORY", "EmailMarketing");

$databaseConnection     = new mysqli($databaseHostAddress, $databaseUsername, $databasePassword);

$databaseConnection->set_charset("UTF-8");

if (mysqli_connect_errno()) {
    //header("Location:https://www." . DOMAIN . DIRECTORY . "/Results/database-connection-error.php");
    echo "couldn't connect";
} else  {
    $databaseConnection->select_db($databaseName);
    echo "bağlantı ok";
}

$page[0]   = "index.php";
$page[1]   = "login.php";
$page[2]   = "login-results.php";
$page[3]   = "Results/admin-login-deactivate.php";
$page[4]   = "Results/admin-login-error.php";

$page[5]   = "forgot-password.php";
$page[6]   = "forgot-password-results.php";
$page[7]   = "Results/forgot-password-continue.php";
$page[8]   = "Results/forgot-password-error.php";
$page[9]   = "Results/forgot-password-deactivate.php";

$page[10]  = "logout.php";

/*
require_once("/home/mahmutonurozden.com/public_html/EmailMarketing/Settings/database-connection.php");
require_once("/home/mahmutonurozden.com/public_html/EmailMarketing/Settings/page.php");
require_once("/home/mahmutonurozden.com/public_html/EmailMarketing/Settings/pages.php");
*/
if (isset($_SESSION["admin"])) {
    $adminInformations = $databaseConnect->query("SELECT * FROM yoneticiler WHERE YoneticiKullaniciAdi='" . $_SESSION["admin"] . "' AND CalismaDurumu='1' ORDER BY ID ASC LIMIT 1");

    $adminInformationSavedNumber = $adminInformations->num_rows();

    if ($adminInformationsSavedNumber > 0) {
        $adminInformationsSaved                     = $adminInformations->fetch_assoc();
        $adminInformationsid                        = $adminInformations["ID"];
        $adminInformationsUsername                  = $adminInformations["YoneticiKullaniciAdi"];
        $adminInformationsPassword                  = $adminInformations["YoneticiKullaniciSifresi"];
        $adminInformationsAdminImage                = $adminInformations["YoneticiResmi"];
        $adminInformationsAdminName                 = $adminInformations["YoneticiAdi"];
        $adminInformationsAdminSurname              = $adminInformations["YoneticiSoyadi"];
        $adminInformationsAdminEmailAddress         = $adminInformations["YoneticiEmailAdresi"];
        $adminInformationsAdminPhone                = $adminInformations["YoneticiTelefonu"];
        $adminInformationsAdminPhoneNumber          = $adminInformations["YoneticiCepTelefonu"];
        $adminInformationsAddingDateTimestamp       = $adminInformations["EklenmeTarihiZamanDamgasi"];
        $adminInformationsAddingDate                = $adminInformations["EklenmeTarihi"];
        $adminInformationsAdminNumber               = $adminInformations["YoneticiSiraNumarasi"];
        $adminInformationsAdminLoginNumber          = $adminInformations["YoneticiGirisSayisi"];
        $adminInformationsLastLoginIp               = $adminInformations["SonGirisIPsi"];
        $adminInformationsAdminLastLoginTimestamp   = $adminInformations["SonGirisTarihiZamanDamgasi"];
        $adminInformationsAdminLastLoginTime        = $adminInformations["SonGirisTarihi"];
        $adminInformationsAdminBeforeLoginIp        = $adminInformations["BirOncekiGirisIPsi"];
        $adminInformationsAdminBeforeLoginTimestamp = $adminInformations["BirOncekiGirisTarihiZamanDamgasi"];
        $adminInformationsAdminBeforeLoginTime      = $adminInformations["BirOncekiGirisTarihi"];
        $adminInformationsAdminRunStatus            = $adminInformations["CalismaDurumu"];
    }

}
else {
    header("Location:http://www." . DOMAIN . DIRECTORY . "/Results/table-connection-error.php");
}

$siteSettings = $databaseConnect->query("SELECT * FROM siteayarlari");

$siteSettingsSavedNumber = $siteSettings->num_rows();
if ($SiteAyarlariKayitSayisi > 0) {
    $siteSettingsAdminInformations = $SiteAyarlari->fetch_assoc();
    $siteSettingsId = $adminInformations["ID"];
    $siteSettingsSiteName = $adminInformations["SiteAdi"];
    $siteSettingsAdminInformationsSiteBaslik = $adminInformations["SiteBaslik"];
    $siteSettingsCopyright = $adminInformations["SiteCopyright"];
    $siteSettingsFavicon = $adminInformations["SiteFavicon"];
    $siteSettingsSiteLogo = $adminInformations["SiteAnaLogosu"];
    $siteSettingsLoginFormLogo = $adminInformations["GirisFormuLogosu"];
    $siteSettingsEmailAddress = $adminInformations["SiteAnaEmailAdresi"];
    $siteSettingsPassword = $adminInformations["SiteAnaEmailAdresiSifresi"];
    $siteSettingsPop3ConnectionType = $adminInformations["SiteAnaEmailAdresiPOP3SunucuBaglantiTuru"];
    $siteSettingsPop3ServerAddress = $adminInformations["SiteAnaEmailAdresiPOP3SunucuAdresi"];
    $siteSettingsPop3ServerPort = $adminInformations["SiteAnaEmailAdresiPOP3SunucusuSSLPortu"];
    $siteSettingsPop3TlsPort = $adminInformations["SiteAnaEmailAdresiPOP3SunucusuTLSPortu"];
    $siteSettingsSmtpConnectionType = $adminInformations["SiteAnaEmailAdresiSMTPSunucuBaglantiTuru"];
    $siteSettingsSmtpServerType = $adminInformations["SiteAnaEmailAdresiSMTPSunucuAdresi"];
    $siteSettingsSmtpSslPort = $adminInformations["SiteAnaEmailAdresiSMTPSunucusuSSLPortu"];
    $siteSettingsSmtpTlsPort = $adminInformations["SiteAnaEmailAdresiSMTPSunucusuTLSPortu"];
    $siteSettingsEmailPerAction = $adminInformations["İslemBasinaGönderilecekEmailSayisi"];
    $siteSettingsPanelPageListingLimit = $adminInformations["PanoSayfasiListelemeLimiti"];
    $siteSettingsPersonsPageListingLimit = $adminInformations["KisilerSayfasiListelemeLimiti"];
    $siteSettingsPersonsPageImportLimit = $adminInformations["KisilerSayfasiİceAktarımSayisiLimiti"];
    $siteSettingsPersonNotificationsPageListingLimit = $adminInformations["KisiBildirimleriSayfasiListelemeLimiti"];
    $siteSettingsSalesPageListingLimit = $adminInformations["KampanyalarSayfasiListelemeLimiti"];
    $siteSettingsThemesPageListingLimit = $adminInformations["TemalarSayfasiListelemeLimiti"];
    $siteSettingsEmailSettingsListingLimit = $adminInformations["EmailHesaplarıAyarlariSayfasiListelemeLimiti"];
    $siteSettingsSocialNetworksPageListingLimit = $adminInformations["SosyalAglarSayfasiListelemeLimiti"];
    $siteSettingsCountriesPageListingLimit = $adminInformations["ÜlkelerSayfasiListelemeLimiti"];
    $siteSettingsCitiesPageListingLimit = $adminInformations["SehirlerSayfasiListelemeLimiti"];
    $siteSettingsAdminsPageListingLimit = $adminInformations["YöneticilerSayfasiListelemeLimiti"];

}

else {
    header("Location:http://www." . DOMAIN . DIRECTORY . "/Results/table-connect-error.php");
}

$companySettings = $databaseConnect->query("SELECT * FROM firmaayarlari");

$companySettingsSavedNumber = $companySettings->num_rows();
if ($companySettingsSavedNumber > 0) {
    $companySettingsSaved             = $companySettings->fetch_assoc();
    $companySettingsId                = $companySettings["ID"];
    $companySettingsCompanyName       = $companySettings["FirmaAdi"];
    $companySettingsCompanyTitle      = $companySettings["FirmaUnvani"];
    $companySettingsCompanyAddress    = $companySettings["FirmaAdresi"];
    $companySettingsCompanyPostalCode = $companySettings["FirmaPostaKodu"];
    $companySettingsCompanyCounty     = $companySettings["FirmaIlcesi"];
    $companySettingsCompanyCity       = $companySettings["FirmaSehri"];
    $companySettingsCompanyCountry    = $companySettings["FirmaUlkesi"];
    $companySettingsCompanyPhone      = $companySettings["FirmaTelefonu"];

}

else {
    header("Location:http://www." . DOMAIN . DIRECTORY . "/Results/table-connection-error.php");
}

$statisticsInformations = $databaseConnect->query("SELECT * FROM siteayarlari");

$statisticsInformationsSavedNumber = $statisticsInformations->num_rows();
if ($statisticsInformationsSavedNumber > 0) {
    $statisticsInformationsSaved                                          = $statisticsInformations->fetch_assoc();
    $statisticsInformationsId                                             = $statisticsInformations["ID"];
    $statisticsInformationsPersonNumber                                   = $statisticsInformations["KisiSayisi"];
    $statisticsInformationsWaitedImportActionNumber                       = $statisticsInformations["BekleyenIceAktarimIslemSayisi"];
    $statisticsInformationsWaitedExportActionNumber                       = $statisticsInformations["BekleyenDisaAktarimIslemSayisi"];
    $statisticsInformationsWaitedExportActionFilesNumber                  = $statisticsInformations["BekleyenDisaAktarimDosyalariSayisi"];
    $statisticsInformationsExportActionFilesNumber                        = $statisticsInformations["DisaAktarimDosyalariSayisi"];
    $statisticsInformationsSalesNumber                                    = $statisticsInformations["KampanyaSayisi"];
    $statisticsInformationsThemesNumber                                   = $statisticsInformations["TemaSayisi"];
    $statisticsInformationsEmailAccountNumber                             = $statisticsInformations["EmailHesapSayisi"];
    $statisticsInformationsActiveEmailAccountNumber                       = $statisticsInformations["AktifEmailHesapSayisi"];
    $statisticsInformationsDeactivateEmailAccountNumber                   = $statisticsInformations["PasifEmailHesapSayisi"];
    $statisticsInformationsWaitedEmailAccountNumber                       = $statisticsInformations["DinlendirilenEmailHesapSayisi"];
    $statisticsInformationsPerDayMaxMailNumber                            = $statisticsInformations["GunlukMaksimumMailSayisi"];
    $statisticsInformationsPerDaySendedMailNumber                         = $statisticsInformations["GunlukGonderilenMailSayisi"];
    $statisticsInformationsPerDayRemainingMailNumber                      = $statisticsInformations["GunlukKalanMailGonderimSayisi"];
    $statisticsInformationsSocialNetworksNumber                           = $statisticsInformations["SosyalAgSayisi"];
    $statisticsInformationsCountriesNumber                                = $statisticsInformations["UlkeSayisi"];
    $statisticsInformationsCitiesNumber                                   = $statisticsInformations["SehirSayisi"];
    $statisticsInformationsAdminsNumber                                   = $statisticsInformations["YoneticiSayisi"];
    $statisticsInformationsActiveAdminNumber                              = $statisticsInformations["AktifYoneticiSayisi"];
    $statisticsInformationsDeactivateAdminNumber                          = $statisticsInformations["PasifYoneticiSayisi"];
    $statisticsInformationSendingWaitingNumber                            = $statisticsInformations["GonderimBekleyenMailSayisi"];
    $statisticsInformationsSendedMailNumber                               = $statisticsInformations["GonderilenMailSayisi"];
    $statisticsInformationsReturnsInvalidMailNumber                       = $statisticsInformations["GeriDonenGecersizMailSayisi"];
    $statisticsInformationsOpenedMailNumber                               = $statisticsInformations["AcilanMailSayisi"];
    $statisticsInformationsMailOpeningNumber                              = $statisticsInformations["MailAcilmaSayisi"];
    $statisticsInformationsClickedContentMailNumber                       = $statisticsInformations["IcerigineTiklananMailSayisi"];
    $statisticsInformationsClickedContentClickNumber                      = $statisticsInformations["MailIcerigineTiklanmaSayisi"];
    $statisticsInformationsDeclaringUnauthorizedNotificationsPersonNumber = $statisticsInformations["IzinsizGonderimBildirenKisiSayisi"];
}

else {
    header("Location:http://www." . DOMAIN . DIRECTORY . "/Results/table-connection-error.php");
}

?>


[fiyako]

sorunu çözebildin mi

[Empat]

[mention=644678]@fiyako[/mention]

Çözdüm. Ip adresi yerine localhost yazınca sorun çözüldü. Fakat başka bir sorun var