alces Posted August 20, 2011 Share Posted 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"> Quote Link to comment Share on other sites More sharing options...
alces Posted August 20, 2011 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted August 21, 2011 Share Posted August 21, 2011 You should store the phone numbers as int's, and format the data when displaying it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.