the result of query mysql output "if exists" in store procedure with "select exist" is different

I want to check if this record is already on the list. l have 3 query. 1 procedure "if exists". 1 procedure "if (select count(*) from tbl ) > 0". 1 "select exists()". but 2 procedures have the same result. different from the "select exists" query query procedure "if exists" CREATE DEFINER=`admin`@`localhost` PROCEDURE `ins_upd_price_cust`(IN buyerid2… Read More the result of query mysql output "if exists" in store procedure with "select exist" is different

August 11, 2022 MRLeave a comment

store url in same list with id php sql

hi i want to store the url in the list loop that comes from db using primary key and foreign key but I don’t know how to store the url in each list and have the same id in the first table and the second table what i want to do is something like this… Read More store url in same list with id php sql

July 21, 2022 MRLeave a comment

Query for mysql

Given the following input tables: table_1 tid name pic 1 name1 XXX 2 name2 ZZZ 3 name3 YYY table_2 fid fname tid desc 1 abcd1 1 File1 2 abcd2 1 File2 3 xyze3 2 File1 I want to show "table_2.desc" as a field and the value is "yes" or "no" based on if "tid" have… Read More Query for mysql

July 3, 2022 MRLeave a comment

Want to show date counter

I want to make date counter in following codes. the format must be today’s date – previous date. I tried to add but I think the format is wrong. Can you guys please check? if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_array($result); $curr_dt = DateTime::createFromFormat("Y-m-d H:i:s", date("Y-m-d") . " 00:00:00"); $row_dt = DateTime::createFromFormat("Y-m-d H:i:s", $row["dt_corr"]);… Read More Want to show date counter

May 25, 2022 MRLeave a comment

foreach() argument must be of type array|object, bool given. How can i join another table where a where clause also must be there.?

$SQL = "SELECT * FROM note_list JOIN `notemaker_tables` ON note_list.notemaker_id=notemaker_tables.notemaker_id WHERE notemaker_id = ‘$notemaker_id’;"; $result = $con->query($SQL); ?> <?php <!– Featured Project Row–> <h1 class="text-white">Notes By <?php echo $notemaker_id; ?></h1><br> <?php foreach ($result as $r) { ?> <div class="row align-items-center no-gutters mb-4 mb-lg-5"> <div class="col-xl-8 col-lg-7"> <iframe id="pdf-js-viewer" src="dashboard/note-pdf/<?php echo $r[‘note’]; ?>" title="webviewer" frameborder="0" width="500"… Read More foreach() argument must be of type array|object, bool given. How can i join another table where a where clause also must be there.?

May 21, 2022 MRLeave a comment

Php mysqli Welcome page redirect without login

I Search on stackoverflow it show similar question, but its not relative to my query When i run my project on localhost it not show login page rather it redirect to index page it show error message in session variable. Warning: Undefined array key "uid" in My Codes are given below : index.php <?php session_start();… Read More Php mysqli Welcome page redirect without login

May 20, 2022 MRLeave a comment

I can't create a user object in php

I want to create an object user for a website project that I am using. I have made the blueprint of the class in a saperate file called calsses.php and it contains the following code: <?php class User { private $username; private $email; private $address; private $password; private $telephone; public function __construct($username, $email, $address, $password,… Read More I can't create a user object in php

May 20, 2022 MRLeave a comment

Causing Uncaught Syntax error when clicking the dropdown list in navbar

Currently, I got an error when I click the dropdown list in my website. Error is Uncaught Syntax error, unrecognized expression: #. That error only cause when I use my website in Chrome or Edge. Currently, I’m using in IE11 and it cause no error for me but IE11 is shutting down, so I’m migrating… Read More Causing Uncaught Syntax error when clicking the dropdown list in navbar

May 18, 2022 MRLeave a comment

Display last, 2nd last and 3rd last value from a database and display in a specific order

Assume i have the following in my database, db connection established: A user form that has and input enter product with a submit button, which inserts into the database. id and product, with a table named table. Filled with information. Then i select the last id by doing the following: $results = mysqli_query($con, "SELECT *… Read More Display last, 2nd last and 3rd last value from a database and display in a specific order

May 16, 2022 MRLeave a comment

If statement inside While loop

I want the delete button to have an If statement inside my While loop so that the current user won’t be able to delete its account but it’s always having an error. What to do? Here’s my if statement btw; <?php if($_SESSION["username"]!= $array[2]){ echo <a class="btn btn-danger delete_user" href="javascript:void(0)" data-id = ‘<?php echo $row[‘id’] ?>’>Delete</a>… Read More If statement inside While loop