PHPBuilder.com http://www.phpbuilder.com/board This is a discussion forum for discussing all aspects of the serverside scripting language PHP en Sun, 22 Nov 2009 13:01:00 GMT vBulletin 60 http://www.phpbuilder.com/board/images/misc/rss.jpg PHPBuilder.com http://www.phpbuilder.com/board Search before Adding (PHP/Mysql) http://www.phpbuilder.com/board/showthread.php?t=10369712&goto=newpost Sun, 22 Nov 2009 11:32:48 GMT --------- Now im sure i haven't missed any ; because i have looked over it, and i have viewed tutorials online that use this code almost EXACT (Just changed entires etc). But here is the error: Code: --------- Parse error: syntax error, unexpected T_STRING in /hosted/subs/ulmb.com/t/h/###/public_html/### on line 19 --------- Eh, im probably being an idiot again lols. I need to learn errors asap. But thanks.]]> Hi.
Well i've been trying to make a little script for a mates website.
What it does, you type something into a text field, it searches the database for the value in that textfield, if there is an entry already like that in the database, it will not add it, if there isn't, it will add into the database.
Kinda like a Registration form (But its not, same principle)

Here is my code (Some bits edited out)

Code:
<?php

$dbhost = "mysql"; //Database Host
$dbuser = "###"; //Database User
$dbpass = "###"; //Database Password
$dbname = "###"; //Database Name

//connect
$db = mysql_pconnect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

        $searchdb="SELECT * FROM ### WHERE keywords ='$_POST[###]';
        $result=mysql_query($searchdb);
        $num=mysql_num_rows($result);
       
        if ($num = 0){
        echo "No results found";
        }else{
echo "Found results";
}

?>
Now im sure i haven't missed any ; because i have looked over it, and i have viewed tutorials online that use this code almost EXACT (Just changed entires etc).

But here is the error:

Code:
Parse error: syntax error, unexpected T_STRING in /hosted/subs/ulmb.com/t/h/###/public_html/### on line 19
Eh, im probably being an idiot again lols. I need to learn errors asap.
But thanks. ]]> Newbies thatshanekid http://www.phpbuilder.com/board/showthread.php?t=10369712 Email confirmation form. http://www.phpbuilder.com/board/showthread.php?t=10369711&goto=newpost Sun, 22 Nov 2009 08:14:42 GMT Is this possible.

Is it possible to create a new file each time someone submits a form that changes the URL so the previous user can't revisit the link?

So for instance

User submits form. Some script then copies that same form and complete page template and all, then changes the pages file name.

So

User 1 visits form1.php - submits the form, then on submission a script then creates a new page named form2.php deleting form1.php and uploads somehow to the webserver.

Or even creating a random number so people can't cheat and cycle through simple numbers if they figure it out.

Ill pay anyone to figure this out. Or suggest another way. ]]> Newbies TwistedLogix http://www.phpbuilder.com/board/showthread.php?t=10369711 Uploading files in database http://www.phpbuilder.com/board/showthread.php?t=10369710&goto=newpost 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... 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... ]]> Coding belat http://www.phpbuilder.com/board/showthread.php?t=10369710 How to receive a ping http://www.phpbuilder.com/board/showthread.php?t=10369709&goto=newpost 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? 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? ]]> General Help TheBeginner http://www.phpbuilder.com/board/showthread.php?t=10369709 Dynamic variable based on database record/recall - Help? http://www.phpbuilder.com/board/showthread.php?t=10369708&goto=newpost Sun, 22 Nov 2009 02:19:47 GMT $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]]> 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"<div class='left'>";
echo"$prod_prop_title\n";?>
<select name='<? echo $prod_prop_title?>'>
<option value="select">Select</option>
<?php
foreach($prod_prop_attri_array as $rowNum => $data10){
$itemname=$data10[2];
$itemvalue=$data10[3];
$itemprice=$data10[4];
if($itemprice<="0"){
echo"<option value='".$itemvalue."'>".$itemvalue."</option>\n";
}
else{
echo"<option value='".$itemvalue."'>".$itemvalue."&nbsp;-&nbsp;".$currency_type.$itemprice."</option>\n";
}
}
echo"</select></br></br></div>";
}
}

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

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 ]]> General Help kelsofield http://www.phpbuilder.com/board/showthread.php?t=10369708 Php link exporter http://www.phpbuilder.com/board/showthread.php?t=10369707&goto=newpost 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 ;) ]]> Coding The_L http://www.phpbuilder.com/board/showthread.php?t=10369707 calculate total in simple shopping cart http://www.phpbuilder.com/board/showthread.php?t=10369706&goto=newpost Sat, 21 Nov 2009 22:30:19 GMT Error performing query1: " . mysql_error() . "

"); exit(); } ?> 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?]]>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:

<?php
$result = mysql_query( "SELECT * FROM Shopping_sessions WHERE Session_id='$ses_id'", $db);
if (!$result) {
echo("<p>Error performing query1: " . mysql_error() . "</p>");
exit();
}
?>
<table width="100%" cellpadding="3" cellspacing="0" bgcolor="#FAF9CF">
<tr>
<td height="30"><strong>Item</strong></td>
<td width="120"><strong>Quantity</strong></td>
<td width="80"><strong>Item Price</strong></td>
<td width="80"><strong>Subtotal</strong></td>
</tr>
<?php
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("<p>Error performing query1: " . mysql_error() . "</p>");
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 "<tr> <td>$Product_name</td>
<td>$Product_quantity</td>
<td>$Product_price</td>
<td>$total2</td>
</tr>";
}
?>

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

How do I calculate the combined value of $total2? ]]>Codingmayandyhttp://www.phpbuilder.com/board/showthread.php?t=10369706 PhP Mysql query blog latest results http://www.phpbuilder.com/board/showthread.php?t=10369704&goto=newpost 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! 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! ]]> Coding gwolff2005 http://www.phpbuilder.com/board/showthread.php?t=10369704 Problems with Function + SQL http://www.phpbuilder.com/board/showthread.php?t=10369701&goto=newpost 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 ]]> Database intervelopment http://www.phpbuilder.com/board/showthread.php?t=10369701 <![CDATA[[RESOLVED] remove values from string]]> http://www.phpbuilder.com/board/showthread.php?t=10369700&goto=newpost Sat, 21 Nov 2009 13:21:42 GMT I have a string of numeric ids in a comma separated format PHP: --------- $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? 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? ]]> Newbies zzz http://www.phpbuilder.com/board/showthread.php?t=10369700 <![CDATA[[RESOLVED] register_globals]]> http://www.phpbuilder.com/board/showthread.php?t=10369699&goto=newpost 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 ]]> General Help msnhockey http://www.phpbuilder.com/board/showthread.php?t=10369699 Can someone modify this easy code please http://www.phpbuilder.com/board/showthread.php?t=10369698&goto=newpost 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.]]> <?php $links = array
(
'<a href="link1" />HERE</a>',
'<a href="link2" />HERE</a>',
'<a href="link3" />HERE</a>',
'<a href="link4" />HERE</a>',
'<a href="link5" />HERE</a>',
'<a href="link6" />HERE</a>',
);

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

<?print $links[$rand];?>

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

Thanks. ]]> Newbies TwistedLogix http://www.phpbuilder.com/board/showthread.php?t=10369698 Mail functionality from localhost to server http://www.phpbuilder.com/board/showthread.php?t=10369697&goto=newpost 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 ]]> General Help asparsh http://www.phpbuilder.com/board/showthread.php?t=10369697 youtube integration http://www.phpbuilder.com/board/showthread.php?t=10369696&goto=newpost Sat, 21 Nov 2009 05:38:17 GMT

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:
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
 
"; } $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'); --------- ]]> 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:
<?php
include('application.php');
if ($myID == 0) goto('login.php');
_v('e;i:eid');

if ($mode == 'e')
{
  $main .= "<center><br><br>
      The video cannot be found. <br> <br> <br>
      <input type='button' name='b1' class='bttn' value='< Go Back' onclick=\"location.replace('myvideos.php');\">
    </center>";
}

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 = '<object width="425" height="355"><param name="movie" value="http://www.youtube.com/v/'.$v__id.'&hl=en"></param><param name="wmode" value="transparent"></param><embed src="http://www.youtube.com/v/'.$v__id.'&hl=en" type="application/x-shockwave-flash" wmode="transparent" width="425" height="355"></embed></object>';
  $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 .= "<form action='myvideos.php' method='post' name='frmab' id='frmab' style='margin:0px' enctype='multipart/form-data'><input type='hidden' name='mode' value='addys'><input type='hidden' name='thumb' value='$thumb'><input type='hidden' name='v__id' value='$v__id'>
        <table border='0' cellspacing='2' cellpadding='3' align='center' width='400'>
          <tr><td><b>Title</b>:<br><input type='text' name='ttl' value=\"$title\" class='input' style='width:340px'></td></tr>
          <tr><td><br><b>Category</b>:<br>".sel_db('catid', 'category', 'cat_id', 'cat_name', "`cat_type` = 'videos'", '', '- Select -', 'input', '', '238')."</td></tr>
          <tr><td><b>Description</b>:<br><textarea name='dsc' class='input' style='width:340px;height:100px'>$desc</textarea></td></tr>
          <tr><td><b>Tags</b>: <br><input type='text' name='tags' value=\"$tags\" class='input' style='width:340px'></td></tr>
          <tr><td align='center'><br><input type='submit' name='sub' class='bttn' value='Add Video'> &nbsp; &nbsp; <input type='button' name='cnc' class='bttn' value='Cancel' onclick=\"location.replace('myvideos.php');\"></td></tr>
        </table></form>$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 .= "<form action='myvideos.php' method='post' name='frmab' id='frmab' style='margin:0px' enctype='multipart/form-data'><input type='hidden' name='mode' value='edits'><input type='hidden' name='eid' value='$eid'>
      <table border='0' cellspacing='2' cellpadding='3' align='center' width='400'>
        <tr><td><b>Title</b>:<br><input type='text' name='ttl' value=\"$vid_title\" class='input' style='width:340px'></td></tr>
        <tr><td><br><b>Category</b>:<br>".sel_db('catid', 'category', 'cat_id', 'cat_name', "`cat_type` = 'videos'", $vid_catid, '', 'input', '', '238')."</td></tr>
        <tr><td><b><br>Description</b>:<br><textarea name='dsc' class='input' style='width:340px;height:100px'>$vid_desc</textarea></td></tr>
        <tr><td><b>Tags</b>: <br><input type='text' name='tags' value=\"$tags\" class='input' style='width:340px'></td></tr>
        <tr><td align='center'><br><input type='submit' name='sub' class='bttn' value='Update'> &nbsp; &nbsp; <input type='button' name='cnc' class='bttn' value='Cancel' onclick=\"location.replace('myvideos.php');\"></td></tr>
      </table></form>$js";
  $main .= tabe();
}


if ($mode == 'addy')
{
  $main = "
    <form action='myvideos.php' method='post' name='frmab' id='frmab' style='margin:0px' enctype='multipart/form-data'>
    <input type='hidden' name='mode' value='adda'>
    <center><br>
    Please enter the YOUTUBE URL of the video <br>
    <i>eq: http://www.youtube.com/watch?v=B5i3mQhtNtg</i><br><br>
      <input type='text' name='vurl' class='input' style='width:300px'><br><br>
      <input type='submit' name='sub' class='bttn' value='Continue >'> &nbsp; &nbsp;
      <input type='button' name='cnc' class='bttn' value='Cancel' onclick=\"location.replace('myvideos.php')\">
  </center>";
  if ($e == 1) $main .= "<center><font color='red'>The video details cannot be retrieved.</font>";
}


if ($mode == '')
{
  $main .= tab2('My Videos', "<input type='button' name='b1' class='bttn' value='Add Youtube Video' onclick=\"location.replace('$base_url/myvideos.php?mode=addy');\">", 650);
  $main .= "<div style='margin:10px'>";
  $qe = mysql_query("SELECT * FROM `video` WHERE `vid_useid` = '$myID' ORDER BY `vid_id` DESC");
  if (mysql_num_rows($qe) == 0) $main .= "<center><br>You have not added any videos yet.</center>";
  else
  {
      $main .= "<table border='0' cellspacing='4' cellpadding='3' width='600' align='center'>";
      while ($re = mysql_fetch_assoc($qe))
      {
        extract($re);
        $thumb = '&nbsp;';
        if ($vid_thumb != '') $thumb = "<img src='photo/video/$vid_thumb' border='0'>";
        $vid_desc = mktext($vid_desc, 250);
        $vlink = URL::video($vid_id, $vid_url);
        $main .= "
            <tr>
              <td width='140' valign='top'><a href='$vlink'>$thumb</a></td>
              <td width='460' valign='top'>
                <a class='evtt' href='$vlink'>$vid_title</a>
                <div style='margin-top:5px;line-height:17px'>$vid_desc</div>
                <div style='margin-top:3px;color:#555555;line-height:19px'>
                    <a href='myvideos.php?mode=edit&eid=$vid_id'>Edit Video</a> &nbsp;
                    <a href='#' onclick=\"if (confirm('Are you sure you want to delete this video?')==true) location.replace('myvideos.php?mode=delete&eid=$vid_id');\">Delete Video</a></div>
              </td>
            </tr><tr><td colspan='2'><div style='border-top:1px solid #C7C7C7;height:2px;margin-top:4px;'>&nbsp;</div></td></tr>";
      }
      $main .= "</table>";
  }
  $main .= "<center><br><br>
      <input type='button' name='b1' class='bttn' value='Add Youtube Video' onclick=\"location.replace('$base_url/myvideos.php?mode=addy');\"> &nbsp; &nbsp;       
    </center></div>";
  $main .= tabe();
  $main .= "<div style='line-height:19px;margin-left:20px;margin-bottom:20px'>Easily import your favorite YouTube videos and share them with members. No uploading required. <br /> <a href='".URL::page('faq')."'>Support</a> </div>";
}

$_vtemplate['main'] = $main;
$_vtemplate['right'] = $right;
$tp = new page($_vtemplate, 'template/default2.html');
]]> Coding diabloroker http://www.phpbuilder.com/board/showthread.php?t=10369696 Live preview of PHP? http://www.phpbuilder.com/board/showthread.php?t=10369695&goto=newpost 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! ]]> Newbies Francoise http://www.phpbuilder.com/board/showthread.php?t=10369695