PHP - Moved: Having One Item In A While Loop Diffrent From The Rest

I have a script that seems to work well to insert a bookmark into a users database when he/she is logged into the system but I am having a hard time figuring out how I would go about making a work-a-round for having an item selected before being logged in, and inserted after they have logged in or registered.

For example, I would like a user to be able to select an Item to add to bookmark whether that user is logged in/registered or not and if they are not, they would be greeted with a login/registration form and after successful login the add bookmark script would be initiated on the item previously selected.

What I've got this far:

Simple form to add bookmark:

<form name="bm_table" action="add_bms.php" method="post">
<input type="text" name="new_url" value="http://" />
<input type="submit" value="Add Bookmark"/>
</form>


Then I have the add bookmark script:

BEGIN php

$new_url = $_POST['new_url'];

try {
    check_valid_user();  //cannot get past this part since it ends the script....code below
    if (!filled_out($_POST)) {
      throw new Exception('Form not completely filled out.');
    }
    // check URL format
    if (strstr($new_url, 'http://') === false) {
       $new_url = 'http://'.$new_url;
    }

    // check URL is valid
    if (!(@fopen($new_url, 'r'))) {
      throw new Exception('Not a valid URL.');
    }

    // try to add bm
    add_bm($new_url);
    echo 'Bookmark added.';

    // get the bookmarks this user has saved
    if ($url_array = get_user_urls($_SESSION['valid_user'])) {
      display_user_urls($url_array);
    }
  }
  catch (Exception $e) {
    echo $e->getMessage();
  }

END php


Checking valid user - the portion I cannot get past in the above script:


function check_valid_user() {
// see if somebody is logged in and notify them if not
  if (isset($_SESSION['valid_user']))  {
      echo "Logged in as ".$_SESSION['valid_user'].".<br />";
  } else {
     // they are not logged in
     do_html_heading('Problem:');
     echo 'You are not logged in.<br />';
     do_html_url('login.php', 'Login');
     do_html_footer();
     exit;
  }
}



How would I go about modifying the script so that a user could fill in the form (later it would be a link...obviously they probably wouldn't be filling in a form that is log-in specific - but same concept I think)

Thanks in advance for the help!

tec4

Hello, im looking for some help if anyone can be of help... i want to read from a file each line of that file, for each line search the database for that line found in the file and return what comes back, but i want it todo this for the whole file which could be up to 500 diffrent lines. what i have so far doesnt work ive tried a number of things including foreach() some of this could i got some somewhere else they said it worked for them.


$lines = file("/var/www/htdocs/mp32/playlist.lst"); 
   require('dbconfig1.php');//connect to db script 

while($n < count($lines))  {  //get number of lines in file or array 
        $recipeQuery = mysqli_query($conn1, "SELECT * FROM mp_id3_tags WHERE filename LIKE = '$lines[$n]'");   //query database for each one 
            while($recipeQuery1 = mysqli_fetch_array($recipeQuery))  
            {  
            print "{$recipeQuery1['artist']}";  
            }  
        $n = $n + 1;  
        } 

Hi there,

I think this is a big question but I'd appretiate any help you can provide!!
I have a list of items and subitems in a table that looks like this:

id    parent_id    title 1    0    House Chores 2    1    Take Out Trash 3    1    Clean Room 4    0    Grocery List 5    4    Eggs 6    4    Produce 7    6    Lettuce 8    6    Tomato 9    4    Milk
I want to display it like this:

(+) House Chores:
       > Take Out Trash
       > Clean Room

(+) Grocery List:
       > Eggs
       (+) Produce
            > Letutce
           > Tomato
       > Milk

 
So basically each entry in the table has an unique id and also a parent id if it's nested inside another item.
I "sort of" got it figured out in one way, but it doesnt really allow for nested subgroups. I'd like to know how would y'all PHP freaks to this

Also taking suggestions for the javascript code to expand/collapse the tree !!

Thank you!

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=346652.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=354677.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=315341.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306079.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=310594.0

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=358236.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333337.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=321230.0

Well I am looking to change this url

Code: [Select]
http://website.com/product.php?Item=2369
to

Code: [Select]
http://website.com/product.php?Item=Item-Name

Heres a snip of the code that handles that.

<?php include_once('mysql_connect.php');$id = (int)$_GET['Item'];?>()

any help would be appreciated.

Here is the scenario.

I created a niche market API which provides environmental data.  The data is obtained by industrial controllers which don't monitor anything by default, and the API has additional endpoints which are used to instruct the industrial controllers to start monitoring some parameter so the API can then start storing the trend data.  The API primarily responds with JSON, however, a couple of endpoints support CSV data.

For humans/webclients to access the data, I also created a webserver application which can be added to a Concrete5 (C5) CMS.  I tried to make as many of its endpoints do nothing except receive the webclient's request, add a JSON Web Token to it which contains a unique identifier, forward it to the API using cURL, and return the response as is to the webclient.  To limit the scope which needed to be created for the C5 application, the API has endpoints to return JSON which is used by JavaScript on the webclient for client-side validation, endpoints (actually, a different domain) to return static JavaScript/CSS/etc, and endpoints to restructure the JSON data to some more suitable format.

I now am looking at creating different applications which does not use C5, but either are 100% custom or use some other CMS such as Drupal, etc.  While I tried to limit the scope implemented on the C5 application, I have much more than I desire and will need to duplicate much for any future application.  The primary scope I would like to remove from the webserver application relates to the HTML views and consists of templates which create HTML from JSON, the JavaScript which interacts with the HTML, and to a lesser degree controllers to determine the type of view (i.e. a list of records or one specific detail record).

While the API will only be managed by myself, the intent is that the C5, 100% custom, etc webserver apps are installed and managed by others. 

Ideally, there is some existing Composer package for transforming JSON to HTML which is CMS agnostic, however, I don't know whether such exists.  Also, while not 100% necessary, ideally this functionality could exist on my server and not the individual web application's server.

Whether I build it myself or use some existing package, I expect it will need to do something like the following:

The various webserver apps will have some routing table to proxy the request either to my JSON API server (complete) or my new "HTML API Server" (remaining discusses this portion).

This HTML API server would generate the content either by making a cURL request to the main JSON API, or better yet since likely located on the same server have routing functional to make direct calls to the JSON API's methods, and return something like the following:

{
    "html": "<div>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Pharetra massa massa ultricies mi quis hendrerit dolor. Leo integer malesuada nunc vel risus commodo viverra.</div>",
    "javascript_files": [
        "https://resources.myserver.com/someFile.js",
        "https://resources.myserver.com/someOtherFile.js"
    ],
    "css_files": [
        "https://resources.myserver.com/someFile.css",
        "https://resources.myserver.com/someOtherFile.css"
    ]
}

The various applications would then take the HTML and resource files and insert them using their proprietary methods. 

EDIT.  Also, thinking of using an IFRAME, however, definitely have concerns with doing so.

My day job has nothing to do with software, however, am hoping to make it so.  Before embarking on this task, I would like to know whether some existing framework exists and if not what general strategy (organization, caching, etc) I should take to develop it.

Thanks

Edited January 18 by NotionCommotion
Added IFRAME idea

Hi guys. I'm new to php and struggleing with the REST POST for some reason....

I need to insert a contact into this accouting system http://help.saasu.com/api/#toc-http-post  search for Example: Insert Contact.

the data strcutre looks like:

Code: [Select]
<?xml version="1.0" encoding="utf-8"?>
<tasks>
  <insertContact>
    <contact uid="0">
      <salutation>Mr.</salutation>
      <givenName>John</givenName>
      <familyName>Smith</familyName>
      <organisationName>Saasy.tv</organisationName>
      <organisationAbn>777888999</organisationAbn>
      <organisationPosition>Director</organisationPosition>
      <email>john.smith@saasy.tv</email>
      <mainPhone>            02 9999 9999      </mainPhone>
      <mobilePhone>            0444 444 444      </mobilePhone>
      <contactID>XYZ123</contactID>
      <tags>Gold Prospect, Film</tags>
      <postalAddress>
        <street>3/33 Victory Av</street>
        <city>North Sydney</city>
        <state>NSW</state>
<postCode>2000</postCode>
        <country>Australia</country>
      </postalAddress>
      <otherAddress>
        <street>111 Elizabeth street</street>
        <city>Sydney</city>
        <state>NSW</state>
<postCode>2000</postCode>
        <country>Australia</country>
      </otherAddress>
      <isActive>true</isActive>
      <acceptDirectDeposit>false</acceptDirectDeposit>
      <directDepositAccountName>John Smith</directDepositAccountName>
      <directDepositBsb>000000</directDepositBsb>
      <directDepositAccountNumber>12345678</directDepositAccountNumber>
      <acceptCheque>false</acceptCheque>
      <customField1>This is custom field 1</customField1>
      <customField2>This is custom field 2</customField2>
      <twitterID>Contact twitter id</twitterID>
      <skypeID>Contact skype id</skypeID>
    </contact>
  </insertContact>
</tasks>

I only have to insert 3 mandatory fields whcih are in the below code snipit im using but nothings working...

Code: [Select]
//set POST variables
$service_url = 'https://secure.saasu.com/webservices/rest/r1/tasks?wsaccesskey=<key removed>';


       $curl = curl_init($service_url);

$fileds = array(
'insertContact' => array(
'contact' => array(
'givenName' => urlencode('John'),
'familyName' => urlencode('Smith'),
'organisationName' => urlencode('Saasy.tv')
)
)
);

       curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
       curl_setopt($curl, CURLOPT_POST, true);
       curl_setopt($curl, CURLOPT_POSTFIELDS, $curl_post_data);
       $curl_response = curl_exec($curl);
       curl_close($curl);
 
       $xml = new SimpleXMLElement($curl_response);
   



Please help, I'm not sure what I'm doing wrong....   

I want to create a REST  API for my website. What I want to do is to display advertisements from my database on websites that I sell to clients. Their website will call my database for advertisements to display on their websites. Also, I am performing a site validity check where the client's site would send the site URL, site name, and site token to my database for validation. If it returns false then the site will not display as it will be invalid according to my database. I've been Googling this topic all day, but cannot seem to get my head around it. I want to set an API key on my website so that not just anybody can be querying my database. For the advertisement query, no parameters need to be sent from the client websites to my database. Can anyone offer some advice on how to do this?