PHP - Trouble With Database Query In Php

Hey guys I am trying to read my xml file and itterate through the list. I am having trouble. 

<?xml version="1.0" encoding="UTF-8"?>
<stock>

	<itemPlace id="1">
		<name>null</name>
		<image>null</image>
		<wholeSale>44</wholeSale>
		<retailPrice>null</retailPrice>
		<quantity>null</quantity>
		<location>null</location>
		<color>null</color>
		<size>null</size>
		<weight>null</weight>
		<description>null</description>
		<itemType>null</itemType>
		<date>null</date>
	</itemPlace>
	<itemPlace id="2">
		<name>null</name>
		<image>null</image>
		<wholeSale>55</wholeSale>
		<retailPrice>null</retailPrice>
		<quantity>null</quantity>
		<location>null</location>
		<color>null</color>
		<size>null</size>
		<weight>null</weight>
		<description>null</description>
		<itemType>null</itemType>
		<date>null</date>
	</itemPlace>
</stock>

<?php 
		$xml = simplexml_load_file('stock.xml');
		foreach ($xml->xpath('itemPlace') as $eq) 
		{
			echo "<p><a class='inline' href=\"#inline_content\"> {$eq->name}</a></p>";
		    echo '<br>';
		    
		  	echo " <div style='display:none'>";
		   	echo " <div id='inline_content' style='padding:10px; background:#fff;'>";
		   	echo " <p>";
		    	
			echo "  <strong>{$eq->wholeSale}</strong>";
                        echo "</div></div>";

Is there a way I can look up the object through the itemPlace id="#" and call out the parameters of the item? Like the name price, etc?   I know how to mySQL query but not XML, and this is a project that needs to use xml... FML..I have been looking for a few hours so any help would be appreciated!  

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313679.0

Never worked with GoDaddy before... Can't get my config script to connect to the database.  Here's my code (I'm sure all the login info is correct, except maybe the host name but I copied that from GoDaddy too...)
<?php
ob_start();
// MySQL connection settings
$db_host = "anakdesigns.db.2089823.hostedresource.com";
$db_user = "********";
$db_pass = "********";
$db_name = "********";
// Connect to the database
$con = mysql_connect($db_host, $db_user, $db_pass) or die("Cannot connect to DB");
mysql_select_db($db_name) or die("Error accessing DB");
?>

http://www.anakdesigns.com/dev

hello
I want query from one table and insert in another table on another domain .
each database on one domain name.
for example http://www.site.com $con1
and http://www.site1.com $con.

can anyone help me?
my code is :
<?php



$dbuser1 = "insert in this database";
$dbpass1 = "insert in this database";
$dbhost1 = "localhost";
$dbname1 = "insert in this database";

// Connecting, selecting database

$con1 = mysql_connect($dbhost1, $dbuser1, $dbpass1)
   or die('Could not connect: ' . mysql_error());



mysql_select_db($dbname1) or die('Could not select database');


$dbuser = "query from this database";
$dbpass = "query from this database";
$dbhost = "localhost";
$dbname = "query from this database";

// Connecting, selecting database

$con = mysql_connect($dbhost, $dbuser, $dbpass)
   or die('Could not connect: ' . mysql_error());

mysql_select_db($dbname) or die('Could not select database');

//query from database
$query = mysql_query("SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1");
    while($row=mysql_fetch_array($query)){
$result=$row[0];
$text=$row[1]."</br>Size:(".$row[4].")";
$alias=$row[2];
$link = '<a target="_blank" href='.$row[3].'>Download</a>';
echo $result;
}  
//insert into  database
mysql_query("SET NAMES 'utf8'", $con1); 
$query3= " INSERT INTO `jos_content`
 (`id`,
  `title`,
   `alias`,
    `) VALUES 
                        (NULL, 
                        '".$result."', 
                        '".$alias."', 
                       '')";
if (!mysql_query($query3,$con1))
  {
  die('Error: text add' . mysql_error());
  }


            mysql_close($con);
                        mysql_close($con1);
             


?>

Hello,

I have this code running and I keep getting
"Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/.../search.php on line 10

Any help would be appreciated

   <table><tr><td>ID</td><td>SCHOOL NAME</td><td>TEACHER NAME</td></tr>
<?php 
  if(isset($_POST['submit'])){ 
  if(isset($_GET['go'])){ 
  if(preg_match("/^[  a-zA-Z]+/", $_POST['name'])){ 
  $name=$_POST['name']; 
  $db=mysql_connect  ("", "", "") or die ('I cannot connect to the database  because: ' . mysql_error()); 
  $mydb=mysql_select_db(""); 
  $sql="SELECT  ID, school_name, teacher_name FROM Project_Registration WHERE school_name LIKE '%" . $name .  "%'"; 
  $result=mysql_query($sql); 
  while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ 
      echo 
         "<tr><td> {$row['ID']}                           </td>" .
         "<td>     {$row['school_name']}             </td>" .
         "<td>     {$row['teacher_name']}    </td></tr>";}}}}
?> 
    </table>

First time poster, and very amateur php coder.  I am trying to delete items that in a list using ajax.  I can't figure out what I am doing wrong.  Any help would be greatly appreciated!

 

Here is a snippet of my javascript...

    $('.delete-item').click(function() {
        var itemID = $(this).data('itemID');
        var clear = 1;
        $.ajax({
            url: 'includes/delete-item.php',
            method: 'POST',
            data: {
                itemid:itemID,
                clear:1
            },
            success: function(data) {
                $('.content').load('includes/lists.php')
            }
        })
    })

 

and here is the relevant php...

$item = $_POST['itemid'];
$clear = $_POST['clear'];
$clearSQL = "DELETE FROM `List_Items` WHERE `item_ID` = $item";
$cleared = mysqli_query($connect, $clearSQL);

Hey guys, I have made an admin page for a game Im working on to quickly allow me to update many aspects of the game. My form is sending the correct data because i can echo the $_post but for some reason it isnt updating my database. I just get a blank white page. Could anyone see what i have done wrong. Thanks

Code: [Select]
<?php
    require($DOCUMENT_ROOT . "/game/includes/connection.php");
    require($DOCUMENT_ROOT . "/game/includes/settings.php");
?>

<?php

    $name = $_POST['admin_name'];
    $img = $_POST['admin_img'];
    $current_hp = $_POST['admin_current_hp'];
    $max_hp = $_POST['admin_max_hp'];
    $current_energy = $_POST['admin_current_energy'];
    $max_energy = $_POST['admin_max_energy'];
    $level = $_POST['admin_level'];
    $exp_total = $_POST['admin_exp_total'];
    $exp = $_POST['admin_exp'];
    $exp_level = $_POST['admin_exp_level'];
    $pos_x = $_POST['admin_pos_x'];
    $pos_y = $_POST['admin_pos_y'];
    $potion = $_POST['admin_potion'];
    $ether = $_POST['admin_ether'];
    $elixir = $_POST['admin_elixir'];
    $zenni = $_POST['admin_zenni'];
    $sector = $_POST['admin_sector'];
    $battle = $_POST['admin_battle'];
          
?>


<?php

    $sql_1 = "UPDATE game_character SET name='$name', img='$img', current_hp='$current_hp', max_hp='$max_hp', current energy='$current_energy', max_energy='$max_energy', level='$level', exp_total='$exp_total', exp='$exp', exp_level='$exp_level', pos_x='$pos_x', pos_y='$pos_y', potion='$potion', ether='$ether', elixir='$elixir', zenni='$zenni' WHERE id=1";
    $sql_2 = "UPDATE game_status SET sector='$sector', battle='$battle' WHERE id=1";
    $statement_1 = $dbh->prepare($sql_1); 
    $statement_2 = $dbh->prepare($sql_2); 
    $statement_1->execute();
    $statement_2->execute();
       
?>

<SCRIPT LANGUAGE="JavaScript">
redirTime = "1";
redirURL = "<?php echo $r_admin ?>";
function redirTimer() { self.setTimeout("self.location.href = redirURL;",redirTime); }
</script>
<BODY onLoad="redirTimer()">

I have a textbox which i want users to be able to search the database for zipcodes, I can't seem to make it work my IDE doesn't show any errors but when I test the code everything goes blank, the mysql credentials are all correct the code is, any suggestions would help

<form action="index.php" method="post">
   <label for="search2" style="color:#FFF;background-color:#0A016D"><b>Search Homes by Zipcode</b></label><br>
 zipcode:  <input type="text" name="zipcode"><br>
   <button type="submit" name="submit" value="submit"/>
   </form>
<?php
    $zipcode= @$_post['zipcode'];
    require("myconn.php");
    mysql_select_db("phplogin")or die(mysql_error());
   $sql= mysql_query("SELECT * FROM users WHERE zipcode='$zipcode' ");
   $numrow= mysql_num_rows($sql);
   while($row= mysql_fetch_assoc($sql))
   {
    echo "zipcode: ".$row['zipcode']." city :".$row['city']."<br/>";
      
   }
   ?>

Hello. Many thanks for your help.

I am writing a PHP/MySQL dating-site and have hit a programming impass.

I have a database full of members and a search form consisting of checkboxes.

So to search, a member ticks say...gender: female; age: 21,22,23,24,25,26; height: 5'4",5'5",5'6",5'7"; county: cornwall,devon,somerset

How can a run a check on the database selecting all entries that fall into the selected criteria. For example a 23 year old female of 5'5" living in Cornwall and a 26 year old female of 5'4" living in Somerset?

The key index of my database is 'id' and the fields a age,height,county
The names of the form checkboxes a
Gender: male, female; Age: 21,22,23,24 etc; Height: 5_4,5_5,5_6 etc; county: cornwall,devon etc

I need help trying to figure out why my form won't write the database it is supposed to - i checked the connection to the database and it works and the user seems to have permission to edit database - the error I get is "Error: User not added to database." from "register.php". Can someone please look over my code and see if the problem is coming from somewhere within?   I created a connection file (connect.php)

<?
session_start();
// Replace the variable values below
// with your specific database information.
$host = "localhost";
$user = "master";
$pass = "hidden";
$db   = "user";
// This part sets up the connection to the 
// database (so you don't need to reopen the connection
// again on the same page).
$ms = mysql_pconnect($host, $user, $pass);
if ( !$ms )
{
echo "Error connecting to database.\n";
}
// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>

Then there is the php script (register.php):

<?php
session_start();
// connect.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
	require('connect.php');
    // If the values are posted, insert them into the database.
    if (isset($_POST['email']) && isset($_POST['password'])){
        $firstname = $_POST['firstname'];
        $lastname = $_POST['lastname'];
		$email = $_POST['email'];
        $password = $_POST['password'];
 
        $query = "INSERT INTO `member` (firstname, lastname, email, password) VALUES ('$firstname', '$lastname', '$email' '$password')";
        $result = mysql_query($query);
        if ( !mysql_insert_id() )
  {
  die("Error: User not added to database.");
  }
 else
  {
  // Redirect to thank you page.
  Header("Location: surveylanding_no-sidebar.html");
  }
    }
    ?>

Here is the HTML form:

<form name="htmlform" method="post" class="form" action="register.php"> 
   
    <p class="firstname"> 
        <input type="text" name="firstname" id="firstname" /> 
        <label for="firstname">First Name</label> 
    </p> 
     
    <p class="lastname"> 
        <input type="text" name="lastname" id="lastname" /> 
        <label for="lastname">Last Name</label> 
    </p> 
     
    <p class="email"> 
        <input type="email" name="email" id="email" /> 
        <label for="email">Email</label>
    </p> 
     <p class="Password"> 
        <input type="password" name="password" id="password" /> 
        <label for="password">Password</label> 
    </p> 
       
    <p class="submit"> 
        <input type="submit" value="Register"/> 
    </p> 
   
</form>

Hello Everyone,

I am pretty new to the forums and was curious if i could get some help here. Basically, in a nutshell, i have PayPal integrated into my website. I will use this to collect money from clients. when a client logs into his/her account they see their balance (which is pulled from the database to correspond with the user that's logged-in). Now, everytime a payment is submitted a notify_url is contacted after payment has been verified, that notify_url is the code written below. What I am trying to execute here is when this notify_url is called the current balance is reduced from the amount paid through paypal.

In the second If condition, you will see that the word success is being entered into the paypal.txt file, which is working perfectly fine. Now, you will also see the variable


$update_balance;  


which is suppose to update the original balance with the balance paid through PayPal

BUT IT'S NOT!! WHY?? LOL

Thank You in advance!


<?php
ob_start();

session_start();

include_once ('/home/rdewebde/public_html/includes/paypal.php');

$myPaypal = new Paypal();

$myPaypal->ipnLog = TRUE;
        
include_once "/home/rdewebde/public_html/includes/_config.php";

$username = "".$_SESSION['username']."";

$users_data = mysql_query("SELECT * FROM `members` WHERE `username`='".$username."'");

$user_info = mysql_fetch_array($users_data);

$current_amount = $user_info['balance'];
     
$deduct_amount = $myPaypal->ipnData['payment_gross'];

$new_amount = $current_amount - $deduct_amount;

$update_balance = mysql_query("UPDATE `members` SET `balance` = '$new_amount' WHERE `username` = '".$username."'");

if ($myPaypal->validateIpn()) {

    if ($myPaypal->ipnData['payment_status'] == 'Completed') {

         $update_balance;  

         file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', 'SUCCESS');

            

    }

else { file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt', "FAILURE\n\n" . $myPaypal->ipnData); }

   }

?> 

I am very new to php and am trying to create a simple application that uploads a PDF file to a database. I have one field for the Volume Number and on file field for the PDF to be uploaded. My issue is i can't get the PDF to upload or insert the name of the pdf (eg volume1.pdf) into the data base.

I would also like to point out that I know i have a low post count, but i only seek help when i truly need it and have exhausted all other resources...

Here is what i have, please go easy on me this is my first round at php:
Code: [Select]
<?php
if(isset($_POST['submit'])){
$vol_num = $_POST['vol_num'];
$pdf = $_FILES['pdf']['name'];
$path = '../pdf/'.$_FILES['pdf']['name'];
move_uploaded_file($_FILES["pdf"]["tmp_name"], $path);
        mysql_query("INSERT INTO volumes set vol_num='$vol_num', vol_link='$pdf'") or die (mysql_error());
echo "<script>location.href='add_volume.php'</script>";
}
?>
what am i doing wrong here?

Thanks in advance

Hello All,

This is my first post.  I have tried getting some help on the PHP channel in IRC but people there always point you to a reference page.  I need actual help and example with my code.  Possible someone to show/highlight what I did wrong and then show me the correction.

First, my code is supposed to create a form.  The form (server_select.php) is a pre-populated form that has a drop down box that queries a table from the database.  The form then sends the info to get_disk.php page to post the results of the users selected query options.  Here is how it's supposed to work:

User goes to webpage.tld/index.php.
They click on "Select Server Details" page (server_select.php).
A form gets loaded
User then has to select from the drop down menu's: server, date range from and to and then hit submit
User gets sent to get_disk.php

The get_disk.php is supposed to show them all of the following info from their selected server and date range:
hostname, device name, device size, current usage, remaining size, percentage used, mount point, time stamp.

All of that is supposed to show when they user hits submit.

Issue:

My submit page seems to work but my "get_disk.php" page doesn't seem to know how to query the database correctly.  Attached are both of my files.  Can someone tell me why my query on the get_disk.php page is not working and how I get it to display my requested info, please?

Is it possible to query my database and display results from a varible that changes each time from a users search?

I know how to get results from a variable like a field name and display them but i was wondering if for example; the user searches for criteria and gets the result there looking for (postcode); they then click that result in the browser and are redirected to another page with lots more information.(company_name and location).

There result from the original search would be different each time but i would like to know if i could take that result and display all other fields in my table associated with that one result.

***Freelistings***
id company_name location      postcode

1 Dave's Storage  London        PO Box1

2 Steve's Trucks   Birmingham WS12 3

3 Sue's Tyres       Manchester  M14 6

4 Paul's               Birmingham WS11 7

***Basicpackge***
id company_name location      postcode

1 Storage Ltd       London       LN12 5TW

2 Fran's Grit        Birmingham WS5 37

3 Raj Walls          Manchester  M14 60

4 Paul's Light's     Birmingham WS12 17

***Premiumuser***
id company_name location      postcode

1 Name1               Location1    PC1

2 Name2               Location2    PC2

3 Name3               Location3    PC3

4 Name4               Location4    PC4

I'm sure this can be done, i'm just getting stuck on how to treat the user's search result. Currently it's called '%$var%'.

Can i use:

$query = "(SELECT company_name, location FROM freelistings
             WHERE company_name, location like '%$var%')         
         UNION           
               (SELECT company_name, location FROM basicpackage             
            WHERE company_name, location like '%$var%')         
         UNION           
        (SELECT company_name, location FROM premiumuser             
            WHERE company_name, location  like '%$var%')         
        ORDER BY postcode"; 

So that would be looking at all three tables, getting the details from each field that is associated with that (result) postcode. I hope i have given enough information to explain my problem i'm having. for me quite a tough one? any help would be appreciated, thanks guys in advance!

Hello All,

Trying to write a log-in script using PDO.  But have one question.  With the below when I query the database and even run a print_r on $RES nothing is outputted?

Any ideas?

Thanks



if (isset($_POST['Submit']))
{
 $email  = $_POST['email'];
 $password  = $_POST['password'];
 
 $QUERY = $dbc->prepare("SELECT email, password FROM tbl WHERE email = :email");
 $QUERY->bindParam(':email', $email);
 $QUERY->execute();
 $RES = $QUERY->fetchColumn();

 echo "Email is:".$RES['email'];
 echo "PW is: ".$RES['password'];
 print_r($RES);
}