PHPBuilder.com

Uploading files in database

belat — Sun, 22 Nov 2009 05:52:52 GMT

Need help!...I wanted to create a simple document management system and i want a sample codes for uploading text files .pdf files,/ .doc files and etc.. directly to the database..and also viewing all files that already uploaded and ready for download...
Hope you can help me....
thank you...

How to receive a ping

TheBeginner — Sun, 22 Nov 2009 05:32:42 GMT

Looking for some guide, code examples, on how to receive a ping from a blog. Not sending, but receiving, so I know when the blog is updated.

Any pointers to some guides?

Dynamic variable based on database record/recall - Help?

kelsofield — Sun, 22 Nov 2009 02:19:47 GMT

OK, ill keep this as short as I can..

I am trying to create a truly scalable environment for my users and so allow them to..
1. define a new option (dshop_options_name)
2. define option values (dshop_options_values)
separate tables in the database

this is to allow distinct values to be assigned and also in any combination.
ok, the script is in 2 parts. The form page and the result page

** form.php (using POST)

first I need to create dropdowns dynamically based on the options assigned to the product, and then run through the dshop_options_values table to get any values assigned to that option

//////////////////////////////////////////////////////////////////////////////////////////

$prod_prop_name=mysql_query("SELECT * FROM `dshop_options_name`");
$prod_prop_name_array= array();
while($data9=mysql_fetch_array($prod_prop_name)) {
$prod_prop_name_array[]=$data9;
}

foreach($prod_prop_name_array as $rowNum => $data9) {
$prod_prop_id=$data9[0];
$prod_prop_title=$data9[1];

$prod_prop_attri=mysql_query("SELECT * FROM `dshop_options_values` WHERE `prod_id`='".$selected_product."' AND `attri_name`='".$prod_prop_title."' ORDER BY `attri_value` ASC ");
$prod_prop_attri_array= array();
while($data10=mysql_fetch_array($prod_prop_attri)) {
$prod_prop_attri_array[]=$data10;
}
if(!$prod_prop_attri_array){}
else{
echo"

";
echo"$prod_prop_title\n";?>

";
}
}

//////////////////////////////////////////////////////////////////////////////////////////

ok, as you can see, I name the select the same as the option name, this is so I then use that name to again call the value in the next script.

** result.php

Ok, to reasemble the data posted, I again, do a few calls to get all the data

//////////////////////////////////////////////////////////////////////////////////////////

$prod_prop_name=mysql_query("SELECT * FROM `dshop_options_name`");
$prod_prop_name_array= array();
while($data9=mysql_fetch_array($prod_prop_name)) {
$prod_prop_name_array[]=$data9;
}
foreach($prod_prop_name_array as $rowNum => $data9){
$option_id=$data9[0];
$option_name=$data9[1];
$varnval=$_REQUEST[$option_name];
//echo"$varnval";
$results = array();

if(!$varnval | $varnval=="select"){}
else{
$results[] = $option_name."-".$varnval;
$optpricesum_query=mysql_query("SELECT * FROM `dshop_options_values` WHERE `attri_name`='".$option_name."' AND `attri_value`='".$varnval."'");
$optpricesum_result=mysql_fetch_array($optpricesum_query);
$optpricesum=$optpricesum_result[4];
}
if(!$varnval | $varnval=="select"){}
else{
for ($i=0;$i<=0;$i++){$options.=$results[$i]." | ";}
}
}

//////////////////////////////////////////////////////////////////////////////////////////

ok, down to the issue...

in the form.php, I am posting a value dynamically created, essentially by the admin user.

Lets say they created an option "Foo", and the values "foo1", "foo2", "foo3" (in the admin area)

form.php builds the selects by cross referencing the two tables, names the select and then populates it (nothing is pre-defined)

then the end user arrives at the form on the front end and on posting the form, they selected "foo3"

result.php at first has nothing to _REQUEST (remember we had nothing to define) until it rebuilds the possible vaiables that could have been posted.
I then used the foreach to run through all the option names stored with the hope of then creating dynamic variables...
$varnval=$_REQUEST[$option_name];

I then filter the names that have not been posted with..
if(!$varnval | $varnval=="select"){}

now...

Locally I get the value "foo3" no problem, but not on the web server. I then noticed that when using local php (Xampp) values dont even need to be defined $var=$_POST['var']; it will still work.... annoying when debugging!! BUT shows to apoint anyways, that the script will work.

I places an echo after the $varnval $_REQUEST, but nothing displays.

It seems to me that the $_REQUEST is not getting the variable, either because of the parse or because I have just missed something.

I have spent days working on this, trying many different ways but all threads lead nowhere.

Maybe I am trying the impossible, but I feel there has to be a way to create a set of variables from database records alone (NOT the other way around as most searches seem to produce)

This is my first post here, so i apologise if it is in the wrong place!

I thank you in advance for any help

Kelso

Php link exporter

The_L — Sun, 22 Nov 2009 00:19:18 GMT

Hello...can anyone around here help me make this script...i saw it somewhere it should be simple...so..
I'm some sort of newbie in this...what i wanna make is a php script that will put an input field on the page for url of some forum page...like:
http://www.phpbuilder.com/board/newt...newthread&f=10
and a button below it. When the button is pressed the script will search the source code of the page and export links that begins with "http://www.google.com/" (for example) and print it on the page one below the other...
Example:
http://img265.imageshack.us/img265/2237/32881531.jpg

Please answer as quick as you can i really need this.

Thanks ;)

calculate total in simple shopping cart

mayandy — Sat, 21 Nov 2009 22:30:19 GMT

Hi,

I'm doing a very simple shopping cart for my website and I'm quite rusty at PHP and have forgotten how to calculate the grand total in my shopping cart. I am able to calculate the subtotal in every row but now I need to get the total of all the rows put together.

Basically I have a mysql database which records all the products added to a cart during a session. In my basket.php file, I retrieve all the products for this particular session using a database query as follows:

$result = mysql_query( "SELECT * FROM Shopping_sessions WHERE Session_id='$ses_id'", $db);
if (!$result) {
echo("

Error performing query1: " . mysql_error() . "

");
exit();
}
?>

while($row = mysql_fetch_array($result)){
$Product_quantity = $row["Quantity"];
$Product_id = $row["Product_id"];
$result2 = mysql_query( "SELECT * FROM Products WHERE Product_id=$Product_id", $db);
if (!$result2) {
echo("

Error performing query1: " . mysql_error() . "

");
exit();
} // query
$row2 = mysql_fetch_array($result2);
$Product_name = $row2["Product_name"];
$Product_price = $row2["Product_price"];
$total1 = $Product_quantity * $Product_price;
$total2 = number_format($total1, 2);
echo "

";
}
?>

// SO FAR SO GOOD, HERE IS WHERE I NEED HELP

How do I calculate the combined value of $total2?

PhP Mysql query blog latest results

gwolff2005 — Sat, 21 Nov 2009 19:52:27 GMT

Hi guys,
I need your help. I have a blog and on a complete different page my homepage. Now what I want to do is that if I post a new post on my blog that the first 35 words of it appear in a layer, and then as well next to it the publish date.
I realized that I would need to create an mysql query which comes up with the last entry,
How can I do that? And then which is probably more complicated how can I tell mysql to give me just 35 words, or can I limit in any way the layer????
I am helpless! I would deeply appreciate if someone could help me!
Thanks!

Problems with Function + SQL

intervelopment — Sat, 21 Nov 2009 13:35:38 GMT

Hey All,

Im having a problem with a query and function im writing.

I have 2 database tables.

The first one, lets call it scores, has the columns email, correct, time, stamp and month

the second table, which is called users, has email, dispname, country

example of the first table
----------------------------------------------
| email | correct | time | stamp | month |
| test@test.com | 3 | 2 | 12345678 | 11 |
| test@test.com | 6 | 12 | 12345678 | 11 |
| testing@testing.com | 12 | 30 | 12345678 | 11 |
| testing@testing.com | 122 | 10 | 12345678 | 11 |
---------------------------------------------------------

So what i need to do is extract all the rows with the same email address and the same month, then add the correct fields and the time fields together so i am left with the following result
----------------------------------------------
| email | correct | time | stamp | month |
| test@test.com | 9 | 4 | 12345678 | 11 |
| testing@testing.com | 134 | 40 | 12345678 | 11 |
---------------------------------------------------------

and so on for every email address that happens to be inserted into the scores table.

Once that that has been completed, i need to find the top 10 people with the highest "correct" score and with the lowest "time" score, so they are ranked according to their score and time.

Once the top 10 have been found, i then need to search the 'users' table to find the dispname and country of each of the outputted top 10 users.

and finally i need to display the top 10 as:

rank - dispname - country - correct - time

If anyone could help me out .... i would be so greatful ... its doing my head in something bad hahah

Thanks

[RESOLVED] remove values from string

zzz — Sat, 21 Nov 2009 13:21:42 GMT

I have a string of numeric ids in a comma separated format

PHP Code:


		
			
$IDs = 23,34,55,42,33,41,22 ... 6767,4556;

I also have a table that may have some values that should be removed from the string of IDs. How do I do that?

register_globals

msnhockey — Sat, 21 Nov 2009 12:36:40 GMT

my old scripts which were designed for me about 4 years ago required registered_globals to be on.

I never knew this but in October my host got rid of this feature and my scripts do not work. It won't allow me to have a .htaccess file, but i can have a php.ini file

my host is Yahoo.

This only needs to be temp as all new scripts are in the works and should be done soon.

any help on what i might need to make this work is appriciated

Can someone modify this easy code please

TwistedLogix — Sat, 21 Nov 2009 11:11:20 GMT

(
'HERE',
'HERE',
'HERE',
'HERE',
'HERE',
'HERE',
);

$max = count($links)-1;
$rand = rand(0, $max);
?>

I need it to go in order from top down, then start again. Not random like it is.

Thanks.

Mail functionality from localhost to server

asparsh — Sat, 21 Nov 2009 08:43:32 GMT

Hi

I am facing problem of mail functionality.

When i tested mail functionality in my localhost it works fine but when i tried it on server it didn't work and also no error it displays.

So please give me solution if any changes required to setting mail functionality on server from local.

Thanks in advance

Anish Panchal
Software Outsourcing India
Web Development Company India

youtube integration

diabloroker — Sat, 21 Nov 2009 05:38:17 GMT

A friend of mine coded this but it suddenly stopped working.

After placing the youtube URL into the field, it displays the error, "The video details cannot be retrieved.". We like that the error detection works but why did it break?

Code:


include('application.php');

if ($myID == 0) goto('login.php');

_v('e;i:eid');



if ($mode == 'e')

{

   $main .= "



      The video cannot be found. 
 
 


      

    ";

}



if ($mode == 'delete')

{

   $qc = mysql_query("SELECT * FROM `video` WHERE `vid_id` = '$eid' AND `vid_useid` = '$myID'");

   if (mysql_num_rows($qc) == 0) goto('myvideos.php');

   $rc = mysql_fetch_assoc($qc);

   extract($rc);

   if ($vid_thumb != '') @unlink("$base_path/photo/video/$vid_thumb");

   $qd = mysql_query("DELETE FROM `video` WHERE `vid_id` = '$eid' AND `vid_useid` = '$myID' LIMIT 1");

   goto('myvideos.php');

}



// Add From Youtube



if ($mode == 'addys')

{

   _v('ttl,dsc,ytc,tags,thumb,v__id,catid');

   $now = date('Y-m-d H:i:s');

   $url = gen_url($ttl, 60, 'video', 'vid_url');

   $fname = '';



   if ($m_ytc != '') $hcode = $m_ytc;

   else $hcode = '';

   $tags = make_tags($tags, ' ');



   $qins = mysql_query("INSERT INTO `video`

     (`vid_useid`, `vid_catid`, `vid_title`, `vid_url`, `vid_desc`, `vid_code`, `vid_date`, `vid_enabled`, `vid_tags`, `vid_thumb`) VALUES 

     ('$myID', '$catid', '$m_ttl', '$url', '$m_dsc', '$hcode', '$now', '1', '$tags', '$fname')") or die(mysql_error());

   $last = mysql_insert_id();



   $yfile = "http://i2.ytimg.com/vi/$v__id/default.jpg";

   $fname = 'vt'.$last.'.'.'jpg';

   $thumb = new thumb($yfile, 'jpg', "photo/video/$fname");

   $thumb -> fixed(120, 90);

   if (!file_exists("photo/video/$fname")) $fname = '';

   $qupd = mysql_query("UPDATE `video` SET `vid_thumb` = '$fname' WHERE `vid_id` = '$last'");

   goto('myvideos.php');

}



if ($mode == 'adda')

{

   _v('vurl');

   $info = get_youtube_info($vurl);

   if ($info['error'] != '') { $mode = 'addy';  $e = 1; }

   else

   {

      extract($info);

      $cj = new jsValid('frmab');

      $cj->addf('ttl,catid');

      $js = $cj->show(1, 0);

      $main .= "

Item	Quantity	Item Price	Subtotal
$Product_name	$Product_quantity	$Product_price	$total2

Title:

Category:
".sel_db('catid', 'category', 'cat_id', 'cat_name', "`cat_type` = 'videos'", '', '- Select -', 'input', '', '238')."

Description:

Tags:

$js";

   }

}



if ($mode == 'edits')

{

   _v('ttl,catid,dsc,tags');

   $tags = make_tags($m_tags, ' ');

   $qupd = mysql_query("UPDATE `video` SET `vid_catid` = '$m_catid', `vid_title` = '$m_ttl', `vid_desc` = '$m_dsc', `vid_tags` = '$tags' WHERE `vid_id` = '$eid' AND `vid_useid` = '$myID'");

   goto("$base_url/myvideos.php");

}



if ($mode == 'edit')

{

   $qv = mysql_query("SELECT * FROM `video` WHERE `vid_id` = '$eid' AND `vid_useid` = '$myID'");

   if (mysql_num_rows($qv) == 0) goto("$base_url/myvideos.php");

   $rv = mysql_fetch_assoc($qv);

   extract($rv);

   $tags = unmake_tags($vid_tags, ',');

   

   $cj = new jsValid('frmab');

   $cj->addf('ttl,catid');

   $js = $cj->show(1, 0);

   $main .= tab('Edit Video', 600);

   $main .= "

       

        

        

        

        

        

       Title:

Category:
".sel_db('catid', 'category', 'cat_id', 'cat_name', "`cat_type` = 'videos'", $vid_catid, '', 'input', '', '238')."

Description:
$vid_desc
Tags: 

     
$js";

   $main .= tabe();

}





if ($mode == 'addy')

{

   $main = "



     

     


     Please enter the YOUTUBE URL of the video 


     eq: http://www.youtube.com/watch?v=B5i3mQhtNtg



       



           

       

   ";

   if ($e == 1) $main .= "

The video details cannot be retrieved.";

}





if ($mode == '')

{

   $main .= tab2('My Videos', "", 650);

   $main .= "";

   $qe = mysql_query("SELECT * FROM `video` WHERE `vid_useid` = '$myID' ORDER BY `vid_id` DESC");

   if (mysql_num_rows($qe) == 0) $main .= "
You have not added any videos yet.";

   else

   {

      $main .= "";

      while ($re = mysql_fetch_assoc($qe))

      {

         extract($re);

         $thumb = ' ';

         if ($vid_thumb != '') $thumb = "";

         $vid_desc = mktext($vid_desc, 250);

         $vlink = URL::video($vid_id, $vid_url);

         $main .= "

             

              

              

             ";

      }

      $main .= "$thumb 

                $vid_title

                $vid_desc


                

                     Edit Video  

                     Delete Video


              
 
";

   }

   $main .= "



                   

     
";

   $main .= tabe();

   $main .= "Easily import your favorite YouTube videos and share them with members. No uploading required. 
 Support 
";

}



$_vtemplate['main'] = $main;

$_vtemplate['right'] = $right;

$tp = new page($_vtemplate, 'template/default2.html');

Live preview of PHP?

Francoise — Sat, 21 Nov 2009 03:29:10 GMT

I'm trying to put together a small subscription-type website. It will have one main database-type program. Nothing very elaborate. For the content pages, I'm using HTML and CSS, of course. For the program, I expect to use PHP and MySQL. I'm teaching myself the latter -- as you might expect, I have my good days and my bad days. :)

I've been looking at editors and have researched them to the point of overload. Still, I expect that one could help me quite a lot. One of the features I would most like is a live preview of PHP pages. But . . . is that a realistic expectation?

I'm just not in a position right now to purchase anything like Dreamweaver. I've been looking seriously at Webuilder 2010.

Two questions, I guess:
1: Does anyone know of any reason why Webuilder 2010 would be a bad idea? (I'll use the trial version first, of course.)

2: Would I need to install a web server on my computer in order to have a preview of PHP pages? I really don't want to do that, I don't think. How much of a hassle would it be, though? to what extent would I really need it??

Any help would be much appreciated, and would probably help me stop going around in all these circles!

Need help displaying results of FOREACH in 4 columns

Mariniertje — Sat, 21 Nov 2009 00:09:46 GMT

Hi guys,

I need some help.:confused:

I have a .inc file for the queries and a separate php file to echo the results.

Now what I want to do is echo 2 results per line, but I can't find the right solution on the internet. Now I am quite new to this, so it might be just my inability to translate the given solutions to my situation.

What I want is that the following foreach:
"foreach($projectStatusEntries as $projectStatusEntry"
displays a total of 10 statusfields as below:

Header1 Value1 Header2 Value2
Header3 Value3 Header4 Value4
Header5 Value5 Header6 Value6
Header7 Value7 Header8 Value8
Header9 Value9 Header10 Value10

Ofcourse it also fine, if the first 5 results are listed in the left column and the other 5 are listed in the right column.

Can anyone help me to get this fixed??
I've been messing around myself for quite some time now, but can't get it to work.

Thanks in advance (i have attached the 2 relevant files below)

This is the .inc file

Quote:

require_once("domain.inc");

class ProjectStatusEntry extends Domain {
var $projectId;
var $projectStatusId;
var $statusId;

function ProjectStatusEntry($id=0) {
$this->id = $id;
}

}

class ProjectStatusEntryDAO extends DomainDAO {

public static function getAllProjectStatusEntries($projectId) {
$query = "SELECT * FROM project_status_entries WHERE project_id = ".$projectId;
return ProjectStatusEntryDAO::queryProjectStatusEntries($query);
}

public static function findProjectStatusEntryById($id) {
$query = "SELECT * FROM project_status_entries WHERE id=$id";
$results = mysql_query($query);
$line = mysql_fetch_array($results);
$projectStatusEntry = ProjectStatusEntryDAO::getProjectStatusEntryFromResultSet($line);

mysql_free_result($results);

return $projectStatusEntry;
}

public static function findProjectStatusEntryByProjectStatusId($projectId, $projectStatusId) {
$query = "SELECT * FROM project_status_entries WHERE project_id = $projectId AND project_status_id=.$projectStatusId";
$results = mysql_query($query);
$line = mysql_fetch_array($results);
$projectStatusEntry = ProjectStatusEntryDAO::getProjectStatusEntryFromResultSet($line);

mysql_free_result($results);

return $projectStatusEntry;
}

private static function queryProjectStatusEntries($query) {
$query = $query." ORDER BY id";
$results = mysql_query($query);
$projectStatusEntries = array();
if($results) {
while ($line = mysql_fetch_array($results)) {
$projectStatusEntry = ProjectStatusEntryDAO::getProjectStatusEntryFromResultSet($line);
$projectStatusEntries[$projectStatusEntry->id] = $projectStatusEntry;

}

mysql_free_result($results);
}

return $projectStatusEntries;
}

private static function queryProjectStatusEntry($query) {
$results = mysql_query($query);
$projectStatusEntry = null;
if($line = mysql_fetch_array($results)) {
$projectStatusEntry = ProjectStatusEntryDAO::getProjectStatusEntryFromResultSet($line);
}

mysql_free_result($results);

return $projectStatusEntry;
}

public static function getProjectStatusEntryFromResultSet($line) {
$projectStatusEntry = new ProjectStatusEntry();
$projectStatusEntry->id = $line["id"];
$projectStatusEntry->projectId = $line["project_id"];
$projectStatusEntry->projectStatusId = $line["project_status_id"];
$projectStatusEntry->statusId = $line["status_id"];

return $projectStatusEntry;
}

public static function saveProjectStatusEntry($projectStatusEntry) {
if($projectStatusEntry->id > 0) {
$statement = "UPDATE project_status_entries SET "
." project_id='".$projectStatusEntry->projectId."',"
." project_status_id='".$projectStatusEntry->projectStatusId."',"
." status_id='".$projectStatusEntry->statusId."'"
." WHERE id=".$projectStatusEntry->id;
}

else {
$statement = "INSERT INTO project_status_entries (project_id, project_status_id, status_id)"
." VALUES ("
."'$projectStatusEntry->projectId',"
."'$projectStatusEntry->projectStatusId',"
."'$projectStatusEntry->statusId'"
.")"
;
}

$result = mysql_query($statement);

DomainDAO::checkErrors($statement);
DomainDAO::updateId($projectStatusEntry);

return $projectStatusEntry;
}

}

?>

And this is (part of) the PHP file

Quote:

import_request_variables("gp", "p_");

$project = ProjectDAO::findById($p_id);
$benefits = BenefitDAO::getAllBenefits($p_id);
$resources = ResourceDAO::getAllResources();
$phases = PhaseDAO::getAllPhases();
$resourceTypes = ResourceDAO::getAllResourceTypes();
$projectResources = ProjectResourceDAO::getProjectResources($p_id);
$projectDependencies = ProjectDependencyDAO::getProjectDependencies($p_id);
$campaignDependencies = CampaignDependencyDAO::getAllCampaignDependencies($p_id);
$projectphases = ProjectPhaseDAO::getAllProjectPhases($p_id);
$deliverables = DeliverableDAO::getAllDeliverables($p_id);
$projectissues = ProjectIssueDAO::getAllProjectIssues($p_id);
$projectrisks = ProjectRiskDAO::getAllProjectRisks($p_id);
$projectBenefits = BenefitDAO::getProjectBenefits($p_id);
$businesspriorities = BusinessPriorityDAO::getAllBusinessPriorities($p_id);
$campaigns = CampaignDAO::getAllCampaigns();
$budgetFundingTypes = BudgetFundingTypeDAO::getAllBudgetFundingTypes();
$projectstatuses = ProjectStatusDAO::getAllProjectStatuses();
$statuses = StatusDAO::getAllStatuses();
$projectStatusEntries = ProjectStatusEntryDAO::getAllProjectStatusEntries($p_id);
$actualprojectphase = ProjectPhaseDAO::getActualProjectPhase($p_id);

?>

Project Dashboard

projectStatusId]->projectStatusName?>

if(isset($statuses[$projectStatusEntry->statusId])) {
echo $statuses[$projectStatusEntry->statusId]->statusName;
} else {
echo "status $projectStatusEntry->statusId onbekend";
}
?>

Need help with this articles display

bgbs — Fri, 20 Nov 2009 23:33:02 GMT

I need help to properly script this echo php script that displays recent articles from wordpress on static homepage. It's doing weird things.
First, it spits out the actual permalink
Secondly, after the permalink it spits out the Title but it disregards all the

/

tag styling, and the title is not a link, which it should be.

It displays the content correctly, but the title incorrectly. Because it should display a clickagle title with

/

styles rendered and the permalink is the actual link for the Title.

Please help.

PHP Code:

$recent = new WP_Query("cat=1&showposts=6"); $i = 0; while($recent->have_posts()) : $recent->the_post(); if($i == 0){ echo '; the_permalink(); echo '" rel="bookmark">'.the_title().' '; if (function_exists('the_content_limit')){ the_content_limit(195, "Read more »"); } }else{ echo '; the_permalink(); echo '" rel="bookmark">'.the_title().' '; the_content_limit(130, ""); echo ''; echo ''.the_time('F j, Y').' | ; the_permalink(); echo '" rel="bookmark">Read the story » '; echo ' '; } echo ' '; $i++; endwhile; ?>