Jump to content

datas to site

apr1515

By apr1515
in PHP Coding Help

 Share

Recommended Posts

phpian Newbie

phpian

Posted
Posted

You can get a good introduction to PHP and MySQL on W3Schools. There are many ways to do it but this should get you started.

 

<?php
//make a connection to your database server
$con = mysql_connect("localhost","peter","abc123");

//if you weren't able to connect to the database then stop here
if (!$con)
  die('Could not connect: ' . mysql_error());

//otherwise select the database you want to use
mysql_select_db("my_db", $con);

//write a query
$result = mysql_query("SELECT * FROM table");

//loop through the results
while($row = mysql_fetch_array($result))
{
  echo $row['field1'];
}

mysql_close($con);
?>

 

Hope this helps

Link to comment
https://forums.phpfreaks.com/topic/221352-datas-to-site/#findComment-1145942
Share on other sites
apr1515 Newbie

apr1515

Posted
  • Author
Posted 
<?
session_start();

include "config.php";
global $c,$loggedin;
include "data.php";
global $config;
include "funciones.php";

// Include of settings (not for the script but for 

the chat support button)
include("_settings.php");

// Show the 2 columns or not? 1 = yes, 0 = no
$show_columns = 0;

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 

1.0 Transitional//EN" 

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-trans

itional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" 

content="text/html; charset=iso-8859-1" />
<title>Offbux - Your Profile</title>
<link href="_main.css" type="text/css" 

rel="stylesheet" />
<!--[if lte IE 6]>
<link href="_ie6hacks.css" type="text/css" 

rel="stylesheet" />
<![endif]-->
</head>

<body>

   <?php include("_header.php"); ?>
   
   <div id="content_stretch">
<?
include('menum.php');
?>
<br><br>
<?php


// incluimos archivos necesarios


if ($_POST) {


if($_POST['code']!=$_SESSION['string']){ 
$error = 1;
$errormsg .= "<b>Error</b> - The captcha was 

entered incorrectly <br />";
}

>>>>>>>I WANT TO PUT IT HERE sir [b]phpian[/b]<<<<<<<<<<<<<<

// Declaramos las variables
$password = $_POST["password"];
$cpassword = $_POST["cpassword"];
$email = $_POST["email"];
$pemail = $_POST["pemail"];
$country = $_POST["country"];
$referer = $_POST["country"];


// comprobamos que no haya campos en blanco

if($password==NULL|$cpassword==NULL|$email==

NULL|$pemail==NULL|$referer==NULL|$country=

=NULL) {
$error = 1;
$errormsg .= "<b>Error</b> - Please fill in all 

required fields<br />";
}



$password = uc($password);
$cpassword = uc($cpassword);
$email = securedata($email);
$referer = securedata($referer);
$pemail = securedata($pemail);
$country = securedata($country);



$password=limitatexto($password,15);
$cpassword=limitatexto($cpassword,15);
$email=limitatexto($email,100);
$referer=limitatexto($referer,100);
$pemail=limitatexto($pemail,100);
$country=limitatexto($country,15);



minimopass($password);

if($password!=$cpassword) {
$error = 1;
$errormsg .= "<b>Error</b> - The new passwords 

did not match<br />";
}

ValidaMail($email);
ValidaMail($pemail);
$laip = getRealIP();



if($error == 1)
{
print $errormsg."<br /><br />";

} else {




$trok=uc($_COOKIE["usNick"]);

// Si todo parece correcto procedemos con la 

inserccion

$queryb = "UPDATE tb_users SET 

password='$password', ip='$laip', email='$email', 

pemail='$pemail', country='$country' WHERE 

username='$trok'";
mysql_query($queryb) or die(mysql_error());

echo "<b>Profile Updated</b><br />
You need to re-login now to confirm your 

changes.<br />";

?>
<META HTTP-EQUIV="REFRESH" 

CONTENT="1;URL=logoutp.php">
<?
showFooter();
exit();

}
}

$uzer=uc($_COOKIE["usNick"]);
$pazz=uc($_COOKIE["usPass"]);

$sql = "SELECT * FROM tb_users WHERE 

username='$uzer'";
$result = mysql_query($sql);        
$row = mysql_fetch_array($result);

if ($pazz != $row["password"]){ exit(); }


?>
<form action="profile.php" method="POST">

<font color="#9c1515">*</font> Password (at least 

6 characters):<br>
<input type="password" size="25" class="form" 

autocomplete="off" maxlength="15" 

name="password" value="<? echo $row["password"]; 

?>">
<br>
<br>

<font color="#9c1515">*</font> Confirm 

Password:<br>
<input type="password" class="form" 

autocomplete="off" size="25" maxlength="15" 

name="cpassword" value="<? echo 

$row["password"]; ?>">
<br><br>

<font color="#9c1515">*</font> Email Address:<br>
<input type="text" class="form" 

autocomplete="off" size="25" maxlength="100" 

name="email" value="<? echo $row["email"]; ?>">
<br><br>

<br><br>


<font color="#9c1515">*</font> Alertpay E-mail 

Address For Payments:<br>
<input type="text" class="form" 

autocomplete="off" size="25" maxlength="100" 

name="pemail" value="<? echo $row["pemail"]; ?>">
<br><br>



<font color="#9c1515">*</font> Your Country (only 

Alertpay allowed countries):<br>
<select name="country" class="form" 

autocomplete="off">



<option value="<? echo $row["country"]; 

?>"></option>



<option value=1>United States</option><option 

value=2>Albania</option><option 

value=3>Algeria</option><option 

value=4>Andorra</option><option 

value=5>Angola</option><option 

value=6>Anguilla</option><option value=7>Antigua 

and Barbuda</option><option 

value=8>Argentina</option><option 

value=9>Armenia</option><option 

value=10>Aruba</option><option 

value=11>Australia</option><option 

value=12>Austria</option><option 

value=13>Azerbaijan Republic</option><option 

value=14>Bahamas</option><option 

value=15>Bahrain</option><option 

value=16>Barbados</option><option 

value=17>Belgium</option><option 

value=18>Belize</option><option 

value=19>Benin</option><option 

value=20>Bermuda</option><option 

value=21>Bhutan</option><option 

value=22>Bolivia</option><option value=23>Bosnia 

and Herzegovina</option><option 

value=24>Botswana</option><option 

value=25>Brazil</option><option value=26>British 

Virgin Islands</option><option 

value=27>Brunei</option><option 

value=28>Bulgaria</option><option value=29>Burkina 

Faso</option><option 

value=30>Burundi</option><option 

value=31>Cambodia</option><option 

value=32>Canada</option><option value=33>Cape 

Verde</option><option value=34>Cayman 

Islands</option><option 

value=35>Chad</option><option 

value=36>Chile</option><option value=37>China 

Worldwide</option><option 

value=38>Colombia</option><option 

value=39>Comoros</option><option value=40>Cook 

Islands</option><option value=41>Costa 

Rica</option><option 

value=42>Croatia</option><option 

value=43>Cyprus</option><option value=44>Czech 

Republic</option><option value=45>Democratic 

Republic of the Congo</option><option 

value=46>Denmark</option><option 

value=47>Djibouti</option><option 

value=48>Dominica</option><option 

value=49>Dominican Republic</option><option 

value=50>Ecuador</option><option value=51>El 

Salvador</option><option 

value=52>Eritrea</option><option 

value=53>Estonia</option><option 

value=54>Ethiopia</option><option 

value=55>Falkland Islands</option><option 

value=56>Faroe Islands</option><option 

value=57>Federated States of 

Micronesia</option><option 

value=58>Fiji</option><option 

value=59>Finland</option><option 

value=60>France</option><option value=61>French 

Guiana</option><option value=62>French 

Polynesia</option><option value=63>Gabon 

Republic</option><option 

value=64>Gambia</option><option 

value=65>Germany</option><option 

value=66>Gibraltar</option><option 

value=67>Greece</option><option 

value=68>Greenland</option><option 

value=69>Grenada</option><option 

value=70>Guadeloupe</option><option 

value=71>Guatemala</option><option 

value=72>Guinea</option><option value=73>Guinea 

Bissau</option><option 

value=74>Guyana</option><option 

value=75>Honduras</option><option value=76>Hong 

Kong</option><option 

value=77>Hungary</option><option 

value=78>Iceland</option><option 

value=79>India</option><option 

value=80>Indonesia</option><option 

value=81>Ireland</option><option 

value=82>Israel</option><option 

value=83>Italy</option><option 

value=84>Jamaica</option><option 

value=85>Japan</option><option 

value=86>Jordan</option><option 

value=87>Kazakhstan</option><option 

value=88>Kenya</option><option 

value=89>Kiribati</option><option 

value=90>Kuwait</option><option 

value=91>Kyrgyzstan</option><option 

value=92>Laos</option><option 

value=93>Latvia</option><option 

value=94>Lesotho</option><option 

value=95>Liechtenstein</option><option 

value=96>Lithuania</option><option 

value=97>Luxembourg</option><option 

value=98>Madagascar</option><option 

value=99>Malawi</option><option 

value=100>Malaysia</option><option 

value=101>Maldives</option><option 

value=102>Mali</option><option 

value=103>Malta</option><option 

value=104>Marshall Islands</option><option 

value=105>Martinique</option><option 

value=106>Mauritania</option><option 

value=107>Mauritius</option><option 

value=108>Mayotte</option><option 

value=109>Mexico</option><option 

value=110>Mongolia</option><option 

value=111>Montserrat</option><option 

value=112>Morocco</option><option 

value=113>Mozambique</option><option 

value=114>Namibia</option><option 

value=115>Nauru</option><option 

value=116>Nepal</option><option 

value=117>Netherlands</option><option 

value=118>Netherlands Antilles</option><option 

value=119>New Caledonia</option><option 

value=120>New Zealand</option><option 

value=121>Nicaragua</option><option 

value=122>Niger</option><option 

value=123>Niue</option><option value=124>Norfolk 

Island</option><option 

value=125>Norway</option><option 

value=126>Oman</option><option 

value=127>Palau</option><option 

value=128>Panama</option><option value=129>Papua 

New Guinea</option><option 

value=130>Peru</option><option 

value=131>Philippines</option><option 

value=132>Pitcairn Islands</option><option 

value=133>Poland</option><option 

value=134>Portugal</option><option 

value=135>Qatar</option><option 

value=136>Republic of the Congo</option><option 

value=137>Reunion</option><option 

value=138>Romania</option><option 

value=139>Russia</option><option 

value=140>Rwanda</option><option value=141>Saint 

Vincent and the Grenadines</option><option 

value=142>Samoa</option><option value=143>San 

Marino</option><option value=144>São Tomé and 

Príncipe</option><option value=145>Saudi 

Arabia</option><option 

value=146>Senegal</option><option 

value=147>Seychelles</option><option 

value=148>Sierra Leone</option><option 

value=149>Singapore</option><option 

value=150>Slovakia</option><option 

value=151>Slovenia</option><option 

value=152>Solomon Islands</option><option 

value=153>Somalia</option><option value=154>South 

Africa</option><option value=155>South 

Korea</option><option 

value=156>Spain</option><option value=157>Sri 

Lanka</option><option value=158>St. 

Helena</option><option value=159>St. Kitts and 

Nevis</option><option value=160>St. 

Lucia</option><option value=161>St. Pierre and 

Miquelon</option><option 

value=162>Suriname</option><option 

value=163>Svalbard and Jan Mayen 

Islands</option><option 

value=164>Swaziland</option><option 

value=165>Sweden</option><option 

value=166>Switzerland</option><option 

value=167>Taiwan</option><option 

value=168>Tajikistan</option><option 

value=169>Tanzania</option><option 

value=170>Thailand</option><option 

value=171>Togo</option><option 

value=172>Tonga</option><option 

value=173>Trinidad and Tobago</option><option 

value=174>Tunisia</option><option 

value=175>Turkey</option><option 

value=176>Turkmenistan</option><option 

value=177>Turks and Caicos Islands</option><option 

value=178>Tuvalu</option><option 

value=179>Uganda</option><option 

value=180>Ukraine</option><option value=181>United 

Arab Emirates</option><option value=182>United 

Kingdom</option><option 

value=183>Uruguay</option><option 

value=184>Vanuatu</option><option 

value=185>Vatican City State</option><option 

value=186>Venezuela</option><option 

value=187>Vietnam</option><option 

value=188>Wallis and Futuna 

Islands</option><option 

value=189>Yemen</option><option 

value=190>Zambia</option>
	  </select>


<br><br>


<font color="#9c1515">*</font> Security code:<br>
<img src="image.php" 

onclick="this.src='image.php?newtime=' + (new 

Date()).getTime();">(Click to reload)<br />
<input type="text" size="5" class="form" 

autocomplete="off" maxlength="5" name="code">
<br><br>

<input type="submit" value="Edit">

</form>

   </div>
   
   <?php include("_footer.php"); ?>

</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/221352-datas-to-site/#findComment-1145963
Share on other sites
phpian Newbie

phpian

Posted
Posted

There isn't anything wrong with line 51 in the code you posted but I'm quite sure that this is because the formatting has been messed up. There are lots of extra line breaks in the code you posted. If you run that code, I would actually expect you to hit an error on line 12 

the chat support button)

.

 

However, if this script is formatted correctly for you, I don't think you need to do anything to it - so revert any changes you have made. If you open up the config.php or _settings.php you may see some settings there for connecting to your database.

 

There is already code there for getting the data out of the table and updating it with what the user enters.

Link to comment
https://forums.phpfreaks.com/topic/221352-datas-to-site/#findComment-1145988
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.