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:
session_start(); ob_start(); $_SESSION["admin"]=1; ini_set("max_execution_time", 86400);date_default_timezone_set("Europe/Istanbul");header("Content-Type:text/html; charset=UTF-8");$databaseHostAddress = "myServerIpAdress";$databaseName = "myDatabaseNmae";$databaseUsername = "myUsername";$databasePassword = "myPassword";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");}ob_end_flush();