PHP - Linking To Field In Database - Hyperlink

Right i want to have friends displayed on peoples profiles but i can only ave there name and not the avater displayed here is the code ive got which doesnt work

        <? 
$picture = mysql_query("SELECT * FROM users WHERE username = '$dip->person'");
$pc = mysql_fetch_object($picture);
$query_friends=mysql_query("SELECT * FROM friends WHERE username='$viewuser' AND type='Friend'");

$rows=mysql_num_rows($query_friends);
if ($rows == "0"){ echo "<center>No friends</center>"; }
$friend = 0;
while($dip=mysql_fetch_object($query_friends)){

echo "&nbsp;&nbsp;<img src='$pc->image' width='50' height='50' border='1'><br><a href='profile.php?viewuser=$dip->person'>$dip->person</a>,"; 
$friend++; 
echo ($friend % 3 == 0)? "<br>" : ""; }
?>


The friends are from the friends database and the avater is from the users database how can i link them so the name and the avater show ive tried this but only the names are displayed and the avaters dont show

hi,
this is my first post, i hope someone here can give me a hand with this.
i have created a new field in the member_profile table in my database. lets say i named it newfield.
i would like a yes to be placed in this newfield at the same time i give moderator privlages to a member.
i can manually enter a yes in newfield now with phpmyadmin.

i believe this code applies the moderator settings, any ideas on a way to have this post yes in my new field as well.


//make Moderator
//////////////////////
if (isset($_POST['moderator']) && isset($_POST['list'])) {
    foreach ($_POST['list'] as $user_id) {
        managemember($user_id,'moderator');
}

    //notifications
    $show_notification = 1;
    $message = notifications(1);
}


any help greatly appreciated.

I have text field in database, where I have let's say 5000 words.
I  want to split this text having 5000 words in pages, each one having 500 words.
How can I realise this ?
A practical example would be appreciate  !
Thank you in advance.

Hi,

I need to make it so the items on my page are only displayed if the value in their database column is set to 1 (and 0 for no display). And I should be able to change those values with a checkbox toggle on my admin panel.

Ideally I wouldn't have to click submit either.

Table:

<table id="datatables" class="table table-striped table-no-bordered table-hover" cellspacing="0" width="100%" style="width:100%">
                      <thead>
                        <tr>
                          <th>ID</th>
                          <th>Item name</th>
                          <th>Item group</th>
                          <th>Actions</th>
                          <th>Display</th>
                        </tr>
                      </thead>
                      <tbody>
                        <?php
                        if($result -> num_rows > 0){
                          while($row = $result-> fetch_assoc()){
                            echo "<tr>";
                            echo "<td>" . $row["id"] ."</td>";
                            echo "<td>" . $row["item_name"]. "</td>";
                            echo "<td>" . $row["group_name"] ."</td>";
                            ?>
                            <?php
                            require_once "deleteitem.php";
                            ?>
                            <td>
                              <a href="edititem.php?edit=<?php echo $row['id']; ?>" name="edit"><i class="material-icons">edit</i></a>
                              <a href="?delete=<?php echo $row['id']; ?>" name="delete"><i class="material-icons">delete</i></a>
                            </td>
                            <td>
                            <form action="displayitem.php" method="POST">
                              <div class="togglebutton">
                                <label>
                                  <input type="checkbox" name="display">
                                  <span class="toggle"></span>
                                </label> 
                              </div>
                              </form>
                            </td>
                            <?php
                            echo "</tr>";
                        }
                          }
                        ?>
                      </tbody>
                    </table>

https://i.imgur.com/Qyz6s8v.png

In displayitem.php

<?php
if(isset($_POST['display'])){
    echo '<p>'.$_POST['display'].'</p>';
	// queries etc here
}
?> 

I'm not getting the value here unless I add a submit button.

Guessing jQuery / AJAX is the way to go but can't seem to find any good tutorials on it, are there any other suitable approaches to this?

 

 

 

 

I have been trying to hack two parts of code together... I had code writen that will grab the text from a website and completely clean it of all junk except for full words... then echo it.  Now I am trying to use the same script to pull from a database instead of a URL but am lost... Here is my code... I would make another donation to the site if we can get this going... THANK YOU!

Code: [Select]

<?php

$con = mysql_connect("localhost","USERNAME","PASSWORD!");
mysql_select_db("DATABASE",$con);

$get = "SELECT * FROM information_description WHERE information_id=4";
$SQ_query = mysql_query($get) or die("Query failed: $get\n" . mysql_error());
$fetch = mysql_fetch_array($SQ_query);

$raw = $fetch['description'];


/* Set internal character encoding to UTF-8 */
mb_internal_encoding("UTF-8");
mb_http_output( "UTF-8" );
ob_start("mb_output_handler");

function clean($html) {
###Remove number in html################
//$html  = preg_replace("/[0-9]/", " ", $html);


$html =  preg_replace("/<([a-z][a-z0-9]*)[^>]*?(\/?)>/i",'<$1$2>', $html);

// $html = preg_replace('/(<[^>]+) style=".*?"/i', '$1', $html);
echo $html;

$html = str_replace("&nbsp;", " ", $html);
$html = str_replace("&amp;", " ", $html);
$html = str_replace("-", " ", $html);
######remove space
$html =  preg_replace ('/<[^>]*>/', '', $html);

$html =  preg_replace('/\s\s+/', ', ', $html);
$html =  preg_replace('/[\s\W]+/',' ',$html);   // Strip off spaces and non-alpha-numeric 
return $html;
}

#call function
//$raw = StripHtmlTags($raw);
$raw = clean($raw);
echo $raw;

##echo clean($html);

$url = (isset($_GET['url']) ?$_GET['url'] : 0);
$str = file_get_contents($url);
####################################################################3
function get_url_contents($url){
        $crl = curl_init();
        $timeout = 5;
        curl_setopt ($crl, CURLOPT_URL,$url);
        curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
        $ret = curl_exec($crl);
        curl_close($crl);
        return $ret;
}
#--------------------------------------Strip html tag----------------------------------------------------
function StripHtmlTags( $text )
{
  // PHP's strip_tags() function will remove tags, but it
  // doesn't remove scripts, styles, and other unwanted
  // invisible text between tags.  Also, as a prelude to
  // tokenizing the text, we need to insure that when
  // block-level tags (such as <p> or <div>) are removed,
  // neighboring words aren't joined.
  $text = preg_replace(
    array(
      // Remove invisible content
      '@<head[^>]*?>.*?</head>@siu',
      '@<style[^>]*?>.*?</style>@siu',
      '@<script[^>]*?.*?</script>@siu',
      '@<object[^>]*?.*?</object>@siu',
      '@<embed[^>]*?.*?</embed>@siu',
      '@<applet[^>]*?.*?</applet>@siu',
      '@<noframes[^>]*?.*?</noframes>@siu',
      '@<noscript[^>]*?.*?</noscript>@siu',
      '@<noembed[^>]*?.*?</noembed>@siu',

      // Add line breaks before & after blocks
      '@<((br)|(hr))@iu',
      '@</?((address)|(blockquote)|(center)|(del))@iu',
      '@</?((div)|(h[1-9])|(ins)|(isindex)|(p)|(pre))@iu',
      '@</?((dir)|(dl)|(dt)|(dd)|(li)|(menu)|(ol)|(ul))@iu',
      '@</?((table)|(th)|(td)|(caption))@iu',
      '@</?((form)|(button)|(fieldset)|(legend)|(input))@iu',
      '@</?((label)|(select)|(optgroup)|(option)|(textarea))@iu',
      '@</?((frameset)|(frame)|(iframe))@iu',
    ),
    array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0", "\n\$0",),$text );

  // Remove all remaining tags and comments and return.
  return strtolower( $text );
}

function RemoveComments( & $string )
{
  $string = preg_replace("%(#|;|(//)).*%","",$string);
  $string = preg_replace("%/\*(?:(?!\*/).)*\*/%s","",$string); // google for negative lookahead
  return $string;
}


$html = StripHtmlTags($str);

###Remove number in html################
$html  = preg_replace("/[0-9]/", " ", $html);

#replace &nbsp; by ' '
$html = str_replace("&nbsp;", " ", $html);

######remove any words################

$remove_word = file("swords.txt", FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
foreach($remove_word as $word) {
$html = preg_replace("/\b". $word ."\b/", " ", $html);
}
######remove space
$html =  preg_replace ('/<[^>]*>/', '', $html);

$html =  preg_replace('/\b\s+/', ', ', $html);
$html =  preg_replace('/[\b\W]+/',', ',$html);   // Strip off spaces and non-alpha-numeric

#remove white space, Keep : . ( ) : &
//$html = preg_replace('/\s+/', ', ', $html);


###process#########################################################################
$array_loop = explode(",", $html);
$array_loop1 = $array_loop;
$arr_tem = array();

foreach($array_loop as $key=>$val) {
if(in_array($val, $array_loop1)) {
if(!$arr_tem[$val]) $arr_tem[$val] = 0;
$arr_tem[$val] += 1;

if ( ($k = array_search($val, $array_loop1) ) !== false )
unset($array_loop1[$k]);
}
}

arsort($arr_tem);

###echo top 20 words############################################################
echo "<h3>Top 20 words used most</h3>";
$i = 1;
foreach($arr_tem as $key=>$val) {
if($i<=20) {
echo $i.":&nbsp;&nbsp;".$key." (".$val." words)<br />";
$i++;
}else break;
}
echo "<hr />";
###print array#####################################################################
echo (implode(", ", array_keys($arr_tem)));

?>

This is kind of hard to explain, but I will try my best.

I have a script that is attempting to display information in a MySQL database by month fields that are chosen by the user. For instance, they can choose for the start date to start in January, and pick the end date which in this example will be April.

The script then puts the required field that match the specific dates into a column for each month. For the most part it outputs fine as: Jan: 15, Feb: 14, Mar: 9, Apr: 2.

However, sometimes there is nothing in the database for certain months. This causes the script to display wrong so instead I get: Jan 3, Feb: , Mar: , Apr: .

In the above example, the Jan: 3 might be wrong, because the field might have been for Mar instead. I need it to display like this when there is no fields in the database: Jan: 0, Feb: 0, Mar: 3, Apr: 0.

How would I go about doing this?

This topic has been moved to Ajax Help.

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

I need some help with updating the database table with the correct selection from that box.
I have a dropdown box. This is actually a list from the images in a curtain directory.
here the code I used:

<?php
$dhandle = opendir('../images/Vessels/');
$files = array();
if ($dhandle) {
   // loop through all of the files
   while (false !== ($fname = readdir($dhandle))) {
      if (($fname != '.') && ($fname != '..') &&
          ($fname != basename($_SERVER['PHP_SELF']))) {
          $files[] = (is_dir( "./$fname" )) ? "(Dir) {$fname}" : $fname; }
            }
   closedir($dhandle);
}


So when inserting a new record I can use the dropdownbox to populate the correct field.

Database:
Id, Vesselname, Image, more, andmore

There is a section where an authorized user can upload an image to the directory.
This image will then be available in dropdown when the need to add a new vessel (in this case)
The problem that I have is, when I later what to update the vessel, I want that same dropdownbox
to be showing the correct imagename as "selected".
How can I do that?

This is what I have been expirementing with sofar:

<?php require_once('../Connections/bgf_db.php'); ?>
<?php
$dhandle = opendir('../images/Vessels/');
$files = array();
$selectedFile = "mare.jpg";
if ($dhandle) {
   // loop through all of the files
   while (false !== ($fname = readdir($dhandle))) {
      if (($fname != '.') && ($fname != '..') &&
          ($fname != basename($_SERVER['PHP_SELF']))) {
          $files[] = (is_dir( "./$fname" )) ? "(Dir) {$fname}" : $fname; }
      }
   closedir($dhandle);
}
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
$MyFile_Recordset1 = "no-picture.jpg";
if (isset($selectedFile)) {
  $MyFile_Recordset1 = $selectedFile;
}
mysql_select_db($database_bgf_db, $bgf_db);
$query_Recordset1 = sprintf("SELECT vessels.Name, vessels.Image FROM vessels WHERE vessels.Image = %s", GetSQLValueString($MyFile_Recordset1, "text"));
$Recordset1 = mysql_query($query_Recordset1, $bgf_db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$selectedFile = $row_Recordset1['Image'];
?>
<select name="NameHere">
<option value="<?php echo $selectedFile?>" 
<?php if (!(strcmp($selectedFile, $row_Recordset1['Image']))) {echo "selected=\"selected\"";} ?>><?php echo $selectedFile ?>
</option>
<?php
// Now loop through the files, echoing out a new select option for each one
foreach( $files as $fname )
{
   echo "<option value=\"$fname\">{$fname}</option>\n";
}
echo "</select>\n";
?>


 

I am building a system where people are able to choose a food menu, they can modify each dish if needed and then say how many of each item they need for the order.

So when they pick the breakfast menu, it selects all starters, mains and desserts.  Should something need to be edited (sausages changed to vegitarian sausages) the user should be able to overtype what has been populated from the select statement)

When the form is submitted, the order needs to be linked to the current job which is in a field ssm_job.job_id but the changes to the menu items need to be stored somewhere for the current order only.  This obviously needs to be accessile later so further changes can be made if needed.  I am not sure of the best way to go about this as i am trying not to save every item in another database (just trying to be tidy)

Any advise on this would be greatly appreciated.

I have had help on this project in relation to an sql and the background can be found below, the help has been amazing but as this is a very different question i thought i would start a new thread.

 

Kind Regards

i hav dis checkstatus.php page where the user enters a random number sms to him..but after tht he shud be able to see d reply given by admin ..d problem over here is d user only views half of the field called 'anything'
(my database is named "proj")
heres my code
jst cant understand why dis is happening...pls help

Howdy,

I'm trying to display text from a table in a database. It's a list of quotes, so I just need to pull out the quote and the author name. However, the quote and name are not fields in the same record; they are separate records. Example data:

Code: [Select]
quoteid    name        value
1            content You guys are great! Thanks for being awesome.
1            author John Jackson
2            content Gosh you're amazing! Always been so darn helpful!
2            author Peter Davis
So, I just need to rip out the data from 'content' and 'author', and then group them together based on the quoteid. This is my code thus far:

$testimonial_resource = mysql_query("SELECT name, value FROM quotes GROUP BY quoteid ORDER BY author ASC") or die(mysql_error());

while ($testimonial = mysql_fetch_assoc($testimonial_resource)) {

echo '<p>'.$testimonial['value']'.<br /><strong>'.$testimonial['value'].'</strong></p>';

}

Any help would be greatly appreciated for this novice.

Cheers.

Hi all.

The title pretty much says it all.  I really have no idea if this is even possible or where to start.  A recent dilemma caused me to have to change a field name with some spaces in it.  I have a database with ~65 tables, a majority of which were converted from Access.  So I'm curious as to how many others have bad field names.  Is there a way to use PHP to go through all the field names in a database and remove spaces?

Hey guys,
I m not yet an experienced coder. SO faced alot of problems. Here, I'm trying to generate a UNIQUE RANDOM NUMBER set between two numbers. Repetative occurance must be avoided by all means as I want every number so generated bears a unique value. In other words, every values that made entry into the field of my database should be differant from each others.


<?php
$conN=mysql_connect("localhost","root","");
if(!$conN)
{
die('error'.mysql_error());
}
mysql_select_db("freebie_allusers",$conN);
$UIN=mt_rand(1,5);
$locateUIN="SELECT UIN FROM user_info WHERE UIN='".$UIN."'";
$fetchUIN=mysql_query($locateUIN);
$resultUIN=mysql_num_rows($fetchUIN);
if($resultUIN>0)
{



WHAT CODE IS REQUIRED HERE SO AS TO GENERATE UNIQUE RANDOM NUMBER?






}

else 
echo $UIN;
?>

Thanx in advance