<div>
strstr($xxxxx, '.0');<br />

</div>


<div>
Try:<br />
<br />
$value = substr($url, strrpos($url, &quot;.&quot;));
</div>


Try:

$value = substr($url, strrpos($url, "."));

<div>
Correction, ommitted 0 for start:<br />
<br />
$value = substr($url, 0, strrpos($url, &quot;.&quot;));
</div>


Correction, ommitted 0 for start:

$value = substr($url, 0, strrpos($url, "."));

<div>
Thanks guys!<br />
<br />
I have only tried hernst42's suggested solution, and it works for me.<br />
<br />
I want to be fair in allocating points &nbsp;to others who contributed correct solutions but I don't have the time to test out all the other suggestions at the moment.<br />
<br />
Could hernst confirm if the other solutions will work?
</div>


Thanks guys!

I have only tried hernst42's suggested solution, and it works for me.

I want to be fair in allocating points  to others who contributed correct solutions but I don't have the time to test out all the other suggestions at the moment.

Could hernst confirm if the other solutions will work?

<div>
the solution of glummicus should also work, the others not
</div>


the solution of glummicus should also work, the others not

<div>
<div class="content wysiwyg-content">
PHP MySQL<br />
<br />
<br />
Hello,<br />
<br />
How do I code in a PHP script to look for part of a string retrieved from MySQL database?<br />
<br />
<br />
For example...<br />
<br />
MySQL database field contents: (call this $url)<br />
xxxxxxxxx=123.0<br />
xxxxxxxxx=5161163.0<br />
xxxxxxxxx=25523.0<br />
xxxxxxxxx=11.0<br />
<br />
<br />
I want to extract the value between = and .0<br />
so I get<br />
123<br />
5161163<br />
25523<br />
11<br />
<br />
<br />
So in PHP, we will have something like<br />
<br />
$value = substring of $url<br />
<br />
but I don't know how to limit the substring to be between = and .0<br />
<br />
<br />

</div>
</div>


PHP MySQL


Hello,

How do I code in a PHP script to look for part of a string retrieved from MySQL database?


For example...

MySQL database field contents: (call this $url)
xxxxxxxxx=123.0
xxxxxxxxx=5161163.0
xxxxxxxxx=25523.0
xxxxxxxxx=11.0


I want to extract the value between = and .0
so I get
123
5161163
25523
11


So in PHP, we will have something like

$value = substring of $url

but I don't know how to limit the substring to be between = and .0




PHP MYSQL: How to select part of string?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.