Category : phpmyadmin

I have freshly created laravel application which i am trying to connect to remote database but i’m getting an error. SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = tomsin1 and table_name = migrations and table_type = ‘BASE TABLE’) My .env file DB_CONNECTION=mysql DB_HOST=stud.if.ktu.lt DB_DATABASE=tomsin1 DB_USERNAME=tomsin1 DB_PASSWORD=ooShen4ooPaechad Source: ..

Read more

I want to put ErrorMessageBox on this block of code. Like it shows that "The data has already existed". Here is the block of code that saves to the database: if (t1.get()=="" or t2.get()=="" or t3.get()=="" or t4.get()==""): messagebox.showinfo("Result","Please Complete the Provided Details!") Here Connection to Database And Insertion else: databases = mysql.connector.connect( host ="localhost", ..

Read more

UPDATE `sellcar` t1 JOIN `Listing` t2 ON t1.car_id =’20’ AND t2.car_id = ’20’ SET t1.City = ‘$city’, t1.Postal_code = ‘90998’, t1.Manu_year = ‘2000/07/7’, t1.Brand = ‘$brandhajaaia’, t1.Model = ‘$modelagayaga’, t1.Kmsdriven = ‘88788’, t1.No.ofown = ‘$nojKa’, t1.Price = ‘9888778’, t1.Name = ‘$name’, t1.Mobileno = ‘$mobnum’, t1.Email = ‘$email’, t2.Image = ‘$new_img_name’, t2.Fuel = ‘$fuel’, t2.Color = ..

Read more

Can someone help me as to why the fields are not pushed and appearing on my PHPMyAdmin please? <?php $consentNumber = ""; $issueDate = ""; $lapseDate = ""; $keywords = ""; $db = new mysqli("localhost", "root", "", "AnC_Sep22"); if (isset($_POST[‘submitConsent’])) { $consentNumber = mysqli_real_escape_string($db, $_POST[‘consentNumber’]); $issueDate = mysqli_real_escape_string($db, $_POST[‘issueDate’]); $lapseDate = mysqli_real_escape_string($db, $_POST[‘lapseDate’]); $keywords = ..

Read more

Fatal error: Uncaught TypeError: implode(): Argument #2 ($array) must be of type ?array, string given in /usr/share/phpmyadmin/libraries/classes/Rte/Routines.php:1413 Stack trace: #0 /usr/share/phpmyadmin/libraries/classes/Rte/Routines.php(1413): implode() #1 /usr/share/phpmyadmin/libraries/classes/Rte/Routines.php(72): PhpMyAdminRteRoutines::handleExecute() #2 /usr/share/phpmyadmin/libraries/rte/rte_main.inc.php(81): PhpMyAdminRteRoutines::main() #3 /usr/share/phpmyadmin/db_routines.php(23): require_once(‘…’) #4 {main} thrown in /usr/share/phpmyadmin/libraries/classes/Rte/Routines.php on line 1413 *kindly help when i’m using stored procedure of Routines in phpmyadmin enter image description here* Source: ..

Read more

I’m trying to take input from the form but Whenever I’m refreshing the page blank data is inserted in the database, Please help here is the code: <?php session_start();` $dbhost = ‘localhost’; $dbname = ‘transfer’; $dbusername = ‘root’; $dbpass = ”; $conn = mysqli_connect("localhost", "root", "", "transfer"); //check connection if(!$conn){ die(‘Could not Connect My Sql:’.mysql_error()); ..

Read more

hii i want to make grafik every week, from my table from the result of count and i want to get date group date SELECT date(created_at) x , jumlah_data as y FROM( select created_at, count(*) as jumlah_data from ( select kontrakid,created_at, tahapan_kontrak as tahapan_usulan from histori_summary a where tahapan_kontrak_id = 7 AND IFNULL(tahapan_kontrak_is_setuju, 1) !=0 ..

Read more