PHP - Moved: Count Up Script ?

This topic has been moved to Miscellaneous.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

I've been trying to come up with a way to accurately count a word string which includes punctuation marks. I've got close but the white-space is causing a problem. I have used a couple of functions such as str_replace and explode and I can now get an accurate count for texts with most punctuation and 'normal' white space. BUT.. If I put in three extra spaces between words the count adds 1 to the total.

$words2 = str_replace("-", "", $string); // strips a hypen
$words3 = str_replace('  ', ' ', $words2); // strips double spaces
$words = explode(' ', $words3);

This is obviously NOT a script - rather a string of text being passed through three functions to cleanse it. But as you can see it will strip two white spaces when they occur but no more. So three, four, five etc. will be counted as extra words.

What else could I try to give me an accurate count?

I am very raw at php. 

thanks

Richard

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to PHP Math Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

is this possible?

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$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']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?