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:
<?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");
}
?>
sorunu çözebildin mi
[mention=644678]@fiyako[/mention]
Çözdüm. Ip adresi yerine localhost yazınca sorun çözüldü. Fakat başka bir sorun var