PHP - I Want To Add A Note Field And A Check Box To My Page And I Think I Want To Record This Information In A Json File.

Hi, I just want to know how to check if a row/record already exists for a given table, but this code gives me message in browser: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in myTest.php

This is the the snippet I am running:
Code: [Select]
<?php
$connxn=mysql_connect("localhost","root");
$db=mysql_select_db("siliconvalley");
$toyNodePath="#document/siliconValleyHELLO";
$queryA=mysql_query("SElECT FROM pathexpress (path_express) WHERE path_express='$toyNodePath'");//make sure AT MOST ONE ROW EXISTS!!
if(mysql_num_rows($queryA)==1)
print "ALREADY IN table pathexpress!";
else {
mysql_query("INSERT INTO pathexpress (path_express) VALUES ('$toyNodePath')");
print "ADDED $toyNodePath to table pathexpress!";
}

?>
Please, any help is greatly appreciated!

json - how to check if this is installes on opensuse 13.1
  can i chek it with the terminal?

Hi All,

Please can someone help me with this bit of code. I have a mysql database with a table called 'events'. I have six fields namely 'ID, mxitID, type, message, ts, publish'.
I am trying to update the field 'publish' from Yes --> No or if it is already No then back to Yes again. I have two files then main one beacon.php and publish.php
Here is the code:

beacon.php
Code: [Select]
<?php
        // connect to the database
        include('connect-db.php');

        // display data in table
//        echo "<p><b>View All</b> | <a href='view-paginated.php?page=1'>View by Page</a></p>";
//   echo "Select your Carousel: ";
   
   // get results from database
        $result = mysql_query("SELECT * FROM events WHERE type='beacon'")
                or die(mysql_error());

        echo "<table border='1' cellpadding='10'>";
   echo "<a href='index.php'>b Back</a><br><br>";
        echo "<tr> <th>ID</th> <th>mxitID</th> <th>Type</th> <th>Message</th> <th>Timestamp</th> <th>Published</th> <th>Modify</th></tr>";

        // loop through results of database query, displaying them in the table
        while($row = mysql_fetch_array( $result )) {
                
                // echo out the contents of each row into a table
                echo "<tr>";
                echo '<td>' . $row['ID'] . '</td>';
                echo '<td>' . $row['mxitID'] . '</td>';
                echo '<td>' . $row['type'] . '</td>';
      echo '<td>' . $row['message'] . '</td>';
      echo '<td>' . $row['ts'] . '</td>';
      echo '<td>' . $row['publish'] . '</td>';
                echo '<td><a href="publish.php?id=' . $row['ID'] . '"><input name="update" type="submit" id="update" value="Update"></a></td>';
                echo "</tr>"; 
        } 
        // close table>
        echo "</table>";
?>

publish.php
<?php

 // connect to the database
 include('connect-db.php');

 // get id value
 $id = $_GET['id'];
echo "$id";

 $sql="SELECT * FROM events WHERE type='beacon'";
$result=mysql_query($sql);


$active=($result['publish']=='')?'Yes':'No';
echo "$active";

if ($active='Yes') {
    $active='No';
 } else {
    $active='Yes';
}
$sql = "UPDATE events SET publish='$active' WHERE ID='$id'";
$result = mysql_query($sql);

// header("Location: beacon.php");
?>

I cant seem to change the value...any help would be much appreciated. Thank you in advance.

MOD EDIT: code tags added.

Hello Everyone,

I have a PHP code that reads data from db table. Then it converts it into JSON and show it. However if data table field has - or so then it gives json error.

For e.g.

if($num > 0){
			while($res = mysqli_fetch_array($query)){
				
				$NDate = $res['NDate'];				
				$Summary = substr($res['Summary'],0,256);				
				
				/* CREATE ARRAY FOR SHORT TERM NEWSLETTER */
				$newsletters[]=array('newsletter'=>array("RecID"=>$SNo,"Summary"=>$Summary));
				
			}
			/* JSON OUTPUT*/
			$json = array("AuthOK" => 'True',"newsletters"=>$newsletters);
	
header('Content-type: application/json');
echo json_encode($json);

How to solve the issue ?

Regards,
GR

Yesterday, I created a topic about how I could update records and I managed to achieve that successfully.

Now I have another dilemma.

When I have a specific record I want to update, I want to change a category ID of an product (e.g. change it from 1 to 2) but how do I go about doing this?

Here is my code thus far:

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$id=$_GET['prodID'];

$results = mysqli_query($dbc, "SELECT * FROM product WHERE prodID=".$_GET['prodID']."");
$row = mysqli_fetch_assoc($results);

?>
<form action="" method='POST'>
Product ID: <input type="text" value="<?php echo $row['prodID'];?>" name="prodID" /> <br />
Product: <input type="text" value="<?php echo $row['product'] ;?>" name="product" /> <br />
Product Description: <input type="text" value="<?php echo $row['prod_descr'] ;?>" name="prod_descr" /> <br />
Category:
<select name="category">
<option value="<?php echo $row['catID'];?>"></option>
</select>
Price: <input type="text" value="<?php echo $row['price'] ;?>" name="price" /> <br />
In Stock: <input type="text" value="<?php echo $row['stock'] ;?>" name="stock" /> <br />
<br /><input type="submit" value="save" name="save">
</form>

<?php

if(isset($_POST['save']))
 {
    $id = $_POST['prodID'];
    $product = $_POST['product'];
$descr = $_POST['prod_descr'];
$price = $_POST['price'];
$stock = $_POST['stock'];

// Update data
    $update = mysqli_query($dbc, "UPDATE product SET product='$product', prod_descr='$descr', price='$price', stock='$stock' WHERE prodID=".$_GET['prodID']."");
header( 'Location: update_save.php' ) ;
}
?>

Hi,

I have a script that dumps the information from one of my MySQL tables into a CSV. The script works great, but in the result, the names of the MySQL columns are shown as-is. In other words, I have a column named "field4" that shows up as "field4" in the CSV. How can I modify the columns to more descriptive names without modifying the database itself?

Here's my code:
Code: [Select]
<?php
$host = "*********";
$user = "*********";
$pass = "*********";
$db = "database_name";
$table = "table";
$file = "member_information";

$link = mysql_connect($host, $user, $pass) or die("Cannot connect." . mysql_error());
mysql_select_db($db) or die("Cannot connect.");

$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;

if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].",";
$i++;}
}
$csv_output .= "\n";
$values = mysql_query("SELECT * FROM ".$table."");

while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j].", ";
}
$csv_output .= "\n";
}

$filename = $file."_".date("m.d.y");

header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("m.d.y") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");

print $csv_output;

exit;
?>

The CSV it spits out looks like this:
Code: [Select]
field1    field2     field3    field 4
info      info        info       info

I want it to look like this:
Code: [Select]
Name      Email      Location      Age
info         info          info             info

Thanks in advance!

There are 50 csv files. each csv file have the same column's name. some content in the column are the same, some don't.

eg：test1.csv,  example1.csv, hello.csv,  world.csv.......test70.csv.
now, i want to make a change to two column's content.

a, all csv files have a column named qty. whose rows content are all 0. now, i want to change it into Code: [Select]
888
b, all csv files have a column named image. whose rows content are all

Code: [Select]
upload/img1.jpg
 upload/img2.jpg
 upload/img3.jpg
 upload/img01.jpg
 upload/img14.jpg
 upload/img01.jpg
.......If i open each csv file then do a search and replace. i fell it too bored.

Thank you in advance.


i want to delete Uploadin the image column, change 0 to 888 in the qty column.

i using the file change.php to update the record.

one csv file. http://phplist.xxmn.com/women.csv



the code:

Code: [Select]
<?php
$dir    = getcwd();
$files = array_diff(scandir($dir), array('..', '.','change.php'));
foreach ($files as $file) {
    if (($handle = fopen($file, "r")) !== FALSE) {
        $new_content = '';
        while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
            //var_dump($data);
           $data[2]=888; 
            $new_content .= implode(',', $data);
            //var_dump($new_content);
        }
       file_put_contents($file, $new_content);
        echo 'down';
    }
}

?>
the code doesn't work how to correct it . thank u

I have a php script defined that parsed the xml file and runs through the 1st record - encased within the EOF tags.
However, I need to capture ALL records - each defined between "EOF" tags - of the select xml file that will be pass to the script.

Currently, the php script I have finds the 1st set of info from the xml file but doesn't loop through the remaining records which all encased between the "EOF" tags. I know I need a while loop but not sure on the syntax to get it through the remaining files. Any comments appreciated to help edit code to form the required loop:


$xml = simplexml_load_file($new_location);
        foreach($xml->EOF as $eof) {
             $autoNoT  = $eof->AutoNo;
             $vegregnoT = $eof->TruckNo; 
             $clientIDT  = $eof->ClientID;
}


Here's the example xml file which contains multiple records that I need to extract each set of date between the <EOF></EOF> tags.
Note: the above php code extract just the 1st record then stops (I know I'm missing the loop but need help defining it...)

Code: [Select]
- <DocumentElement>
- <EOF>
  <AutoNo>109531</AutoNo>
  <TruckNo>XLX885GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109532</AutoNo>
  <TruckNo>ZFN726GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109533</AutoNo>
  <TruckNo>ZFP113GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109534</AutoNo>
  <TruckNo>WSG299GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
- <EOF>
  <AutoNo>109872</AutoNo>
  <TruckNo>XKR493GP</TruckNo>
  <ClientID>3</ClientID>
  </EOF>
</DocumentElement>

Hi, As I am new to PHP and JSON my Interest in the field pushes me to know further. I have successfully parsed a JSON file:
{
"birthdays": [
"319507200" :"Kyle",
"1390435200" :"Noah",
"307843200" :"Carla"
]
} Using this PHP file:
<?php
$jsondata = file_get_contents("birthdays.json");
$json = json_decode($jsondata,true);
echo $json["birthdays"][0]['1390435200'];
?>

Now I would like to know how to display when Noah’s birthday is, in the form yyyy/MM/dd. Can an expert tell me how this would be done?

Thank you :-)

Hi Everyone,

i need some help how can i save this jsonfile to the webserver? 

my code

       // Load initial values from JSON 'file'
    jsonfile = '[{"lane 1":"1","lane 2":"1","lane 3":"5","lane 4":"2"}]';
    var initialstate = JSON.parse(jsonfile);
    setLaneState("lane1",initialstate[0]['lane 1'])
    setLaneState("lane2",initialstate[0]['lane 2'])
    setLaneState("lane3",initialstate[0]['lane 3'])
    setLaneState("lane4",initialstate[0]['lane 4'])

 

Hello
I am using curl to get a json file which can be located he (It's way too long to copy paste it): http://www.opap.gr/web/services/rs/betting/availableBetGames/sport/program/4100/0/sport-1.json?localeId=el_GR

After that i use json_decode to get the assosiative array.Till here everything seems ok.When i am using var_dump the characters inside the array are in Greek.After that i am using the following code:

Code: [Select]
class ArrayToXML {

public static function toXML( $data, $rootNodeName = 'ResultSet', &$xml=null ) {

    // turn off compatibility mode as simple xml throws a wobbly if you don't.
    if ( ini_get('zend.ze1_compatibility_mode') == 1 ) ini_set ( 'zend.ze1_compatibility_mode', 0 );
    if ( is_null( $xml ) ) //$xml = simplexml_load_string( "" );
        $xml = simplexml_load_string("<?xml version='1.0' encoding='UTF-8'?><$rootNodeName />");

    // loop through the data passed in.
    foreach( $data as $key => $value ) {

        $numeric = false;

        // no numeric keys in our xml please!
        if ( is_numeric( $key ) ) {
            $numeric = 1;
            $key = $rootNodeName;
        }

        // delete any char not allowed in XML element names
        `enter code here`$key = preg_replace('/[^a-z0-9\-\_\.\:]/i', '', $key);

        // if there is another array found recrusively call this function
        if ( is_array( $value ) ) {
            $node = ArrayToXML::isAssoc( $value ) || $numeric ? $xml->addChild( $key ) : $xml;

            // recrusive call.
            if ( $numeric ) $key = 'anon';
            ArrayToXML::toXml( $value, $key, $node );
        } else {

            // add single node.
            $value = htmlentities( $value );
            $xml->addChild( $key, $value );
        }
    }

    // pass back as XML
    return $xml->asXML();


}
public static function isAssoc( $array ) {
    return (is_array($array) && 0 !== count(array_diff_key($array, array_keys(array_keys($array)))));
}


And here comes the problem .All the greek characters inside the result are in some strange characters Code: [Select]
&Icirc;?&Icirc;?&Icirc;&yen;&Icirc;?&Icirc;?&Icirc;&iexcl;&Icirc;&copy;&Icirc;&pound;&Icirc;?&Icirc;? for example.I really don't know what am i doing wrong.I am really bad with encoding /decoding things .

Thanks in advance for your replies.

PS:I have also Code: [Select]
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> in the page i display the result but it doesnt help.

I actually have two parts to this post.  One which describes just my understanding on how a multipart request should look with a REST API and gives a little context, and the second how to actually implement it using Sympony and api-platform.

Part 1

Looking to simultaneously upload a file, some file meta data, and identifier of the uploading user to a REST API, and will do so using a multipart request.

Based on swagger, looks like the request should look something like the following:

POST /upload HTTP/1.1
Content-Length: 428
Content-Type: multipart/form-data; boundary=abcde12345
--abcde12345
Content-Disposition: form-data; name="id"
Content-Type: text/plain
123e4567-e89b-12d3-a456-426655440000
--abcde12345
Content-Disposition: form-data; name="address"
Content-Type: application/json
{
  "street": "3, Garden St",
  "city": "Hillsbery, UT"
}
--abcde12345
Content-Disposition: form-data; name="profileImage "; filename="image1.png"
Content-Type: application/octet-stream
{…file content…}
--abcde12345--

Background noise... The above example shows three parts which include the text ID, JSON address and octet-stream file.  Doing so doesn't make sense to me and I will probably just have two parts for the meta data JSON.  Note that potentially, I will be removing the user from the JSON payload and including it in some JWT header.  Also, showing resources as links such as /api/users/1 in the request and response JSON is new to me, but I guess makes sense.

Regardless, my meta data JSON will look like:

{
    "projectId": 1234,
    "documentDescription": "bla bla bla",
    "specification": "230903.2.4.D",
    "user": "/api/users/1"
}

and the response will look like:

{
    "projectId": 1234,
    "documentDescription": "bla bla bla",
    "specification": "230903.2.4.D",
    "uploadAt": "2021-01-27 08:41:17",
    "fileName": "pressuresensor.pdf".
    "user": "/api/users/1".
    "file": "/api/uplodaed_files/1234"
}

Am I somewhat going down the right path?

Part 2

Wow, should have looked into Sympony before now!  Entities, validation, the API, etc were a breeze.  Still confused with some of the "magic", but understanding what is under the hood more and more.

As stated initially, I am utilizing api-platform and am looking at api-platform's file-upload.

I guess the first question is whether my POST request with both the file and JSON meta data can be performed in a single request.

Per making-a-request-to-the-media_objects-endpoint:

Quote

Your /media_objects endpoint is now ready to receive a POST request with a file. This endpoint accepts standard multipart/form-data-encoded data, but not JSON data.

What?  Am I reading this correct?  Do I first need to make a multipart requests using either a standard HTML form or a XMLHttpRequest which just sends the file, receive the document locator, and then send a second request with the location and my meta data?

If so, I guess I have enough to go forward.  I would rather, however, perform the work in a single request.  My previous mentioned swagger multipart-requests shows both in the same request.  symfonycasts's api-uploads also describes doing so, but not with api-platform.  Is there a way to do so with api-platform?  Does it make sense to use api-platform for all other routes but then make a custom route for document with meta data uploads?  Any recommendations are much appreciated.

Thanks

I got some code to make a simple quiz, but I'm struggling to get it to work. I think the form and the following JavaScript code are set up correctly, but I'm running into problems with the PHP code at the end. I'm especially confused by the JSON reference at the very end; I don't have a clue what it means or what do do with it.   Does anyone know how to fix/complete this script?   On another note, why is it necessary to use JSON in the first place? Aren't the answers already provided in the PHP code (e.g. $answer1 = $_POST['A']?   Thanks.  

<form action="">
    <fieldset>
        What color is an apple?
        <label>blue <input type="radio" value="A" name="question-1"></label>
        <label>red <input type="radio" value="B" name="question-1"></label>
        <label>yellow <input type="radio" value="C" name="question-1"></label>
        <label>gray <input type="radio" value="D" name="question-1"></label>
    </fieldset>
    <fieldset>
        What color is a banana?
        <label>yellow <input type="radio" value="A" name="question-2"></label>
        <label>blue <input type="radio" value="B" name="question-2"></label>
        <label>red <input type="radio" value="C" name="question-2"></label>
        <label>gray <input type="radio" value="D" name="question-2"></label>
    </fieldset>
    <fieldset>
        What color is the sky?
        <label>yellow <input type="radio" value="A" name="question-3"></label>
        <label>blue <input type="radio" value="B" name="question-3"></label>
        <label>red <input type="radio" value="C" name="question-3"></label>
        <label>gray <input type="radio" value="D" name="question-3"></label>
    </fieldset>
    <fieldset>
        What color is snow?
        <label>white <input type="radio" value="A" name="question-4"></label>
        <label>blue <input type="radio" value="B" name="question-4"></label>
        <label>red <input type="radio" value="C" name="question-4"></label>
        <label>gray <input type="radio" value="D" name="question-4"></label>
    </fieldset>
  <input type="button" value="Submit" class="submit" id="Submit2">
</form>
 
<script>
$(function(){
 
    // Trap the form submit event
    $('form').submit(function(e){
        e.preventDefault() // Prevent browser refresh
        var answers = $(this).seralize()
 
        // Manually send the data with AJAX
        $.post({
            url: $(this).attr('action'),
            data: answers,
 
            // Stuff to do after we get a response
            success: function(response){
                $('#results').text(response.correct)
            }
        })
    })
})
</script>
 
<?php 
$answer1 = $_POST['A'];
$answer2 = $_POST['A'];
$answer3 = $_POST['C'];
$answer4 = $_POST['D'];
$totalCorrect = 0;
if ($answer1 == "B") { $totalCorrect++; }
if ($answer2 == "A") { $totalCorrect++; }
if ($answer3 == "B") { $totalCorrect++; }
if ($answer4) { $totalCorrect++; }
 
// Send the data back as JSON
die json_encode(array(
    'correct'    => $totalCorrect;
));
?>

Hey all. What is the best way to check if a form field has been entered by the user? Because a field left blank by the user still shows up as set with the isset function.

Example:
if (isset($_POST['name']))
{
echo "The field is set";
}

This is a problem if I'm checking if the user has skipped over the name field on a form because an empty value gets passed to the POST array even if the field is left blank.

Do people use empty or a regular expression instead?

Cheers!

I have this script running:


<?php
$query = mysql_query("SELECT * FROM jobs WHERE event = 'Yes' ORDER BY title");
while ($row = mysql_fetch_array($query)) {
?>


How do I check if a field is empty and NOT display it...?

For instance it has a 'applied' field, if that is empty I dont want it to display, however I still  need the event = 'Yes' part.