deeej

any1 have any idea? post got pushed on another page so no1 could see it

Hi, Having real trouble for day's with this one, I am trying to upload a csv file to mySql dBase via a php script. I have a csv file and the contents of the file are as follows: Name|250|General|Asset|UK|AM|B1W2|www.website.com|Specialist|1 Name|250|General|Asset|UK|AM|B1W2|www.website.com|Specialist|1 Name|250|General|Asset|UK|AM|B1W2|www.website.com|Specialist|1 I have a mysql database set-up with exactly the same amount of columns to accept this data. Here is the PHP script I am using: if(isset($_POST['submit'])) { $filename=$_POST['filename']; $handle = fopen("$filename", "r"); while (($data = fgetcsv($handle, 1000, "|")) !== FALSE) { $import="INSERT into XXXXX(name,link,issue,date,type,type2,type2,type3,type4,typ45) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]')"; mysql_query($import) or die(mysql_error()); } fclose($handle); print "Import done"; } else { print "<form action='converter.php' method='post'>"; print "Type file name to import:<br>"; print "<input type='file' name='filename' size='20'><br>"; print "<input type='submit' name='submit' value='submit'></form>"; } I Keep getting the same error: "Column count doesn't match value count at row 1". Much appreciate any1s help thanks!!

sorry pressed quote instead of modify

the code works but it set's all the passwords to only 1 random generated password I want every entry to have its own random password, do not have a clue how to do it though. Thanks

Hi,I am stuck with this random password generator I want it to create a random password for every entry in my database but when I submit the code it does the same random password for all the entries. code: // random password gen function createRandomPassword() { $chars = "abcdefghijkmnopqrstuvwxyz023456789"; srand((double)microtime()*1000000); $i = 0; $pass = '' ; while ($i <= 7) { $num = rand() % 33; $tmp = substr($chars, $num, 1); $pass = $pass . $tmp; $i++; } return $pass; } // set new password for all $password = createRandomPassword(); $q1 = "update members set password = '$password'"; Probably really easy, hope some one can help thanks.!!

Hi all, this is either really easy or a bit complicated below is the .php file I am having trouble with I have managed to get it to work but it has to be done twice. Basically I have a selection box which gets it's values from a database once this is selected the selection box's below will get the correct value from the above selection box which again comes from the database. The first selection box works by refreshing the current page and adding a variable to the file for example instead of useraddnew.php it would be useraddnew.php?maintcat=5 but the number 5 only gets set the second time you choose from the top selection I hope some one can help sorry if I explained it poorly. This is the require_once includes.php function ptypes($x, $menu_name) { //$rid = $_POST[$menu_name]; $rid = $_GET['maincat']; if ($rid != '') { $qt = "select * from ** where maincat='$rid' order by CategoryName"; $rt = mysql_query($qt) or die(mysql_error()); if(mysql_num_rows($rt) > '0') { $SelectType = "<select name=\"$menu_name\">\n\t<option value=\"\"></option>\n\t"; while($at = mysql_fetch_array($rt)) { if($x != "0") { if($at[CategoryID] == $x) { $SelectType .= "<option value=\"$at[CategoryID]\" selected>$at[CategoryName]</option>\n\t"; } else { $SelectType .= "<option value=\"$at[CategoryID]\">$at[CategoryName]</option>\n\t"; } } else { $SelectType .= "<option value=\"$at[CategoryID]\">$at[CategoryName]</option>\n\t"; } } $SelectType .= "</select>"; } } return $SelectType; } function ptypes2($x, $rid, $menu_name) { if ($rid != '') { $qt = "select * from **** where maincat='$rid' order by CategoryName"; $rt = mysql_query($qt) or die(mysql_error()); if(mysql_num_rows($rt) > '0') { $SelectType = "<select name=\"$menu_name\">\n\t<option value=\"\"></option>\n\t"; while($at = mysql_fetch_array($rt)) { if($x != "0") { if($at[CategoryID] == $x) { $SelectType .= "<option value=\"$at[CategoryID]\" selected>$at[CategoryName]</option>\n\t"; } else { $SelectType .= "<option value=\"$at[CategoryID]\">$at[CategoryName]</option>\n\t"; } } else { $SelectType .= "<option value=\"$at[CategoryID]\">$at[CategoryName]</option>\n\t"; } } $SelectType .= "</select>"; } } return $SelectType; } function mtypes($x, $menu_name) { $qt = "select * from *** order by name"; $rt = mysql_query($qt) or die(mysql_error()); if(mysql_num_rows($rt) > '0') { $SelectType = "<form action=\"$PHP_SELF?maincat=$_POST[$menu_name]\" method=\"post\" name=\"form\">"; $SelectType .= "<select name=\"$menu_name\" onChange=\"document.form.submit();\">\n\t<option value=\"$_GET[maincat]\"></option>\n\t"; while($at = mysql_fetch_array($rt)) { if($x != "0") { $rid = $_GET['maincat']; if($at[id] == $rid) { $SelectType .= "<option value=\"$at[id]\" selected>$at[name]</option>\n\t"; } else { $SelectType .= "<option value=\"$at[id]\">$at[name]</option>\n\t"; } } else { $SelectType .= "<option value=\"$at[id]\">$at[name]</option>\n\t"; } } $SelectType .= "</select>"; $SelectType .= "</form>"; } return $SelectType; } function mtypes2($x, $id, $menu_name) { $qt = "select * from *** order by name"; $rt = mysql_query($qt) or die(mysql_error()); if(mysql_num_rows($rt) > '0') { $SelectType = "<select name=\"$menu_name\">\n\t<option value=\"$_GET[maincat]\"></option>\n\t"; while($at = mysql_fetch_array($rt)) { if($x != "0") { $rid = $_GET['maincat']; if($x == $at[id]) { $SelectType .= "<option value=\"$at[id]\" selected>$at[name]</option>\n\t"; } else { $SelectType .= "<option value=\"$at[id]\">$at[name]</option>\n\t"; } } else { $SelectType .= "<option value=\"$at[id]\">$at[name]</option>\n\t"; } } $SelectType .= "</select>"; } // $SelectType .= "<a href=\"changecat.php\">Change</a>"; return $SelectType; } This is the file I am having trouble with (useraddnew.php) <? require_once("includes.php"); //get the prices $q2 = "select * from ***"; $r2 = mysql_query($q2) or die(mysql_error()); if(mysql_num_rows($r2) == '0') { echo "<br><br><font face=verdana color=red size=2><b>You need to set up the prices first!</b></font></center>"; exit(); } $sprices = "<select name=price>\n"; while($a2 = mysql_fetch_array($r2)) { $sprices .= "<option value=\"$a2[Duration]|$a2[PriorityLevel]\">$a2[PackageName] ($a2[Duration] months, $a2[PriorityName])</option>\n\t"; } $sprices .= "</select>"; if(isset($_POST[s1])) { if($_FILES['picture']['size'] > '0') { $ext_array = explode(".", $_FILES['picture']['name']); $ext = array_pop($ext_array); $ext = strtolower($ext); $allowed = array("gif", "jpg", "jpeg"); if(in_array($ext, $allowed)) { $new_picture = $t."_".$_FILES['picture']['name']; copy($_FILES['picture']['tmp_name'], "../yellow_images/".$new_picture); } } else { $new_picture = $_POST['OldLogo']; } //manage files $MyImages = array(); if($_FILES[ResumeImages][size][0] > '0') { while(list($key,$value) = each($_FILES[ResumeImages][name])) { if(!empty($value)) { $NewImageName = $t."_resume_".$value; copy($_FILES[ResumeImages][tmp_name][$key], "../***/".$NewImageName); $MyImages[] = $NewImageName; } } if(!empty($MyImages)) { $ImageStr = implode("|", $MyImages); } } if(!empty($_POST['website'])) { $NewWebsite = $_POST['website']; } else { $NewWebsite = "http://"; } $my_Manager = htmlspecialchars($_POST[Manager]); $my_address = htmlspecialchars($_POST[address]); $my_ms = htmlspecialchars($_POST[medical_school]); $my_rt = htmlspecialchars($_POST[residency_training]); $my_members = htmlspecialchars($_POST[Menu]); $lunchmenu = htmlspecialchars($_POST[lunchmenu]); $winemenu = htmlspecialchars($_POST[winemenu]); $othermenu = htmlspecialchars($_POST[othermenu]); //get the price info $pv = explode("|", $_POST['price']); //update the advertiser's record/credits $aexp = mktime(0,0,0,date(n) + $pv[0],date(j),date(Y)); $q1 = "insert into *** set username = '$_POST[NewUsername]', password = '$_POST[p1]', Manager = '$my_Manager', maincat = '$_POST[maincat]', primary_specialty = '$_POST[primary_specialty]', secondary_specialty = '$_POST[secondary_specialty]', Waiter = '$_POST[Waiter]', FirstName = '$_POST[FirstName]', LastName = '$_POST[LastName]', address = '$my_address', city = '$_POST[city]', state = '$_POST[state]', country = '$_POST[country]', phone = '$_POST[phone]', cellular = '$_POST[cellular]', pager = '$_POST[pager]', email = '$_POST[email]', website = '$_POST[website]', medical_school = '$my_ms', residency_training = '$my_rt', graduation_year = '$_POST[graduation_year]', Menu = '$my_members', lunchmenu = '$lunchmenu', othermenu = '$othermenu', winemenu = '$winemenu', Description = '$_POST[Description]', Smoking = '$_POST[smoking]', birthyear = '$_POST[birthyear]', picture = '$new_picture', ResumeImages = '$ImageStr', news = '$_POST[news]', NewsletterType = '$_POST[format]', RegDate = '$t', ExpDate = '$aexp', AccountStatus = 'active', PriorityLevel = '$pv[1]' "; mysql_query($q1); if(ereg("key 2", mysql_error())) { $error = "<span class=\"RedLink\">The username <span class=\"BlackLink\">$_POST[NewUsername]</span> is already in use!<br>Select another one, please!</span>"; unset($_POST[NewUsername]); } elseif(ereg("key 3", mysql_error())) { $error = "<span class=\"RedLink\">You are already registered!<br>Update your account, please!</span>"; unset($_POST); } else { $last = mysql_insert_id(); $_SESSION['NewAgent'] = $last; //send an email $to = $_POST['email']; $subject = "Your registration at $_SERVER[HTTP_HOST]$dir"; $message = "Hello $_POST[FirstName] $_POST[LastName],\nhere is your login information for $_SERVER[HTTP_HOST]$dir\n\nUsername: $_POST[NewUsername]\nPassword: $_POST[p1]\n\nTo login, follow this link:\nhttp://$_SERVER[HTTP_HOST]$dir/login.php\n\nThank you for your registration!"; $headers = "MIME-Version: 1.0\n"; $headers .= "Content-type: text/plain; charset=iso-8859-1\n"; $headers .= "Content-Transfer-Encoding: 8bit\n"; $headers .= "From: $_SERVER[HTTP_HOST]$dir <$aset[ContactEmail]>\n"; $headers .= "Reply-To: $_SERVER[HTTP_HOST]$dir <$aset[ContactEmail]>\n"; $headers .= "X-Priority: 3\n"; $headers .= "X-MSMail-Priority: Normal\n"; $headers .= "X-Mailer: PHP/" . phpversion()."\n"; mail($to, $subject, $message, $headers); header("location:info.php?id=$last"); exit(); } } include_once("LeftStyles.php"); //will receive news $ch1 = "checked"; //news in HTML format $ch3 = "checked"; for($z = '1'; $z <= (5 - $i); $z++) { $ImageBlock .= "<input type=file name=\"ResumeImages[]\"><br>\n"; } if(!empty($a1[website])) { $MyWeb = $a1[website]; } else { $MyWeb = "http://"; } ?> <? if ($_GET['maincat'] != '') //If a category has been chosen { ?> <form method=post enctype="multipart/form-data" name=RegForm onsubmit="return CheckRegister();"> <table align=center class="BlackText"> <caption align=center><font face=verdana size=2><b>Add a new member</b></font><br><?=$error?></caption> <tr> <td align="right">Category:</td> <td><?=mtypes($a1['maincat'], "maincat")?> </td> </tr> <tr> <td align="right">Primary specialty:</td> <td><?=ptypes($_POST['primary_specialty'], "primary_specialty")?></td> </tr> <tr> <td align="right">Secondary specialty:</td> <td><?=ptypes($_POST['secondary_specialty'], "secondary_specialty")?></td> </tr> <tr> <td align=right>Username:</td> <td><input type="text" name="NewUsername" value="<?=$_POST[NewUsername]?>"></td> </tr> <tr> <td align=right>Password:</td> <td><input type=password name=p1></td> </tr> <tr> <td align=right>Confirm Password:</td> <td><input type=password name=p2></td> </tr> <tr> <td align=right>Manager:</td> <td><input type=text name="Manager" value="<?=$_POST['Manager']?>"></td> </tr> <tr> <td align=right>Business Name:</td> <td><input type=text name=FirstName value="<?=$_POST[FirstName]?>"></td> </tr> <tr> <td align=right>Last Name:</td> <td><input type=text name=LastName value="<?=$_POST[LastName]?>"></td> </tr> <tr> <td align=right>Address:</td> <td><input type=text name=address value="<?=$_POST[address]?>"></td> </tr> <tr> <td align=right>City:</td> <td><input type=text name=city value="<?=$_POST[city]?>"></td> </tr> <tr> <td align=right>Town:</td> <td><input type=text name=state value="<?=$_POST[state]?>"></td> </tr> <tr> <td align=right>Country:</td> <td><?=country($_POST[country]);?></td> </tr> <tr> <td align=right>Phone:</td> <td><input type=text name=phone value="<?=$_POST[phone]?>"></td> </tr> <tr> <td align=right>Email:</td> <td><input type=text name=email value="<?=$_POST[email]?>"></td> </tr> <tr> <td align=right>Website:</td> <td><input type=text name=website value="<?=$MyWeb?>"></td> </tr> <tr> <td align="right">Store Hours:</td> <td><input type="text" name="medical_school" value="<?=$_POST['medical_school']?>"></td> </tr> <tr> <td align="right">WeekEnd Hours:</td> <td><input type="text" name="residency_training" value="<?=$_POST['residency_training']?>"></td> </tr> <tr> <td align="right" valign="top">Main Menu:</td> <td><input type="text" name="Menu" value="<?=$_POST['Menu']?>"></td> </tr> <tr> <td align="right" valign="top">Wine Menu:</td> <td><input type="text" name="winemenu" value="<?=$_POST['winemenu']?>"></td> </tr> <tr> <td align="right" valign="top">Lunch Menu:</td> <td><input type="text" name="lunchmenu" value="<?=$_POST['lunchmenu']?>"></td> </tr> <tr> <td align="right" valign="top">Other Menu:</td> <td><input type="text" name="othermenu" value="<?=$_POST['othermenu']?>"></td> </tr> <tr> <td align="right" valign="top">Description:</td> <td><textarea name="Description" rows="6" cols="45"><?=$_POST['Description']?></textarea></td> </tr> <tr> <td align="right">Smoking:</td> <td><?=Smoking_status($_POST['Smoking']);?></td> </tr> <tr> <td align="right">Year Established:</td> <td><?=years("birthyear", $_POST['birthyear']);?></td> </tr> <tr> <td align=right>Your picture:</td> <td><input type=file name="picture"></td> </tr> <tr> <td align=right valign=top>Other photos:</td> <td> <?=$ImageBlock?> </td> </tr> <tr> <td align=right>Receive updates:</td> <td> <input type=radio name=news value="y" <?=$ch1?>>yes <input type=radio name=news value="n" <?=$ch2?>>no </td> </tr> <tr> <td align=right>Newsletter format:</td> <td> <input type=radio name=format value="html" <?=$ch3?>>html <input type=radio name=format value="plain" <?=$ch4?>>plain text </td> </tr> <tr> <td align=right>Select Plan:</td> <td><?=$sprices?></td> </tr> <tr> <td> </td> <td><input type=submit name=s1 value="Update"></td> </tr> </table> </form> <? } else { ?> <table align=center class="BlackText"> <caption align=center><font face=verdana size=2><b>Add a new member</b></font><br><?=$error?></caption> <tr> <td align="right">Category:</td> <td><?=mtypes($a1['maincat'], "maincat")?> </td> </tr> <tr> <td align="right">Primary specialty:</td> <td><?=ptypes($_POST['primary_specialty'], "primary_specialty")?></td> </tr> <tr> <td align="right">Secondary specialty:</td> <td><?=ptypes($_POST['secondary_specialty'], "secondary_specialty")?></td> </tr> <tr> <td align=right>Username:</td> <td><input type="text" name="NewUsername" value="<?=$_POST[NewUsername]?>"></td> </tr> <tr> <td align=right>Password:</td> <td><input type=password name=p1></td> </tr> <tr> <td align=right>Confirm Password:</td> <td><input type=password name=p2></td> </tr> <tr> <td align=right>Manager:</td> <td><input type=text name="Manager" value="<?=$_POST['Manager']?>"></td> </tr> <tr> <td align=right>Business Name:</td> <td><input type=text name=FirstName value="<?=$_POST[FirstName]?>"></td> </tr> <tr> <td align=right>Last Name:</td> <td><input type=text name=LastName value="<?=$_POST[LastName]?>"></td> </tr> <tr> <td align=right>Address:</td> <td><input type=text name=address value="<?=$_POST[address]?>"></td> </tr> <tr> <td align=right>City:</td> <td><input type=text name=city value="<?=$_POST[city]?>"></td> </tr> <tr> <td align=right>Town:</td> <td><input type=text name=state value="<?=$_POST[state]?>"></td> </tr> <tr> <td align=right>Country:</td> <td><?=country($_POST[country]);?></td> </tr> <tr> <td align=right>Phone:</td> <td><input type=text name=phone value="<?=$_POST[phone]?>"></td> </tr> <tr> <td align=right>Email:</td> <td><input type=text name=email value="<?=$_POST[email]?>"></td> </tr> <tr> <td align=right>Website:</td> <td><input type=text name=website value="<?=$MyWeb?>"></td> </tr> <tr> <td align="right">Store Hours:</td> <td><input type="text" name="medical_school" value="<?=$_POST['medical_school']?>"></td> </tr> <tr> <td align="right">WeekEnd Hours:</td> <td><input type="text" name="residency_training" value="<?=$_POST['residency_training']?>"></td> </tr> <tr> <td align="right" valign="top">Main Menu:</td> <td><input type="text" name="Menu" value="<?=$_POST['Menu']?>"></td> </tr> <tr> <td align="right" valign="top">Wine Menu:</td> <td><input type="text" name="winemenu" value="<?=$_POST['winemenu']?>"></td> </tr> <tr> <td align="right" valign="top">Lunch Menu:</td> <td><input type="text" name="lunchmenu" value="<?=$_POST['lunchmenu']?>"></td> </tr> <tr> <td align="right" valign="top">Other Menu:</td> <td><input type="text" name="othermenu" value="<?=$_POST['othermenu']?>"></td> </tr> <tr> <td align="right" valign="top">Description:</td> <td><textarea name="Description" rows="6" cols="45"><?=$_POST['Description']?></textarea></td> </tr> <tr> <td align="right">Smoking:</td> <td><?=Smoking_status($_POST['Smoking']);?></td> </tr> <tr> <td align="right">Year Established:</td> <td><?=years("birthyear", $_POST['birthyear']);?></td> </tr> <tr> <td align=right>Your picture:</td> <td><input type=file name="picture"></td> </tr> <tr> <td align=right valign=top>Other photos:</td> <td> <?=$ImageBlock?> </td> </tr> <tr> <td align=right>Receive updates:</td> <td> <input type=radio name=news value="y" <?=$ch1?>>yes <input type=radio name=news value="n" <?=$ch2?>>no </td> </tr> <tr> <td align=right>Newsletter format:</td> <td> <input type=radio name=format value="html" <?=$ch3?>>html <input type=radio name=format value="plain" <?=$ch4?>>plain text </td> </tr> <tr> <td align=right>Select Plan:</td> <td><?=$sprices?></td> </tr> <tr> <td> </td> <td><input type=submit name=s1 value="Update"></td> </tr> </table> <? } ?> Hope some one can help thanks!

!!!!!!! I do want help Why wouldn't I?!?!?! Please Help!!!

Sorry the php code works fine I just changed it a bit, it is all a1.. (it's getting it to display how I want I am having trouble with I was showing the code I want to change to display correct) Try reading it again (I am a bit of a n00b sorry lol) I showed an example of how I want it to display but I only want data shown if they have that facility, the values are enum ('y','n') and some are numbers (like amount of rooms a hotel has), obviously if they do not have the facility I do not want it to display This bit I can get working fine. It's just to display the data in a table with 2 columns with out the data having random spaces if they do not have that facility. Example 1, Example 2 , Example 3 Example 4, Example 5 Thanks, Hope you can understand now!!! Sorry

Please help I have no idea what to do^^

Hi people, not a clue how I would do this if someone could help that would be great, I tried putting all the information in a table but if there is no value some of the data is displayed randomly! if ($1[pool]=="y") { $ShowInfo .= "<tr><img src='images/icons/pool.gif'><B> Pool</B></tr>"; } if ($1[valet]=="y") { $ShowInfo .= "<tr><img src='images/icons/valet.gif'><B> Valet</B></tr>"; } if ($1[gym]=="y") { $ShowInfo .= "<tr><img src='images/icons/gym.gif'><B> Gym</B></tr>"; } $ShowInfo .= "<tr><img src='images/icons/beds.gif'><B> $a1[beds] Beds</B></tr>"; $ShowInfo .= "<tr><img src='images/icons/checkin.gif'><B> Check-In Time:</B> $1[checkintime]</tr>"; $ShowInfo .= "<tr><img src='images/icons/checkout.gif'><B> Check-Out Time:</B> $1[checkouttime]</tr>"; if ($1[parking]=="y") { $ShowInfo .= "<tr><img src='images/icons/parking.gif'><B> Parking</B></tr>"; } if ($1[wireless]=="y") { $ShowInfo .= "<tr><img src='images/icons/wireless.gif'><B> Wireless</B></tr>"; } basically I have a database full off businesses and each business has a list of extra facilities. What I am trying to do is to display the facilities they do have, and not the ones they do not have. like so: Extra facility 1, extra facility 2 extra facility 3, extra facility 4 extra facility 5, extra facility 6 2 Facilities on each row then go to a new line I tried a table but if they do not have 'for example facility 3' then there is a gap where it should be in the table and data looks odd. This is mysql and PHP. Thanks

also i tried carrying the id with include login.php?id=$id but it cannot find the login page then. Thanks

Hey guys hope some one can help ill try explain it as best i can. the trouble is i cannot seem to get the id= to carry across so when the user logs in it takes them back to the page they wer at before. it starts like this, >> when you are on the resteraunt page you would like to add a testimonial for, > you click add testimonial, > for example if you were on le petit blanc resteraunt it would say in the url bar add_testimonial.php?id=2 (because the id of the resteraunt you are leaving a testimonial for is id=2.) >in the add_testimonial.php page there is a little script to say if logged in continue if not to include login.php, (so the user must login before being able to leave a testimonial. >in login.php this is where i have the if and get command. >the idea is if you logged from how i just explained for it to take you back to the add_testimonial.php?id=2 page.(once oyou have logged in) >but you can also login from the home page, >for example: by clicking login on the home page, this is where the if command comes in, >if they login from the home page there would be no ?id=2 so there for i would like them to be taken to the home page when logged in. [b] This is the add_testimonial.php page. which would be displayed like this in the url page add_testimonial.php?id=123 [/b] <?php session_start(); if (isset ($_SESSION['loggedin']) && isset ($_SESSION['time'])) { ?> <form method="POST" name="t1" OnSubmit="return CheckTestimonial();"> <table align="center"> <caption align="center" class="TitleLinks">Add your testimonial</caption> <tr> <td align="right">Your name: </td> <td><input type="text" name="testimonial_name"></td> </tr> <tr> <td align="right" valign="top">Testimonial: </td> <td><textarea rows="5" cols="40" name="testimonial_text"></textarea></td> </tr> <tr> <td></td> <td><input type="submit" name="s1" value="Submit"></td> </tr> </table> </form> <?php } else { include ("login1.php"); } ?> [b]this is the code i have so far that is in the login.php page with the if get command[/b] $id = $_GET["id"]; if($id != ''){ header ("Location: add_testimonial.php?id=$id"); exit; } else { header ('Location: index.php'); exit; } exit; } [b]Also tried echoing the id but it does not seem to show in the login page i am wondering if it something to do with the if get command being in the login page and the login page being an include to the add_testimonial page. Thanks guys[/b]