PHP - Print All Data In One Row Separated By Semicolon

Hello I would like to know how to print data generated by PHP into a bond paper? is there a php function that i can use?

Hi guys,

I have a little problem here. I have stored the data in firstname column of mysql database. I am trying to achieve by print the data from the mysql and input the data on my php page, but the page is blank.

Here it is the code:


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypassword');
    define('DB_DATABASE', 'mydatabasename');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  
    $login = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE login='$login' AND passwd='$password'";

  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


if(mysql_num_rows($result) > 0) {

  $row = mysql_fetch_row($result);
    $firstname = htmlspecialchars($author['firstname']);
    echo("$firstname <br>");
      }
else {


echo 'Username and/or Password not found.';
}
}
?>


Do you know why the php page is blank as I effort to get the data from mysql??

Any idea??

so here the code that i am confusing the whole month , how can i get it to print out the filtered data

$sql="SELECT COUNT(*) as conflicts
        FROM rental
        WHERE Dispatch < :dropoff AND Dropoff > :dispatch";
$stmt = $pdo->prepare($sql);
$stmt->execute( [ 
                   'dropoff'  => $Dropoff,
                   'dispatch' => $Dispatch
                ]);

im so frustrated on myself that cant do anything

Hi guys,

I have a problem of prints of the data from table1. I am checking out the data of username and password in the url to go through in members table and then checking the username in table1 to get matching data and select rows with the fields id of teststrings1, teststrings2 and teststrings3, then print out the data.


Here it is the code


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'password');
    define('DB_DATABASE', 'mydatabasetable');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());


    if($result) { 
  $qrytable1="SELECT teststrings1, teststrings2, teststrings3 FROM table1 WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());
  echo "<p id='teststrings1'>";
  echo $row['teststrings1'] . "</p>";
  echo "<p id='teststrings2'>";
  echo $row['teststrings2'] . "</p>";
  echo "<p id='teststrings3'>";
  echo $row['teststrings3'] . "</p>";
  }
 }
?>


When I am am checking the data of username and password through in members table and then checking the username in table1 before select the rows with the fields id of teststrings1, teststrings2 and teststrings3 to prints out, but it have print out as blank on php page.

Any idea?

so this is my code


Code: [Select]

<?
$b=$_GET['b'];
$m=$_GET['m'];
$y=$_GET['y'];

if  ($b <> '' && $m <> '' && $y <> '') {

$branch=$b;
$leavemonth=$m;
$leaveyear=$y;
}
else
{
$branch=$_POST['branch'];
$leavemonth=$_POST['leavemonth'];
$leaveyear=$_POST['leaveyear'];
}



$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


   
    $query="SELECT * from tblworkgroup";
    $result=mysql_query($query);?>


        &nbsp;&nbsp;Branch&nbsp;
        <select name="branch" >
<option value="all">ALL Branches</option>       
        <? while($row=mysql_fetch_array($result)) { ?>       
    <option value= "<?=$row['WorkGroupID']?>" <? if ($branch==$row['WorkGroupID']){ echo 'selected'; } ?> ><?=$row['WorkGroupName']?></option>
     <? } ?>
        </select>
           </td>
          </tr>
       <br><br><br>
  &nbsp;&nbsp;Month &nbsp;&nbsp;
<select name="leavemonth" >
<option value = "1" <? if ($leavemonth==1){ echo 'selected'; } ?>>January</option>
<option value = "2" <? if ($leavemonth==2){ echo 'selected'; } ?>>February</option>
<option value = "3" <? if ($leavemonth==3){ echo 'selected'; } ?>>March</option>
<option value = "4" <? if ($leavemonth==4){ echo 'selected'; } ?>>April</option>
<option value = "5" <? if ($leavemonth==5){ echo 'selected'; } ?>>May</option>
<option value = "6" <? if ($leavemonth==6){ echo 'selected'; } ?>>June</option>
<option value = "7" <? if ($leavemonth==7){ echo 'selected'; } ?>>July</option>
<option value = "8" <? if ($leavemonth==8){ echo 'selected'; } ?>>August</option>
<option value = "9" <? if ($leavemonth==9){ echo 'selected'; } ?>>September</option>
<option value = "10" <? if ($leavemonth==10){ echo 'selected'; } ?>>October</option>
<option value = "11" <? if ($leavemonth==11){ echo 'selected'; } ?>>November</option>
<option value = "12" <? if ($leavemonth==12){ echo 'selected'; } ?>>December</option>
</select>

&nbsp;&nbsp;
Year &nbsp;&nbsp;
<select name="leaveyear" >
<option value = "2010" <? if ($leaveyear==2010) { echo 'selected';} ?>>2010</option>
<option value = "2011" <? if ($leaveyear==2011) { echo 'selected';} ?>>2011</option>
<option value = "2012" <? if ($leaveyear==2012) { echo 'selected';} ?>>2012</option>
<option value = "2013" <? if ($leaveyear==2013) { echo 'selected';} ?>>2013</option>
<option value = "2014" <? if ($leaveyear==2014) { echo 'selected';} ?>>2014</option>
<option value = "2015" <? if ($leaveyear==2015) { echo 'selected';} ?>>2015</option>
<option value = "2016" <? if ($leaveyear==2016) { echo 'selected';} ?>>2016</option>
<option value = "2017" <? if ($leaveyear==2017) { echo 'selected';} ?>>2017</option>

</select>


  &nbsp;&nbsp;

<input type='submit' name='submit' value='Preview' Class="button" onclick='return validate()'>
   
   </div>

</form>


<br /><br />

<div id="box" valign="top">
                <h3>&nbsp;<strong>Leave Application Details</strong>&nbsp;&nbsp</h3>
<br><br>
<FORM name="printbutton" method="post" align="left" action="report_print.php" target="_blank">
<input type="hidden" name="leavemonth" value="<?php echo $leavemonth; ?>">
<input type="hidden" name="leaveyear" value="<?php echo $leaveyear; ?>">
<input type="hidden" name="branch" value="<?php echo $branch;?>">
<Input type = "Submit" Name = "Submit1" Class="button" VALUE = "Print Leave Details">
</form>
                <table width="80%" align="center" >
<thead>
<tr>
<th width="700px" align="left">Name</a></th>
                           
<th width="500px" align="center"></a>Application Date</th>

<th width="500px" align="center"></a> </th>
                           
<th width="500x" align="right"></a>Reason</th>
</tr>
</thead>
<tbody>
<?
/*echo "branch:".$branch.'<br />';
echo "leavemonth:".$leavemonth.'<br />';
echo "leaveyear:".$leaveyear.'<br />';*/
//--------------------------------------------------
if ($leavemonth =='' ||  $leaveyear =='' || $branch == '') {
// one value missing, so don't display
}
else
{
// start display data
$branchtracker = '';

if ($branch=='all'){
$branch = '%';
}

$rs = mysql_query( " call vwleavereport('$leavemonth', '$leaveyear', $branch, 0);");
$query="SELECT *,
MONTH(tblleaveapplication.DateFrom) as DFMonth,
MONTH(tblleaveapplication.DateTo) as DTMonth,
YEAR(tblleaveapplication.DateFrom) as DFYear
FROM `tblleaveapplication`
LEFT JOIN `tblemployee`
ON tblleaveapplication.employeeid = tblemployee.id
WHERE WorkGroupID LIKE '".$branch."'
AND (
(MONTH(tblleaveapplication.DateFrom)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
OR
(MONTH(tblleaveapplication.DateTo)=".$leavemonth." AND YEAR(tblleaveapplication.DateFrom)=".$leaveyear.")
)
ORDER BY WorkGroupID
";

$result = mysql_query($query);
while($row=mysql_fetch_array($result))
{
if ($branchtracker<>$row['WorkGroupID']){
echo '<tr><td colspan=4 style="background-color: #e8e8e8; font-weight: bold;">'.$row['WorkGroupID'].'</td></tr>';
$branchtracker = $row['WorkGroupID'];
}
echo '<tr>';
echo '<td>'.$row['EmployeeName'].'</td>';
echo '<td>'.$row['DateFrom'].'</td>';
echo '<td>'.$row['DateTo'].'</td>';
echo '<td>'.$row['Purpose'].'</td>';
echo '</tr>';
}

}
?>


the problem is i want the print button only appear when there is output..

Hello,   I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator.   How can I separate the numbers in this array with the given code?  Ive attached a photo of the code.

 

 

 

 

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=328435.0

Hi,

I have in column "keywords" comma separated keywords in one row/news. Example in ID "1" in column "keywords" have: "Šport, Fudbal, Četvrta Liga". I want to make a tag-s from those words to be like: http://site.com/tag/sport,  http://site.com/tag/fudbal, http://site.com/tag/cetvrta-liga.

At first I separate those words by:

$input = $vest_keywords;
$removed_spaces = preg_replace('/\s*,\s*/', ',', $input);
$output = explode(',', $removed_spaces);
foreach($output as $tags) {
  echo $tags;
}

This give me: Šport | Fudbal | Četvrta liga

 

But I have a "slug-maker", and I have a problem with redeclare.

/* SLUG */
$string = $output;
  function my_str_split($string) {
    $slen = strlen($string);
    for ($i = 0; $i < $slen; $i++) {
      $sArray[$i] = $string{$i};
    }
    return $sArray;
  }
  function noDiacritics($string) {
    //cyrylic transcription
    $cyrylicFrom = array('А', 'Б', 'В', 'Г', 'Д', 'Е', 'Ё', 'Ж', 'З', 'И', 'Й', 'К', 'Л', 'М', 'Н', 'О', 'П', 'Р', 'С', 'Т', 'У', 'Ф', 'Х', 'Ц', 'Ч', 'Ш', 'Щ', 'Ъ', 'Ы', 'Ь', 'Э', 'Ю', 'Я', 'а', 'б', 'в', 'г', 'д', 'е', 'ё', 'ж', 'з', 'и', 'й', 'к', 'л', 'м', 'н', 'о', 'п', 'р', 'с', 'т', 'у', 'ф', 'х', 'ц', 'ч', 'ш', 'щ', 'ъ', 'ы', 'ь', 'э', 'ю', 'я');
    $cyrylicTo = array('A', 'B', 'W', 'G', 'D', 'Ie', 'Io', 'Z', 'Z', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'R', 'S', 'T', 'U', 'F', 'Ch', 'C', 'Tch', 'Sh', 'Shtch', '', 'Y', '', 'E', 'Iu', 'Ia', 'a', 'b', 'w', 'g', 'd', 'ie', 'io', 'z', 'z', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'r', 's', 't', 'u', 'f', 'ch', 'c', 'tch', 'sh', 'shtch', '', 'y', '', 'e', 'iu', 'ia');
    $from = array("Á", "À", "Â", "Ä", "Ă", "Ā", "Ã", "Å", "Ą", "Æ", "Ć", "Ċ", "Ĉ", "Č", "Ç", "Ď", "Đ", "Ð", "É", "È", "Ė", "Ê", "Ë", "Ě", "Ē", "Ę", "Ə", "Ġ", "Ĝ", "Ğ", "Ģ", "á", "à", "â", "ä", "ă", "ā", "ã", "å", "ą", "æ", "ć", "ċ", "ĉ", "č", "ç", "ď", "đ", "ð", "é", "è", "ė", "ê", "ë", "ě", "ē", "ę", "ə", "ġ", "ĝ", "ğ", "ģ", "Ĥ", "Ħ", "I", "Í", "Ì", "İ", "Î", "Ï", "Ī", "Į", "IJ", "Ĵ", "Ķ", "Ļ", "Ł", "Ń", "Ň", "Ñ", "Ņ", "Ó", "Ò", "Ô", "Ö", "Õ", "Ő", "Ø", "Ơ", "Œ", "ĥ", "ħ", "ı", "í", "ì", "i", "î", "ï", "ī", "į", "ij", "ĵ", "ķ", "ļ", "ł", "ń", "ň", "ñ", "ņ", "ó", "ò", "ô", "ö", "õ", "ő", "ø", "ơ", "œ", "Ŕ", "Ř", "Ś", "Ŝ", "Š", "Ş", "Ť", "Ţ", "Þ", "Ú", "Ù", "Û", "Ü", "Ŭ", "Ū", "Ů", "Ų", "Ű", "Ư", "Ŵ", "Ý", "Ŷ", "Ÿ", "Ź", "Ż", "Ž", "ŕ", "ř", "ś", "ŝ", "š", "ş", "ß", "ť", "ţ", "þ", "ú", "ù", "û", "ü", "ŭ", "ū", "ů", "ų", "ű", "ư", "ŵ", "ý", "ŷ", "ÿ", "ź", "ż", "ž");
    $to = array("A", "A", "A", "AE", "A", "A", "A", "A", "A", "AE", "C", "C", "C", "C", "C", "D", "D", "D", "E", "E", "E", "E", "E", "E", "E", "E", "G", "G", "G", "G", "G", "a", "a", "a", "ae", "ae", "a", "a", "a", "a", "ae", "c", "c", "c", "c", "c", "d", "d", "d", "e", "e", "e", "e", "e", "e", "e", "e", "g", "g", "g", "g", "g", "H", "H", "I", "I", "I", "I", "I", "I", "I", "I", "IJ", "J", "K", "L", "L", "N", "N", "N", "N", "O", "O", "O", "OE", "O", "O", "O", "O", "CE", "h", "h", "i", "i", "i", "i", "i", "i", "i", "i", "ij", "j", "k", "l", "l", "n", "n", "n", "n", "o", "o", "o", "oe", "o", "o", "o", "o", "o", "R", "R", "S", "S", "S", "S", "T", "T", "T", "U", "U", "U", "UE", "U", "U", "U", "U", "U", "U", "W", "Y", "Y", "Y", "Z", "Z", "Z", "r", "r", "s", "s", "s", "s", "ss", "t", "t", "b", "u", "u", "u", "ue", "u", "u", "u", "u", "u", "u", "w", "y", "y", "y", "z", "z", "z");
    $from = array_merge($from, $cyrylicFrom);
    $to = array_merge($to, $cyrylicTo);
    $newstring = str_replace($from, $to, $string);
    return $newstring;
  }
  function makeSlugs($string, $maxlen = 0) {
    $newStringTab = array();
    $string = strtolower(noDiacritics($string));
    if (function_exists('str_split')) {
      $stringTab = str_split($string);
    } else {
      $stringTab = my_str_split($string);
    }
    $numbers = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "-");
    //$numbers=array("0","1","2","3","4","5","6","7","8","9");
    foreach ($stringTab as $letter) {
      if (in_array($letter, range("a", "z")) || in_array($letter, $numbers)) {
        $newStringTab[] = $letter;
      } elseif ($letter == " ") {
        $newStringTab[] = "-";
      }
    }
    if (count($newStringTab)) {
      $newString = implode($newStringTab);
      if ($maxlen > 0) {
        $newString = substr($newString, 0, $maxlen);
      }
      $newString = removeDuplicates('--', '-', $newString);
    } else {
      $newString = '';
    }
    return $newString;
  }
  function checkSlug($sSlug) {
    if (preg_match("/^[a-zA-Z0-9]+[a-zA-Z0-9\-]*$/", $sSlug) == 1) {
      return true;
    }
    return false;
  }
  function removeDuplicates($sSearch, $sReplace, $sSubject) {
    $i = 0;
    do {
      $sSubject = str_replace($sSearch, $sReplace, $sSubject);
      $pos = strpos($sSubject, $sSearch);
      $i++;
      if ($i > 100) {
        die('removeDuplicates() loop error');
      }
    } while ($pos !== false);
    return $sSubject;
  }
  $vesti_tag_slug = makeSlugs($string, $maxlen = '0');
  /* /. SLUG */

So I want to have tags like: sport | fudbal | cetvrta-liga

Can You help how can I get the links that You se above?

Thanks in advanced!

T

So i have a blog that has the tags store in one field in my blog table. So tags are saved as this in each blog post with its respective tags.    Tags: john, carlos, the great tag, this is a tag   What i want to do is get random tags from each blog post and display them. I am not sure how i can begin to make this query. Do you guys have an idea on how to do this?     

Say you have a string that you know has two, and exactly two, periods in it, like this...

$string = "3.12.8"

How can you grab the three different values that are separated by periods (in this case, 3, 12 and ?   I was thinking use strpos to find the position of the first period, then could use that info to grab everything up to that position.  But then I couldn't figure out how you would find the position of the SECOND period.   And even if I could get the exact positions of the two periods, it seems like there should be an easier way to simply retrieve values separated by specific characters.     Is there a specific function for this type of thing, or was my initial though correct with having to do it in two parts essentially (find positions of periods, then use that knowledge to get the values)?   Thanks!

How can i convert an array of results to a single comma separated string so that I can run it through an SQL query?

Hello all,

I'm trying to get better at manipulating arrays and I'm stumped on this one.

What would be the most efficient way of converting an array such as this:

Quote

Array ( [3] => 3 [9] => 1 [15] => 9 )


Into this:

Quote

3,3,3,9,15,15,15,15,15,15,15,15,15

Hi Guys

I'm returning to programming after 5 years, almost a newbie.

I have a field(column) in a MySQL database table that has strings of characters separated by a delimiter (||).

For example: (TOM||PAUL||HARRIS)

I would like to separate the strings into an array.

Something like this:
ARRAY[0] = 'TOM';
ARRAY[1]='PAUL';
ARRAY[3]='HARRIS';

Can some one tell me how to do this?

TIA.

I have a file that is uploaded by the user that has a series of rows of data in an html table.

The columns are always a constant, but the number of rows in the file can change.  These rows of the html table are the only information in the file when I am processing it.

I need to either convert the file to a CSV file or write the values to a CSV list so that I can then insert them into a database.

Any suggestions would be wonderful...I've spent the last three hours spinning my wheels.

Here is an example of one row of data from the file:

Code: [Select]
<tr><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT >5 (Excellent)</td><td bgcolor=#dddddd class=dataFT >&nbsp;</td><td bgcolor=#dddddd class=dataFT >&nbsp;</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >1015020</td><td bgcolor=#dddddd class=dataFT >155498322</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >4731751</td><td bgcolor=#dddddd class=dataFT >2011-09-25 11:18:33  (-5:00)</td><td bgcolor=#dddddd class=dataFT >2011-09-25 12:16:50  (-5:00)</td><td bgcolor=#dddddd class=dataFT >0:58:17</td><td bgcolor=#dddddd class=dataFT >0:58:16</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >DATA</td><td bgcolor=#dddddd class=dataFT >Resolved</td></tr>

I have a kind of search and react on my site. The user can search for a number in a column as below

$search = mysqli_real_escape_string($link, $_POST["query"]);

$query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";

 

The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... 

I want to expand the oemnr column as

12345/03124/34713, numbers separated with / or another character.

If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql.

Edited February 14 by jigga