Leading zeroes is removed

alces · August 20, 2011

I'm using dreamweaver wizard to create database connection forms. It creates a php script and it works fine except i strips the leading zeroes from any datatype i try to put in. (char, vchar, text, int etc.)

I need the zeroes for storing phonenumbers.

I also tried changing the sprintf variable

Here's the script:

<?php require_once('Connections/dbtest1.php'); ?>
<?php
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;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO contacts (idcontacts, name_first, name_last, name_middle, street, areacode, city, phone_home, phone_mobile, fax, country, picture, title, company, bookings, email, website, note) VALUES (%s, %s, %s, %s, %s, %s, %s, %s,%s , %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['idcontacts'], "int"),
                       GetSQLValueString($_POST['name_first'], "text"),
                       GetSQLValueString($_POST['name_last'], "text"),
                       GetSQLValueString($_POST['name_middle'], "text"),
                       GetSQLValueString($_POST['street'], "text"),
                       GetSQLValueString($_POST['areacode'], "int"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['phone_home'], "int"),
                       GetSQLValueString($_POST['phone_mobile'], "int"),
                       GetSQLValueString($_POST['fax'], "int"),
                       GetSQLValueString($_POST['country'], "text"),
                       GetSQLValueString($_POST['picture'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['company'], "text"),
                       GetSQLValueString($_POST['bookings'], "int"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['website'], "text"),
                       GetSQLValueString($_POST['note'], "text"));

  mysql_select_db($database_dbtest1, $dbtest1);
  $Result1 = mysql_query($insertSQL, $dbtest1) or die(mysql_error());

  $insertGoTo = "bikesweden_databas_add_kontakt.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Namnlöst dokument</title>
<link href="databas.css" rel="stylesheet" type="text/css" />
</head>

<body>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">

alces · August 20, 2011

Oh I found it out.

GetSQLValueString($_POST['phone_home'], "int"),

I missed that i can set the datatype sent here.

GetSQLValueString($_POST['phone_home'], "text"),

works fine.

The Little Guy · August 21, 2011

You should store the phone numbers as int's, and format the data when displaying it.

Sign In

Leading zeroes is removed

Recommended Posts

alces

Link to comment

Share on other sites

alces

Link to comment

Share on other sites

The Little Guy

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information