Comments by FRS4002 (Top 67 by date)

It worked! Thanks!

Both methods didn't work... They both displayed an empty image... But the second method gave me this long thing:

<img src="image/jpeg;base64,/9j/4AAQSkZJRgABAQAASABIAAD/4gogSUNDX1BST0ZJTEUAAQEAAAoQAAAAA">

The code of course is larger than that... How to fix this issue?

Sorry, but I don't understand what should I do...

No I have a PDF file, and I want to convert the first page only to a JPG thumbnail... I also tried using

<img src="<?=$im;?>">

but I am getting the same result...

Thanks it worked! But I need to change the initial color... I need it to be default color. Like for exampe, initial or inherit...

Ok, but how this will affect my code and my problem ??

Ok I fixed it!! The problem is that I must add exit(); after header(); But I don't know why though...

It is returning nothing ... If I put this code:

        if(isset($_SESSION["msg"])){
        echo $_SESSION['msg'];
        }

It works but the message will not be removed. I just need a fix here. If I add unset the message will never be displayed at all.

I added session_start it says:
Notice: session_start(): Ignoring session_start() because a session is already active
There is a session start in init.php I said that multiple times ... and it is working fine. Also, I am not getting any errors... I don't know where the problem is...

This code is in init.php

<?php
ob_start();
session_start();
?>

Also, I tried to echo session msg but nothing happened... But why it works when I remove unset? How to fix this issue?

I already said that session_start(); is in init.php and it works well ...

Ok, could you please give me at least a temporary fix for the issue corresponding to my code above?

Ok thanks, but what about my main question?

Done!! I just added:
$param = str_replace('%', '\\%', $param);
above foreach loop. Thanks alot!

Ok, what I understand from you is to leave % on both sides and add \%. I tried that here:
$condition .= "description LIKE '%\%" . mysqli_real_escape_string($db, $text) . "%' AND ";
It didn't work too ... Sorry, I am facing difficulties on how to apply the escape on the code ... Is it even doing \% right ?? Could you please help me apply the escape on the code ??

Ok thanks for explaining the issue. I think you are right ... But I didn't understand the solution ... I checked the link you sent, there is a table 9.1, that it says I should use \%, I don't know if I understand or no. So, I changed the code to this:
$condition .= "description LIKE '\%" . mysqli_real_escape_string($db, $text) . "\%' AND ";
But the search stopped working ... I am not getting any results even if I type an existing word ... Could you please help me what to do ??

@Sandeep Thanks Sandeep, But I tried that, and it didn't work... It didn't show the header... Could you please help me to apply same code on my fiddle?

For example, if I have 3 dates in the database 28/07/2022, 29/07/2022 and 30/07/2022. If I input 01/05/2022 as a first date and 30/07/2022 as a second date it will calculate the total between these 2 dates, meaning, it will calculate the total of dates of 28/07/2022 until 30/07/2022, even though there is no 01/05/2022 in the database, but it will still calculate, and that's not what I want...

Yes! It worked like a charm!

Oh my god! Unbelievable! It worked after a long time finding a solution! Thanks a lot! But what if I added Copy Code

uom.id = 'uom' + rowNumber;

underCopy Code

items.id = "items" + rowNumber;

How can I add it in here?Copy Code

 $(`input[name="inputpicker-${++inputCounter}"]`).data("itemsSelector", "#" + items.id); $(document).on("input", "input[name^='inputpicker-']", function(){     const itemsSelector = $(this).data("itemsSelector");     if(itemsSelector){       $(itemsSelector).val("");     } });

I've tried this

 $(`input[name="inputpicker-${++inputCounter}"]`).data("itemsSelector", "#" + items.id);
 $(`input[name="inputpicker-${++inputCounter}"]`).data("uomSelector", "#" + uom.id);
 $(document).on("input", "input[name^='inputpicker-']", function(){
     const itemsSelector = $(this).data("itemsSelector");
     const uomSelector = $(this).data("uomSelector");
     if(itemsSelector){
       $(itemsSelector).val("");
     }
     if(uomSelector){
       $(uomSelector).html("");
     }
 });

But itemsSelector code didn't work as it should after adding uomSelector...

It gives a number to the row when the row is added to the document. The plugin is initialized automatically, when a new row is added. When I add a new row, it automatically adds to the row a new name to first input (inputpicker) and id to the second input (items).

Ok, name="inputpicker-2", is automatically created by the inputpicker plugin. It automatically gives to each row a number. For example, row 2, inputpicker-2, row 3, inputpicker-3. I am sure about that from the elements tab in the browser. Now regarding items, I have edited the code above. I made a counter to items, it gives to each row a number exactly same as inputpicker.

I've added X-Content-Type-Options=nosniff in meta tag, but still the issue exist...

There are 7 steps, did I say I need someone else to debug my code ?? I am saying there are 7 steps, which should I choose among them ?? I am just asking which steps to choose. If I need someone to debug my code, I would not open the link at all ...

There are a lot of steps... Which is the easier and better step?

Could you explain more? What do you mean by "Set a breakpoint on the first line of the event handler and step through it"? How can I do that?

Ok, there is no ajax request. I've tried on a working code and I see the ajax request, but the code that has the issue there is no ajax request

In short, the aim of this code is to check if the item number and title is available in the database, if item number is available in the database change the input color into red and show a red exclamation mark else make input green and show a green check mark, same thing to title. So, these colors are not working... Also, where and how to see exactly ajax request in developer console?

@long ware I already said before there are no errors in console. Regarding software fiddler there are 5 products, what products should I use ?? and how to use it ?? Also, there are no errors in php logs regarding this issue. Could you please check my code and tell me where is the error or what's wrong in my code ??

But I am using for loop, separate items means a lot of code to be done + not efficient

Then how can I send array values ??

uom[] is the name attribute, is it way wrong?

Thanks. I don't have any issues at all regarding this... I just need to validate fields.

Thanks for your reply. Yes, that's because php code is between two html code blocks. It is not an issue, I need the answer to my question, thanks.

I don't know if it is a good idea, but here is the usage of quantity package. Quantity is different than quantity package, so there is a column called quantity and another column called quantity package (qp). I am using quantity package to calculate the remaining quantity of a product. Because some products could have multiple uom. Therefore, I need to unite the database to one uom which is pieces. Uom 1 is piece, uom 2 is dozen, uom 3 is set. So, when a product with a quantity of 50 has multiple uom let us say piece and dozen so, 2 dozens x 12 = 24 piece. 12 is the qp. But if I have 1 uom for a product like dozen only so, 2 dozens x 1 = 2 dozens. Therefore, uom 2 could have 1 or 12 as a qp. I hope you understand. I don't know if you have a better way of doing this, please share it to me. Thanks.

Yes! I understand the composite key now! You made the id a primary key because the value in it is the value of a primary key in Items table which is id. Same thing for uom in Prices table, the id is also a primary key because it gets the value from a primary key from another table which is uom table. So, in both columns we are actually adding ids/primary keys of another tables! Since we have 2 primary keys in the table, we call them composite key. Ok, then there will never be an autoincrement to any column even the primary keys in Prices table, right? Also, please you didn't answer my question above regarding 2nd normal form... "What is the role of 2nd normal form in this 2 tables, Items and Prices? Does 2nd normal form apply to these tables?" and why?

There are exactly 2 tables only in the database uom table and products table. Uom table has id and uom only, products table is available in the original post.

First of all, I read the links, honestly I didn't understand, it is a little bit confusing. Because, I am getting different info from different links/people.
For point 2, uom in step 1 is considered has multi-value or not? And if not, why?
For point 5, 2 columns are primary keys? Is that normal? And why uom is also primary key with id?
Also, what is the role of 2nd normal form in this 2 tables, Items and Prices? Does 2nd normal form apply to these tables?

Thanks a lot for clarifying the matter, but I have a lot of questions regarding on what you post.
1-In step 1 and step 2 I don't see a primary key at all... Is that normal? And what if I need to add a primary in the same table, how this could happen?
2-In step 1, you considered that uom column is free of multi-value? That means 1:1:10.00 itself is not a multi-value? I thought uom column in step 1 is still has multi-value, it has uomid, quantity package and price. Why didn't you skip step 1 and head to step 2 directly?
3-When you split step 2 into 2 tables Items and Prices, is it still in 1st normal form?
4-In Prices table, the id is repeated, as if the itemNo and title is repeated in step 2 but with the id. So, the repetition is still there...
5-Same question of number 1 but in Prices table regarding primary key.

If you mean uom table, the uom table has only the id and the uom, nothing else. I think uom table won't affect here...

Ok, can't I normalize it in one table? Is that an issue if the name and supplier is repeated? Some people said you can normalize on the same table or by splitting it into 2 tables, is that correct? Which way to use?

Thanks a lot!

Yep! I edited the code to:

$uom_price = explode(",", $product['uom_price']);
$price_price = explode(",", $product['price']);
echo $uom_price[0].':'.$price_price[0].' ';
if(!empty($uom_price[1])){
   echo $uom_price[1].':'.$price_price[1].' ';
    }
if(!empty($uom_price[2])){
   echo $uom_price[2].':'.$price_price[2].' ';
  }

and it worked! But I have 2 questions, in my situation which is better to use !is_null or !empty? Also, regarding my previous question there is an optional issue, I need to display the prices without the double zeros at the end 10.00 > 10 unless there are numbers...

I just did that

$uom_price = explode(",", $product['uom_price']);$price_price = explode(",", $product['price']);echo $uom_price[0].':'.$price_price[0].' ';echo $uom_price[1].':'.$price_price[1].' ';echo $uom_price[2].':'.$price_price[2].' ';

and that's the result https://jsfiddle.net/vapfchr6/ it is almost exactly what I wanted but as you can see there is an issue. In uom and price for chests, it displays piece:60.00 :: with 2 colons, how to fix this issue? I think I need to do if statement if there are more uoms display the colon, but I don't know how to do it in my code above... Also there is an optional issue, I need to display the prices without the double zeros at the end 10.00 > 10 unless there are numbers...

What do you mean by split requests? You mean I should do another MYSQL code and add it to a variable?

It gives almost same result as the previous MYSQL code... I made this code:

SELECT products.id, products.itemNo, products.title, GROUP_CONCAT(uom.uom) AS uom_price, GROUP_CONCAT(products_uom.price) AS price, products.quantity FROM ((products INNER JOIN products_uomON products_uom.product_id = products.id)INNER JOIN uomON products_uom.uom_id = uom.id) GROUP BY products.id

and did a while loop afterwards but this is what I got https://jsfiddle.net/b3dv4ckf/
and this what I want to achieve https://jsfiddle.net/aczshequ/
A little bit similar to my goal. Now I need to print the prices against each uom like so piece:10 dozen:20. How can I do that in PHP?

I am thinking of doing GROUP BY(title) for example, but I don't know if it can help. Also, if it helps I don't know how to implement it in MYSQL code above...

This is what I got https://jsfiddle.net/mz9aoxyb/
and this what I want to achieve https://jsfiddle.net/aczshequ/

Thanks, I have tried the above MYSQL code that you wrote but I got almost everything repeated...

Thanks, now I tried the code in phpmyadmin and I didn't get any issues. Now pardon me, you didn't answer my question above, there are 4 kinds of joins, which to use in my case? Is it only inner join? Also, now if I want to implement this in PHP I am thinking to do a while loop correct me if I am wrong

while($product = mysqli_fetch_assoc($presults)){-----}

Now how can I display a specific value from joins? like this?

$product['uom.uom'];

Does this works or there is a right way?

Thanks, but weird, it says "Unknown column 'products_uom.uom_id' in 'on clause'". Also there are 4 kinds of joins, which to use in my case? Is it only inner join?

@Richard MacCutchan Could you please provide me for the right MYSQL code for my situation?

What do you mean it is not my code ?? What if the user want to choose another value ?? I must let user choose/edit the input ...

SQL injection fixed. But what about my issue? I think javascript is saving the value of the filter in the memory or something similar. I don't know what to do...

SQL injection fixed. I think javascript is saving the value of the filter in the memory or something similar. I don't know what to do...

@Richard Deeming This is the sanitize function

function sanitize($dirty){ return htmlentities($dirty, ENT_QUOTES, "UTF-8"); }

It isn't enough? I've tested SQL injection and the function works fine

@Richard Deeming Oh my god! It fixed the issue! I literally asked a lot of people about it no one know the solution. Thank you so much! You deserve 100 stars!