PHP - Pulling Out My Hair!! On Php Form...

I am having trouble pulling a youtube embedded code from my database. Everything else comes out fine however it just doesnt pull anything out where the embedded code is supposed to be. Any ideas I put the code below. All help would be greatly appreciated, also if anyone is feeling generous and would like to help me some more please message me I have a couple other small questions.

Code: [Select]
<?php
//open database
$connect = mysql_connect("Database","name","password") or die("Not connected");
mysql_select_db("database") or die("could not log in");

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);

 // Get the page number, if none is set - it is 0
if( isset($_GET['page']) )
{ 
$page =$_GET['page']; 
}
else
{
$page  = 0;
}

$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
{
$link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table
$username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table
$messsage = mysql_result($result,$loops,"message");
$date = mysql_result($result,$loops,"date");
if ($pagelimit == 0)
{
$pagelimit == 1;
}
if ($pagelimit <= 15)
// echo stuff here
$loopz = $loops + 1;
 echo "&nbsp;&nbsp;&nbsp
 </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
  <tr>
<td>$loopz.&nbsp;
</br>
$message
</br>
Posted By: $username $date
</td>
  </tr>
</table></br><br>";
 $count++ ;
 $pagelimit++;
 $loops++;
}

if ( $page!=0 ) // Show 'Previous' link
{
$page--;
$prevpage = ($page +  1);
echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
$page++;
}
if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
{
$page++;
$nextpage = ($page + 1);
echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
}
 
?>

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?


<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

 = array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>


an example XML file would be:
Code: [Select]
<!--
 Automatically generated data from EVE-Central.com
-->
<!-- This is the new API :-) -->
−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

hello.

please could someone help me with this conundrum 

im trying to pull my content dynamically. im almost there but im stuck with some code.

so i have a layout with 3 columns and in each column i have a place holder. ph01, ph02, ph03

each page has its own id and depending on what the page id is i what to pull different elements into the 3 placeholders.

so for this code in the database i have the following:


table name: placeholders
pages_id = page id
ph_number = placeholder number
contElements_id = element ids

id    pages_id   ph_number      contElements_id
1     1              1                    1, 2, 3                         
2     1              2                    4, 5, 6                 
3     1              3                    7, 8, 9                         


table name: contelements
name = name of the element

id    name   
1    E1
2    E2
3    E3
4    E4
5    E5
6    E6
7    E7
8    E8
9    E9


SO, page_ID=1 has 3 placeholders and they should show:
ph01 should display = E1, E2, E3
ph02 should display = E4, E5, E6
ph03 should display = E7, E8, E9


this is the code im trying to put together.

on the page im using this include function in the left, center and right columns.

Code: [Select]

$phNo = "1";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "2";
echo include_admin_contElements($phNo, $pageID); 

$phNo = "3";
echo include_admin_contElements($phNo, $pageID); 



now this is where the problem is.... i think
in the function file i have this but its a mess..

Code: [Select]
function  include_admin_contElements($phNo, $pageID){


$PH = Placeholders::find_all();

foreach ($PH as $PHs){
$PHid = $PHs->id;
$PHpid = $PHs->pages_id;
$PHce = $PHs->contElelments_id;
$PHn = $PHs->ph_number;

if($pageID == $PHpid){

$CE = Contelements::find_by_PHce($PHce);

foreach ($CE as $CEs){
echo $CEid = $CEs->id;
echo $CEname = $CEs->name;
}
}
}
}


- so the idea is i get $phNo, $pageID from the page,
- then find all the placeholders in the database Quote

Placeholders::find_all();

- then if the $pageID is the same as the $PHpid in the placeholder database Quote

if($pageID == $PHpid){

get the content elents for that page.
- then i want to get the elements that belong to that page using Quote

Contelements::find_by_PHce($PHce);


but that does not work

Code: [Select]
                public static function find_by_PHce($PHce=0){
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$PHce."";
$result_array = self::find_by_sql($sql);
return $result_array;
                }


anyway... im stuck. this code doesn't even seperate the 3 different placeholders. it needs a more experienced eye..

its a mess

please help

thanks

ricky

Code: [Select]
id: 20 Reason: this is a test
id: 21 Reason: Tests
id: 22 Reason: Lolcatz
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: 36 Reason: Test
As you can see on the 2nd code box there are id's 20,21,22 and 36 in the database the rest are not active in the database.

i am using using Code: [Select]
for to pull out the id that starts with the lowest value in the database, and only have it run until it gets to the maximum value.
Code: [Select]
for ($id=$set_min; $set_max<=7; $id++)
{
                // $id=$set_min is pulling the smallest value and $set_max is pulling the maximum value so it stops  after it gets to 36
$query=mysql_query("SELECT * FROM posted WHERE id = $id");
$query_row=mysql_fetch_array($query);

$reason = $query_row[reason];
$pulled_id = $query_row[id];
$pulled_pic22 = $query_row[picture];
$href_pull = "<a href=" . "search.php?id=" . "$id" .">";

echo "<td>" . $href_pull . "<img src=$pulled_pic22 height=200 width=150 />" . "</td>";
}

how would i make it so i do not pull the values 23-35 which are not in the active database.

Example: http://dev.hackmuch.com/of-the-day/search.php?id=36

Code: [Select]
<?php
ob_start();
session_start();
$pagerank=2; 
if ($rank < $pagerank){
header('Location:main.php?id=lowrank.php');
}
else{
$name1 = $_GET["name"];
$type2 = $_GET['type'];

Echo "Your seach for ".$name1." gave the following results: ";

$records_per_page = 15;
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM systems WHERE '$type2' LIKE '%$name1%'"), 0) or die(mysql_error());
$page_count = ceil($total / $records_per_page);
Echo $total." Records Found";
echo "<table border=0>";


$page = 1;
if (isset($_GET['page']) && $_GET['page'] >= 1 && $_GET['page'] <= $page_count) {
    $page = (int)$_GET['page'];
}
$skip = ($page - 1) * $records_per_page;

$result = mysql_query("SELECT * FROM systems WHERE $type2 LIKE '%$name1%' ORDER BY Security DESC LIMIT $skip, $records_per_page") or die(mysql_error()); 

echo "<table border=1>";
echo "<td>System Name</td><td>Security</td><td>Class</td>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td valign =top>".$row['System Name']."</td>";
echo "<td valign =top>".round($row['Security'],1)."</td>";
echo "<td valign =top>".$row['System Type']."</td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
for ($i = 1; $i <= $page_count; ++$i) {
    echo '<a href="main.php?id=' . $_GET['id'] .'&name='.$name1.'&type='.$type1. '&page=' . $i . '">'
        . $i . '</a> ';
}
}
?>
The above code takes data entered in a form and is suppose to show the matching results, but no records are showing, it works when I replace the $name1 and $type2 with the actual values, any ideas?

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

Hi the

I have a PDF form that generates an XFDF file (form field valies in XML form) and I am passing it to PHP for processing. I am having trouble pulling a specific value from the XML block because of the way that the XML data is generated and organized. Please see a sample of the XML block below:

'test.xml' file:
Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<xfdf xmlns="http://ns.adobe.com/xfdf/" xml:space="preserve">
<annots/><fields>

<field name="Non">
<value>Off</value>
</field>

<field name="PayRequest">
<value>XYZ</value>
</field>


From the above XML snip it, once it's sent to PHP, I would like to somehow reference the "PayRequest" field value and retrieve the value "XYZ" and assign it to a variable. I have been kicking around some code that I thought should work, but doesn't appear to. If anyone could offer any insight to get it working that would be greatly appreciated.

PHP Code:
Code: [Select]
$prq_ret = simplexml_load_file('test.xml');
foreach($prq_ret->xpath("//field[@name='PayRequest']") as $item) {
 
 $row = simplexml_load_string($item->asXML());
 //print $item->value;
 print $row;
 }

So I am trying to pull the first image that was uploaded to the database.  But for some reason this only works part of the time and if you delete any image in the database it seems to just pic another another random one.  Any suggestions?

<?php
{
$row = getad();
header("Content-type: image/jpeg");
$pic = ($row['image']);
print "$pic";
}

function getad()
{
$ads = array();
mysql_connect("localhost","******","********");
mysql_select_db("users");


$query  = "SELECT image FROM image_ads";
$result = mysql_query($query);

$i = 0;

while($row = mysql_fetch_array($result))
{
  $i ++;
  $ads[$i] = $row;
}

$id = date("z");
$index = $id % $i + 1;

mysql_close();
return $ads[$index];
}

?>

Hi Everyone,

Let me start by saying i need any help put to me in dumb person terms, i know nothing but the bare bare basics of most web coding let alone php, enough to make very simple pages and forms.

On to my problem... What i am aiming for us a single web page which takes a list of names from a file, generates a 2 column table, makes the second column into boxes where data can be entered in to, then i want it to be submitted to email in the form of a html email, the email doesn't need any fancy formatting or colour scheme, just want the the table of names and entered information sent

Now this is how far i have got (with help obviously):
Code: [Select]
<body>
<h1 align="center"><u>7B Praise Points</u></h1>
<div id="contact-wrapper">
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" id="contactform">
<?php 

$file = file("7B.txt"); 
$count = 0;
print "<table cellspacing='2'>\n 
<tr><td>Student Name</td><td>Number of Praise Points</td></tr>\n"; 

foreach($file as $line){ 
$line = trim($line); 
$split = split("\t",$line); 
print "<tr>\n<td>$split[0]<input name='name$count' type='hidden' value='$split[0]'></td>\n<td>$split[1]<input name='points$count' type='hidden' value='$split[1]'></td>\n</tr>"; 
$count++;
} 

print "</table>"; 

?>
  <p>
    <input name="submit" type="submit" value="Submit">
  </p>
</form>
</div>
</body>

So i've got it generating the table from the list of names in the file called "7B.txt" all i need to be able to do is making the second column in to a data entry box and generating the email
Starting with the first problem of making the second column in to data entry boxes how do i go about doing this?

Thanks

Hi. I am trying to figure out the best approach to pull THE most recent record for display, and ONLY the most recent one. I am really not sure how to go about doing this. Ive just started into stored procedure programming and php, but havent found anything yet on this one. Thanks.

I'm not sure I know how to explain what I want to allow you to understand. I'm working on a ventilation app that has different fan sizes. In the input php file I have a dropdown list that's populated by what's in the database. I'd like a results page that lists the fan size and number of each size and the cfm's each fan kicks out. the problem is that I don't know how to do anything with it other than hard code it.

What I'd like, is for it to also pull all of the fan sizes and list them, that way the database can be fluid.   This is the code I'd like to replace with some sort of loop.    //9" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=9", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity9 = $row['capacity'];

              };
              //---------------------------------------------------------
              //10" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=10", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity10 = $row['capacity'];

              };


                        //---------------------------------------------------------
              //14" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=14", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity14 = $row['capacity'];

              };


                        //---------------------------------------------------------
              //16" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=16", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity16 = $row['capacity'];

              };

              //---------------------------------------------------------
              //18" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=18", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity18 = $row['capacity'];

              }
              //---------------------------------------------------------
              //20" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=20", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity20 = $row['capacity'];

              };
              //---------------------------------------------------------
              //24" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=24", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity24 = $row['capacity'];

              };
              //---------------------------------------------------------
              //36" fan
              $results = mysql_query("SELECT * FROM fan WHERE size=36", $link);
              while ($row = mysql_fetch_array($results)) {
                $capacity36 = $row['capacity'];

              };

This topic has been moved to Other Libraries and Frameworks.

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

I am creating a music blogging site however the main page will only show one video the code is below anyone have any ideas?

"
<?php
            //open database
            $connect = mysql_connect("******","username","password") or die("Not connected");
            mysql_select_db("collegebooxboox") or die("could not log in");
   
            $query = "SELECT * FROM boox ORDER BY date DESC";
            $result = mysql_query($query);
            
             // Get the page number, if none is set - it is 0
            if( isset($_GET['page']) )
            {
               $page =$_GET['page'];
            }
            else
            {
               $page  = 0;
            }   
            
$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
   {
   $link = mysql_result($result,$loops,"link"); // get result from the 'Title' field in the table
   $username = mysql_result($result,$loops,"username"); // get result from the 'Content' field in the table
   $messsage = mysql_result($result,$loops,"message");
   $date = mysql_result($result,$loops,"date");
   if ($pagelimit == 0)
      {
      $pagelimit == 1;   
      }
   if ($pagelimit <= 15)
   // echo stuff here
      $loopz = $loops + 1;
       echo "&nbsp;&nbsp;&nbsp
          </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
                 <tr>
                  <td>$loopz.&nbsp;$link   
                            </br>
                  $message
                  </br>
                  Posted By: $username $date
                  </td>
                 </tr>
               </table></br><br>";
          $count++ ;
          $pagelimit++;
          $loops++;
   }
      
      if ( $page!=0 ) // Show 'Previous' link
      {
         $page--;
         $prevpage = ($page +  1);
         echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
         $page++;
      }
      if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
      {
         $page++;
         $nextpage = ($page + 1);
         echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
      }
   
         ?>
"

This is working just fine on a single page. It gives me all information I need. But I want to send an email with it. Although I couldn`t figure out how can I do it

Code: [Select]
$db = new mysqli('localhost', 'root', '', 'panel');
$sql = "select * from detail";
$read = $db->query($sql);

<table style="border:0;width:600px;">
  <tr>
    <td width="50px">Who</td>
    <td width="150px">Time</td>
    <td width="300px">What</td>
  </tr>
<?php 
while($wr = mysqli_fetch_array($read)) {
 echo' <tr>
    <td>'.$wr['Who'].'</td>
    <td>'.$wr['Time'].'</td>
    <td>'.$wr['What'].'</td>
  </tr> ';
}


?>