Learn VBA & Macros in 1 Week!

PHP - Unable To Send Data To Mysqli From Php

Full Excel VBA Course - Beginner to Expert

Unable To Send Data To Mysqli From Php	View Content

Hello everyone,

I am trying to submit a comment in a comment box and send it to the DB but is not happening. The connection is good as I am logging in and all but no data is sent to the DB when I post the comment. It doesn't show in my comment section either.

Form

    <!--comment section-->
<?php
if(isset($_SESSION['id'])) {
    echo "<form method='POST' action='" . setComments($conn) . "'>
        <input type='hidden' name='uidUsers' value='".$_SESSION['id']."'>
        <input type='hidden' name='posted' value='" . date('Y-m-d H:i:s') . "'>
        Comments: <textarea rows = '5' cols = '15' name='body'></textarea><br><br>
        <button name='commentSubmit' type='submit'>Comment</button>
        </form>";
}else {
    echo "Log in to comment!";
}
 getComments($conn);

Function to set and get comments

function setComments($conn) {
    if (isset($_POST['commentSubmit'])){
        $user_id = $_POST['uidUsers'];
        $body = $_POST['body'];
        $posted = $_POST['posted'];
        $sql = "INSERT INTO comments (uidUsers, posted, body) VALUES ('$user_id', '$posted', '$body')";
        $result = mysqli_query($conn, $sql);
    }
    
}

function getComments($conn) {
    $sql = "SELECT * FROM comments";
    $result = mysqli_query($conn, $sql);
    while ($row = $result->fetch_assoc()){
        $id = $row['uidUsers'];
        $sql2 ="SELECT * FROM users WHERE uidUsers='$id'";
        $result2 = mysqli_query($conn, $sql2);
        if($row2 = $result2->fetch_assoc()){
            echo "<div class='comment-box'><p>";
            echo $row2['uidUsers'] . "<br>";
            echo $row['posted'] . "<br>";
            echo nl2br($row['body']);
            echo "</p></div>";


        }

    
    }

}

Full Excel VBA Course - Beginner to Expert

Unable To View Mysql/mysqli Under Phpinfo()

Similar Tutorials

View Content

Hi there, I'm new to all this so I've been following instructions from various sites and books. So far I have installed Apache, PHP and mysql, however when I browse to localhost/test.php (created to view phpinfo() through the browser) i can't see mysql or mysqli only the mysqlnd. Here is an overview of software I've installed, OS and things I've added so far; OS ver Windows7 Professional 32-bit VM

Unable To Send Text To Metropcs Using Php Mail

Similar Tutorials

View Content

I have an old script for sending a text message to cellphone via PHP mail.

The script has not changed in a year, and it did work approximately 9 months ago.

Now, after dusting off the script and trying it, no message is received on the cellphone.

When sent directly from my email account to 1231231234@mymetropcs.com, a text message arrives nearly immediately.

But when sent through my email server script, even as a simplified test script

<?php
 
 mail( '1231231234@mymetropcs.com', "How are you", "Your packaged has arrived!", "From: Me <MyEmail@yahoo.com>\r\n");

//OR even  mail( '1231231234@mymetropcs.com', "", "Your packaged has arrived!", "From: Me <MyEmail@yahoo.com>\r\n");
 
?>

there is still nothing received on cellphone.

How can I resolve this?

Are there anti-spam filters generally in place and how can I overcome them?

Is there a way to validate that the message I am sending is actually leaving the server?

Or are there settings [there were none before and normal email messages are sent without any problems] that need to be adjusted to send a text message?

Thanks for the help.

Teach Me How To Send Newsletter To All Subscriber To Using Php Mailer And Mysqli Procedural

Similar Tutorials

View Content

help!

Unable To Insert The Data Into Data Base

Similar Tutorials

View Content

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!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=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">

</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">
<div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
<div id="Layer13">

<input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
<input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
<input type="submit" name="B1" value="Start !" />

</div>
<div id="Layer12">
<div align="left">

<input name="rad1" type="radio" value="RF" id="rad1" />
<label >RF</label>

</div>
</div>
<div id="Layer11">
<div align="left">
<input name="rad1" type="radio" value="ISAP" id="rad1" />
<label >ISAP</label>

</div>
</div>
<div id="Layer10">
<div align="left">
<input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
<label >GSD</label>

</div>
</div>
<div id="Layer9">
<div align="left">
<input name="rad1" type="radio" id="rad1" value="CSD" />
<label>CSD</label>
</p>
</div>
</div>
<br />
</div>
</div>
</form>
</div>
</body>
</html>

Below is the insert.php

<!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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`,
`processname`,
`begindate`,
`dateposted`,
`CALL`,
`EMAIL`,
`NEW`,
`EXISTING`,
`Piroty`,
`MTICKET`,
`Services`,
`group1`,
`group2`,
`Icall`,
`Tcreatedtime`,
`comment`)
VALUES ( '$empidno' , '$pname' , '$olddate' , '$Date' , '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">

</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
{
alert("Enter Max Ticket No");
return false;
}
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
{
alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
return false;
}
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
<div id="Layer2">
<div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
<h1 align="center"> </h1>
<div class="style1" id="Layer4">
<h1 align="center" class="style2">BHP DATA TRACKER </h1>
</div>
</div>
<div id="Layer7">

<form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

<div id="Layer8">

<input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
CALL</label>

</div>
<div id="Layer9">

<label>
<input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
EMAIL</label>

</div>
<div id="Layer10">

<label>
<input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
NEW</label>

</div>
<div id="Layer11">

<label>
<input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
EXISTING</label>

</div>
<div id="Layer12">

<label>
<input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
P1</label>

</div>
<div id="Layer13">

<label>
<input name="radio1" type="radio" id="radio1" value="P2" />
P2</label>

</div>
<div id="Layer14">

<label>
<input name="radio1" type="radio" id="radio1" value="P3" />
P3</label>

</div>
<div id="Layer15">

<label>
<input name="radio1" type="radio" id="radio1" value="P4" />
P4</label>

</div>
<div id="Layer16">

<label>MAXIMUM TICKET
<input type="text" name="textfield" />
</label>

</div>
<div id="Layer17">

<label>SERVICE DROP DOWN
<select name="select" style="width: 162px; height: 23px">
<option>SELECT SERVICE DROP DOWN</option>
<option>OTHER(FW)</option>
<option>1 MESSAGE</option>
<option>1 MOBILITY</option>
<option>1 VOICE</option>
<option>1 SAP</option>
<option>1 PORTAL</option>
<option>1 COLLAB</option>
<option>1 GSAP</option>
<option>1 SECURITY</option>
<option>1 WAN</option>
<option>S DOMAIN</option>
<option>1 AUTH</option>
<option>1 DOCM</option>
<option>1 REMOTE</option>
</select>
</label>

</div>
<div id="Layer18">

<label>RG GROUP
<select name="select2" style="width: 162px; height: 23px">
<option>SELECT RG GROUP</option>
<option>I-AM-AU-AM-HWT</option>
<option>I-EUS-IN-CSC-DSK-CSD</option>
<option>I-EUS-IN-CSC-DSK-GSD</option>
<option>I-EUS-GB-DCS-BHPVICFW</option>
<option>I-ITS-AU-HW</option>
<option>I-SRM-AU-IAM-LAMU</option>
<option>I-ITS-AU-SW</option>
<option>C-BHP-AU-CSC-LSD-NONBRG</option>
<option>C-BHP-AU-ACN-AQM</option>
</select>
</label>

</div>
</div>
<div id="Layer19">

<label>SELECT GROUPS
<select name="select3" onchange="showInfo()" style="width: 162px; height: 23px">
<option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
<option value="verify1">OA</option>
<option>OC</option>
<option>OTHERS</option>
</select>
</label>
<div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
<input type="text" name="textfield4" />
</label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
<input type="text" name="textfield3" />
</label>
</div>

<div id="Layer24">

<label>COMMENTS
<input type="text" name="textfield2" />
</label>

</div>
<div id="Layer26">

<input name="Reset" type="reset" id="Reset" value="Reset" />

</div>
<div id="Layer25">
<input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
<input type="hidden" name="chkbox2" id="chkbox2" />
<input type="hidden" name="chkbox3" id="chkbox3" />
<input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
<input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
</form>

</div>
</div>
</div>
</body>
</html>

THANKS IN ADVANCED

How Do I Send Data And Return Data From The Server-side Php, Properly?

Similar Tutorials

View Content

Here's the code that deals with the client side:

<?php 
session_start(); 
if(!isset($_SESSION['Logged_in'])){
header("Location: /page.php?page=login");
}
?>
<!DOCTYPE Html>
<html>
<head>
<!--Connections made and head included-->
<?php require_once("../INC/head.php"); ?>
<?php require_once("../Scripts/DB/connect.php"); ?>
<!--Asynchronously Return User Names-->
<script>
$(document).ready(function(){
function search(){
        var textboxvalue = $('input[name=search]').val();
        $.ajax(
        {
            type: "GET",
            url: 'search.php',
            data: {Search: textboxvalue},
            success: function(result)
            {
                $("#results").html(result);
            }
        });
};
</script>
</head>
<body>
<div id="header-wrapper">
<?php include_once("../INC/nav2.php"); ?>
</div>
<div id="content">
<h1 style="color: red; text-align: center;">Member Directory</h1>
<form onsubmit="search()">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label for="search">Search for User:</label>
<input type="text" size="70px" id="search" name="search">
</form>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index.php?do=">Show All Users</a>|<a href="index.php?do=ONLINE">Show All Online Users</a>
<div id="results">
<!--Results will be returned HERE!-->
</div>

search.php

<?php
//testing if data is sent ok
echo "<h1>Hello</h1><br>" . $_GET['search'];
?>

This is the link I get after sending foo. http://www.family-li...php?&search=foo Is that mean it was sent, but I'm not processing it correctly? I'm new to the whole AJAX thing.

Migrating To Mysqli - Not Fetching Data

Similar Tutorials

View Content

Hi,

I am trying to migrate my project from mysql to mysqli but with little knowledge of the later.

Among the noticeable errors is that the code is no longer fetching data from the database, and I am also getting UNDEFINED VARIABLE errors on the in the mysqli statement that should be binding results to variables.

Here is the code if you can help:

//set connection variables
$host = "localhost";
$username = "root";
$password = "password";
$db_name = "mydb"; //database name

//connect to mysql server
$mysqli = new mysqli($host, $username, $password, $db_name);

//check if any connection error was encountered
if(mysqli_connect_errno()) {
    echo "Error: Could not connect to database.";
    exit;
}

//Just counting ...required for pagination...
$query = "SELECT COUNT(*) FROM t_persons";

$result = mysqli_query($mysqli,$query) or die(mysqli_connect_errno());
$num_rows = mysqli_fetch_row($result);


$pages = new Paginator;
$pages->items_total = $num_rows[0];
$pages->mid_range = 9; // Number of pages to display. Must be odd and > 3
$pages->paginate();

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
    
    if ($stmt = $mysqli->prepare("SELECT p.PersonID,
                p.ImagePath,
                p.FamilyName,
                p.FirstName,
                p.OtherNames,
                p.Gender,
                p.CountryID,
                p.StatusID,
                i.IncidentDate,
                i.IncidentCountryID,
                i.AgencyID,
                i.KeywordID
 
FROM t_incidents i
INNER JOIN
  t_incident_persons ip ON ip.IncidentID = i.IncidentID
INNER JOIN
  t_persons p ON ip.PersonID = p.PersonID    

WHERE p.PersonID>0" . $likes . " ORDER BY p.PersonID DESC $pages->limit")) {    
    
    /* Execute the prepared Statement */
    $stmt->execute();
    
    /* Bind results to variables */
    $stmt->bind_result($PersonID,$ImagePath,$FamilyName,$FirstName,$OtherNames,$Gender,$CountryID,$StatusID,$IncidentDate,$IncidentCountryID,$AgencyID,$KeywordID);
    
    /* fetch values */
    while ($rows = $stmt->fetch()) {
     // display records in a table

//    $PersonID=$row[0];
?>
    <div class="thumbnail">
<a href=details.php?PersonID=<?php echo $PersonID ?> target=gallery><img src="./Persons_Images/<?php echo $row[1]; ?>" width="100" height="130" alt="" /></a><br>
<a href="details.php?PersonID=<?php echo $PersonID; ?>"> <?php echo $row[2]; ?> <?php echo $row[3]; ?></a>
</div>

  <?php }?>

<?php
    }

    /* Close the statement */
    $stmt->close();


/* close our connection */
$mysqli->close();
?>

I will appreciate. Joseph

Unable To Insert Data In Db

Similar Tutorials

View Content

Hello....I am using ajax,jquery with php to insert data in db.....but the script is not working.

form.html:
Code: [Select]

<!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>Untitled Document</title>
<style type="text/css">
label{
display:block;
}
</style>
<script type="text/javascript" src="jquery-1.5.min.js">
</script>
<script type="text/javascript">
$(function()
{
$('#submit').click(function(){
$('#container').append('<img src="ajax-loader.gif" id="loading" alt="image" />');

var name=$('#name').val();
var email=$('#email').val();
var d=$('#d').val();
var m=$('#m').val();
var y=$('#y').val();
var add=$('#add').val();
var phone=$('#phone').val();
$.ajax({
url: 'process.php',
type: 'POST',
data: 'name=' + name + '&email=' + email + '&d=' + d + '&m=' + m + '&y=' + y + '&add=' + add + '&phone=' + phone,
success: function(result){
$('#response').remove();
$('#container').append('<p id="response">' + result + '</p>');
$('#loading').fadeOut(500,function(){
$(this).remove();
});
}
});
return false;

});

});

</script>

</head>

<body>
<h2>User Registeration</h2>
<form action="process.php" method="POST">
<div id="container">

Name:<br>
<input type="text" name="name" id="name" /><br>
Email:<br>
<input type="text" name="email" id="email" /><br>
Date Of Birth:<br>
<input type="text" id="d" name="d" size="2" />
<input type="text" id="m" name="m" size="2" />
<input type="text" id="y" name="y" size="4" /><br>
Address:<br>
<input type="text" id="add" name="add" /><br>
Phone:<br>
<input type="text" id="phone" name="phone" /><br>

<input type="submit" name="submit" id="submit" value="GO!" />
</div>
</form>

</body>
</html>

process.php
My db id named "jquery" and table is "tab"

Code: [Select]

<?php
$conns=mysql_connect("localhost","root","");
if(!$conns)
echo "error in connection";
mysql_select_db("jquery", $conns);

$name=$_POST['name'];
$email=$_POST['email'];
$m=$_POST['m'];
$d=$_POST['d'];
$y=$_POST['y'];
$add=$_POST['add'];
$phone=$_POST['phone'];

echo $name,"<br>";
echo $email,"<br>";
echo $m, "<br>";
echo $d,"<br>";
echo $y,"<br>";
echo $add, "<br>";
echo $phone,"<br>";

$query="INSERT INTO tab (name,email,d,m,y,add,phone) VALUES ('$name',$email','$d','$m','$y','$add','$phone')";
if(!mysql_query($query,$conns))
echo "Error";
else
echo "DATA inserted";
?>

The output shown is:
pulkit
pulkit@gmail.com
1
26
1991
lucknow
987576787
Error

For some values i entered.

Insert Data On Mysql Using Mysqli Function

Similar Tutorials

View Content

how i can make a insert using this fuctions I m learning php, as using this functions (mysqli abstract) but after update wont work any more.

/** insert data array */
public function insert(array $arr)
{

if ($arr)
{
$q = $this->make_insert_query($arr);
$return = $this->modifying_query($q);
$this->autoreset();
return $return;
}
else
{
$this->autoreset();
return false;
}
}

complement

/** insert query constructor */
protected function make_insert_query($data)
{
$this->get_table_info();
$this->set_field_types();
if (!is_array(reset($data)))
{
$data = array($data);
}
$keys = array();
$values = array();
$keys_set = false;
foreach ($data as $data_key => $data_item)
{
$values[$data_key] = array();
$fdata = $this->parse_field_names($data);
foreach ($fdata as $key => $val)
{
if (!$keys_set)
{
if (isset($this->field_type[$key]))
{
$keys[] = '`' . $val['table'] . '`.`' . $val['field'] . '`';
}
else
{
$keys[] = '`' . $val['field'] . '`';
}
}
$values[$data_key][] = $this->escape($val['value'], $this->is_noquotes($key), $this->field_type($key), $this->is_null($key),
$this->is_bit($key));
}
$keys_set = true;
$values[$data_key] = '(' . implode(',', $values[$data_key]) . ')';
}
$ignore = $this->ignore ? ' IGNORE' : '';
$delayed = $this->delayed ? ' DELAYED' : '';
$query = 'INSERT' . $ignore . $delayed . ' INTO `' . $this->table . '` (' . implode(',', $keys) . ') VALUES ' . implode(',',
$values);
return $query;
}

before update this class i used to insert data like this

$db = Sdba::table('users');
$data = array('name'=>'adam');
$db->insert($data);

this method of insert dont works on new class. if i try like this i got empty columns and empty values. thanks for any help complete class download http://goo.gl/GK3s4E

Unable To Load Image Data

Similar Tutorials

View Content

I wonder whether someone may be able to help me please.

I'm trying to put together a PHP within Aurigma Image Uploader which will create an image gallery. To do this I need to extract the image from a folder called 'Thumbnails' and image data from a file called 'files.xml'.

The code below is an extract of the default script that performs this functionality and I've tested and it works without any issues.

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
I have now changed my folder and file structure to the following:

UploadedFiles (Folder)
username (Subfolder containing the 'location' folder) location (Subfolder containing 'Thumbnails folder and image, and 'files.xml') Please note that both the 'username' and 'location' folders are dynamically created when the user initially uploads the images.
To try and accomodate the new file structure I changed my code to:

Code: [Select]
<?php

  //This variable specifies relative path to the folder, where the gallery with uploaded files is located.
  //Do not forget about the slash in the end of the folder name.
  $galleryPath = 'UploadedFiles/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
But when I run this I receive the following error:

Quote

d333603417/htdocs/development/UploadedFiles/files.xml" in /homepages/2/d333603417/htdocs/development/gallery.php on line 14

Line 14 is this line:
Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I've been working on this for days and I just can't seem to find the answer.

I just wondered whether someone could possibly look at this and let me know where I'm going wrong.

If it helps, I've added the upload script below.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php';
require_once 'ImageUploaderPHP/UploadHandler.class.php';
$galleryPath = 'UploadedFiles/';

function onFileUploaded($uploadedFile) {
  global $galleryPath;

  $packageFields = $uploadedFile->getPackage()->getPackageFields();
  $username=$packageFields["username"];
  $locationid=$packageFields["locationid"];
  $username = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']);
  $location = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']);
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']);

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $username . DIRECTORY_SEPARATOR . $location . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true);
  chmod($absGalleryPath, 0777);
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true);
  chmod($absGalleryPath . $dirName, 0777);

  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0)
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE);

  $originalFileName = $uploadedFile->getSourceName();
  $files = $uploadedFile->getConvertedFiles();
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName);
  $sourceFile = $files[0];

  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName);
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName);
  $thumbnailFile = $files[1];
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName);

  $descriptions = new DOMDocument('1.0', 'utf-8');
  $descriptions->load($absGalleryPath . 'files.xml');

  $xmlFile = $descriptions->createElement('file');
  // <-- please check the following line
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName);
  $xmlFile->setAttribute('source', $sourceFileName);
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize());
  $xmlFile->setAttribute('originalname', $originalFileName);
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName);
  $xmlFile->setAttribute('description', $uploadedFile->getDescription());
  $xmlFile->setAttribute('username', $username);
  $xmlFile->setAttribute('locationid', $locationid);
  $xmlFile->setAttribute('folder', $dirName);

  $descriptions->documentElement->appendChild($xmlFile);
  $descriptions->save($absGalleryPath . 'files.xml');
}

$uh = new UploadHandler();
$uh->setFileUploadedCallback('onFileUploaded');
$uh->processRequest();
?>
Many thanks

Unable To Insert Data Into Database

Similar Tutorials

View Content

Hello all,
I hope you are doing great.I am using phpmyadmin for the first time.So I created a table called guestbook with 4 attributes: id,name,email,message..Then I created a php file with the following code (saved in htdoc in Xampp folder)and html form which would take the data from the user and insert into the database which could later be retrieved.So far I have just written the insertion code which successfully creates the form but when I click on submit button it opens the same php file with the code and no insertion is made in the database..here is my code..please help me urgently..i have my project deadline very soon.
php file called guest.php:
<?php
   $user="root";
   $password="";
   $database="Guestbook";
   $name=$_POST['name'];
   $email=$_POST['email'];
   $body=$_POST['body'];
   $connect("localhost",$user,$password);
   mysql($connect);
   @mysql_select_db($database)or die("unable to select db");
   $query = mysql_query("INSERT INTO Guestbook(id,name,email,body) VALUES('','$name','$email','$body')");
   if(!$query)
   {
      echo mysql_errno().':'.mysql_error();
         }
   mysql_close();
   ?>
html file called new.html:
<html>
<head>
<title>Guestbook</title>
</head>
<body>
<form method="post" action="guest.php" >
Name:<input type="text" name="name" size="30"/><br/>
Email: <input type="text" name="email" size="30"/><br/>
<p>Text:<br/>
<textarea name="message" rows="15" cols="60"></textarea></p>
<br/>
<input type="submit" value="Submit"/>
<input type="reset" value="Clear"/>
</form>
</body>
</html>

Unable To Retrieve Mysql Data

Similar Tutorials

View Content

Hi folks,

Complete No0b here when it comes to PHP and MySQL.

I am in the middle of creating a PHP website. What I want to do is have the contents of a page in a MySQL table and have PHP gather the page content and display it on the page.
Here is what I have in my home.tpl file:

Code: [Select]
<?php $query = "SELECT home, FROM $database_name";
$result = mysql_query($query); ?>
And, in my index.php I simply call that home.tpl to display the data by using:

Code: [Select]
<?php include 'templates/default/home.tpl'; ?>
Now, all I get is a blank page on index.php. Is there something else I should be doing?
Remember, I am a complete No0b!

Thanks folks.

Unable To Retrieve Data For One Column

Similar Tutorials

View Content

I have some php code on view invoice and it's getting all the data I need to from three database tables but for some reason it's not getting the data for one specific column and unsure why

I have done a echo sql and it is echoing the sql query ok and have ran the sql query in phpmyadmin and is displaying the column in phpmyadmin that is not displaying on the php page so am bit confused, below is the coding I have. I took out a lot of it and tried to keep to the relevant parts

<?php
$sql = "SELECT t1.id, t1.invoice_number, DATE_FORMAT(t1.invoice_date,'%d/%m/%Y') AS invoice_date, t1.user_id, t2.invoice_number, t2.service_name, t2.service_price, t3.user_id, t3.customer_name, t3.customer_phone, t3.customer_email, t2.service_name, t2.service_price, t1.invoice_total, t1.balance, t1.notes, DATE_FORMAT(t1.payment_date,'%d/%m/%Y') AS payment_date, t1.payment_method
FROM invoices as t1
LEFT JOIN invoice_products as t2
ON t1.id = t2.invoice_id
LEFT JOIN users as t3
ON t1.user_id = t3.user_id
WHERE t1.user_id = '".$_SESSION['user_id']."' and t1.id = '".$_GET['id']."'";

$result = mysqli_query($connect, $sql);

                if(mysqli_num_rows($result) > 0)
                {
                if($row = mysqli_fetch_array($result))  
                {
                ?>

                Notes: <?php echo $row['notes'];?>

                <?php
                    }
                    }
                    ?>

Unable To Write Data Into A File In My Server Using Php

Similar Tutorials

View Content

Hey guys i am writing a code which will get data frm the user and then write a file in my server and well sadly i am really confused with the annoying errors and warnings i am getting please help here is my code
<?php
//This File Gets the data from the chat setup form and then writes the chat file or edits it

//Get Data from the form
$cname=$_POST['cname'];
$nicklen=$_POST['nicklen'];
$msglen=$_POST['msglen'];
$pm=$_POST['pm'];
$msgh=$_POST['msgh'];
$aname=$_POST['aname'];
$pass=$_POST['pass'];
$cheight=$_POST['cheight'];
$cwidth=$_POST['cwidth'];
$prcadmin=$_POST['prcadmin'];
$cas=$_POST['cas'];
$frznick=$_POST['frznick'];
$sm=$_POST['sm'];
$id=$_COOKIE["id"];
//Check if the cookie id is empty
if (!isset($id))
{
header( 'Location: www.techbreeze.in/mychat/chat-add.html') ;
}
//Check if any field is empty and redirect to setup page if empty
if ((isset($cname))&&(isset($nicklen))&&(isset($msglen))&&(isset($pm))&&(isset($msgh))&&(isset($aname))&&(isset($pass))&&(isset($cheight))&&(isset($cwidth)))
{
if ((is_numeric ($nicklen)) && (is_numeric ($msglen))&&(is_numeric($pm))&&(is_numeric($msgh))&&(is_numeric ($cheight))&&(is_numeric ($cwidth)))
{
//Start writting data into the file
                        $str1=";";
                $str2 = ".php";
                $str4 = "\n";

$File = $id . $str2;
$fh = fopen($File, 'w') or die("can't open file");

       $stringData = "<?php\n";
                fwrite($fh, $stringData);

                $strt1= "require_once /mychat/src/phpfreechat.class.php;\n";
                $stringData = $strt1;
                fwrite($fh, $stringData);

                $strt1='$params["serverid"]    =';
                $stringData = $strt1 . $id . $str1 . $str4;
                fwrite($fh, $stringData);
                fclose($fh);

$strt3 = "$params";
$stringData = $strt3;
fwrite($fh, $stringData);
fclose($fh);
}
else
{
echo "Only numeric Inputs allowed for the fields";
echo  "<br><br><br>";
echo "Enter the maximum length of nick";
echo  "<br>";
echo "Maximum Lenth of message";
echo  "<br>";
echo "Max number of Simultaneous PM";
echo  "<br>";
echo "No. of msg to be stored in history";
echo  "<br>";
echo "Height of the Chat Room";
echo  "<br>";
echo "Width of Chat Room";
echo  "<br><br><br>";
echo "Please Fill them up Carefully!";
echo "<meta HTTP-EQUIV='REFRESH' content='6; url= http://www.techbreeze.in/chat-setup.html'>";

}
}
else
{
echo "You Have one or more incomplete Field";
echo  "<br>";
echo "Please Fill them up Carefully!";
echo "<meta HTTP-EQUIV='REFRESH' content='2; url= http://www.techbreeze.in/chat-setup.html'>";
}

       ?>

ok now the error i am getting is Quote

Warning: fclose(): 3 is not a valid stream resource in /home/techbr/domains/techbreeze.in/public_html/mychat/chatcreate.php on line 52

Any ideas as to what i should do and why i am getting this error.

Php Undefined Variable, Unable To Retrieve Data

Similar Tutorials

View Content

I am trying to create a code where the user enters the zip code and if found in the database, a location will be retrieved. I am getting two undefined variables as errors. I am still learning the POST and GET method and I fear that is where I am getting something mixed up. I have also attached an image of my DB.

Thank you so much any input is greatly appreciated.

Notice: Undefined variable: address in C:\xampp\htdocs\index.php on line 53

Notice: Undefined variable: zip in C:\xampp\htdocs\index.php on line 54

index.php file code:

<?php

     include ('header.php');
     include ('function.php');

     ?>


        <div class="wrapper">
           <div>
               <?php
               echo'<form method="POST" action"'.getLocations($conn).'">
                   <input type="text" name="zip" class="search" placeholder="Zip code"><br>
                   <button type="submit" value="submit" id="submit">Submit</button>
                   </form>';
               getLocations($conn);
              ?>         
           </div>
        </div>
        
        <div>
             <!--foreach($zip as $zip) : -->
            <?php 
                  echo $address['address'];
                  echo $zip['zip']; 
            ?>
        </div>
    
    
 function.php file code:
    
    
    <?php
    
    $dBServername = "localhost";
    $dBUsername = "root";
    $dBPassword = "";
    $dBName = "addresses";
    
    // Create connection
    $conn = mysqli_connect($dBServername, $dBUsername, $dBPassword, $dBName);
    
    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    function getLocations($conn) {
        if (isset($_POST['submit'])){
            
             // Validate Zip code field
            if (!empty ($_POST['zip']) && is_numeric ($_POST['zip'])) {
                
            $zip = (int)$_POST['zip'];
        
            
        $query = "SELECT * FROM locations WHERE zip = '$zip'";
        
        //get the results
        $result = mysqli_query($conn, $query);
        
        //fetch the data
        $zip = mysqli_fetch_all($result, MYSQLI_ASSOC);
        var_dump($zip);
        
        
        mysqli_free_result($result);
        
        //close connection
        mysqli_close($conn);
    
        
       }
    } 
      
    }

Unable To Load Image Data With Dynamic Folders

Similar Tutorials

View Content

I wonder whether someone may be able to help me please.

I've put together the following script which saves user defined images to server folders using the Aurigma Image Uploader software.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php';
require_once 'ImageUploaderPHP/UploadHandler.class.php';
$galleryPath = 'UploadedFiles/';

function onFileUploaded($uploadedFile) {
  global $galleryPath;

  $packageFields = $uploadedFile->getPackage()->getPackageFields();
  $username=$packageFields["username"];
  $locationid=$packageFields["locationid"];
  $usernamefolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']);
  $locationfolder = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']);
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']);

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true);
  chmod($absGalleryPath, 0777);
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true);
  chmod($absGalleryPath . $dirName, 0777);

  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0)
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE);

  $originalFileName = $uploadedFile->getSourceName();
  $files = $uploadedFile->getConvertedFiles();
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName);
  $sourceFile = $files[0];

  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName);
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName);
  $thumbnailFile = $files[1];
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName);

  $descriptions = new DOMDocument('1.0', 'utf-8');
  $descriptions->load($absGalleryPath . 'files.xml');

  $xmlFile = $descriptions->createElement('file');
  // <-- please check the following line
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName);
  $xmlFile->setAttribute('source', $sourceFileName);
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize());
  $xmlFile->setAttribute('originalname', $originalFileName);
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName);
  $xmlFile->setAttribute('description', $uploadedFile->getDescription());
  $xmlFile->setAttribute('username', $username);
  $xmlFile->setAttribute('locationid', $locationid);
  $xmlFile->setAttribute('folder', $dirName);

  $descriptions->documentElement->appendChild($xmlFile);
  $descriptions->save($absGalleryPath . 'files.xml');
}

$uh = new UploadHandler();
$uh->setFileUploadedCallback('onFileUploaded');
$uh->processRequest();
?>
This code saves the files in the following structu

UploadedFiles (Pre-existing folder)
'username' (Subfolder created dynamically on image upload if it doesn't already exist. This folder contains the 'location' folder) 'location' (Subfolder created dynamically on image upload if it doesn't already exist. This contains original image, 'files.xml' and 'Thumbnails' folder) 'Thumbnails' (Subfolder created dynamically on image upload if it doesn't already exist. This contains thumbnail of original image)
I'm now trying to put together a script which creates an image gallery, with those images pertinent to the current user and location. The code below is the piece of my script which deals with the loading of the images.

Code: [Select]
<?php
  $galleryPath = 'UploadedFiles/';

  $thumbnailsPath = $galleryPath . 'Thumbnails/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
The initial problem I had, was resolved from guidance I received on this site, and that was to find the correct 'realpath' of the 'Thumbnails' folder and 'files.xml'
These are as follows: Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1

and Quote

/homepages/2/d333603417/htdocs/development/UploadedFiles/IRHM73/1/Thumbnails

with 'IRHM73' being the 'username' value and '1' the 'location' value.

The problem I now have lies within this line of code:

`$absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR;`

Because the 'username' and 'location' are dynamic and hence contain different values for each user and location, I've found it impossible to find a way of creating the correct file path to open the 'Thumbnails' folder and 'files.xml'.

I had tried this:

Code: [Select]
<?php

  $galleryPath = 'UploadedFiles/';

  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR;
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR;

  $descriptions = new DOMDocument('1.0');
  $descriptions->load($absGalleryPath . 'files.xml');
?>
But I receive the following error: DOMDocument::load() domdocument.load: I/O warning : failed to load external entity /homepages/2/d333603417/htdocs/development/UploadedFiles/'files.xml'; in /homepages/2/d333603417/htdocs/development/gallery.php on line 13 and line 13 is this: Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I really am stumped with what to do next to get this to work. I appreciate that this is a fairly lengthy post, but thought it would be better to post all the information.

I just wondered whether someone could perhaps take a look at this and let me know where I'm going wrong and how I can get it to work.

Many thanks and regards

Unable To Save Submitted Data In A Mysql Database Using Php

Similar Tutorials

View Content

<?php $GLOBALS['title']="Admission-HMS"; $base_url="http://localhost/hms/"; require('./../../inc/sessionManager.php'); require('./../../inc/dbPlayer.php'); require('./../../inc/fileUploader.php'); require('./../../inc/handyCam.php'); $ses = new \sessionManager\sessionManager(); $ses->start(); if($ses->isExpired()) { header( 'Location:'.$base_url.'login.php'); } else { $name=$ses->Get("loginId"); } $msg=""; if ($_SERVER["REQUEST_METHOD"] == "POST") { if (isset($_POST["btnSave"])) { $db = new \dbPlayer\dbPlayer(); $msg = $db->open(); echo '<script type="text/javascript"> alert("'.$msg.'");</script>'; if ($msg = "true") { $userIds = $db->getAutoId("U"); $flup = new fileUploader\fileUploader(); $perPhoto = $flup->upload("/hms/files/photos/",$_FILES['perPhoto'], $userIds[1]); // var_dump($perPhoto); $handyCam=new \handyCam\handyCam(); if (strpos($perPhoto, 'Error:') === false) { $dateNow=date("Y-m-d"); $data = array( 'userId' => $userIds[1], 'userGroupId' => "UG004", 'name' => $_POST['name'], 'studentId' => $_POST['stdId'], 'cellNo' => $_POST['cellNo'], 'gender' => $_POST['gender'], 'dob' => $handyCam->parseAppDate($_POST['dob']), 'passportNo' => $_POST['passportNo'], 'fatherName' => $_POST['fatherName'], 'fatherCellNo' => $_POST['fatherCellNo'], 'perPhoto' => $perPhoto, 'admitDate' => $dateNow, 'isActive' => 'Y' ); $result = $db->insertData("studentinfo",$data); if($result>=0) { $data = array( 'userId' => $userIds[1], 'userGroupId' => "UG004", 'name' => $_POST['name'], 'loginId' => $_POST['stdId'], 'verifyCode' => "vhms2115", 'expireDate' => "2115-01-4", 'isVerifed' => 'Y' ); $result=$db->insertData("users",$data); if($result>0) { $id =intval($userIds[0])+1; $query="UPDATE auto_id set number=".$id." where prefix='U';"; $result=$db->update($query); // $db->close(); echo '<script type="text/javascript"> alert("Admitted Successfully.");</script>'; } else { echo '<script type="text/javascript"> alert("' . $result . '");</script>'; } } elseif(strpos($result,'Duplicate') !== false) { echo '<script type="text/javascript"> alert("Student Already Exits!");</script>'; } else { echo '<script type="text/javascript"> alert("' . $result . '");</script>'; } } else { echo '<script type="text/javascript"> alert("' . $perPhoto . '");</script>'; } } else { echo '<script type="text/javascript"> alert("' . $msg . '");</script>'; } }

Send/receive Data.

Similar Tutorials

View Content

Hey,

I'm trying to send a form input to a page, and then get the response (as in, the body) from that page without leaving my PHP script.

So instead of when you normally submit a form and it will take you to the 'action="/somepage"'. I want it to get that information and bring it back to the original page. No navigation should happen.

I'm almost certain this is possible, but the only thing I've found at the moment requires a custom addon - which, isn't on most hosting sites.

Sorry if I haven't described this very well, but any help would be appreciated

Thanks

tree

Send Data In A Form Using Div !

Similar Tutorials

View Content

..and its not working (i replaced <textarea> with <div> to apply some html tags inside it )

and this is my form :

Code: [Select]
<form action="proc.php" method="post">
<div id="text" name="question_text" class="text" contenteditable="true"></div>
</form>
but when i submit some text the $_POST['question_text'] is not set !

Send Post Form Data Through Php

Similar Tutorials

View Content

I needed a server side PHP validation script for my form to use on top of client side Javascript as a backup. I found a nice package where I just include the validator and set a few options then it does the rest. However it doesn't seem to work with the action="whateveraction.php" for the form. It will skip all the validation and immediately go to the action script. So I left that blank as you can see in the form below and figured I would send the post data somehow to the script using PHP when the validation is successful. However I am stumped on how to do that can I get some coding help?

This is the small validation script. I will attach the formvalidator.php in this post.
Code: [Select]
<?php
require_once "formvalidator.php";
if(isset($_POST['submit']))
{
    $validator = new FormValidator();
    $validator->addValidation("age","req","Please fill in your Age");
    $validator->addValidation("mcid","req","Please fill in your Minecraft Username");
    $validator->addValidation("description","req","Please fill in a Description");
    if($validator->ValidateForm())
    {

      //need something here to have it send the post data to /mcbuildapp/form_submit.php

    }
    else
    {
        echo "<div class=blockrow><b><font size=5>Form Errors:</font><b></div>";

        $error_hash = $validator->GetErrors();
        foreach($error_hash as $inpname => $inp_err)
        {
          echo "<div class=blockrow><p><font color=red>$inp_err</font></p>\n</div>";
        }
    }
}

Then the form if it matters....
Code: [Select]
<div class="blockrow">
<font size=4><b>Minecraft Building Rights Application</b></font>
<br />
<br />
<b>Failing to fill in any of these fields sufficiently will result in an automatic denial of your application!</b><br />
<b>Think of it this way, being lazy and applying wrong is only wasting your time. Take the time to do it correctly the first time.</b>

<br />
<br />

<b><font color=red>To ensure proper user authentication and security you must first join the server at least once before applying for your building rights to work!</font></b>
<br />
<br />
<form action="" id="mcbuilderapp" name="mcbuilderapp" method="post">

<label><b>Your Minecraft Username (required)</b><br />
Use exact capitalization and punctuation that matches your Minecraft.net account!</label>

<br />
<br />

<input type="text" name="mcid" id="mcid" maxlength="25"/>

<br />
<br />

<label><b>Your Age (required)</b></label>

<br />
<br />

<input type="text" name="age" id="age" maxlength="3"/>

<br />
<br />

<label><b>Describe Yourself (required)</b><br />
Describe yourself in <b>no less</b> than 3 sentences using <b>correct grammar</b>.</label>

<br />
<br />

<textarea name="description" id="description" minlength="10" maxlength="1000" cols=60 rows=5 wrap="physical">
</textarea>

<br />
<br />

<input type="submit" name="submit" value="Submit" />
</form>
</div>
MOD EDIT: PHP manual tags changed to code tags . . .

[attachment deleted by admin]

Ajax To Send Json Data To Db

Similar Tutorials

View Content

I am retrieving Google Books info in JSON format and displaying it inside a div. I would like to send the contents of this div (name, title, description) to my database using Ajax. Currently only the ISBN field sends because I have it declared as a variable. However my question is, how do I send the other fields (name, title, author). How do I declare these also, I'm not sure what format they need to be in etc. My JS

$(document).ready(function() {
$('#submit').click(function(ev) {
ev.preventDefault();
var isbn = $('#isbn_search').val(); //get isbn direct from input
var url='https://www.googleapis.com/books/v1/volumes?q='+isbn;
$.getJSON(url,function(data){
$.each(data.items, function(entryIndex, entry){
var html = '<div class="results well">'; 
html += '<h3>' + entry.volumeInfo.title + '</h3>';
html += '<div class="author">' + entry.volumeInfo.authors + '</div>';
html += '<div class="description">' + entry.volumeInfo.description + '</div>';
}); 
});
});
});

My Ajax;

        $.ajax({
             type: 'POST',
             url: 'addIsbnScript.php',
             data: {
                 'isbn' : isbn,
                 'title' : title
                 'subtitle' : subtitle,
                 'authors' : authors,
                 'description' : description
             },
             success: function () { 
            $.growl({
            message: " Record added"
});      
}
});

Note, if i manually set the vars like below they all do successfully send to my database, so I know my query is working ok

var title = "some text",
var author = "some text",
Var description = "some text"

Thanks in advance for any help, newbie here (incase it wasn't obvious!). J