Category : mysqli

1st table : CREATE TABLE IF NOT EXISTS `sold` ( `soldID` varchar(5) NOT NULL, `total_pay` text NOT NULL, `date` text NOT NULL, PRIMARY KEY (`soldID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `sold` (`soldID`, `total_pay`, `date`) VALUES (‘S0003’, ‘49500’, ‘2021-11-30’), (‘S0002’, ‘17000’, ‘2021-11-29’), (‘S0001’, ‘3000’, ‘2021-11-29’); 2nd table : CREATE TABLE IF NOT EXISTS `sold_detail` ( ..

Read more

I have problem – can you help me with that? thanks I already created two tables 1. Table name: "grades" id subjecttype grade 2. Table name: "subjects" id name subjecttype So in next i created table with while loop: $sqltest1 = "SELECT * FROM grades, subjects WHERE grades.subjecttype = subject.subjectstype"; <table class="table table-bordered"> <thead> <tr> ..

Read more

I have made query inside blade. these query its work fine and bring data from database but when i’m write where condition its give me error. Call to a member function fetch_assoc() on bool (View: C:xampphtdocsblog6325resourcesviewsassessmentsweek9.blade.php) Here is Query that give me error $conn = new mysqli(‘localhost’, ‘root’, ”, ‘rp’) or die (‘Cannot connect to ..

Read more

Full code below, i am getting error in Update query, Fatal error: Uncaught Error: Object of class mysqli_result could not be converted to string in C:wamp64wwwcrudappcrud_functionsupdate.php and Error: Object of class mysqli_result could not be converted to string in C:wamp64wwwcrudappcrud_functionsupdate.php both errors are on same line (update query) <?php include ‘../conn.php’; $updateSelected = $_GET[‘update’]; $qry ..

Read more

I’m in need of help for the problem I’m facing right now, I created a datatable with JSON data but the data can’t appear in my table. is there something wrong with my code below?: "use strict"; var DataProyek = function () { var datatable = $(‘#permasalahan’).KTDatatable({ data: { type: ‘remote’, source: { read: { ..

Read more