PHP Aggregator

Need some help with forms and mysql

Submitted by programmer on Thu, 08/21/2008 - 14:03.
I have a registration form which new users fill in some basic iinformation and when it is submitted the appropriate tables in mysql database are updated. Is there a way for when the user enters their webpage url to append to the beginning and end of what they submit either in the form itself, the php page it calls on or mysql? For example when they enter http://www.myhomepage.com I would like it pushed to the table as

Friendly url, how do I start?

Submitted by programmer on Wed, 08/20/2008 - 17:41.
Hi! If I have urls looking like this: http://www.mysite.com/?p=2

Access denied using password YES (no replies)

Submitted by programmer on Fri, 08/15/2008 - 12:03.
I get error "That Access denied using password Yes when uploading excel file.But the Code work perfect in my local machine!Take a look of this peace of code and help me solve this <?php<br />$uploadDir = 'C:/Program Files/xampp/htdocs/supplychain/supply/Uploaded Files/';<br /><br />if(isset($_POST['upload']))<br />{<br />$fileName = $_FILES['userfile']['name'];<br />$tmpName = $_FILES['userfile']['tmp_name'];<br />$fileSize = $_FILES['userfile']['size'];<br />$fileType = $_FILES['userfile']['type']; ?>

What is Faster? (1 reply)

Submitted by programmer on Fri, 08/15/2008 - 08:41.
I was wondering wich result is better for my friend list... If I have 1.000.000 rows in a table and need to select multiple rows from it for example select * from friend where login='fever' will have 200 results or is it better that I put in an array and split it in php for example ¦me¦you¦fever¦webmaster¦world¦ select * from friend where login='fever' will have 1 results $friends=split("\¦",$qeuryresults); and loop them out...?

SELECT a blob (1 reply)

Submitted by programmer on Fri, 08/15/2008 - 08:32.
Hey guys, How do I bring a mediumblob from my table into php?

Need to delete specific records in My SQL DB (1 reply)

Submitted by programmer on Fri, 08/15/2008 - 08:28.
Hi, I am a newbee as far as My SQL is concerned. I bought a website with a database full of products. I'd like to delete specific records. I want to delete those records with a price less than $4.95 and all products that don't have a photo. The table is called 'goods' Price is in the 'price' field ie. $6.95 is 695 Product photo is in the 'photoUrl' field ie. http://www.site.com/pic.jpg. The field is empty if no photo exists.

Known limitations of SELECT ... WHERE ... IN ()? (2 replies)

Submitted by programmer on Thu, 08/14/2008 - 17:34.
Below I have some PHP code which is a loop to go through and delete a series of users; however, it seems to fail when $in is too large. I'm trying to figure out what determines too large? Is it a PHP issue of the variable being too long? Is it a MySQL issue of how big $in can be? If I can figure it out what/where the limitation is then I could probably program around it by dumping $in into an array and processing it in chunks. Any suggestions or ideas would be appreciated? Peace - Anthony Borrow, SJ --- code segment ---

Does PHP wait? (no replies)

Submitted by programmer on Thu, 08/14/2008 - 17:34.
Hi! I have a php class that validates user submited content. It goes something like this: $var = $validate->fct($_POST['something']); ... and in my class: function fct($var){ //validates data if($noproblem){ return $var; }else{ //logout the user and exit(); } } I need to be sure that the script exits when !$noproblem. I really don't know if the php waits for the function to end or if it goes on. Any help?

Editting database on server in control panel (no replies)

Submitted by programmer on Thu, 08/14/2008 - 03:13.
Hi Guys Could anyone help me, How can I edit database in a live project by entering into cpanel of server? Any suggestion will be appreciated.Thanks Raj

Dreamweaver Local-&gt;Remote (1 reply)

Submitted by programmer on Wed, 08/13/2008 - 20:03.
I have site set up in Dreamweaver, have local host running (wampserver2.0) with pphpmyadmin and everything..Database and recordset are fine, populated locally. What exactly do I need to do to have the site, when uploaded to my 1and1 server, connect & populate the mySQL database on my 1and1 server?? Would love any info I can get. Thanks all!