PHP - Convert Input Text Into Images Based On Alphabet

Well the topic may not sound very explicit. So I'll do my best to explain it here. I have a pull down menu as part of a form, which contains the months of the year. I'm trying to store the value of this form entry using the $_POST['month'] variable into a database but first, I need to convert the month values into their corresponding integer values( that is 1 for January, 2 for February etc), in order to easily do date calculations later down the road. Any ideas about how to do this? It may be helpful to include the code for the pull down menu.
Code: [Select]
<p><tab> Date of Birth: <?php //Make the month pull down menu.
//Array to store months. 
$months = array (1 => 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); 
print '<select name= "month">';
foreach ($months as $key => $value) {
    print "\n<option value=\"$key\">$value</option>";
}
print '</select>'; ?> </tab>
 

<tab>  <?php //Make the day pull down menu
print '<select name= "day">';
for ($day = 1; $day <= 31; $day++) {
    print "\n<option value=\"$day\">$day</option>";
}
print '</select>'; ?> </tab>

<tab><?php //Make the year pull down menu 
print '<select name= "year">';
$start_year = date('Y');
for ($y = ($start_year - 18); $y >= 1900; $y--) {
    print "\n<option value=\"$y\">$y</option>";
}
print '</select>'; ?> </tab> </p>

I am using PHP's GD to resize uploaded images and create new ones for security purposes.

Should I leave the converted files in their native format (e.g. PNG ---> PNG) or should I convert all images to JPG (i.e. PNG ---> JPEG)??

Thanks,


Debbie

P.S.  Should it be ".jpg" or ".jpeg"

im making a system where people can search by letter of my forum users here is my code:


Code: [Select]
foreach(range('A','Z') as $i) $l.= $i;
now i am echoing out $l  wherever i want

How do I make it so I i can add a hyperlink or a URL for each character? (inside the foreach) so I don't have to manually do it

Hi   I have a form that has a drop-down with a few to choose from, unfortunately I don't get results for some due to the query involved. Some need the AND channel LIKE '%$channel%'"; and some don't and therefore will not get desired results. So I would like to run two queries one with and one without.   $query = "SELECT * FROM asterisk_cdr WHERE calldate BETWEEN '$calldate' AND '$calldate2' AND clid LIKE '%$clid%' AND channel LIKE '%$channel%'";   Thanks  

im wanting to change the sql in my query based on if a field is empty or not. if the field is empty then i dont want it to post anything, but if its not empty then it can post the content. heres what i have so far but it does post the content even if the field is empty.


(!empty($password)) ? $pass_sql = "u_password = '$password'," : $pass_sql = null;

$link->query("UPDATE ".TBL_PREFIX."users
                SET 
                $pass_sql
u_allow_user_pm = '".$_POST['allow_user_pm']."'
                WHERE u_username = '".$_POST['user_name']."'")
                or die(print_link_error());


how can i stop it from updating if the field is empty?

Hello all, looking for some help here as I seem to be fairly stuck... this yields no results at all and I give up, I need help! The user should be able to select an employee from a select field, and based on their selected we should be able to grab the start time and end time of that empoyee, which resides on the database.   My form:

<form action=".php" name="absence" id="absence" method="post">

Employee:
<select name="empid" class="clockinputs" required> 
<option value=""></option>
<option value='20'>Bob Jones</option>
<option value='13'>Bob Phones</option>
<option value='93'>Bob Lomes</option>
<option value='30'>Bob Somes</option>
<option value='107'>Bob Pomes</option>
<option value='74'>Bob Womes</option>
</select>

Shift Start: <input type="text" name="startshift" id="startshift" class="clockinputs" data-inputmask="'mask': '99:99:99'" required>
Shift End: <input type="text" name="endshift" id="endshift" class="clockinputs" data-inputmask="'mask': '99:99:99'" required>

<input type="hidden" name="eid" value="<?php echo $row{'EID'}; ?>">
<input type="submit" value="Save">
</form>

Javascript:

<script type="text/javascript">
    jQuery(document).ready(function(){
        jQuery('#empid').live('change', function(event) {
            $.ajax({
                url     : 'absence-get.php',
                type    : 'POST',
                dataType: 'json',
                data    : $('#absence').serialize(),
                success: function( data ) {
                       for(var id in data) {        
                              $(id).val( data[id] );
                       }
                }
            });
        });
    });
    </script>

And absence-get.php:

<?php
$e = $_POST['empid'];

$result = mysql_query("SELECT * FROM employees WHERE EID='$e' ");
$row = mysql_fetch_array($result, MYSQL_ASSOC)

$startshift = $row{'startshift'};
$endshift = $row{'endshift'};

$arr = array( 'input#startshift' => $startshift , 'input#endshift' => $endshift );
echo json_encode( $arr );
?>

Anyone spot anything? Thank you!

Hi,

I have a question here. Currently my $tutor_id is auto incremental in my SQL, and it is in running numbers.

However I will like to add a 'T' in front of the id.

Example:

Currently, our id number is
1
2
3
4
etc.

Would like to achieve
T1
T2
T3
T4
etc.

How do I do it? Below is my code as well. Please kindly advise. Thanks


/**INSERT into tutor_id table to create a new id for new tutors**/
   $query = "INSERT INTO tutor_id (id) " .
   "VALUES ('$id')";
   
   $results = mysqli_query($dbc, $query)
   or die(mysqli_error());

   $tutor_id = mysqli_insert_id($dbc);

/**INSERT into tutor table**/
   $query1 = "INSERT INTO tutor (tutor_id, email) " .
   "VALUES ('$tutor_id', '$email')";
   
   $results1 = mysqli_query($dbc, $query1)
   or die(mysqli_error());

Hi there,

I found a Javascript with what I want, but I want it to be in PHP because if people don't have Javascript enabled, they won't see the login. 

Here is what I have, but I need it to be converted to PHP:

Code: [Select]
function loginArea() {
val = document.loginForm.password.value;

switch(val) {
case "password1":
document.location = 'http://www.google.com/password1-page/';
break;

case "password2":
document.location = 'http://www.google.com/password2-page/';
break;

default:
document.location ='http://www.google.com/sorry/';
break;
}
}
Code: [Select]
<form name="loginForm" id="loginForm" method="post" action="">
    <input name="password" type="text" id="password" maxlength="5" />
    <input name="login" type="button" id="login" value="Check" onclick="loginArea()" />
</form>
Help?

 - Steph

Hi people, I really hope you guys can help me out today. I'm just a newbe at php and i'm having real trouble.

Bassically all I want to do is have a user type in a company name in a html form.

If what the user types in the form matches the company name in my php script i want the user to be sent to another page on my site.

If what the user types in the form doesnt match the company name in my php script i want the user to be sent to a differnt page like an error page for example.

this is my html form:

Code: [Select]
<form id="form1" name="form1" method="post" action="form_test.php">
  <p>company name:
    <input type="text" name="company_name" id="company_name" />
  </p>
  <p>
    <input type="submit" name="button" id="button" value="Submit" />
  </p>
</form>
And this is the php code I'm trying to process the information on:

Code: [Select]
<?php

$comp_name = abc;

if(isset ($_POST["company_name"])){
 if($_POST["company_name"] == $comp_name){

     header("Location: http://www.hotmail.com");
exit();
 }

else{
   header("Location: http://www.yahoo.com");
exit();   
 }
}
?>
The thing is i'm getting this error when i test it:
Warning: Cannot modify header information - headers already sent by (output started at D:\Sites\killerphp.com\form_test.php:10) in D:\Sites\killerphp.com\form_test.php on line 17

Please can some one help me out, i'm sure this is just basic stuff but i just cant get it to work 

Cheers.

What I'm trying to do here is generate a table based on a form in which the user selects two options. The first option tells the script which database entries to put in the table, the second option tells it how to arrange them. The first works perfectly, the second not at all - it doesn't produce an error, it just doesn't do anything. I've found a number of tutorials that seem to suggest that the problem is somewhere in my punctuation around ORDER BY '$POST[sort]' but I've been unable to find a solution that actually works. Any help would be much appreciated, my code is below.

Thank you!



mysql_select_db($database, $con);

$result = mysql_query("SELECT * FROM main WHERE state='$_POST[state]' ORDER BY '$POST[sort]'");
if(mysql_num_rows($result)==0){
 echo "<p align='left'>View Pantries by State</p><div id='stateform'>
<form action='../admin/viewstate.php' method='post'> <select name='state' />
<option value='AL'>Alabama</option>
<option value='AK'>Alaska</option>
<option value='AZ'>Arizona</option>
</select>
<select name='sort' />
<option value='name'>Name</option>
<option value='id'>Id</option>
<option value='city'>City</option>
<option value='zip'>Zip</option>
<option value='timestamp'>Timestamp</option>
</select>
<input type='submit' value='Go'></input></form>
</div>";
}
else{
echo "<p align='left'>View Pantries by State</p> <div id='stateform'>
<form action='../admin/viewstate.php' method='post'> <select name='state' />
<option value='AL'>Alabama</option>
<option value='AK'>Alaska</option>
<option value='AZ'>Arizona</option>
</select>
<select name='sort' />
<option value='name'>Name</option>
<option value='id'>Id</option>
<option value='city'>City</option>
<option value='zip'>Zip</option>
<option value='timestamp'>Timestamp</option>
</select>
<input type='submit' value='Go'></input></form>
</div>";
echo "<div id='fptext'><span class='h1'>Food Pantries for " . $_POST['state'] . "</span><br><br></div>"; }
echo "<table border='1' align='center' cellpadding='3' width='900px'>
<tr>
<th>ID</th>
<th>Name</th>
<th>Type</th>
<th>Address</th>
<th>State</th>
<th>Phone</th>
<th>E-mail</th>
<th>Website</th>
<th>Hours</th>
<th>Requirements</th>
<th>Additional Information</th>
<th>Lat</th>
<th>Lng</th>
<th>Update</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['type'] . "</td>";
  echo "<td>" . $row['address'] . "</td>";
  echo "<td>" . $row['state'] . "</td>";
  echo "<td>" . $row['phone'] . "</td>";
  echo "<td>";
  echo "<a href=mailto:".$row['email'].">".$row['email']."</a>";
  echo "</td>";
  echo "<td>";
  echo "<a href=".$row['website']."\>".$row['website']."</a>";
  echo "</td>";
  echo "<td>" . $row['hours'] . "</td>";
  echo "<td>" . $row['requirements'] . "</td>";
  echo "<td>" . $row['additional'] . "</td>";
  echo "<td>" . $row['lat'] . "</td>";
  echo "<td>" . $row['lng'] . "</td>";
  echo "<td><a href='../public/updatepage.php?id=".$row['id']."'>Update Pantry</a></td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

So I'm trying to basically trying to make an "advanced search" function in PHP/mysql that will allow users to search by a number of different options like search by zipcode, username, gender, etc.

Now my question is how do I vary my mysql query so that it searches for all these things based on whatever the user inputs?

For example, the user might need to search zipcode and username but not gender, but in another case, might need to search username and gender, but not zipcode. Obviously I could just do some if/else statements, but that would be increasingly more difficult as there are more fields.

What can I do?

We recently upgraded from PHP4 to PHP5 and the below script that was working perfectly in 4 has completely stopped working and I can't figure out why for the life of me. I'm not an experienced PHP programmer--I've done some forms, but this is the first time I've used a database.

What needs to (and was) happen: A user enters their username in the form and gets a readout of their participation so far that month.

The problem(s): I know that it's storing the variable 'user' because it echoes it back properly, but the database is no longer allowing me to select the row based on that variable. I know it's not that I can't connect to the database because if instead of '$user' I change the code to a username I know is in there, I get the proper readout. This all started as soon as I transferred over to PHP5--before that, no problems at all.

The database information is all correct, I just took it out for privacy's sake.

<form id="feedback" method="post" action="index.php">

<input name="user" type="text" value="Enter user name" size="20" maxlength="50" /><br />

<input name="send" id="send" type="submit" value="Submit" />
</form>
<?php
if (isset($_POST['user'])) { 
$_session['user'] = $_POST['user'];
} 
?>

<p>You entered your username as: <strong><? echo $_session['user'];?></strong>. If this is not correct or you do not see your information below, please re-enter your username and click Submit again.</p>

<?php
$con = mysql_connect("database","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);

$result = mysql_query("SELECT * FROM March WHERE Username='$user'") or die ('Error: '.mysql_error ());

while($row = mysql_fetch_array($result))
  {
  echo "<table border='0'>";
  echo "<tr>";
  echo "<td><strong>Username:</strong> </td><td>" . $row['Username'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 2 Discussion:</strong></td><td>" . $row['Mar2Q'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 2 Poll:</strong></td><td>" . $row['Mar2P'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 9 Discussion:</strong></td><td>" . $row['Mar9Q'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 9 Poll:</strong></td><td>" . $row['Mar9P'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 16 Discussion:</strong></td><td>" . $row['Mar16Q'] . "</td></tr>";
  echo "<tr><td><strong>Mar. 16 Poll:</strong></td><td>" . $row['Mar16P'] . "</td></tr>";
  echo "<tr><td><strong>March Participation To-Date:</strong></td><td>" . $row['Participation'] . "</td></tr>";
  echo "</tr>";
  } 
  echo "</table>";

mysql_close($con);
?> 

ANY help would be greatly appreciated! I've got a couple hundred people who use this on a regular basis and are starting to ask why it's not working.

I need to create a SEO friendly string only from alphanumeric and characters of my native language. It is sinhala.

My expected string should be something like this:

$myString = "this-is-a-දහසක්-බාධක-දුක්-කම්කටොලු-මැදින්-ලෝකය-දිනන්නට-වෙර-දරන";

I am using a function to create the string like this. And that function is as follow:

function seoUrl($string) {
    //Lower case everything
    $string = strtolower($string);
    //Make alphanumeric (removes all other characters)
    $string = preg_replace("/[^a-z0-9_\s-]/", "", $string);
    //Clean up multiple dashes or whitespaces
    $string = preg_replace("/[\s-]+/", " ", $string);
    //Convert whitespaces and underscore to dash
    $string = preg_replace("/[\s_]/", "-", $string);
    return $string;
}

This function only works for English characters and output of above string as below:

$title = seoUrl("this-is-a-දහසක්-බාධක-දුක්-කම්කටොලු-මැදින්-ලෝකය-දිනන්නට-වෙර-දරන");
echo $title; // this-is-a-

I modified this function using `mb_ereg_replace` as below:
 

function seoUrl($string) {
    //Lower case everything
    //$string = strtolower($string);
    //Make alphanumeric (removes all other characters)
    $string = mb_ereg_replace("/[^a-z0-9_\s-]/", "", $string);
    //Clean up multiple dashes or whitespaces
    $string = mb_ereg_replace("/[\s-]+/", " ", $string);
    //Convert whitespaces and underscore to dash
    $string = mb_ereg_replace("/[\s_]/", "-", $string);
    return $string;
}

But is not working for me.

Can anybody tell me how to modify above function to get all my characters (including my native language characters)

Hope somebody may help me out. Thank you.

Edited January 28, 2019 by thara

I wonder whether someone may be able to help me please. I'm fairly new to PHP programming so please bear with me.

I currently have a HTML user input form, where two of the fields are dependable drop down boxes. The user selects text values from these and, along with other pieces of information, the record is saved to a mySQL database. However, rather than saving the text value I save the 'id' field value for each selection made.

On another 'Read Only' form, the user can then go back to have a look at the records they have previously saved.

The problem I have is that rather than the user being able to see the text values selected from the drop down menus, they can only see the id for each of the selections made. I just wondered whether it would be at all possible please that someone could show me what I need to do so that the user can see the 'text' rather than the 'id' value from the selections they have made.

The code that I am using to load the information into the read only form is below.

Code: [Select]
<?php 
require("phpfile.php"); 

// Start XML file, create parent node 

$dom = new DOMDocument("1.0"); 
$node = $dom->createElement("markers"); 
$parnode = $dom->appendChild($node); 

// Opens a connection to a MySQL server 

$connection=mysql_connect ("hostname", $username, $password); 
if (!$connection) { die('Not connected : ' . mysql_error());} 

// Set the active MySQL database 

$db_selected = mysql_select_db($database, $connection); 
if (!$db_selected) { 
die ('Can\'t use db : ' . mysql_error()); 
} 

// Select all the rows in the table 

$query = "SELECT findid, locationid, detectorid, searchheadid "; 

$result = mysql_query($query); 
if (!$result) { 
die('Invalid query: ' . mysql_error()); 
} 

header("Content-type: text/xml"); 

// Iterate through the rows, adding XML nodes for each 

while ($row = @mysql_fetch_assoc($result)){ 
// ADD TO XML DOCUMENT NODE 
$node = $dom->createElement("marker"); 
$newnode = $parnode->appendChild($node); 
$newnode->setAttribute("findid",$row['findid']); 
$newnode->setAttribute("locationid",$row['locationid']); 
$$newnode->setAttribute("detectorid",$row['detectorid']);
$newnode->setAttribute("searchheadid",$row['searchheadid']);
} 

echo $dom->saveXML(); 

?> 

The two fields concerned are 'detectorid' and 'searchheadid'. The tables holding the 'id' and 'text' values for each are in the following tables 'detectors' and searchheads'.

Many thanks and kind regards

Chris