10,946 Topics
 | |
| | I posted this the other day and by and large people responded with predictable lack of imagination. I will add additional explicit requirements for the prototype stage. I want to create a prototype of a different type of social media - call it "pro social" media. It would be owned …  |
 | Hello everyone! I working on a social network alike page whare I want to implement a messaging system. I can do all that and I have it working. What I want is, when I get two or more messages from someone. I only want to display the lates message from …  |
 | I don't understand why this update script isn't working. It is supposed to get the names of files in the download folder and update the files table in the database. It is running through the code without exiting when it fails to update but still displays "Update Successful". The downloads … |
 | Hi Am new at programming . I ask about how I but button that onclick it's guide me to form this form had submitted page I need to make this form when fellup the data that the user it's sind to my java SQL . Can any one help me … |
 | Hi, I'm trying to create a theme-compatible category system, but I missed some points. For example; `category_name_women_clothing` and `category_name_women_bag`, etc.. are supposed to be collapsible, but I was not successful in this. How can I make a model that opens and closes sub-categories, where am I missing? [This is what … |
| | I have the below file that opens a pdf and puts some text at the top. This is working fine. But what i want to do now is replace mypdf.pdf with the results of a mysql query. Similar to this: `$pageCount = $pdf->setSourceFile('../folder/folder/$mypdf');` and `$pdf->Write(0, '$sampletext');` Each person going to …  |
| | Im am new to node.js and get the mentioned error in server.js file. I am trying to introduce a gantt diagramm with dhtmlx library. I am using Node v16.13.1 and IntelliJ 2021.3 Below are my code snippets. Index.xhtml: <!DOCTYPE html> <head> <meta http-equiv="Content-type" content="text/html; charset=utf-8"> <title>QuickInfo extension</title> <script src="https://cdn.dhtmlx.com/gantt/edge/dhtmlxgantt.js"></script> <link …  |
| | I am a newbie and i am working with php and i have got the following error Parse error: syntax error, unexpected 'INSERT' (T_STRING), expecting ',' or ')' in verify.php on line 9 CODE SNIPPET:    |
| | **Hello guys,** i need with something, i have aproject that am doing now and i have used php so the only challnge am meeting is to calculate grades for the following Overall marks is 100 (Has been divided into three assessments) **assignment 10% midsemester 30% and end semester is 60%** … |
| | $unpaid1="SELECT t.id, t.year, t.property_id, COALESCE(t.amount,0) AS amount FROM tax_amount t WHERE t.status = 'unpaid' ORDER BY t.year"; $resultpropertyunpaid1 = $db->query($unpaid1); while($row = $resultpropertyunpaid1->fetch_assoc()){ $PropertyUnpaid1 = $row['unpaid']; } > When I'm making a new property and put the amount the error will show but after I paid the total amount the … |
| | I like to display 5 million roWs in feW seconds in table using Laravel 7 pls help |
| | Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master …  |
| | What is the best site to learn hacking or book? |
| | hello, im developing a Windows application with MariaDB database for criminals, i designed the whole database schema but i need an expert to help me study it if it is mall designed. |
| | 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' …  |
| | I am working on search API. Currently I am havinng 3 filter i.e. author, publish date, topic. Now I have created a Search API along with paginantion. based on request data it provides result (default page size is 10 for pagination). Now I want to acheive following. Whenver I change … |
| | Hello everyone So, my objective is to update four rows in my database (id-> int , status->tinyint) from 0 to 1 and vice verca using a checkbox. This should be done without refreshing the page and using a form without submit button. Based on my research, I was able to … |
| | I have a table with multiple columns (11 columns appox.) with seach bar, I need the search to be capable to search any string in all columns(ex. search 2 words in two columns...) I'm using mysqli PDO connection with Jquery, ajax, PHP I have tried the below but serching for … |
| | I'm making a movie website and want to make the limit of movies for example 10 per page but every pagination tutorial or guide I find shows only how to do this with lists, I want to do this with cards so it looks like it does on other movie … |
| |  <?php // This page is for editing a user record. // This page is accessed through view_users.php. $page_title = 'Edit a User'; include ('includes/header.html'); echo '<h1>Edit a User</h1>'; // Check for a valid user ID, through GET or POST: if ( (isset($_GET['id'])) && (is_numeric($_GET['id'])) ) { // From view_users.php … |
 | <?php if (isset($_POST['submit'])) { session_start(); include('connection.php'); $email = mysqli_real_escape_string($conn, $_POST['email']); $password = mysqli_real_escape_string($conn, $_POST['password']); $hash_password = md5($password); $sql = "SELECT * FROM users WHERE email = '$email' AND password = '$hash_password' "; $result = mysqli_query($conn, $sql); $row = mysqli_fetch_array($result); if ($row['email'] == $email && $row['password'] == $hash_password) { echo '<script …  |
| | Hi all, My name is Mike and am a completely blind gamer/computer hobbyist. I am attempting to create an online web based single player game in which people can register so the stats, currency etc gathered are safekept and retrievable when someone wishes to continue playing. The data is stored … |
 | Hi guys, I am using bootstrap carousel and I have some problem with the slide display. I can't switch from one slide to another In the code I have commented the <div class = "item active"> This way the video appears to me as desired, fully functional. If I remove … |
| | > Hi, please advise how to resolve. I want to print the receiptno on a receipt and it prints "receiptno". I don't know how to define "receiptno" to use the value in the table. I'm working with mysqli and having trouble with this code: $receiptno='receiptno'; $sql = "UPDATE numbers SET … |
| | Parse error: syntax error, unexpected variable "$sql" in C:\xampp\htdocs\ProjectIT12\LR\controller.php on line 38 <?php include_once ("connection.php"); // connection created succesfullly session_start(); //store all erros $errors=[]; //When sign up button clicked if(isset($_POST['signup'])){ $fname = mysqli_real_escape_string($conn , $_POST['fname']); $mname = mysqli_real_escape_string($conn , $_POST['mname']); $lname = mysqli_real_escape_string($conn , $_POST['lname']); $street = mysqli_real_escape_string($conn , $_POST['street']); …  |
| | 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 trial (imageType ,imageData,uploaded_on, user_id,tax_payer_id) VALUES('{$imageProperties['mime']}', '{$imgData}',NOW(),'".$_SESSION['id']."','".$_GET['id']."')"; $current_id = mysqli_query($db, $sql) or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($db)); $current_id = mysqli_insert_id($db); if (isset($current_id)) { echo "Upload Succesfully"; }else{ echo "There is a … |
| | <?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"> … |
| | <?php if(isset($_SESSION['id']) ) { ($_SESSION['id']) { //echo "you're login"; } echo "<form action='upload.php' enctype='multipart/form-data' method='post'> <br>Qr Code: <p><input type='file' name='file' > <p><input type='submit' value='Upload' name='submit'> </form>"; } ?> <?php $statusMsg = ''; // File upload path $targetDir = "qr_code/"; $fileName = basename($_FILES["file"]["name"]); $targetFilePath = $targetDir . $fileName; $fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION); … |
| | hello , i wanna do something as below but the problem that names and address out of the connection query are empty how can i assign them and the send them to the page? app.get('/reports', (req, res)=>{ let sql = "SELECT DISTINCT name from users_table ;"; let names; let query … |
| | Hello I just want to ask for some help regarding with the undefined index error. The image are uploaded / stored in database but the image cant store in folder directory. Please can someone help me. This is for my project. Thank you guys in advance. |
 | Hi ... how can i have url seo friendly from database ?? Example: localhost/myshop/product.php? id = 95 Or: https://www.myshop.it/product.php?id=95 I have done several tests with .htccess but it doesn't work. I would like to have as follows: https://www.myshop.it/product.php/shoes-armani Or: https://www.myshop.it/shoes-armani tbl_product +-------------+----------------+-----+----------------+ | p_id |p_name | p_name_friendly| +-------------+----------------------+----------------+ | 95| … |
| | I have a problem assigning position (number) based on the total marks. Here is the code. TQvm for your assistance the calculation is done perfectly, the ranking is shown correctly but with no numbers, 1, 2 ,3..... how to set autoincrement for this field (ranking) which is based on the …  |
| | Hi, below is the code in my login button, yet I'm confused what code to put in logout button. I only know few knowledge about vb.net and I am trying to understand it as much as I can. Thank you for understanding! :) Public Class Form2 Private OPConStr As String …  |
 | Hi guys im trying to do a Login system in Wpf with Visual Studio I got the code and DB working fine with Windows Forms in Visual Studio I have changed the code 3 times and they all work on Windows forms but not with Wpf Forms. Below is the … |
 | I have a issue with the code below what I am trying to get the image from gifts table with matching the user_gifts id with the gifts_id but can not seam to get it right anyone god any ideas thanks. public function get_my_gifts($user_id) { global $db; $my_gifts = []; $get_my_gifts … |
| | 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 … |
| | Hi, I need your help. I am a newbie in PHP and my update statement is not working despite seeing all the values from the console. My code for the bootstrap modal file: <!----------------------------------- modal begin --------------------------------------> <div class="modal fade" id="editmodal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div … |
| | $sql = "SELECT cl_id, cl_name, cl_service_description, cl_contact, cl_dept,status, expiry_date from contract_list"; $result = $conn-> query($sql); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()) { echo "<td>$row[cl_id]</td>"; echo "<td>$row[cl_name]</td> "; echo "<td> $row[cl_service_description]</td>"; echo "<td>$row[cl_dept]<td>"; echo"$row[status]"; echo "<td>$row[cl_contact]</td>"; echo "<td>$row[expiry_date]</td>"; echo "<td></td>"; echo "<td><div class=table-data-feature>"; echo "<button class='item' data-toggle='tooltip' data-placement='top' title='send'>"; … |
| | Hello , I have a program which show reports of students i habe multipile dropdown lists in my page and what the supervisor do is selecting what he wants to show first " for example students who live in usa " /ps i have multi dropdown lists /then my program … |
| | hello i'm trying to schedule event from mysql in node js i know how to execute query (connection.query("select * from test") but how to do that in nodejs --------> CREATE EVENT IF NOT EXISTS reurring_event ON SCHEDULE EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 1 minute DO INSERT … |
| | [ { "regionCode": "0", "": { "amount": "291377681.35999995", "kwh": "5589027.089364664", "numberOfPay": "43876" } }, { "regionCode": "3", "AZARE Region": { "amount": "13494424.550000023", "kwh": "286885.42398979055", "numberOfPay": "3863" } }, { "regionCode": "7", "BAUCHI Region": { "amount": "55739882.11", "kwh": "1297297.378804144", "numberOfPay": "11199" } }, { "regionCode": "5", "BUKURU Region": { "amount": "77074190.08000007", … |
| | I moved my website from host to another, moved database and public_html file, Also, I modified wp-config file and deleted hlaccess. But, now I can't update any plugin or delete there is message said update_option( 'siteurl', 'https://zone1on.com' ); update_option( 'home', 'https://zone1on.com' ); Skip to main contentSkip to toolbar At the … |
| | Hello ... i have a table which has one button i need to send the id of that record in the table to the next page the will be directed to once i click the butoon i don't want to send it in the url ... so what i did … |
| | $company_id = $_SESSION['compid']; $sql="SELECT * FROM `movies` WHERE companyID = ? AND name LIKE '%$search%' OR description LIKE '%$search%' " ; $stmt=mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt,$sql)) { header("location:main.php?error=stmt failed"); exit(); } mysqli_stmt_bind_param($stmt,"i", $company_id); mysqli_stmt_execute($stmt); $result = $stmt->get_result(); |
| | hello i am using node js and mysql and i am dealing with payment table and i wanna insert record automatically based on the date and perod for example i have student who will pay every week something so i wanna be able that insert record every week in my … |
 | Hi I have mysql table as below id | item_id | date | received Now I want to make a html table from above data where columns are year and rows are months. and value will be sum of received on month _ year. like below demo | | 2018 … |
| | Hi, I am currently working on a banlist and I am thinking about which data type to choose for storing the IP address in the database. Will the Binary data type be ideal?  |
| | > Hi guys, I blinked and got lost. All I want to do is copy Payfile to Pmtfile and then update records in Payfile that have been paid(amtpaid !=''). The update doesn't happen and the insert-note comments at botom of post. <?php $link = mysqli_connect("localhost", "root", "", "prerentdb"); // Check …  |
| | Been programming more than half my life and been in industry for over a decade.  |
| | Illustrate a database for the video club using a recent video club entities |
The End.