FloatQuote.php

<?php $page_title = ' Quote Float'; ?>

<?php
$nav_selected = "LIST";
$left_buttons = "NO";
$left_selected = "";
require 'db_credentials.php';
include("./nav.php");
include("puzzlemaker.php");
include("rebuild-puzzle-form.php");
?>

<?php
error_reporting(0);
include_once 'db_credentials.php';

$sql = "SELECT * FROM quote_table
			WHERE id = '-1'";
$flagged = true;
$spaces = array();
$touched = isset($_POST['ident']);
$db->set_charset("utf8");

if (!$touched) {
	echo 'You need to select an entry. Go back and try again. <br>';
?>

	<button><a class="btn btn-sm" href="admin.php">Go back</a></button>

<?php
} else {
	$id = $_POST['ident'];
	$sql = "SELECT * FROM quote_table
		        WHERE id = '$id'";
}

if (!$result = $db->query($sql)) {
	die('There was an error running query[' . $connection->error . ']');
}

$norows = 16;
?>

<script type="text/javascript" src="js/html2canvas.js"></script>
<script type="text/javascript" src="js/main.js"></script>

<form id="columnnumber_form" method="post">

<input type="submit" name="generate" id="generate" value="Generate" id="generate">
<!-- Width dropdown selector, default value is 10 -->
<label for="width">Columns:</label>
    <select name="width" id="width" autocomplete="off">
        <?php
        if (isset($_POST['width'])) {
            $width = $_POST['width'];
        } else {
            $width = get_preference('DEFAULT_COLUMN_COUNT');
            if (is_null($width)) {
                // if no datbase preference for width exists, default value is 16
                $width = "12";
            }
        }
        for ($i = 8; $i <= 13; $i++) {
            echo '<option value="' . $i . '"' . (($i == $width) ? ' selected' : '' ) .'>' . $i . '</option>';
        }
        ?>
    </select>

        <?php
                    echo '<input type="hidden" name="ident" value="'.$_POST["ident"].'"> ';
        ?>

</form>



<div id="convert-to-image">
	<?php

	echo '<h2 id="title">Float Quote</h2><br>';

	$punctuation=TRUE;
	$sqx = "SELECT * FROM preferences WHERE name = 'KEEP_PUNCTUATION_MARKS'";
	$resultPunct = mysqli_query($db,$sqx);

	while ($rowPunct =mysqli_fetch_array($resultPunct)){
		$punctuation=$rowPunct["value"];
	}

	if (isset($_POST['width'])) {
			$width = $_POST['width'];
	} else {
			$width = get_preference('DEFAULT_COLUMN_COUNT');
			if (is_null($width)) {
					// if no datbase preference for width exists, default value is 16
					$width = "12";
			}
	}

	if ($result->num_rows > 0) {
		while ($row = $result->fetch_assoc()) {
			$quoteline = $row["quote"];
			//makes an array from the line
		}
	}
	if (isset($quoteline) == false){
		exit(0);
	}
	else {
		if ($punctuation == "FALSE"){
			$quoteline = str_replace(['?', '!', "'", '.', '-', ';', ':', '[', ']',
			 ',', '/','{', '}', ')', '('], '', $quoteline);
		}
		FloatMaker($quoteline, $width);
	}
	?>
</div>