Posts
 
Reputation
Joined
Last Seen
Ranked #178
Strength to Increase Rep
+8
Strength to Decrease Rep
-2
94% Quality Score
Upvotes Received
212
Posts with Upvotes
159
Upvoting Members
75
Downvotes Received
8
Posts with Downvotes
7
Downvoting Members
7
32 Commented Posts
8 Endorsements
Ranked #247
Ranked #323
~308.34K People Reached
Favorite Tags
php x 210
mysql x 105
c++ x 35
sql x 22
Member Avatar for IQBAL_13

Thank you for looking at this problem, details are all below. Below is the code <form style="overflow: hidden;" method="post"> <input type="checkbox" aria-label="Checkbox for following text input" name="kursus[]" value="<?php echo $row['IDKursus']; ?>"> <div class="d-flex justify-content-between mt-3"> <button type="submit" class="btn btn-success" name="daftar_kursus">Daftar Kursus</button> <button type="reset" class="btn btn-primary">Reset</button> </div> </form> if (isset($_REQUEST['daftar_kursus'])) { …

Member Avatar for Dani
0
147
Member Avatar for Rico_2

hii, i want to ask how to loop this array for menu like in images public $list = [ [ 'id' => 'dashboard', 'text' => 'Dashboard', 'icon' => 'feather-home', ], [ 'id' => 'data_tables', 'text' => 'DataTables', 'icon' => 'feather-layers', 'children' => [ ['id' => 'basic', "text" => "Basic"], ['id' …

Member Avatar for AndrisP
0
121
Member Avatar for Ant_426

Hi. I have a local installation of SQLite3 and PHP which runs a small in house PHP application so sql injection is not an issue. I am able to execute the following: if(isset($_GET['deletequote'])) { $qno = $_GET['deletequote']; echo $qno;?><br><?php // for testing $db = new SQLite3('./fi_data.db') or die('Cannot delete quote. …

Member Avatar for Ant_426
0
480
Member Avatar for larry29936

The following code works without errors on my local server but when I put it up on my hosted website, I get a "Failed - Network Error" message immediately. The way this works is that a button is pressed on a download page to select what file to download. Here's …

Member Avatar for Dani
0
395
Member Avatar for TimTheCoder

I am trying to come up with an SQL query to return all the records earlier than a certain year with SQLite using DB Browser. I can't seem to come up with the right regex expressipn to use for filtering only the year from a row for comparison, below is …

Member Avatar for TimTheCoder
0
66
Member Avatar for Irfan_9

i have two page one is search.php and other is detail.php in search.php <div class="search-field "> <form class="d-flex align-items-center h-100" name="search" action="manage_visitor.php" method="post" > <div class="input-group" style="background-color: #f2edf3;"> <input type="text" class="form-control bg-transparent border-0"name="searchdata" id="searchdata" placeholder="Search by names &amp; mobile no" > </div> Detail.php i get the value of there pagination …

Member Avatar for AndrisP
0
20
Member Avatar for prod.

Hi I have this PHP Code - <?php require_once ("../include/initialize.php"); if (!isset($_SESSION['ACCOUNT_ID'])){ redirect(web_root."index.php"); } $action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] : ''; switch ($action) { case 'add' : doInsert(); break; case 'edit' : doEdit(); break; case 'delete' : doDelete(); break; case 'photos' : doupdateimage(); break; case 'checkid' …

Member Avatar for AndrisP
0
497
Member Avatar for skymhine

<?php if (count($_FILES) > 0) { if (is_uploaded_file($_FILES['userImage']['tmp_name'])) { $imgData = addslashes(file_get_contents($_FILES['userImage']['tmp_name'])); $imageProperties = getimageSize($_FILES['userImage']['tmp_name']); $sql = "INSERT INTO qr(user_id,file_name ,QrCode) VALUES('".$_SESSION['id']."','{$imageProperties['mime']}', '{$imgData}')"; $current_id = mysqli_query($db, $sql) or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($db)); if (isset($current_id)) { header("Location: preview.php"); } } } ?> <form name="frmImage" enctype="multipart/form-data" action="" method="post" class="frmImageUpload"> …

Member Avatar for Dani
0
97
Member Avatar for ChrisJ

I'm trying to modify a web script. Currently, upon uploading a video, in the upload Form, among other things, the uploader chooses a sub-category and enters tags and then submits/uploads. I'd like the sub-category that is selected, to also be searchable as a keyword. Presently, the 'videos' table has a …

Member Avatar for AndrisP
0
74
Member Avatar for vinothini_2021

i have form., in that form i have input field and confirm button., i just want to change the confirm button color if input has some value otherwise the button will be normal., i have tried many method but didnt work.. please help me to fix that problem

Member Avatar for AndrisP
0
43
Member Avatar for ramyaamirtham99

I want to pass my array as an input to the radio button field. I have an array of values, when I click a button, it should show me all the values in the array as a radio button. I tried this, but not able to get any values , …

Member Avatar for AndrisP
0
65
Member Avatar for radhika_3

$query = "INSERT INTO TB_RADIOLOGI (ID_PASIEN, ID_PENDAFTARAN, TGL_PERMINTAAN, JENIS_PERMINTAAN) VALUES(?, ?, ?, ?);"; foreach($_POST['JENIS_PERMINTAAN'], reverse_tanggal($_POST['TGL_PERMINTAAN']) as $idx=>$val){ $params = array($_POST['ID_PASIEN'], $_POST['ID_PENDAFTARAN'], $val ); //--disini input id_pasien=0001 sesuai contoh di form sqlsrv_query($GLOBALS['conn'], $query, $params); } there is an error : Parse error: syntax error, unexpected ',' in Please help

Member Avatar for AndrisP
0
55
Member Avatar for minoesje

Hello I'm trying to create an update statement where it updates inlever_datum with a date from now + 7 days later I already have this case "0": //doesn't work $id = $_GET['id']; $date = date("Y-m-d"); $new_date = date('Y-m-d', strtotime($date. '+7 day')); // je moest '' eromheen zetten $sql = "UPDATE …

Member Avatar for AndrisP
0
58
Member Avatar for soniyabis

Hi All Can anyone help me, if user inactivity and update my datbase row automaticlly ( I mean time set if user inactivity or browser close ) Before login $sql = "UPDATE register set logged_in='1' WHERE (matri_id='" . $username . "' OR email='" . $username . "')"; $DatabaseCo->dbLink->query($sql); After login …

Member Avatar for AndrisP
0
128
Member Avatar for Paulo_9

Hi guys I'm having a bit of a problem with php and linux. I'm using the following function, to find files with specific file extensions within a given folder and all subfolders : function FindVideoFiles($startfolder,$specificextensions){ $it = new RecursiveDirectoryIterator($startfolder); foreach( new RecursiveIteratorIterator($it) as $file) { if (in_array(strtoupper(substr($file, strrpos($file, '.') + …

Member Avatar for AndrisP
1
277
Member Avatar for Gabriel9999

I have multiple files in a Linux systems where I want to copy them with a single cp command into a different path and directory. Should I write a bash script to copy one by one?

Member Avatar for AndrisP
2
382
Member Avatar for litlemaster

Hello to all, I am trying to execute a mysql query for selecting * rows from the table where user name = [one of the usernames stored in an array]. Ok. Sorry if I am not clear. Now I have an array naming $users[]. I want to select all the …

Member Avatar for mukesh_20
0
36K
Member Avatar for larry29936

I'm trying to create a trigger that does two things, first take an ip that's in dot notation and run inet_aton on it and put the result in another field. Second, checks a lookup table to identify an ip range that the result of the first action falls into and …

Member Avatar for larry29936
1
248
Member Avatar for Dani

My code has a query that looks like: INSERT INTO table VALUES (...) ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), ... id is a PRIMARY KEY. My question is that I can't for anything remember why I have id = LAST_INSERT_ID(id). I wrote it years ago and it's not commented. …

Member Avatar for Dani
0
1K
Member Avatar for nishita_1

Dear sir, Please help me about below query. here is two table sale and purchase. i want product wise result in output table like below picture. please help me ![22222.jpg](/attachments/large/4/f8a1f4cfc8eaaad4bde70a850826b310.jpg)

Member Avatar for drmrkrch
0
1K
Member Avatar for larry29936

I'm creating a report page and can't figure out how to convert the array (row) to just get the ip_address. I'm a newbie to php and can't figure out how to accomplish this. Here's the code that I have so far: <?php $filename = NULL; session_start(); // start of script …

Member Avatar for larry29936
0
455
Member Avatar for Aman_24

Write a function that takes as argument a string containing multiple words and returns a string containing the same words in reverse order. Eg., input = 'India is a democracy'; output = 'democracy a is India'

Member Avatar for AndrisP
0
587
Member Avatar for Bhavini_2

Hi, I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so. please help me and give me proper syntex fro the same

Member Avatar for anand9796
0
295
Member Avatar for FarrisFahad

I let users earn money through my site, and I want to record their daily earnings. I want to record their earnings starting from 00:01am I don't know how to do this using PHP and MySQL. I know how to create, update, etc database. But I am streuggling with PHP …

Member Avatar for XxRedSteelxX
0
2K
Member Avatar for lyounkins

This mostly works. It shows the SSN when the first Val radio button is picked. It also shows the PaperAppliction when the second Val radio button is picked. The ONLY problem is that the field PaperApplication shows when the form is loaded before any radio buttons are picked. I need …

Member Avatar for AndrisP
0
274
Member Avatar for kamilacbe

Am looking for something where I could get a array of next three months in number from the current month , i have tried to get the month in string but looking for something like eg : current month is 11 (ie) November so it should return 12,1,2 as next …

Member Avatar for Airshow
0
2K
Member Avatar for Joedanica

idk why my program is not working, i wanted to create a program that counts even and odd number when a user inputs number except 0. Zero is the terminator of the loop. #include <stdio.h> int main(){ int entNum, ans; int even; int odd; do{ even=0; odd=0; scanf("%d",&entNum); ans = …

Member Avatar for Reverend Jim
0
284
Member Avatar for herdhemhola

I am a beginner to php and am designing student information system where students need to enter 9 subject and its corresponding grade based on the number of sittings. Is there any better way to do this apart from what I have been doing? These are my codes: <form name="register" …

Member Avatar for rproffitt
0
678
Member Avatar for jack98

i have manage to insert my checkbox array data into database. the problem is when i check multiple checkbox only the first data in array is inserted in database. i need when i check multiple checkbox, all the data i have check insert into database.can someone help me? this is …

Member Avatar for AndrisP
0
1K
Member Avatar for divyang_patel

[MYSQL] my query is:- SELECT * FROM (SELECT 'attendence' AS 'type',userAS 'username', STR_TO_DATE(in_time, '%d-%m-%Y %H:%i:%s') AS 'time_in', 'in_address' AS 'address_in', STR_TO_DATE(out_time, '%d-%m-%Y %H:%i:%s') AS 'time_out', 'out_address' AS 'address_out' FROM attendence UNION ALL SELECT 'visit', username, STR_TO_DATE(visit_time_in, '%d-%m-%Y %H:%i:%s'), location_in, STR_TO_DATE(visit_time_out, '%d-%m-%Y %H:%i:%s'), location_out FROM visits) t WHERE t.username = 'MCCuser0036' …

Member Avatar for AndrisP
0
334