How to Set HTML Text to Server Information

Question

I've tried things like setting a $var to the MySQL information (such as name or password), then pulling it with PHP, but I cannot figure the PHP out to do so. I use the server connect code as well. I have checked ASP.net out, but don't find any information on altering HTML text to equal SQL information. How might I go about accomplishing this?

One example: The account balance on my website is displayed in the bottom right corner, but I need to pull the balance from a column of my table from my database. What code would I use to set that paragraph element to the server value of account_balance?

My PHP/SQL for Registration:

<?php
$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " .     mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());

$email = $_POST['email'];
$emailConfirm = $_POST['confirmemail'];
$password =  $_POST['password'];
$passwordConfirm = $_POST['confirmpassword'];
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$countryCode = $_POST['countrycode'];
$phoneNumber = $_POST['phone'];
$address = $_POST['address'];
$zipCode = $_POST['zipcode'];
$city = $_POST['city'];
$state = $_POST['state'];
$country = $_POST['country'];
$dateOfBirth = $_POST['birthdate'];
$registerDate = "CURDATE()";
$registerTime = "CURTIME()";
$paymentMethod = $_POST['moneymethod'];
if($email == $emailConfirm && $password == $passwordConfirm){
if(!empty($email) && !empty($_POST['confirmemail']) && !empty($password) && !empty($_POST['confirmpassword']) && !empty($fname) && !empty($lname) && !empty($countryCode) && !empty($phoneNumber) && !empty($address) && !empty($zipCode) && !empty($city) && !empty($state) && !empty($country) && !empty($paymentMethod)){
  $query = "INSERT INTO user_information (email,password,f_name,l_name,country_code,phone_number,address,city,state,zip_code,country,money_option,join_date,join_time) VALUES ('$email','$password','$fname','$lname','$countryCode','$phoneNumber','$address','$city','$state','$zipCode','$country','$paymentMethod','$registerDate','$registerTime')";
$data = mysql_query ($query)or die(mysql_error());
if($data){
  header( 'Location: http://www.madmater.com/register/success.php' );
}else{
  echo "Unknown Error!";
}
}else{
  echo 'Please fill out all required fields before completing your registration!';
}
}else{
  echo 'Your passwords or emails do not match!';
}

?>

I have only tried a simple PHP command, as it is the only thing I could think of, being new to MySQL.

$fname = $_POST['fname']; //From form
echo "<script type="text/javascript">document.getElementById("fname-holder").innerHTML($fname);</script>";

Even a hint of where to start would help, and thank you in advanced.

Can you give us an example or something you tried? I'm having a bit of trouble wrapping my head around this. — Funk Forty Niner, Nov 15 '14 at 17:14
I added an example, if it isn't clear enough, I can add another! — Austin Bunker, Nov 15 '14 at 17:17
As per your edited question: `$var = $row['balance'];` from a fetched query. You should show us what you tried in order to give you a better/definite answer. — Funk Forty Niner, Nov 15 '14 at 17:17
`while($row = (mysqli_fetch_array($query)){...}` or `mysqli_fetch_assoc()` depending on the API and the method you wish to use. — Funk Forty Niner, Nov 15 '14 at 17:19
I updated it, and would that be the script I use to retrieve information and set text, or no? I am quite new to SQL — Austin Bunker, Nov 15 '14 at 17:22
I have gone through multiple PHP tutorials and am comfortable with it. @itachi — Austin Bunker, Nov 15 '14 at 17:23
There is no SQL in your posted/edited question, so it's going to be that much more harder to give you a concrete answer. If you have your SQL, show it. If not, then you'll have to sift through more tutorials. Posting an answer would probably lead to more questions. — Funk Forty Niner, Nov 15 '14 at 17:24
the code you posted does nothing other than outputting some name. — itachi, Nov 15 '14 at 17:24
Ok. You've posted some SQL, but there's only an INSERT yet no SELECT. That isn't a sign of "what you tried". — Funk Forty Niner, Nov 15 '14 at 17:38
That's my problem: I don't know where to begin if not with the JavaScript I've shown as tried. What would I do with a SELECT command? — Austin Bunker, Nov 15 '14 at 17:41
I've posted something for you below to get you started. Modify to suit. @AustinBunker — Funk Forty Niner, Nov 15 '14 at 17:53
@AustinBunker I made a slight typo in my answer, if you seen it yet. Reload it to see the slight change. — Funk Forty Niner, Nov 15 '14 at 18:18

score 1 · Answer 1 · edited Nov 15 '14 at 18:22

1

Use form submit your values,

In that form in action give register.php

echo "<pre>";
print_r($_post);
echo"</pre>;

use that you got value then $name= $_post['name']

$query = "INSERT INTO "Tablename" set name= '".$name."',addeddate=now();

This way you can write.

edited Nov 15 '14 at 18:22

cuSK

809
11
26

answered Nov 15 '14 at 17:29

priya

11
2

Please view the edited version your code :) and learn to format your answer. – cuSK Nov 15 '14 at 17:48

score 1 · Answer 2 · answered Nov 15 '14 at 17:31

There is no sql code in this example. Besides the error i found in this code of PHP for ' is not used.

$fName = $_POST['fname'] //This is from my register form
echo "<script type='text/javascript'>document.getElementById('fname-field').innerHTML(".$fname.");</script>";

and try to give some insert/update code also.

score 1 · Accepted Answer · edited May 23 '17 at 10:33

Since I don't know which row your account balance is called, I've used account_balance as an example in order to get you started.

Here is a basic method to retrieve information from your database:

$fname = stripslashes($_POST['fname']);
$fname = mysql_real_escape_string($_POST['fname']);

// or if DB connnection is required
// $fname = mysql_real_escape_string($_POST['fname'], $db);

$query = "SELECT * FROM user_information WHERE f_name = '$fname'";

    while($row = mysql_fetch_array($query)){

        $user = $row['f_name'];
        $balance = $row['account_balance'];

        echo "Username: " . $user;
        echo "<br>";
        echo "Balance: " . $balance;
}

or mysql_fetch_assoc() depending on what method you wish to use.

For more information on MySQL's SELECT, visit:

http://dev.mysql.com/doc/refman/5.0/en/select.html

You can also try:

$row = mysql_fetch_array($query);
    foreach($row as $r) {
    echo $r . "<br>";
}

or:

$row = mysql_fetch_assoc($query);
    foreach($row as $r) {
    echo $r . "<br>";
}

Footnotes:

I have to state that your present code is open to SQL injection. Use mysqli with prepared statements, or PDO with prepared statements, they're much safer.

How to Set HTML Text to Server Information

3 Answers3