|
Rick is really fond of fruit juices, but he is bored of their traditional flavours. Therefore, he has decided to mix as many of them as possible to obtain something entirely new as a result. He has N glasses, numbered from 0 to N-1, each containing a different kind of juice. The J-th glass has capacity[J] units of capacity and contains juice[J] units of juice. In each glass there is at least one unit of juice. Rick want to create a multivitamin mix in one of the glasses. He is going to do it by pouring juice from several other … |
|
0
95
|
|
|
I have 3 radio buttons on my form A , B , C but when i clicked on A radio it shows specific dropdown which get data from database table but by fruitid 1 and when i clicked on B it will show data fruitid 2 as onnword. i need to show table data by specific fkid Id. Table name--ABC id| fruitid | name 1 | 1 | Apple 2 | 1 | Mango 3 | 2 | Veg-1 4 | 3 | Juice-1 ////////////////////////////////////////////////////////////////// <select> $getdata = mysqli_query($conn, "SELECT * FROM `ABC` WHERE `fruitid`= '$fruitid'); if(mysqli_num_rows($getdata) > 0){ while($data= … |
|
0
114
|
|
|
I played many games but none of them were soo good, but then i found sims4 and i'm playing it from last 1 year andi also want to know how can i make a better game than this with some more functions and updates. I found a [website ](www.sims4studiodownload.com/unlock-all-items)which tell everything about sims4, check it out and tell me how can i make a good game like this. |
|
-1
63
|
|
Hi everyone I am wondering if someone can help me understand why the Sub-Query's SELECT statement ended up producing the column name 'Code' vs. the initial SELECT statment call 'local_name' in the below screenshot Thanks in advance!  |
|
1
36
|
|
|
How will you guide student?? |
|
0
60
|
|
I 'm building an application to store and retrieve books, but I have an issue with retrieving data from the db. I'm using REST and testing with postman. Everything works OK. Currently I have a series of methods written in Java at the backend like so @Override @POST @Path("/add") //@Produces("application/json") @Produces(MediaType.APPLICATION_JSON) @Consumes(MediaType.APPLICATION_JSON) public Response addBook(Book book) { dbAccess.connectToDb(); return dbAccess.addBook(book); } @Override @DELETE @Path("/{id}/delete") @Produces("application/json") public Response deleteBook(@PathParam("id") int id) { dbAccess.connectToDb(); return dbAccess.deleteBook(id); } @Override @GET @Path("/{id}/get") @Produces("application/json") public Book getBook(@PathParam("id") int id) { dbAccess.connectToDb(); return dbAccess.getBook(id); } So in postman I have a request like http://localhost:8080/book-storage-REST/book/15/get to retrieve … |
|
0
321
|
|
|
Request you professional to extend support to write VB 2005 codes to 1. Open an existing excel Workbook, 2. Populate the cells in the worksheet 3. Save 4. Print the worksheet Thank you and looking forward for your usual support. Regards |
0
13
|
|
|
|
I am trying to get user's information and show them in user's profile. And i found this query but it is in PDO and my work is in sqli here the query : if(isset($_SESSION['user'])){ $getuser=$con->prepare("SELECT * From users where username=?"); $getuser->execute(array($sessionuser)); Sinfo=$getuser->fetch(); And here the whole code <?php session_start(); $sessionuser=''; if(isset($_SESSION['user'])){ $sessionuser=$_SESSION['user']; } if(isset($_SESSION['user'])){ $getuser=$con->prepare("SELECT * From users where username=?"); $getuser->execute(array($sessionuser)); Sinfo=$getuser->fetch(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title></title> </head> <body> Username:<?php echo $info['username']?> Email:<?php echo $info['email']?> Register Date:<?php echo $info['reg_date']?> Password:<?php echo $info['password']?> </body> </html> <?php }else{ header("Location: login.php"); } ?> |
|
1
47
|
|
|
<?php error_reporting(0); require 'conn.php'; global $conn; $tablename = $_SESSION['user_id']."_LIETOTAJU_ATIBLDES"; $sql = "CREATE TABLE ".$tablename." ( id INT NOT NULL AUTO_INCREMENT, ATBILDE varchar(255), PATIES varchar(255), PRIMARY KEY (id) )"; if (mysqli_query($conn, $sql)) { } else { } $val = $_GET['QUESTONS']; mysqli_set_charset($conn,"utf8"); $sql = "SELECT * FROM Jautajumi_Prof where TEMAS_NOSAUKUMS = ? "; $stmt = mysqli_stmt_init($conn); if(!mysqli_stmt_prepare($stmt, $sql)){ header ('location: test.php?error'); exit(); }else{ mysqli_stmt_bind_param($stmt, "s", $val); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); } $sum = 0; $one = 1; $sum = $sum + $one; while ($row = mysqli_fetch_assoc($result)){ echo " <form class='test_place' action='answer.inc.php?QUESTONS=".$_GET['QUESTONS']."' method='post'> <h4>". $sum = $sum + $one .". ".$row["JAUTAJUMS"]."</h4> <input type='checkbox' … |
|
0
32
|
|
|
i want to know how to create qr cde in php |
|
0
45
|
|
|
hello, i have a probelm where i want to update my image in database using unlink(). The error is **Warning: unlink(images/481933.jpg): No such file or directory**. I try search the solution but nothing can solve my probelm. anyone can help me? thank you in advanced. this is my code: $upload_dir='images/'; $imgExt=strtolower(pathinfo($images,PATHINFO_EXTENSION)); $valid_extensions=array('jpeg', 'jpg', 'png', 'gif', 'pdf'); $picProfile=rand(1000, 1000000).".".$imgExt; unlink($upload_dir.$edit_row['prod_img']); move_uploaded_file($tmp_dir, $upload_dir.$picProfile); $stmt=$db_conn->prepare('UPDATE product SET prod_name=:prod_name, category=:category, prod_img=:prod_img, unit_price=:price, stock=:stock, min_limit=:min_limit, weight=:weight, description=:description, packaging=:packaging, size=:size, retail_price=:retail, agent_price=:agent WHERE prod_id=:prod_id'); |
|
0
41
|
|
|
Hi All, I am having an issues with an SQL query and I can't quite work out how to resolve it. I have searched Google for the answer but can't seem to find the solution there either. Basically I have a database andin one of the tables it has a start date column and an end date column. I have a form that you input the start date and end date range you want to search the database for and display the results. My issues is with getting the dates that are inputted on the form to display on the … |
|
0
49
|
|
|
Hi everyone! Do you know how to create Pizzeria Program using Python and PostgreSQL where it can keep track of the pizza orders and view the order information using Python and PostgreSQL? Technology needed: -Django for the program -Postgresql for database How it can be used: Every time there is an order, Henry will add a pizza (Pizza A, B, or C) and will input how many pizza was ordered on that day. By the end of the day, Henry will click on the "Report" button and the system will show the following info: How many pizzas in total were … |
|
1
53
|
|
// To protect MySQL injection for Security purpose $stmt = $conn->prepare($SQuery); $stmt->bind_param("i", $user_id); $stmt->execute(); $stmt->bind_result($fullName); $stmt->store_result(); if($stmt->fetstmt->store_result() ch()) //fetching the contents of the row |
|
0
31
|
|
Trying to get the last row inserted from a Excel sheet. The sheet is called clientes. I have id, name, description Since ID is auto incremental, I can sort by ID: My idea is: oledbcmd = "Select top (1) * From [CLIENTES$] ORDER BY id desc"; but it does not work. Any tips? |
|
0
958
|
|
Hlo Plz anyone give a coading of classic asp i want to save my csv and excel file in databse |
|
0
1,229
|
|
|
I have a database where there is an table `wm` for water meters : +------+---------------+ | Code | name | +------+---------------+ | wm1 | water meter 1 | | wm2 | water meter 2 | | wm3 | water meter 3 | +------+---------------+ and another table c`ounters` where there are counters value : +------+---------+-------+------------+ | Code | Code_wm | value | created_at | +------+---------+-------+------------+ | 1 | wm1 | 100 | 2020-10-18 | | 2 | wm1 | 0 | 2020-10-19 | | 3 | wm2 | 0 | 2020-10-18 | | 4 | wm2 | 100 | 2020-10-19 | … |
1
46
|
|
|
|
Please Provide me the sub Query for the below table that the rows must be unique and make sum of it. This is the SQL QUERY THAT I AM USING SELECT Admission_Fee.srno, Stu_Data.clsname, Sum(Stu_Data.adm_fee) AS Gross, Sum(Stu_Data.Final_adm) AS Final, Sum(Balance.Admission) AS Paid FROM ((Stu_Info INNER JOIN Stu_Data ON Stu_Info.Regdno = Stu_Data.Regdno) LEFT JOIN Balance ON Stu_Info.Regdno = Balance.Regdno) LEFT JOIN Admission_Fee ON Stu_Info.clsname = Admission_Fee.clsname GROUP BY Admission_Fee.srno, Stu_Data.clsname, Stu_Info.Admn_typ HAVING (((Stu_Info.Admn_typ)<>"Annual Charges")) ORDER BY Admission_Fee.srno;  > I Need the Unique rows with sum of duplicate rows.  |
0
32
|
|
|
|
New to this forum and to programming in PHP, so apologies if I miss some detail. I have found some code which does almost everything I need, but I can't figure out how to get the 'selected item' from the results on an secondary page (reading in post) .. this properly retrieves a list of names from a sql table and populates a select list, and two input boxes <div id="ifNew" style="display:none" > <form name = "form2" action="../Form/modified.php" method = "post" enctype = "multipart/form-data"> <div class = "form_data1"> <?php $stmt = sqlsrv_query( $conn,$tsql ); if( $stmt === false) { die( … |
|
1
348
|
|
|
Hi, I am new to php and html, so I need some help with a problem: I am trying to make a form where you can select from a dropbox, but thae data from the dropbox should be retrieved from a sql database. If I save the code bellow as php, the dropbox is created and retrieves the data from sql, but then the submit button (together with everything else I put after the while loop) disappeares. If I save it as a html file, the form and submit button works, but it doesn't retrieve any data from sql database. … |
|
0
3,551
|
|
|
Hi everyone, can someone please help me and give advice as to which software solution to use for the business process described below: Process description by person : Person1: RECORDING THE SPEECH, CREATING THE VISUALS 1 By using the PowerPoint software, create the background image file by updating the title, date, speaker and background image 2 Upload the image file to Dropbox 3. Create the audio file by recording the speech 4. Upload the audio recording to Dropbox 5. Send the Whatsapp message to Person 2 (mixing and publishing to youtube) “File are ready for download and further processing” 6. … |
|
0
26
|
|
|
am using a plugin name - pafe - https://pafe.piotnet.com/ which generates a pdf when someone fills a form. and this plugin use fpdf asset. http://www.fpdf.org/en/script/script92.php but currently, it is not supported Hindi font. right now Hindi not work. how can I use Hindi in the current plugin? plugin author does not take this thing seriously. please help to support Hindi font please check complete pdf asset link of the plugin - PDF assest I have a purchase copy of plugin but for author Hindi is not necessary to add support. Current output link - https://drive.google.com/file/d/1jOVoKn-_T1r1rjBdqiE__90VtdHhTM-M/view?usp=drivesdk |
|
0
17
|
|
|
<?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); session_start(); if (isset($_POST['delete_account'])){ require 'conn.php'; global $conn; $password = $_POST['delete_password']; $email = 'delete@gmail.com'; $user_id = '5'; $sql = "SELECT * FROM user_acounts WHERE e_pasts=?;"; $stmt = mysqli_stmt_init($conn); // Inicializācija if(!mysqli_stmt_prepare($stmt, $sql)){ header ('location: userpanel.php?error'); exit(); }else{ mysqli_stmt_bind_param($stmt, "s", $email); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); } if ($row = mysqli_fetch_assoc($result)){ $password_check = password_verify($password, $row["PAROLE"]); if ($password_check == false){ header ('location:userpanel.php?password=false'); exit(); }else if ($password_check == true){ $SQL = "DELETE FROM user_acounts WHERE e_pasts=?;"; $stmt = mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt, $sql)) { header('location: userpanel.php?error'); exit(); } else { mysqli_stmt_bind_param($stmt, "s", $email); mysqli_stmt_execute($stmt); header('location: userpanel.php?delete=true'); exit(); } } } … |
0
27
|
|
|
I am trying to get the last inserted id to be displayed in alert box. Can anyone help me out. I can echo it out but I want to display the ID in alert box and redirect once the user clicks ok. Thank you so much. I am a new php coder. |
|
0
71
|
|
I have a table with the following fields: CREATE TABLE text ( drawing INT NOT NULL, blockID INT NOT NULL, entityID INT NOT NULL, style INT, txt VARCHAR(255) NOT NULL, attrib INT); My csv file contains the data: 19 1CB2 E49 2 CLIENT MODULAR 1C2A 19 1CB3 E4B 2 CLIENT UG - 2 MODULAR PILOT PLANT 1C2C 19 1CB4 E4C 2 100 - 500 MICRON 1C2D 19 -1 E50 2 USERNAME 1C31 19 1CBA E51 2 15.8.2020 1C32 19 1C16 E58 2 PLANT 1C39 I'm using the following SQL to import the CSV file: LOAD DATA INFILE '/tmp/_P2.8Q9nJ4_/text' INTO TABLE … |
|
0
28
|
|
|
Hi there, I've come across an issue while trying to get all the records from a SQL database in java. A bit of necessary introduction here. I'm not using any framework just JDBC and the getAllBooks method is part of a REST call. The failing method is essentially doing this: -getting the number of all records in the db; -getting all the ids and use them to get the records, store them in an array and return that array; Unfortunately the call generates the following error in the while loop: SEVERE: Servlet.service() for servlet [Jersey Web Application] in context with … |
|
1
389
|
|
|
Hi all, I have a question about updating two values in a sql table using a subquery. My database is called books and the below table books too: id title author location_id 11 Tera Netrear 4 14 Disser Bubu 1 15 Tenno Puoio 4 16 Oban Tyrone 5 18 Sisnobi Teru 3 Location_id is indeed another table as it's a foreign key in this table but that shouldn't matter. So what I want to do is to change all the location_id currently at 4 to 2. I know i could do it like this `update books set location_id = 1 … |
|
0
225
|
|
|
Please Help me. I am coding PHP using below code but out put is not perfect. i am also attach output picture below. <?php require_once 'core.php'; include_once("../fpdf182/fpdf.php"); $pdf = new FPDF(); $pdf->AddPage(); $pdf->setFont("Arial","B",16); $orderId = $_POST['orderId']; $sql = "SELECT orders.order_id, orders.order_date, customer.customer_name, customer.customer_mobile, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, orders.payment_place,orders.gstn FROM orders INNER JOIN customer ON customer.customer_id = orders.client_name WHERE orders.order_id = $orderId"; $orderResult = $connect->query($sql); $orderData = $orderResult->fetch_array(); $orderNo = $orderData[0]; $orderDate = $orderData[1]; $clientName = $orderData[2]; $clientContact = $orderData[3]; $subTotal = $orderData[4]; $vat = $orderData[5]; $totalAmount = $orderData[6]; $discount = $orderData[7]; $grandTotal = $orderData[8]; $paid = $orderData[9]; … |
|
0
65
|
|
|
Hi Guys, I am new here I found this forum very well managed this is very satisfactory. I am new in affiliate marketing as well and want to create affiliate website and was looking for solution with data API. Could anyone help me in this regard, I found a solution, https://www.revglue.com/blog-detail/13-setup-free-uk-mobile-comparison-website, it looked me fine but not sure if really it is. Please provide me guidlines how I can build an affiliate comparison webiste or have you worked with revglue or is there any service provider that i can hire? Thanks Alex. |
|
0
51
|
|
|
I would like to build a software career and am looking for the best software training institution. Can you please help me to find one? |
|
0
19
|
The End.