how to call variable in next page

See also questions close to this topic

• HTML tag not working in JavaScript

  I am outputting some information from my database using JavaScript. Some of this information includes HTML tags, such as <sub>. The error I'm getting in my browser is

  Invalid regular expression: missing /

  My guess is that JavaScript is having a problem with the closing tag in </sub>. How can I make a forward slash work in javascript?

  Here is some example code, in case you would need it:

  echo "
  <script>
  function wikitoCalculator() {
      document.getElementsByName('chemicalsearch')[0].value = $name;
      var userChemical = document.getElementsByName('chemicalsearch')[0].value;
      if (userChemical.toLowerCase() === 'vatten') {
          var formel = $vatten3[namn2];
          var massa = $vatten3[molmassa];
          document.getElementById('formel').innerHTML = formel;
          document.getElementById('atommassa').innerHTML = massa;
      } 
  }
  </script>
  ";
  

  As you can see, Im simply trying to output some information from a PHP variable that is taken from a database, through JavaScript into the HTML. Nothing is getting outputted, and Im getting the error stated above.
• 'Title Case' Fringe Case Issue - PHP

  I'm using this function to 'Title Case' titles:

  function titleCase ($title) {
  //remove HTML, storing it for later
  //       HTML elements to ignore    | tags  | entities
  $regx = '/<(code|var)[^>]*>.*?<\/\1>|<[^>]+>|&\S+;/';
  preg_match_all ($regx, $title, $html, PREG_OFFSET_CAPTURE);
  $title = preg_replace ($regx, '', $title);
  
  //find each word (including punctuation attached)
  preg_match_all ('/[\w\p{L}&`\'‘’"“\.@:\/\{\(\[<>_]+-? */u', $title, $m1, PREG_OFFSET_CAPTURE);
  foreach ($m1[0] as &$m2) {
      //shorthand these- "match" and "index"
      list ($m, $i) = $m2;
  
      //correct offsets for multi-byte characters (`PREG_OFFSET_CAPTURE` returns *byte*-offset)
      //we fix this by recounting the text before the offset using multi-byte aware `strlen`
      $i = mb_strlen (substr ($title, 0, $i), 'UTF-8');
  
      //find words that should always be lowercase…
      //(never on the first word, and never if preceded by a colon)
      $m = $i>0 && mb_substr ($title, max (0, $i-2), 1, 'UTF-8') !== ':' && 
          !preg_match ('/[\x{2014}\x{2013}] ?/u', mb_substr ($title, max (0, $i-2), 2, 'UTF-8')) && 
           preg_match ('/^(a(nd?|s|t)?|b(ut|y)|en|for|i[fn]|o[fnr]|t(he|o)|vs?\.?|via)[ \-]/i', $m)
      ?   //…and convert them to lowercase
          mb_strtolower ($m, 'UTF-8')
  
      //else: brackets and other wrappers
      : ( preg_match ('/[\'"_{(\[‘“]/u', mb_substr ($title, max (0, $i-1), 3, 'UTF-8'))
      ?   //convert first letter within wrapper to uppercase
          mb_substr ($m, 0, 1, 'UTF-8').
          mb_strtoupper (mb_substr ($m, 1, 1, 'UTF-8'), 'UTF-8').
          mb_substr ($m, 2, mb_strlen ($m, 'UTF-8')-2, 'UTF-8')
  
      //else: do not uppercase these cases
      : ( preg_match ('/[\])}]/', mb_substr ($title, max (0, $i-1), 3, 'UTF-8')) ||
          preg_match ('/[A-Z]+|&|\w+[._]\w+/u', mb_substr ($m, 1, mb_strlen ($m, 'UTF-8')-1, 'UTF-8'))
      ?   $m
          //if all else fails, then no more fringe-cases; uppercase the word
      :   mb_strtoupper (mb_substr ($m, 0, 1, 'UTF-8'), 'UTF-8').
          mb_substr ($m, 1, mb_strlen ($m, 'UTF-8'), 'UTF-8')
      ));
  
      //resplice the title with the change (`substr_replace` is not multi-byte aware)
      $title = mb_substr ($title, 0, $i, 'UTF-8').$m.
           mb_substr ($title, $i+mb_strlen ($m, 'UTF-8'), mb_strlen ($title, 'UTF-8'), 'UTF-8')
      ;
  }
  
  //restore the HTML
  foreach ($html[0] as &$tag) $title = substr_replace ($title, $tag[0], $tag[1], 0);
  return $title;
  }
  

  It manages most fringe cases well but one thing I'm struggling with is hyphenated words, for example 'Co-operate' would be 'Co-Operate' and 'Well-being' would be 'Well-Being'.

  Does anyone know how I could amend the function to take in to account hyphenated words?
• Confirm on href link before deleting

  I plan to have a confirmation box before the script deletes from the database, just in case of the wrong line been selected.

  Code for the href

  echo '<td align="center" valign="middle"><a href="delete.php?id='.$row["id"].'" class="confirmation"><img src="img/icon/delete.png"></a></td>';
  

  Java script

  <script type="text/javascript">
      var elems = document.getElementsByClassName('confirmation');
      var confirmIt = function (e) {
          if (!confirm('Are you sure?')) e.preventDefault();
      };
      for (var i = 0, l = elems.length; i < l; i++) {
          elems[i].addEventListener('click', confirmIt, false);
      }
  </script>
  

  When the 'delete' image is pressed it just deletes the row, no confirmation box appears?
• Java lang NullPointerException occurred on robocode.KeyPressedEvent at fnl.Tastaturbot.Hinzufuegenfnl.Tastaturbot.onKeyPressed

  Everytime I get this NullpointException. When I put "Hinzufuegen(a,b,c);" in the Main-Method it works.

  I want to when I press like 'W' it write something in the Database.

  Global-Variable: int a=3; double b=23; String c="Hallo";

  public void onKeyPressed(KeyEvent e){
  
      Tastaturbot OnKey= new Tastaturbot();
  
  
  
      switch(e.getKeyCode()){
  
  
      case VK_W: 
          System.out.println("W-Gedrückt!");
          try {
              ahead(100);
              OnKey.Hinzufuegen(a,b,c);
          } catch (SQLException e1) {
  
              e1.printStackTrace();
          }
  
          break;
  
      }
  
  }
  
  public void Hinzufuegen(int Schritte,double Sekunden,String Aktion) throws SQLException{
  
      System.out.println("SQL Statment");
      String sql="INSERT INTO robocode VALUES (?,?,?)";
      PreparedStatement statement=this.connection.prepareStatement(sql);
  
  
  
      statement.setInt(1,Schritte);
  
      statement.setDouble(2,Sekunden);
  
      statement.setString(3,Aktion);
      statement.execute();
  
  }
  
• SQLite Database with 1 Million Rows?

  I am writing a disk catalogue application designed to store metadata for around 1 million files (currently 800,000 or so and not likely to grow much). I do not update records, just store and create views for them. I am using one table with TEXT keys to store parent/child relationships, and another table with 1 row and around 70 columns for each file, also indexed with TEXT keys (md5 hash of the file path). Most of these columns are short text strings, although several are frequently over 500 characters.

  Currently, creating a simple view takes over 30 seconds. My question is, if I break my columns out into other tables and then do foreign key lookups or JOINs, would this increase performance dramatically? I've done some tests and this increases the complexity of SELECT statements while providing minimal performance benefit as far as I can tell. All I am trying to do is select around 10-500 records at a time.

  Below is my table structure and select statement. Any help is greatly appreciated!

  CREATE TABLE family ( pid TEXT, fid TEXT, children TEXT ) CREATE TABLE files ( pid TEXT, fid TEXT, Pathname TEXT, Path TEXT, Filename TEXT, Extension TEXT, Type TEXT, Inode INTEGER, Perms INTEGER, Owner TEXT, ATime INTEGER, CTime INTEGER, MTime INTEGER, LinkTarget TEXT, RealPath TEXT, stat TEXT, items INTEGER, newest INTEGER, gfi_type TEXT, gfi_attr TEXT, gfi_created TEXT, Size INTEGER, Title TEXT, PixelWidth INTEGER, PixelHeight INTEGER, Duration INTEGER, DateTimeOriginal INTEGER, Origin TEXT, GPS TEXT, Author TEXT, spotlight TEXT, kMDItemDateAdded INTEGER, kMDItemLastUsedDate INTEGER, kMDItemUseCount INTEGER, kMDItemContentModificationDate INTEGER, kMDItemContentType TEXT, kMDItemCreator TEXT, kMDItemFSCreatorCode TEXT, kMDItemKind TEXT, kMDItemFSTypeCode TEXT, kMDItemUserTags TEXT, kMDItemFSInvisible INTEGER, kMDItemNumberOfPages INTEGER, kMDItemPageHeight INTEGER, kMDItemPageWidth INTEGER, kMDItemWhereFroms TEXT, kMDItemEncodingApplications TEXT, has_exif INTEGER, has_mediainfo INTEGER, has_hash INTEGER, thumb_filename TEXT, thumb_width INTEGER, thumb_height INTEGER, ProfileDescription TEXT, BitDepth INTEGER, Compression TEXT, Orientation INTEGER, LensType TEXT, VideoFormat TEXT, AudioFormat TEXT, Tracks INTEGER, Profile TEXT, Bitrate INTEGER )

  $dbo = new PDO("sqlite:".$bpath."/pool.sqlite3");
  $dbo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $dir = unserialize($dbo->query("SELECT children FROM family WHERE (pid='".$pid."')")->fetch()['children']);
  foreach ($children as $child) {
      $list[] = $dbo->query("SELECT * FROM files WHERE (pid='".$thing."')")->fetchAll();
      }
  
• JavaFX: Is there a way to insert all dates if it doesn't exist from start date and end date? (MySQL)

  For example if I have a calendar table which ends at 2018-01-01 and I insert a date at 2018-02-01 (using JDBC) is it possible to populate the table with all the dates in between?

  This is what I have in way of my JDBC

  ResultSet uprs = stmt2.executeQuery("SELECT dt FROM calendar_table");
  
  uprs.moveToInsertRow();
  
  
  
          uprs.updateString("dt", orderDate);
  
          uprs.insertRow();
  
          uprs.beforeFirst();
  

  Can I automatically populate the missing dates if there are no dates between the end date and if I wish to enter a new date?
• Insert value variable into sql query from file.Python3

  I have the following Python code extract results to csv from an oracle database.

  I have a txt file that contains a list of ID's Example:

  ID
  
  ID124543
  
  ID124544
  
  ID124545
  

  I want to read each ID from a file, insert it into a sql query as a variable.

  SQL="SELECT ID, FIELD1, FIELD2 FROM SOME_TABLE WHERE ID=variable"

  Help me, maybe someone solved this problem. Tell me how to correctly associate variables with a sql query? I am using cx_Oracle.
• Ionic 2 : Access to a variable value from a provider or page

  I have a problem in Ionic 2 and maybe one of you could help me out. Basically, I have a provider that i'm building which includes the function BLE. I include this provider in one my page. And from this page I can call the function without problem. But what I want, is to access the public variable that is the provider. This variable is a status connection (true or false) and I want to access it from my page to know if I'm connected with BLE or not.

  here's my code

  BleProvider.ts

  @Injectable()
  export class BleProvider {
  
  public isConnected:boolean;
  
  constructor(public http: Http) {
   console.log('Hello BleProvider Provider');
  }
  
  connectToDevice(device){
   this.isConnected = true;
  }
  }
  

  My page Login.ts

  import { BleProvider } from '../../providers/ble/ble'
  @IonicPage()
  @Component({
  selector: 'page-login',
  templateUrl: 'login.html',
  })
  @NgModule({
  providers: [BleProvider],
  })
  
  export class LoginPage {
  
  constructor(public ble: BleProvider){
   ble.connectToDevice();
  }
  
  function testIsConnected(){
  console.log("isConnected value: " + this.ble.isConnected);
  }
  }
  

  The console.log will return "isConnected value: undefined. And if i set isConnected in the constructor of the provider (e.g. this.isConnected = false) even that the function connectToDevice will set isConnected at true, when i call it from my page it will return the value false. Can someone explain to me what happens and how to solve this?
• How to set a directory inside public as class variable in laravel

  I have a folder named source in my laravel 5.4 application which i use quiet often in my controller code.

  For example the statement public_path() . '/source/' is used in many places in my code and so I want to define the public_path() . '/source/' directory as a controller level variable. This way I will just have to use the variable name in all controller functions that use the directory.

  This is what I tried and was surprised to see it fail:

  class PostController extends Controller
  {
      public $source_dir = public_path() . '/source/';
  }
  

  But on the line where $source_dir is defined, the application gives the following error:

  FatalErrorException syntax error, unexpected '(', expecting ',' or ';'

  Thanks for any help!
• error when post request

  <?php
  
  if($_SERVER["REQUEST_METHOD"]=="POST"){
  
      require 'connection.php';
      createusers();
      }
      function createusers(){
  
          global $connect;
  
          $username =$_POST["username"];
          $password =$_POST["password"];
  
          $query = " Insert into users(username,password) values ('$username','$password');";
  
          mysqli_query($connect,$query) or die (mysqli_error($connect));
          mysqli_close($connect);
  
      }
  
  
  
  
  
  ?>
  

  Request Response

  Connected successfully
  Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /storage/ssd2/054/2063054/public_html/insertusers.php on line 17
  
  Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /storage/ssd2/054/2063054/public_html/insertusers.php on line 17
  
• Why my all xml sitemap contains 50000 links and not last extra pages?

  i am trying to build sitemap daily using php + mysqli (mariadb)

  when i checked google for submitted sitemap, all i can see is every sitemap subbmitted has 50k urls in it. daily 3k-4k new Posts get added to the DB, so there should be last sitemap with extra URLs. What i am doing wrong ?

  sitemap generation logic

  <?php
      $subset_count = 50000 ;
  
      $total_count_query = "SELECT COUNT(*) as total_count FROM links WHERE enabled = '1' " ;
  
      $total_count = mysqli_query ($conn, $total_count_query);
      $total_count = mysqli_fetch_assoc($total_count);
      $total_count = $total_count['total_count'];
      $total_pages = ceil ($total_count / $subset_count);
  
      $current_page = 1;
      while($current_page <= $total_pages){
          $from = ($current_page * $subset_count) - $subset_count;
  
          //$get_mysql_data_query = " SELECT tpb_id, slug FROM links WHERE enabled = '1' ORDER BY tpb_id ASC LIMIT $from , $subset_count"; // this is slow query
  
          $get_mysql_data_query = " SELECT tpb_id, slug FROM links WHERE enabled = '1' AND id >  $from ORDER BY tpb_id ASC LIMIT 0 , $subset_count";
  
          if ($result = mysqli_query($conn, $get_mysql_data_query)) {
              while ($row = mysqli_fetch_assoc($result)) {
                      $link = 'https://example.com/post-id/'.$row['tpb_id'];
              }
  
              mysqli_free_result($result);
          }
          $current_page++ ;
      }
  

  My table schema

  MariaDB [Db]> describe links;
  +---------+--------------+------+-----+---------+----------------+
  | Field   | Type         | Null | Key | Default | Extra          |
  +---------+--------------+------+-----+---------+----------------+
  | id      | int(11)      | NO   | PRI | NULL    | auto_increment |
  | tpb_id  | int(11)      | NO   | UNI | 0       |                |
  | slug    | varchar(255) | NO   |     |         |                |
  | enabled | tinyint(1)   | NO   |     | 1       |                |
  +---------+--------------+------+-----+---------+----------------+
  4 rows in set (0.01 sec)
  

  there are some inactive records in the table which i dont want them to be included in sitemaps, so i mark them as

  enabled = '0'
  

  SELECT COUNT(*) as total_count FROM links;

  +-------------+
  | total_count |
  +-------------+
  |     4162840 |
  +-------------+
  1 row in set (0.00 sec)
  

  SELECT COUNT(*) as total_count FROM links WHERE enabled = '1';

  +-------------+
  | total_count |
  +-------------+
  |     4053924 |
  +-------------+
  1 row in set (0.91 sec)
  
• mysqli_query(): Empty query mysqli_error() expects exactly 1 parameter, 0 given

  I am creating a register page. the form has an email, password, confirm password, student ID, first name, second name, Course, Gender and DoB. I want the page to collect that information and store it in the database.

  2 Errors:

  mysqli_query(): Empty query

  mysqli_error() expects exactly 1 parameter, 0 given

          $sql = mysqli_query($connection, "INSERT INTO tblaccounts (Email, Password, Student_ID, ID, FirstName, SecondName, Course, Gender, DoB) VALUES ('".$email."','".$password."','".$Student_ID."','".$id."','".$FN."','".$SN."','".$course."','".$gender."','".$dob."')"); 
          $result = mysqli_query($connection, $sql) or die("Database Connection Failed" . mysqli_error());  
          $count = mysqli_num_rows($result);
  
  
  
  
  
  
      <?php
      require_once 'connect.php';
      require_once 'logincheck.php';
  
          if (($_COOKIE['userID']) == null){
                //true
                //show sign in
                ?>
                  <li><p><center><a class="btn btn-primary btn-lg" href="login.php" role="button">Sign In</a><center></p></li>
                <?php
                //show register button
                ?>
                  <li><p><center><a class="btn btn-primary btn-lg" href="register.php" role="button">Register</a><center></p></li>
                <?php
          } else {
          //false
          //show 'logged in as'
                ?>
          <li><a href="#">Logged in as: <?php echo ($_COOKIE['user']) ?></a></li>
          <?php//show 'my profile'?>
          <li><a href="#">My Profile</a></li>
          <?php//show 'settings'.?>
          <li><a href="#">Settings</a></li>
          <li><p><center><a class="btn btn-primary btn-lg" href="logout.php" role="button">Sign Out</a><center></p></li>
              <!--<br/><a href ="login.php">Go back to the login screen.</a>-->
  
                          <!--logged in menu-->
              <!--<li><a href="#">User ID: <php echo ($_COOKIE['userID']) ?></a></li>-->
      </ul>
      <?php
          } 
      ?>