StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POdatabase string compare in postgresql not recognizing string length
text
Body
copied!<p>I am transferring data between servers, and need to change some links in our wiki database. I wrote a quick script that should be able to do this no problem. But When I run it, the <code>if($datacount)</code> condition never runs. This is probably something simple that I'm missing, but I can't see what the issue is. </p> <pre><code>$dbconn = pg_connect("host= localhost port=5432 dbname=wiki user=user password=password"); $sql = "SELECT old_text FROM wiki_public.pagecontent LIMIT 10"; $go = pg_query($dbconn,$sql); $i=0; $string = 'sometext'; while($data = pg_fetch_assoc($go)) { $info = $data['old_text']; $count = strlen($string); $datacount = strlen($info); echo "Length: ".$datacount."<br/>"; if($datacount != 0) { $position = strpos($string,$info); if($position !== false) { echo "The string ".$string." was found in row ".$i." and exists at position ".$position."The original content was: ".substr($info, $position,$count)."<br/>"; } } $i++; } </code></pre> <p>Thanks! <strong>EDIT</strong></p> <p>When I remove the <code>$datacount</code> condition, this is my output</p> <pre><code>Length: 0 Warning: strpos(): Empty delimiter in D:\www\import\linksupadte.php on line 12 Length: 12 Length: 0 Warning: strpos(): Empty delimiter in D:\www\import\linksupadte.php on line 12 Length: 31 Length: 31 Length: 0 Warning: strpos(): Empty delimiter in D:\www\import\linksupadte.php on line 12 Length: 444 Length: 1614 Length: 153 Length: 125 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload