PHP - Php Form Not Adding Links To Database

I am stuck on inserting the data into mysql via php.

Its a foreach method and I am just stuck

Code: [Select]
include '../Database/take_an_exam.php';
$intNum = 1;
$intnumber = 1;


while( $info = mysql_fetch_array( $sqll )){ 
  echo "<input type='hidden' name=\"Que_ID\" value=\"{$info['Que_ID']}\" /> ";
  echo " $intNum, {$info['Que_Question']} <br />\n";
   $intNum++;
 
 for ($i =1; $i < 5; $i++) { 
 
 echo "<input type=\"checkbox\" name=\"choice[{$info['Que_ID']}.$i][]\" />{$info['Que_Choice'.$i]}<br />\n"; 
  $intnumber++;
 }
 }
?>

<input type="submit" value="submit" name="submit">
This is my form that can output the Question and its choices.

I am echoing this on to the next page, the code is shown below
Code: [Select]
<?PHP
session_start();
$name= $_SESSION['username1'];
echo "User ID: $name <br/>";
$gender = $_POST["choice"];
$que_ID = $_POST["Que_ID"];

foreach ($gender as $key => $array) { 
if($array)
{ 
 $val=1;
 }
 
 ///echo "Question ID and the choice ID:$key. Value is:.$val <br />\n";
 $well = array(floor($key), substr(strstr($key, '.'), 1));
 //$well = array(floor($key), $key - floor($key));
 echo "Question ID: $well[0], ";
 echo "Choice: $well[1]. value: $val<br/>";
 }
 //}break;
?>

Now, instead of echoing. I just want to add this to mysql.

The layout of my sql is Que_ID, Ans_Choice1, Ans_Choice2, Ans_Choice3, Ans_Choice4, Use_ID

When I echo my php my outcome is

Quote

User ID: 2
Question ID= 1 Choice 1
Question ID= 2 Choice 3
Question ID= 3 Choice 4
Question ID= 4 Choice 1

 Hey anybody can please guide me where I m wrong in this php code
please reply

here is the code
Only variables should be passed by reference on line 3
in that function area function get_file_extension($file_name)

main error I guess is the explode one

Aand yeah I checked adding
$file_name = $_FILES['fld']; before the function is started

<?php

require("include/dbconn.php");

    //$username = mysql_real_escape_string($_POST['username1']);



function get_file_extension($file_name) {
   return end(explode('.',$file_name));

}
function errors($error){
   if (!empty($error))
   {
         $i = 0;
         while ($i < count($error)){
         $showError.= '<div class="msg-error">'.$error[$i].'</div>';
         $i ++;}
         return $showError;
   }// close if empty errors
} // close function

if (isset($_POST['submit'])){

   $username = "Sunny";
   $date1 = date("d m y");
    mysql_select_db("deals") or die(mysql_error());

   if($username == "")
   {
   //header("location:newnewuser1.php");
   echo "Username empty";
    //header("location:newnewuser1.php");   
      
   }
   else
   {
   
   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;
}
// Usage

$password = createRandomPassword();

   //$password = mysql_real_escape_string($_POST['Password']);
$date = strtotime("+2hours");
$date1 =  date("d-m-y",$date);
 
if(get_file_extension($_FILES["fld"]["name"])!= 'csv')
{
$error[] = 'Only CSV files accepted!';
echo "Wrong Input";
}//get_file_extension
 
if (!$error)
{
 
$tot = 0;
$handle = fopen($_FILES["fld"]["tmp_name"], "r");

   
 while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
   
   for ($c=0; $c < 1; $c++) {
     
       try {
     mysql_query("INSERT INTO newusers (email,password,location,company,name,contact,sourcename,date)VALUES('".mysql_real_escape_string($data[0])."','$password','".mysql_real_escape_string($data[1])."',
   '".mysql_real_escape_string($data[2])."','".mysql_real_escape_string($data[3])."','".mysql_real_escape_string($data[4])."','$username1','$date1')");
    
    $tot++;
       
      }
      catch(Exception $e)
      {
      PRINT 'ERROR:' +$e;
     }   
   }//for



}//while
fclose($handle);


 
}// end no error
}//close if isset upfile
 



}

?>

and this is the form code

<form name="f1" action="" method="POST" enctype="multipart/form-data">
                             <table><tr><td><input type="file" value="Browse" name="fld" onselect="CheckExtension(fld)"><br/></td><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td></tr><tr><td>Username :<input type="text" name="username1" value="" id="user" onfocus="validateForm1()"></td>
                      <td><input type="submit" name="submit" value="submit" id="submit"></td></tr></table>
                              </form>

Please help me I m stuck in this quite badly
Please


[attachment deleted by admin]

Hey i have set up a database and im trying to ad records to it also upload an image, when i submit my form it clears the fields but does not add to the database. There are no errors that get  outputted or anything so it gives no help 

I have read thru my code over and over and just cant see why its not adding. Any help would be great

<html>
<script language="JavaScript">
function validated(){

var matric = document.s.matric.value;
var name = document.s.name.value;
var course = document.s.course.value;
var sem = document.s.sem.value;
var semint = parseInt(sem);
var tel = document.s.tel.value;
var telint = parseInt(tel);
var address = document.s.address.value;
var picture = document.s.picture.value;

if(matric==""){
window.alert("Please enter matric number!");
document.s.matric.focus();
return false;
}
if(name==""){
window.alert("Please enter student name!");
document.s.name.focus();
return false;
}
if(course==""){
window.alert("Please enter student course!");
document.s.course.focus();
return false;
}
if(isNaN(semint)){
window.alert("Please enter student semester!");
document.s.sem.focus();
return false;
}
if(isNaN(telint)){
window.alert("Please enter contact number!");
document.s.tel.focus();
return false;
}
if(address==""){
window.alert("Please enter student address!");
document.s.address.focus();
return false;
}
if(picture==""){
window.alert("Please enter student picture!");
document.s.picture.focus();
return false;
}
}
</script>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr>
    <td align="center"><h1><font color="#0000FF" face="Arial">ADD STUDENT PROFILE</font></h1></td>
  </tr>
</table>
<br><br>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr>
    <td align="right"><font size="1" face="Arial"><a href='main.php'>Student List</a></font></td>
  </tr>
</table>
<br><br>
<form method="post" action="student_form.php" enctype="multipart/form-data" name='s' onsubmit='return validated()';>
<table width="70%" border="0" align="center" cellpadding="2" cellspacing="2">
  <tr>
    <td width="33%" align="right"><font size="2" face="Arial"><strong>Matric Number</strong></font></td>
    <td width="5%" align="center">:</td>
    <td width="62%"><input type='text' name='matric' size=30 maxlength=15></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Name</strong></font></td>
    <td align="center">:</td>
    <td><input type='text' name='name' size=30 maxlength=50></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Course</strong></font></td>
    <td align="center">:</td>
    <td><input type='text' name='course' size=30 maxlength=50></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Semester</strong></font></td>
    <td align="center">:</td>
    <td><input type='text' name='sem' size=5 maxlength=2></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Sex</strong></font></td>
    <td align="center">:</td>
    <td><input type='radio' name='sex' value='Male' checked> Male  <input type='radio' name='sex' value='Female'> Female</td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Contact Number</strong></font></td>
    <td align="center">:</td>
    <td><input type='text' name='tel' size=30 maxlength=50></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Address</strong></font></td>
    <td align="center">:</td>
    <td><input type='text' name='address' size=50 maxlength=100></td>
  </tr>
  <tr>
    <td align="right"><font size="2" face="Arial"><strong>Picture</strong></font></td>
    <td align="center">:</td>
    <td>
<input type="hidden" name="MAX_FILE_SIZE" value="10485760">
<input type="file" name="picture"  size="40"> <font size="1" face="Arial"> Maxsize 1MB</font>
</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><input type='submit' name="submit" value='Submit'> <input type='reset' value='Reset'></td>
  </tr>
</table>
<?php

if ($submit) 
{

include 'db_connect.php';

$data = addslashes(fread(fopen($picture, "r"), filesize($picture)));

$pjpeg="image/pjpeg";
$jpeg="image/jpeg";
$gif="image/gif";
$png="image/png";
$bmp="image/bmp";

if ($picture_type == $pjpeg OR $picture_type == $jpeg OR $picture_type == $gif OR $picture_type == $png OR $picture_type == $bmp)
{

$sql="INSERT INTO info (matric, name, course, sem, sex, tel, address ,bin_data,filename,filesize,filetype)
VALUES ('$matric', '$name', '$course', '$sem', '$sex', '$tel', '$address', '$data','$picture_name','$picture_size','$picture_type')";
$result=mysql_query($sql);

header ("Location: main.php");
}
else{
echo "<script language='JavaScript'>";
echo "window.alert('Error! You only can upload jpeg, gif, png, bmp file type.')";
echo "</script>"; 
}
}

?>
</form>
</body>
</html>


Thanks,

Code: [Select]
$product_id=$_GET['product'];
$sql500="SELECT * FROM $tbl_name3 WHERE product_id='$product_id'";
$result500=mysql_query($sql500);
$num_rows500=mysql_num_rows($result500);
while($row500=mysql_fetch_array($result500)){
extract($row500);
$review_product_rating_total=$review_product_rating; //What do I do here?
}
$average_rating=$review_product_rating_total/$num_rows500;

I need a way to take a column of product ratings (0-5 in 1/2 increments), add them together, and divide by the number of rows taken from the database. I know how to get the number of rows with mysql_num_rows. But how would I add together the data from database?

Hey All, first off Merry X-Mas

ok so I'm trying to insert something into the batabse in one of three areas' let me explain

there are three fields in the users database bounceone, bouncetwo and bouncethree now what I want to do is when the user clicks add to bounce list insert a value into the databse in one of these three hole, if bounceone is empty put it there, if not check bouncetwo if it's empty put it there, if not check the final one and if it's empty put it there else echo sorry please either remove a bounce

any ideas on how this can be done.

Hi,
how to make this form + php to make it work this way

from the drop-down box choose the database title, or ID, and then the form in which I write some content will be added to the database that matches the title or ID that is sometimes so as not to invade a mistake and content that I type is not added to another title or ID

I created something like this:

<?php
$db = new mysqli('localhost','xxxxx','xxxx','xxxx');
mysqli_query($db,'SET NAMES `utf8`');
$sqlnowe = mysqli_query($db,'SELECT * FROM `cc` ORDER BY `id` DESC  ');

?>

<form action="formu.php" method="post">
<select name="tytul">
<?php while ($rownowe = mysqli_fetch_array($sqlnowe)) { ?>
<option><? echo $rownowe['tytul']; ?></option><?php };?>

</select>


opismax:<br />
<input type="text" name="opismax" /><br />
<textarea name="opismax" cols="50" rows="10">Prosz&#281;, wpisz tutaj jaki&#347; komentarz...</textarea>

<input type="submit" value="dodaj" />
</form>

<?php

// odbieramy dane z formularza
$tytul = $_POST['tytul'];
$opismax = $_POST['opismax'];

if($tytul and $opismax) {
    
   
    
    // dodajemy rekord do bazy
    $ins = mysqli_query("INSERT tytul='$tytul' INTO publications SET  opismax='$opismax'");
    
    if($ins) echo "Good";
    else echo "Bad";
    

}

?>

I have a php page where  I have posts about different  topic.
I have a menu listing all this categories of topics . Some topics may belong to more than one category.

So when i click on a particular menu item, the topic belonging to that category will be displayed.
While displaying it is in this format---Topic Heading,Belongs to which all categories,date posted and the description.

All this are taken from database.

Now my actual issue is I am not able to give links to the categories dispalyed ,if the category exceeds more than 1.
For eg:
Global Warming
Posted on March 11,2011 in News, Issue
-----------description of global warming goes here.

In the above eg: News and issue are the two categories,when i click on News it should display all the items in news category,and when i click on issue it should display all items of issue category.
But I am not able to give this link to the categories.

Code: [Select]
while($row = mysql_fetch_array($q)) {
  if($row[6]=='News'){
  $c='<a href="category_disp.php?category=news">News</a>';
  }
  if($row[6]=='Issues'){
  $c='<a href="category_disp.php?category=issues">Issues</a>';
  }
 
 
   echo "<tr><td><p >$row[1]</p><br></td></tr>";
  echo "<tr><td>  <div >".
  "<p><span>$row[4]</span> <span>".
  "<a href='$row[6]' >$row[6]|<a href='$row[5]'> Post Comments</a></span></p>".
  "<p>&nbsp;</p></div><br></td></tr>";
  echo "<tr><td><p >$row[2]</p><br></td></tr>";
  echo "<tr><td><p ><a href='$row[3]' >Click Here to read more...</a></p></td></tr>";
  echo "</div></td></tr>";
 }

echo"  </table>

Hi there

I've been working with some code to display a single
record on page. This all works fine and I'm able to pull what I
want from the database. My problems is trying to use that
data and turning it into something else like a link.

I have a field in the database called image url which
contains rows of image urls.

So here is the problem area of the code:

Code: [Select]
<?php
//////Displaying Data/////////////
$id=$_GET['id']; // Collecting data from query string
if(!is_numeric($id)){ // Checking data it is a number or not
echo "Data Error";
exit;
}

$fetch=mysql_query("select * from productfeeds where ProductID=$id ");
$row=mysql_fetch_object($fetch);
echo mysql_error();
echo "<table>";
echo "
<tr><td><b>ProductID</b></td><td>$row->ProductID</td></tr>
<tr><td><b>ProductName</b></td><td>$row->ProductName</td></tr>
<tr><td><b>ProductPrice</b></td><td>$row->ProductPrice</td></tr>

//problem area for me
<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>
echo "</table>";
I'm trying to edit this part of the code:

<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>

I've tried this:

<tr><td><b>Image</b></td><td><a href='{$row['URL']}'> <img src='{$row['ImageURL']}'></a>

and

<tr><td><b>Image</b></td><td><a href='$row['URL']'> <img src='$row['ImageURL']'></a>  //removed brackets

but I'm just getting errors. Can you guys help please?

Thank you very much.

Good day guyz... I dont know why this code does not work...

the connection is fine, the database is also fine it works with the localhost, when i upload it on free hosting site like 000webhost and infinityfree this is not working.. the database on free hosting site are also working also the connection is code, just only this code i cant figure it out..

else{

$sql = "INSERT INTO .$name (TrxID, ProductName, Price, ProductImage, PurchasedDate, PurchasedStatus) VALUES (?, ?, ?, ?, ?, ?)";

$stmt = mysqli_stmt_init($conn2);

if(!mysqli_stmt_prepare($stmt, $sql)){

echo 'connection error';

}

mysqli_stmt_bind_param($stmt, "isssss", $val, $PName, $Price, $PImage, $PDate, $PStatus);

mysqli_stmt_execute($stmt);

mysqli_stmt_close($stmt);

header("location: ../customer/cart.html");

exit();

}

}

 

Like many projects, this started small, and keeps growing!  

I am building a photo gallery and would now like to add labels/captions below each photo, HOWEVER, I really don't want to have to build a database and do all the related coding.  (I know how, but its a PITA.)

To display photos in the gallery, I read in files from my "images/" directory, store them in a simple array, and then iterate through the array to display the thumbnails in a gallery.

I am wondering if there would be an easy way that I could merge photo metadata (e.g. a brief caption) with my array or something like that?

If I could type up the file names and a brief description/caption in a Text File or Spreadsheet and then somehow slurp that into my code and merge it with my array or something like that, then I would be willing to type up captions.  (This is for like 600 photos which is why I don't want to do a database as data entry in phpMyAdmin is a PITA!)

Any suggestions how I could do this and add a "cherry on the top" of this mini project I am doing for my co-workers?

Thanks!

 

 

Hi Im having some trouble implementing info into a database

Hi all,

I have a code which works just fine for adding one picture to my database but when I change the form to add mutliples i get an error because my code is set for multiple pictures as an array. Error says this is a string code. Does anyone know the code for array?

Code: [Select]
$target = "upload/";
$target = $target . basename( $_FILES['photo']['name']); Error message says 
Warning: basename() expects parameter 1 to be string, array given in /home/content/19/6550319/html/listingsss.php on line 7

Thanks,
Philip

Hello to all phpfreaks out there 

I need help with sorting some database columns. I ve been searching all day but i didnt found something nice to implement (or my mind is too tired to think right at this specific time)

I have a table and inside it i display  a picture and some other data.Above the table i inserted a div and inside it i have 5 links which when clicking on them i want to change the display order of the data being displayed in the table, and if clicked again to change again the state for ASC to DESC and so on...

Is there any short solution that do the trick?

With an array maybe?

PS:I have also a pagination which i would like to keep the sorted order from the above table so not to mess around with the results.

Thanks in advance

I have a field gmap  the data would be  a variation of this, the gmap data to place the map on the site. The rest of the string is in my code because I want to size the iframe etc. Whean I use an input form to update this field using Null data and using a simple text line like yellow, the script works, when I try and add data as below I get a 403 error, how can I resolve this? 

https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3573.197380400117!2d28.465316315605516!3d-26.41710627907957!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1e94d9c942963de9%3A0xc560ec1cd5d52b74!2sArrie%20Nel%20Nigel%20Pharmacy!5e0!3m2!1sen!2sza!4v1603786030983!5m2!1sen!2sza>

Code
Should I str_replace all the ! with asccii? or something else?

Hello and good day to all of you
I have passed my midterms project(Online Shopping) with a score of 94 in PHP ( Click here to see file ) ( Sorry if the design is too ugly, I'm just new in programming XD )
Now our finals project will be a PHP site again but now with a database in it.. So instead of making a new project/design for a site, why not just add a database to my existing midterms?
I would like to ask for some help here in helping me on connecting to the database, adding a database/tables and anything that would be of help like suggesting Databases would be like, - Users ( Admin and Members ) - Upper Clothing ( Shirts, Jackets, Long Sleeves, Raglan and etc ) - Lower Clothing ( Pants, Shorts, Boxers and etc ) - Stock on a current item
- Single member's Transaction History - All user's Transaction History   Is there a way that I could add those database named above to my project?
Thank you in advance!