PHP - Appending Query Strings

strings from a field(type: VARCHAR(4000)) are being truncated at 255 characters. Apparently this is how varchars work(how is that useful?). I've found these two solutions on the internet but neither of them seemed to work.

first, some people thought it might be a php.ini thing, so I put this at the top of my php file:

Code: [Select]
ini_set ( 'mssql.textlimit' , '65536' );
ini_set ( 'mssql.textsize' , '65536' );
that didn't work, so other people suggested using the text field type instead but these two queries return nothing, so I must be doing something wrong or this just isn't the answer:

Code: [Select]
$bquery="SELECT CONVERT(TEXT,description) FROM table WHERE userID='$row[userID]'";
$bquery="SELECT CAST(description AS TEXT) FROM table WHERE userID='$row[userID]'";

I am building a project that requires I store query strings in a table (stage_reqs) which are called to determine permissions. These strings will look something like this:

Code: [Select]
select salesman from jobs where salesman is not NULL and job_id='".$this->job_id."' limit 1
The variable value needs to be determined from within the function it is being accessed in. Can I use eval to do this?

Thanks,
Chris

Hello there, i`m trying to figure out a way to reorder a query string depending on variables.

So the url would have the following query:
/result/index.php?page=Weissenfels+Clack+and+Go&tyre=155_70_12&option1=30_02&option2=43_02&v_t=car&options=2

It should depend what page they come from if the page is equal to option2 then option1 is op1 and option2 is op2

To make it myself easier i have converted some variables
On every first two digits ie 43 from the 43_02 can have 13 different ending digits, ie _03 or _04 or _05 etc...

So i have converted all 43_02 43_03 etc to one variable ie $chain1 or $chain2 which holds in this case 43

a 43 is equal to Weissenfels+Clack+and+Go

in the index page i have included the following process.

At the moment i can only use php coding, unfortunately no mysql atm

thank you in advance.

Code: [Select]
<?php


$tyre = $_GET['tyre'];  // finds the tyre size
$op1 = $_GET['option1'];  // finds the first chain size if applicable
$op2 = $_GET['option2'];  // finds the second chain size if applicable
$op3 = $_GET['option3'];  // finds the third chain size if applicable
$op4 = $_GET['option4'];  // finds the fourth chain size if applicable
$op5 = $_GET['option5'];  // finds the fith chain size if applicable
$op6 = $_GET['option6'];  // finds the sixth chain size if applicable
$op7 = $_GET['option7'];  // finds the seventh chain size if applicable
$op8 = $_GET['option8'];  // finds the eighth chain size if applicable
$options = $_GET['options'];
$page = $_GET['page'];
$error = $_GET['info'];
$vehicle_type = $_GET['v_t']; // finds the vehicle type

$b = "Weissenfels+WeissTech+Tecna";
$c = "Weissenfels+Clack+and+Go";


if (($op1 == "30_02") || ($op1 == "30_03"))
{
$chain1 = "m30";
}

elseif (($op2 == "43_02") || ($op2 == "43_03"))
{
$chain2 = "m43";
}
else echo "error";

switch ($page)
{
case (($page == $c) && ($chain1 == "m43"));
$option1 = $op1;
$option2 = $op2;
break;
case (($page == $c) && ($chain2 == "m43"));
$option1 = $op2;
$option2 = $op1;
break;
default;
        $option1 = $op1;
$option2 = $op2;
    break;
}

if ($options=="1") // calculates the possible combination
{

// outputs the results

include 'options_1.php'; // type the amount of possible chains in here ie options_3 options_4 etc

}

elseif ($options=="2")
{
// outputs the results

include 'options_2.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="3")
{
// outputs the results

include 'options_3.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="4")
{
// outputs the results

include 'options_4.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="5")
{
// outputs the results

include 'options_5.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="6")
{
// outputs the results

include 'options_6.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="7")
{
// outputs the results

include 'options_7.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}

elseif ($options=="8")
{
// outputs the results

include 'options_8.php'; // type the amount of possible chains in here ie options_3 options_4 etc
}


else
echo "there is an error on process_action2";


?>

Is it possible to have a link like this, http://www.somesite.com/?id=243 and transfer the "id" (or another query string) into the website from the link but at the same time, not affect the website (since "id" isn't a query string originally used in the website's URL)? I hope that makes sense..

I am trying to append data to a variable through each loop of a MySQL array, but I am doing it wrong. Is this possible? Here is the code.
$html = <<<TABLE
<table border = "1" align = "center">
TABLE;
//// Get Endorsement Info
$endo = mysql_query("SELECT * FROM endorse WHERE endonum = '$endonum' AND agency = '$agency' ORDER BY ID DESC LIMIT 1");
while($endofetch = mysql_fetch_array($endo)){
$endotype = $endofetch['type'];
$typeid = $endofetch['typeid'];
$change = $endofetch['changetype'];
$info = mysql_query("SELECT * FROM $endotype WHERE ID = '$typeid'") or die(mysql_error());
$infoout = mysql_fetch_array($info);
$date = date("m/d/Y g:i a", strtotime($endofetch['date']));
if($endotype == "drivers"){
$firstname = $infoout['firstname'];
$lastname = $infoout['lastname'];
$licnum = $infoout['driverslic'];
$vyear = $infoout['year'];
$vmake = $infoout['make'];
$vmodel = $infoout['model'];
$vvin = $infoout['year'];
$html .= <<<TABLE
<tr>
<td>Endorsement Request Date:</td><td>{$date}</td>
</tr>
<tr>
<td>Change Requested:</td><td>{$change} Driver</td>
</tr>
<tr>
<td>Driver Info:</td><td>{$firstname} {$lastname} </td>
</tr>
<tr>
<td>License Number:</td><td>{$licnum}</td>
</tr>
<tr>
<td>Signature __________________</td><td>Date:_____________</td>
</tr>
TABLE;
}
if($endotype == "vehicles"){
    if($change == "Delete"){
     $veyear = $endofetch['year'];
     $vemake = $endofetch['make'];
     $vemodel = $endofetch['model'];
     $vevin = $endofetch['vin'];
    $html .= <<<TABLE
<tr>
<td>Endorsement Request Date:</td><td>{$date}</td>
</tr>
<tr>
<td>Change Requested:</td><td>Delete Vehicle</td>
</tr>
<tr>
<td>Vehicle Info:</td>
</tr>
<tr>
<td>Year:</td><td>{$veyear}</td><td>Make:</td><td>{$vemake}</td><td>Model:</td><td>{$vemodel}</td>
</tr>
<tr>
<td>Vin Number:</td><td>{$vevin}</td>
</tr>
<tr>
<td>Signature __________________</td><td>Date:_____________</td>
</tr> 
TABLE;
    }
    else
    {
$html .= <<<TABLE
<tr>
<td>Endorsement Request Date:</td><td>{$date}</td>
</tr>
<tr>
<td>Change Requested:</td><td>{$change} Vehicle</td>
</tr>
<tr>
<td>Vehicle Info:</td>
</tr>
<tr>
<td>Year:</td><td>{$vyear}</td><td>Make:</td><td>{$vmake}</td><td>Model:</td><td>{$vmodel}</td>
</tr>

<tr>
<td>Vin Number:</td><td>{$vvin}</td>
</tr>
<tr>
<td>Signature __________________</td><td>Date:_____________</td>
</tr>
TABLE;
}
}
}
$html .= <<<TABLE
</table> 
TABLE;
echo $html;
This code is for creating a PDF  with fpdf and a third party table class. Its only displaying the last table data in the loop when I echo $html so the data is being overwritten each loop.