Php FPDF, VALUE=2 then 2 ROWS

Question

0.00/5 (No votes)

See more:

Hello, is it possible to display to rows when MySQL value=2?

For Example: value=2 then Row1=Test1234, Row2=Test1234

Thanks!

Edit:

PHP

<pre><?php
require_once("DBController.php");
$db_handle = new DBController();
$result = $db_handle->runQuery("SELECT * FROM toy");
$header = $db_handle->runQuery("SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='blog_samples' 
    AND `TABLE_NAME`='toy'");

require('fpdf/fpdf.php');
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',12);		
foreach($header as $heading) {
	foreach($heading as $column_heading)
		$pdf->Cell(90,12,$column_heading,1);
}
foreach($result as $row) {
	$pdf->SetFont('Arial','',12);	
	$pdf->Ln();
	foreach($row as $column)
		$pdf->Cell(90,12,$column,1);
}
$pdf->Output();
?>

That is the basic code.
The Database entry looks like this:
name=test1234
value=2

if value=2 i want to display this row twice. If value=1 i want to display the data only once.

What I have tried:

I tried to search for this in google but I dont found any soloution.

Posted 29-May-20 23:46pm

Fynn Pfingsten

Updated 7-Jun-20 6:34am

v3

Add a Solution

Comments

Richard MacCutchan 30-May-20 5:48am

Your question is not clear; please add more details, especially explain what is not working.

Fynn Pfingsten 30-May-20 5:57am

Done!

Richard MacCutchan 30-May-20 7:07am

Just use it as another loop variable to repeat a row. But I cannot see where the value variable gets set.

Fynn Pfingsten 30-May-20 7:26am

Thanks! Yes because i dont know how to do, can you help me please?

Richard MacCutchan 30-May-20 8:11am

OK. Where is the value variable? I do not see any mention of it in your code. Where is the code that is trying to display this data?

Fynn Pfingsten 7-Jun-20 10:02am

Hello this is the code i have, but i dont know how to do it with a table. I test it with echo in php but i dont know how to do it with html table row.

$sql = "SELECT * FROM list";

//use for MySQLi OOP
$query = $conn->query($sql);
while($row = $query->fetch_assoc()){
$contents .= "
".$row['1']." ".$row['2']." ".$row['3']." ".$row['4']." ";

if ($row['4']> "1") {
echo "Zeile wird verdoppelt!!";
echo "";

} else {
echo "Zeile wird nicht verdoppelt!";
echo "";
}

}

Richard MacCutchan 7-Jun-20 11:16am

See How to create a table in HTML using PHP - Stack Overflow[^]

Fynn Pfingsten 7-Jun-20 11:52am

Hello, thanks! But now its displayed as row. But how can i list it first all and then when row4=2 then to the if else statement?

if ($row['4']> "1") {

echo "" . $row["1"] . ""
. $row["2"]. "";

} else {
echo "" . $row["1"] . ""
. $row["2"]. "";

}

Richard MacCutchan 7-Jun-20 12:07pm

Sorry, I do not understand what you are trying to do, or what the problem is. In your if-else statement you are displaying the same things in both blocks.

Fynn Pfingsten 7-Jun-20 12:14pm

you're right! I will explain the problem to you. first I want to put the unchanged data in a table (from mysql). if the values are now from column 4 = 2, the column should be displayed twice in the table just created. Do you understand my problem

Richard MacCutchan 7-Jun-20 12:28pm

No, I am sorry but that really does not mean anything to me. What values are you referring to? What do you mean by "if the values are now from column 4 = 2", etc.?

Fynn Pfingsten 7-Jun-20 14:10pm

Sorry for the lack of understanding. I explain it to them very precisely because I don't want to make them unnecessarily work. if you enter a form name = test and a value = 2. Value = 2 is the quantity as an example. If Quantity = 2, the input from mysql, ie name = test, should be displayed in two columns.

Here is a sample photo of a table of how it should look:

https://drive.google.com/file/d/1TJyRIzaD0YJUU3D5hTdS1rUqsW2rxeLA/view?usp=sharing

Richard MacCutchan 8-Jun-20 3:38am

So my suggested Solution below is correct or not?

Fynn Pfingsten 8-Jun-20 7:45am

your code is half correct 2 is a variable and so often the column should be doubled. if it is three, it should be displayed three times.

Richard MacCutchan 8-Jun-20 8:04am

So what exactly is your problem? Writing a simple if (or even a compound if-else) statement and a few echo commands is not exactly difficult.

Fynn Pfingsten 8-Jun-20 9:31am

I don't get the if else statement because I'm not a programmer. could you help me? if value = 3 the column should be displayed three times in the table.

Richard MacCutchan 8-Jun-20 11:24am

It's just the same as the one for value = 2 below, except for 3.

Fynn Pfingsten 8-Jun-20 11:42am

yes that's what i wanted. Thanks a lot. I have a question though, if value can be 1 to 100, do I have to do this step for numbers 1 to 100? dss is important!

Richard MacCutchan 8-Jun-20 11:57am

No, then you would need to get the number as an integer and create a loop. So you would need something like:

var count = $row[4];for (i = 0; i < count; i++) {  echo $row[1]." ";}

But if you really want to solve this you need to go and study Javascript.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2020-06-07T06:35:00

Solution 1

Is this what you mean?

PHP

if ($row['4'] == "2") {
			
 echo "" . $row["1"] . "" . $row["1"]. "";
}
else if ($row['4'] == "3") {	

 echo "" . $row["1"] . "" . $row["1"]. "". $row["1"]. "";
} 
else {

 echo "" . $row["1"] . "";	
				
}

Posted 7-Jun-20 6:35am

Richard MacCutchan

Updated 8-Jun-20 5:29am

v2

Comments

Maciej Los 26-Jun-20 3:10am

This version:

var count = $row[4];for (i = 0; i < count; i++) {  echo $row[1]." ";}

is more adequate ;)

Richard MacCutchan 26-Jun-20 3:16am

Yes, as in my comment the following day. I really cannot remember what this was all about. :(

Maciej Los 26-Jun-20 3:27am

I think that the modesty inside you is taking...
Seems, you've guessed what OP is trying to achieve...
Cheers!
Maciej

Richard MacCutchan 26-Jun-20 3:57am

Oh I know that. It's just that i can't remember how I got the answer. :)

Maciej Los 26-Jun-20 4:17am

Well... In such of cases, we call that phenomena in Poland: "pomroczność jasna". (BTW: Lech Walesa - ex. polish president use it for the first time) I'm pretty sure there's no direct translation. I think it might be: 1) "momentary laps in judgment", 2) "blind-drunk". The second one is more about original meaning... Some times some words, some ideas, thoughts come to our brains with no reason...

Richard MacCutchan 26-Jun-20 4:43am

I think version 2 applies to me. Even when sober my brain struggles to remember things. Google translates that as "clear darkness", which makes a lot of sense.

Maciej Los 26-Jun-20 4:52am

It happens to me quite often too ;)