PHP - Break A Continuous Text String?

I am having problems with these slashes. They keep showing up when I echo data....
The code is to update a field in a mysql database table.

Here is my code:
Code: [Select]
$query = mysql_query("SELECT * FROM `bus` WHERE username='$username'");
$row = mysql_fetch_array($query);
$bio = $row['about'];
$bio = str_replace("<br />","\r\n",$bio);



if(isset($_POST['submit'])){
if(empty($errors)){
if($password == $pass){

$about1 = mysql_real_escape_string($_POST["about"]);
$about1 = str_replace("\r\n","<br />",$about1);

mysql_query("UPDATE bus SET about='$about1' WHERE username='$username'");

}else{$errors[] = 'Incorrect Password';}
}
}

When I run this and put:
About: 
I'm very tired today
It's been very hard

I get the about1 string as: I\\\'m very tired today\r\nIt\\\'s been very hard

Why???

Can someone please help me?

Scenario:  Database table with varying amount of records, these will be displayed on a big screen with no user interaction, updating every set amount of time say 15 seconds.  Once new data enters the database the page updates and shows that record.  As there is only limited space on the screen i can only show e.g 1 record per page.  I setup pagination which splits these records up into separate pages.  so

   if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
   $start_from = ($page-1) * 1;
   $query = "SELECT * FROM table ORDER BY id ASC LIMIT $start_from, 1";
   // run the query and store the results in the $result variable.
   $result = $mysqli->query($query) or die(mysqli_error($mysqli));

then output the links

        $total_pages = ceil($total / 1);
   for ($i=1; $i<=$total_pages; $i++) {
      echo "<a href=bigscreen.php?page=".$i.">".$i."</a> ";
            
   }

This is all working fine and splits the pages and displays the links. 

Problem:

I have been trying to get the page bigscreen.php to automatically loop through the pages that are created e.g 3 records = 3 pages so i want it to load bigscreen.php?page=1 then wait for 15 seconds then update to bigscreen.php?page=2 then 15 seconds then update to bigscreen.php?page=3 then back to bigscreen.php?page=1 and this will continue to do this for the amount of pages created.

I have tried various methods but i am struggling.  I keep getting a redirect loop error in chrome when i setup my loop.  I was thinking of putting the links into an array? but i dont know that will work!  Any help or tips would be greatly appreciated!

i am working on this search engine. and in the advanced section you can turn on/off some of the options. So it you turn on an option it will search another table and so on.

Instead of building a massive query and left joining lots of stuff. I tried a different approach.

There is always a basic query and it returns the results to an array like this


Code: [Select]
$sql = mysql_query("SELECT SQL_CACHE id FROM table WHERE field LIKE '$getquery' ORDER BY field");
  while ($row = mysql_fetch_array($sql)) {
     $idArray[] = $row['id'];
  } mysql_free_result($sql);
and if something is turned on then it adds something like this:

Code: [Select]
if($_POST['value'] == "1") {
$sql = mysql_query("SELECT SQL_CACHE table1_relation_id FROM table2 WHERE field2 LIKE '$getquery' ORDER BY field2");
  while ($row = mysql_fetch_array($sql)) {
    $idArray[] .= $row['table1_relation_id'];
  } mysql_free_result($sql);
} //end if

so basicy i just continue the array and it keeps pumping ids into a big aray. after that i run array_unique and remove all duplicate results and then i foreach and get the whole item info ased on every id. it runs pretty fast.


now i would like to make the second one a function. but when i do that it does not work.

Code: [Select]
function sample($query, $table, $field) {
$sql = mysql_query("SELECT SQL_CACHE naziv_id FROM ".$table." WHERE ".$field." LIKE '$query'");
while ($row = mysql_fetch_array($sql)) {
$return[] .= $row['naziv_id'];
} mysql_free_result($sql);

return $return;

}
before i put it into a function $idArray vas a single continuous array. And if i try to do it like this:

Code: [Select]
$arr[] = sample($query, "table1", "filed_id");
$arr[] .= sample($query, "table2", "filed_id");
it returns the result of the first array ok but if there are more then one results in other arrays it returns and arary inside of the array.

like this:

Code: [Select]
array(4) { [0]=> array(2) { [0]=> string(4) "9057" [1]=> string(5) "14186" } [1]=> string(5) "Array" [2]=> string(5) "Array" [3]=> string(0) "" }
and all i wanna have is a single id variable that has all the id's in it. like $array = 1,2,3,4,5 but from different sources/functions

can you help? thank you so much.

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

Hi all just a bit like twitter i have a message system where when one recieves a mail i want there username to be like @user in blue but when sending a message the @user is in the message itself along with the actual message itsself, so i am trying to get the @ and everything after it so i can then change its color, can anyone help with this?

I have managed to get this to work but it seems like it is a very long and messy solution. I was wondering if anyone had an idea of how this can be done better. I am new to php and don't know a lot.

It shows the text between the tags <h1> and </h1> from the content of a different file
Basically I had to start the substr() from the fourth position so it would actually skip the "<h1>" being included, and because I started on the fourth postion I then had to finish four places back to skip the "</h1>" being included. 

Code: [Select]
<?php
$id = $_GET['id'];
$homepage = file_get_contents("./".$id.".php");
$title = stristr($homepage,"<h1>");
$titlepos = strpos($homepage,"</h1>");
$endpos = $titlepos - 4;
echo "Title " . substr($title,4,$endpos);

?>

I do want to validate a password input field to only allow numbers and letters without special character and spaces, and I also do want the same for the name input field.

Since the old fashioned ways are deprecated. How would one approach to solve this issue the new way?

I have the following variable:

$text = "javascript:openimage('http://images.icecat.biz/img/norm/high/5966342-254.jpg',850,850)"

Now I want to put the string "http://images.icecat.biz/img/norm/high/5966342-254.jpg" into a variable called $url
( $url = "http://images.icecat.biz/img/norm/high/5966342-254.jpg" )

How do I do this?

Hey, I need a simple bit of code to do the following:

I am trying to strip out a username in a string. This string will distinguish the username because the string will contain a * right before the username.

For example:    $string = "blah blah *username blah blah blah"

The username can only contain numbers and letters. no spaces.

And from that string all I want is the username, for example: $string = username    (which will vary of course)

Hope this makes sense, made it as clear as I possibly could.

Thanks ahead!

Hello,

Okay for some reason i cannot do this, when i open a file in php and search for string, it doesn't seem to work, some codes i tried:

Code: [Select]
$filename = 'example.txt';
$searchfor = 'hello';
$fh = fopen($filename, 'r');
$olddata = fread($fh, filesize($filename));
if(strpos($olddata, $searchfor)) {
           //fount it
}
else {
          //can't find it
}
fclose($fh);
(above it just sample text, i was hoping you could give me sample code that will work)

I tried many others like strstr, stristr, preg_replace etc etc, doesn't seem to find it.. this is my text file:

Code: [Select]
sdfsdfsdfsdfsdf[b]hello[/b]sdvsdf
dfadfsdfsdfsddfsdf
sdfsdfsdfs
sdffffffffffffffffffffdv
vsvdsdsf

I don't want to find it by line, i want to simply open the text file and find the string..

thanks..

Hi,


I am trying to take a string from a database and replace everything within {} with code... similar to how posting in a forum works.


so say I have "...Lorem ipsom {gallery:1} sit imet..."
it will take that string (from a DB) and replace "{gallery:1}" with "<?php gallery('1'); ?>". How can this be done? Or is there keywords I can search on to find the answer? Thank you in advance.

I am trying to wrap a string with an anchor tag if it finds a match with a block of text. Here is an example text block:

CONOCO 1'10x8 VC DF TP SGN||PRINCIPAL ILLUMINATION||ENG: CO3028TP_0VPR||DWG: CO200428||TO BE: DYED DIESEL (SPEC)||

The string I would want to wrap with a link would be "CO200428". 

The next problem is the drawings (what I'm searching the text for) has over 115,000 possibilities. The text blocks to search are over 1300.

I have the drawing names stored in a simple mysql table...but doing a foreach takes forever...I imagine it will take even longer when looking in the text blocks...

Is there a way to easily to do the anchor wrap? I don't know regex very well...

I wanted to replace a strings in a large text file .. what would be the fastest way ?!

e.g the text file contains ..

INSERT INTO `subjects` VALUES (1, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (2, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (3, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (4, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (5, 'some text here', 'some text here', 'some text here');

I wanted to replace the string " VALUES (1, " with  "VALUES (" in each line ..
I'm new in PHP so any response would be much appreciated .. thanks

This topic has been moved to JavaScript Help.

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

Hi, and thanks for any help with this. 

I have this but of php i have been trying relentlessly to get working.. for over a month.
 

<?php
$abs="one two three four words";
$mT = "testing for matching words";

$words=explode(' ', $abs);
//$sf=($words);


if (preg_match($words, $mT))
{
        echo "the url $mT contains a Word";
}
else
{
        echo "the url $mT does Not contain a Word";

echo "$words[4]";

}
?>

You see, I get a responce only using the last line "$words[4]", (obviously, because I am pointing it the Matching word, (ie: with [4])
What i need to have is that the script will automatically "find" that Matching Word for me with ANYwhere of the string of $abs (not just the beginning or the ending)". 

not making it confusing, but the obvious word in this I am looking to find is the word, "words".
😕

Thanks so much for any help.

 

 

Edited June 9, 2020 by x1705
better description.